Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.1(EOL), 11.2, 11.4, 10.4(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.3(EOL), 11.5(EOL)
-
None
Description
--source include/have_partition.inc
|
|
CREATE TABLE t1 (id int, a int, KEY id (id), KEY (a)) partition BY list (id) (PARTITION p1 VALUES IN (1,2,3,4,5,6,7,8,9,10 )); |
INSERT INTO t1 VALUES (1,5),(2,3),(3,7),(4,2),(5,7),(6,4),(7,9),(8,7),(9,NULL),(10,NULL); |
|
SELECT * FROM t1 WHERE id IN (255) OR a IN (25,1); |
Version: '10.4.31-MariaDB-debug-log'
|
mysqld: /10.4/include/my_bitmap.h:133: uint bitmap_is_set(const MY_BITMAP*, uint): Assertion `bit < (map)->n_bits' failed.
|
230808 15:54:09 [ERROR] mysqld got signal 6 ;
|
|
|
Server version: 10.4.31-MariaDB-debug-log source revision: 277968aa4cfa46a290af1c44e9d756381005939a
|
|
stdlib/abort.c:81(__GI_abort)[0x7f6c4ba50535]
|
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f6c4ba5040f]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x301a2)[0x7f6c4ba5e1a2]
|
include/my_bitmap.h:134(bitmap_is_set)[0x55750729481e]
|
sql/ha_partition.cc:7687(ha_partition::handle_ordered_index_scan(unsigned char*, bool))[0x5575072d274c]
|
sql/ha_partition.cc:6649(ha_partition::multi_range_read_next(void**))[0x5575072c871d]
|
sql/opt_range.cc:12345(QUICK_RANGE_SELECT::get_next())[0x557506e4900d]
|
sql/opt_range.cc:11894(read_keys_and_merge_scans(THD*, TABLE*, List<QUICK_RANGE_SELECT>, QUICK_RANGE_SELECT*, READ_RECORD*, bool, Bitmap<64u>*, Unique**))[0x557506e44a45]
|
sql/opt_range.cc:11963(QUICK_INDEX_MERGE_SELECT::read_keys_and_merge())[0x557506e4533d]
|
sql/opt_range.cc:1389(QUICK_INDEX_SORT_SELECT::reset())[0x557506dfe168]
|
sql/sql_select.cc:21820(join_init_read_record(st_join_table*))[0x5575063fc8b9]
|
sql/sql_select.cc:20886(sub_select(JOIN*, st_join_table*, bool))[0x5575063f5e75]
|
sql/sql_select.cc:20412(do_select(JOIN*, Procedure*))[0x5575063f3ec1]
|
sql/sql_select.cc:4605(JOIN::exec_inner())[0x557506382f84]
|
sql/sql_select.cc:4388(JOIN::exec())[0x5575063805d0]
|
sql/sql_select.cc:4828(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55750638462f]
|
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x557506355942]
|
sql/sql_parse.cc:6473(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5575062c4fbd]
|
sql/sql_parse.cc:3976(mysql_execute_command(THD*))[0x5575062b2716]
|
sql/sql_parse.cc:8010(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5575062ce12b]
|
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5575062a4ba9]
|
sql/sql_parse.cc:1378(do_command(THD*))[0x5575062a16b5]
|
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x55750669c7f1]
|
sql/sql_connect.cc:1325(handle_one_connection)[0x55750669c093]
|
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x5575073792f1]
|
nptl/pthread_create.c:487(start_thread)[0x7f6c4bf1bfa3]
|
x86_64/clone.S:97(clone)[0x7f6c4bb2706f]
|
|
Query (0x62b000062290): SELECT * FROM t1 WHERE id IN (255) OR a IN (25,1)
|
Attachments
Issue Links
- relates to
-
MDEV-24283 Assertion `bitmap_is_set(&m_part_info->read_partitions, m_part_spec.start_part)' failed in ha_partition::handle_ordered_index_scan
- Closed