Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
Description
Reproducible on MySQL 5.5.21 and filed as a comment to http://bugs.mysql.com/bug.php?id=64037.
mysqld: include/my_bitmap.h:124: uint bitmap_is_set(const MY_BITMAP*, uint): Assertion `bit < (map)->n_bits' failed.
|
[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/maria-5.5/include/my_bitmap.h:124
|
#10 0x0850f993 in make_used_partitions_str (part_info=0x9702d10, parts_str=0x970acc0)
|
at /home/elenst/maria-5.5/sql/sql_partition.cc:7012
|
#11 0x08294b31 in select_describe (join=0x9715460, need_tmp_table=false, need_order=false,
|
distinct=false, message=0x0) at /home/elenst/maria-5.5/sql/sql_select.cc:21071
|
#12 0x08269ab6 in JOIN::exec (this=0x9715460)
|
at /home/elenst/maria-5.5/sql/sql_select.cc:2308
|
#13 0x0826bd3e in mysql_select (thd=0x9659a80, rref_pointer_array=0x965b62c,
|
tables=0x9709700, wild_num=0, fields=..., conds=0x9709c28, og_num=0, order=0x0,
|
group=0x0, having=0x0, proc_param=0x0, select_options=2147748612, result=0x9709d90,
|
unit=0x965b054, select_lex=0x965b4f0) at /home/elenst/maria-5.5/sql/sql_select.cc:3003
|
#14 0x0829695c in mysql_explain_union (thd=0x9659a80, unit=0x965b054, result=0x9709d90)
|
at /home/elenst/maria-5.5/sql/sql_select.cc:21547
|
#15 0x0823f4c8 in execute_sqlcom_select (thd=0x9659a80, all_tables=0x9709700)
|
at /home/elenst/maria-5.5/sql/sql_parse.cc:4588
|
#16 0x082385f1 in mysql_execute_command (thd=0x9659a80)
|
at /home/elenst/maria-5.5/sql/sql_parse.cc:2185
|
#17 0x08241c4b in mysql_parse (thd=0x9659a80,
|
rawbuf=0x9709578 "EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a < 3", length=47,
|
parser_state=0xad17ddb8) at /home/elenst/maria-5.5/sql/sql_parse.cc:5732
|
#18 0x082360bb in dispatch_command (command=COM_QUERY, thd=0x9659a80, packet=0x97038f1 "",
|
packet_length=47) at /home/elenst/maria-5.5/sql/sql_parse.cc:1056
|
#19 0x08235580 in do_command (thd=0x9659a80) at /home/elenst/maria-5.5/sql/sql_parse.cc:795
|
#20 0x0831fbf5 in do_handle_one_connection (thd_arg=0x9659a80)
|
at /home/elenst/maria-5.5/sql/sql_connect.cc:1253
|
#21 0x0831f740 in handle_one_connection (arg=0x9659a80)
|
at /home/elenst/maria-5.5/sql/sql_connect.cc:1168
|
#22 0x08547c3b in pfs_spawn_thread (arg=0x9735998)
|
at /home/elenst/maria-5.5/storage/perfschema/pfs.cc:1015
|
#23 0xb77edb25 in start_thread () from /lib/libpthread.so.0
|
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/have_partition.inc
|
 |
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; |
Attachments
Issue Links
- links to