Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2(EOL)
Description
CREATE TABLE t1 (f int) PARTITION BY LIST COLUMNS (f) (PARTITION pdef DEFAULT); |
insert into t1 values (1),(2); |
select * from t1 where f = 1; |
10.2 143d512a2202dbd320ec9b9e37dafc36fc2b36d8 |
mysqld: /data/src/10.2/sql/sql_partition.cc:7709: int get_part_iter_for_interval_cols_via_map(partition_info*, bool, uint32*, uchar*, u
|
char*, uint, uint, uint, PARTITION_ITERATOR*): Assertion `part_info->num_list_values' failed.
|
161228 19:29:49 [ERROR] mysqld got signal 6 ;
|
 |
#5 0x00007f9fd95c3448 in __GI_abort () at abort.c:89
|
#6 0x00007f9fd95bb266 in __assert_fail_base (fmt=0x7f9fd96f4238 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7f9fdc17cc6a "part_info->num_list_values", file=file@entry=0x7f9fdc17bd40 "/data/src/10.2/sql/sql_partition.cc", line=line@entry=7709, function=function@entry=0x7f9fdc17dac0 <get_part_iter_for_interval_cols_via_map(partition_info*, bool, unsigned int*, unsigned char*, unsigned char*, unsigned int, unsigned int, unsigned int, st_partition_iter*)::__PRETTY_FUNCTION__> "int get_part_iter_for_interval_cols_via_map(partition_info*, bool, uint32*, uchar*, uchar*, uint, uint, uint, PARTITION_ITERATOR*)") at assert.c:92
|
#7 0x00007f9fd95bb312 in __GI___assert_fail (assertion=0x7f9fdc17cc6a "part_info->num_list_values", file=0x7f9fdc17bd40 "/data/src/10.2/sql/sql_partition.cc", line=7709, function=0x7f9fdc17dac0 <get_part_iter_for_interval_cols_via_map(partition_info*, bool, unsigned int*, unsigned char*, unsigned char*, unsigned int, unsigned int, unsigned int, st_partition_iter*)::__PRETTY_FUNCTION__> "int get_part_iter_for_interval_cols_via_map(partition_info*, bool, uint32*, uchar*, uchar*, uint, uint, uint, PARTITION_ITERATOR*)") at assert.c:101
|
#8 0x00007f9fdbaaf78b in get_part_iter_for_interval_cols_via_map (part_info=0x7f9fd060c088, is_subpart=<optimized out>, store_length_array=0x7f9fdc760f60, min_value=0x7f9fd05880c0 "", max_value=0x7f9fd05880c8 "", min_len=5, max_len=5, flags=0, part_iter=0x7f9fdc761548) at /data/src/10.2/sql/sql_partition.cc:7709
|
#9 0x00007f9fdba5d6f4 in find_used_partitions (ppar=ppar@entry=0x7f9fdc761180, key_tree=0x7f9fd0588158) at /data/src/10.2/sql/opt_range.cc:4006
|
#10 0x00007f9fdba5e715 in prune_partitions (thd=0x7f9fd0416070, table=table@entry=0x7f9fd04d5870, pprune_cond=0x7f9fd04653b0) at /data/src/10.2/sql/opt_range.cc:3514
|
#11 0x00007f9fdb7ba478 in JOIN::optimize_inner (this=this@entry=0x7f9fd0464c88) at /data/src/10.2/sql/sql_select.cc:1369
|
#12 0x00007f9fdb7bd6d3 in JOIN::optimize (this=this@entry=0x7f9fd0464c88) at /data/src/10.2/sql/sql_select.cc:1076
|
#13 0x00007f9fdb7be079 in mysql_select (thd=thd@entry=0x7f9fd0416070, tables=0x7f9fd0464278, wild_num=1, fields=..., conds=0x7f9fd0464a30, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f9fd0464c68, unit=0x7f9fd0419b48, select_lex=0x7f9fd041a278) at /data/src/10.2/sql/sql_select.cc:3570
|
#14 0x00007f9fdb7be331 in handle_select (thd=thd@entry=0x7f9fd0416070, lex=lex@entry=0x7f9fd0419a80, result=result@entry=0x7f9fd0464c68, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.2/sql/sql_select.cc:373
|
#15 0x00007f9fdb74eb5d in execute_sqlcom_select (thd=thd@entry=0x7f9fd0416070, all_tables=0x7f9fd0464278) at /data/src/10.2/sql/sql_parse.cc:6399
|
#16 0x00007f9fdb757a0e in mysql_execute_command (thd=thd@entry=0x7f9fd0416070) at /data/src/10.2/sql/sql_parse.cc:3423
|
#17 0x00007f9fdb761776 in mysql_parse (thd=thd@entry=0x7f9fd0416070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f9fdc7638e0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7842
|
#18 0x00007f9fdb7639ff in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f9fd0416070, packet=packet@entry=0x7f9fd0458071 "select * from t1 where f = 1", packet_length=packet_length@entry=28, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:1799
|
#19 0x00007f9fdb766531 in do_command (thd=0x7f9fd0416070) at /data/src/10.2/sql/sql_parse.cc:1359
|
#20 0x00007f9fdb854480 in do_handle_one_connection (connect=connect@entry=0x7f9fd8871410) at /data/src/10.2/sql/sql_connect.cc:1354
|
#21 0x00007f9fdb854669 in handle_one_connection (arg=arg@entry=0x7f9fd8871410) at /data/src/10.2/sql/sql_connect.cc:1260
|
#22 0x00007f9fdbb02943 in pfs_spawn_thread (arg=0x7f9fd880f9f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#23 0x00007f9fdae550a4 in start_thread (arg=0x7f9fdc765300) at pthread_create.c:309
|
#24 0x00007f9fd967587d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Attachments
Issue Links
- relates to
-
MDEV-8348 Add catchall to all table partitioning for list partitions
- Closed