Assertion `bit < (map)->n_bits' failed in bitmap_is_set on EXPLAIN PARTITIONS
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Confirmed
|
Low
|
Unassigned |
Bug Description
Reproducible on MySQL 5.5.21 and filed as a comment to http://
mysqld: include/
[ERROR] mysqld got signal 6 ;
#8 0xb750e014 in __assert_fail () from /lib/libc.so.6
#9 0x08502bc5 in bitmap_is_set (map=0x9702da8, bit=3)
at /home/elenst/
#10 0x0850f993 in make_used_
at /home/elenst/
#11 0x08294b31 in select_describe (join=0x9715460, need_tmp_
distinct=false, message=0x0) at /home/elenst/
#12 0x08269ab6 in JOIN::exec (this=0x9715460)
at /home/elenst/
#13 0x0826bd3e in mysql_select (thd=0x9659a80, rref_pointer_
tables=
group=0x0, having=0x0, proc_param=0x0, select_
unit=0x965b054, select_
#14 0x0829695c in mysql_explain_union (thd=0x9659a80, unit=0x965b054, result=0x9709d90)
at /home/elenst/
#15 0x0823f4c8 in execute_
at /home/elenst/
#16 0x082385f1 in mysql_execute_
at /home/elenst/
#17 0x08241c4b in mysql_parse (thd=0x9659a80,
rawbuf=
parser_
#18 0x082360bb in dispatch_command (command=COM_QUERY, thd=0x9659a80, packet=0x97038f1 "",
packet_
#19 0x08235580 in do_command (thd=0x9659a80) at /home/elenst/
#20 0x0831fbf5 in do_handle_
at /home/elenst/
#21 0x0831f740 in handle_
at /home/elenst/
#22 0x08547c3b in pfs_spawn_thread (arg=0x9735998)
at /home/elenst/
#23 0xb77edb25 in start_thread () from /lib/libpthread
Query (9709578): EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a < 3
Connection ID (thread ID): 2
Status: NOT_KILLED
bzr version-info
revision-id: <email address hidden>
date: 2012-03-17 12:16:57 -0700
build-date: 2012-03-19 05:01:04 +0400
revno: 3334
Test case:
--source include/
CREATE TABLE t1 ( a INT ) ENGINE=MyISAM
PARTITION BY RANGE (a) (
PARTITION p0 VALUES LESS THAN (4),
PARTITION p1 VALUES LESS THAN (191),
PARTITION p2 VALUES LESS THAN (54850),
PARTITION p3 VALUES LESS THAN MAXVALUE
);
INSERT INTO t1 VALUES (8),(6),(3),(3);
SET GLOBAL c2.key_buffer_size = 128*1024;
CACHE INDEX t1 PARTITION ( p1, p1 ) IN c2;
ALTER TABLE t1 ORDER BY a;
EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a < 3;
# End of test case
tags: | added: assertion partitions |