Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
-
None
Description
CREATE TABLE t1 ( f1 double(21,4), f2 int(1) NOT NULL); |
INSERT INTO t1 VALUES (20121123.0000,0),(20121123.0000,0); |
|
|
CREATE TABLE t2 (d1 date); |
INSERT INTO t2 VALUES (NULL),('1900-01-01'); |
|
|
SELECT * FROM t1 WHERE (f1,f2) NOT IN (SELECT TRUNCATE(d1, 4), 'a' <=> NULL FROM t2); |
|
5.5 4932ec871f6e8270fd |
#3 <signal handler called>
|
#4 0x00007fa01cea9428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#5 0x00007fa01ceab02a in __GI_abort () at abort.c:89
|
#6 0x00007fa01cea1bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0xe28b78 "count_partial_match_columns == field_count", file=file@entry=0xe27d28 "/5.5/sql/item_subselect.cc", line=line@entry=4937, function=function@entry=0xe2a300 <subselect_hash_sj_engine::exec()::__PRETTY_FUNCTION__> "virtual int subselect_hash_sj_engine::exec()") at assert.c:92
|
#7 0x00007fa01cea1c82 in __GI___assert_fail (assertion=0xe28b78 "count_partial_match_columns == field_count", file=0xe27d28 "/5.5/sql/item_subselect.cc", line=4937, function=0xe2a300 <subselect_hash_sj_engine::exec()::__PRETTY_FUNCTION__> "virtual int subselect_hash_sj_engine::exec()") at assert.c:101
|
#8 0x000000000087f0fb in subselect_hash_sj_engine::exec (this=0x7fa017d40ed0) at /5.5/sql/item_subselect.cc:4937
|
#9 0x0000000000873bd9 in Item_subselect::exec (this=0x7fa017d49c48) at /5.5/sql/item_subselect.cc:664
|
#10 0x00000000008741db in Item_in_subselect::exec (this=0x7fa017d49c48) at /5.5/sql/item_subselect.cc:839
|
#11 0x0000000000876a45 in Item_in_subselect::val_bool (this=0x7fa017d49c48) at /5.5/sql/item_subselect.cc:1680
|
#12 0x000000000056bf4d in Item::val_bool_result (this=0x7fa017d49c48) at /5.5/sql/item.h:992
|
#13 0x000000000080fc1e in Item_in_optimizer::val_int (this=0x7fa017d81738) at /5.5/sql/item_cmpfunc.cc:1826
|
#14 0x000000000056bec1 in Item::val_int_result (this=0x7fa017d81738) at /5.5/sql/item.h:988
|
#15 0x0000000000800d6f in Item_cache_int::cache_value (this=0x7fa017d43bf0) at /5.5/sql/item.cc:8853
|
#16 0x00000000008083c6 in Item_cache_wrapper::cache (this=0x7fa017d43b30) at /5.5/sql/item.cc:7659
|
#17 0x00000000007fded8 in Item_cache_wrapper::val_bool (this=0x7fa017d43b30) at /5.5/sql/item.cc:7823
|
#18 0x000000000080b5a5 in Item_func_not::val_int (this=0x7fa017d49ef0) at /5.5/sql/item_cmpfunc.cc:347
|
#19 0x000000000066da5c in evaluate_join_record (join=0x7fa017d80670, join_tab=0x7fa017d987a0, error=0) at /5.5/sql/sql_select.cc:17281
|
#20 0x000000000066d67b in sub_select (join=0x7fa017d80670, join_tab=0x7fa017d987a0, end_of_records=false) at /5.5/sql/sql_select.cc:17186
|
#21 0x000000000066cea4 in do_select (join=0x7fa017d80670, fields=0x7fa0197e9b88, table=0x0, procedure=0x0) at /5.5/sql/sql_select.cc:16848
|
#22 0x0000000000647f8a in JOIN::exec (this=0x7fa017d80670) at /5.5/sql/sql_select.cc:2914
|
#23 0x000000000064886f in mysql_select (thd=0x7fa0197e6060, rref_pointer_array=0x7fa0197e9d10, tables=0x7fa017d482e8, wild_num=1, fields=..., conds=0x7fa017d49ef0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fa017d80650, unit=0x7fa0197e9388, select_lex=0x7fa0197e9a70) at /5.5/sql/sql_select.cc:3135
|
#24 0x000000000063e74b in handle_select (thd=0x7fa0197e6060, lex=0x7fa0197e92d8, result=0x7fa017d80650, setup_tables_done_option=0) at /5.5/sql/sql_select.cc:324
|
#25 0x000000000061448c in execute_sqlcom_select (thd=0x7fa0197e6060, all_tables=0x7fa017d482e8) at /5.5/sql/sql_parse.cc:4684
|
#26 0x000000000060cf46 in mysql_execute_command (thd=0x7fa0197e6060) at /5.5/sql/sql_parse.cc:2222
|
#27 0x00000000006173a6 in mysql_parse (thd=0x7fa0197e6060, rawbuf=0x7fa017d48078 "SELECT * FROM t1 WHERE (f1,f2) NOT IN (SELECT TRUNCATE(d1, 4), 'a' <=> NULL FROM t2)", length=84, parser_state=0x7fa01e724660) at /5.5/sql/sql_parse.cc:5929
|
#28 0x000000000060a2ee in dispatch_command (command=COM_QUERY, thd=0x7fa0197e6060, packet=0x7fa018af4061 "", packet_length=84) at /5.5/sql/sql_parse.cc:1067
|
#29 0x0000000000609453 in do_command (thd=0x7fa0197e6060) at /5.5/sql/sql_parse.cc:793
|
#30 0x0000000000720f7e in do_handle_one_connection (thd_arg=0x7fa0197e6060) at /5.5/sql/sql_connect.cc:1268
|
#31 0x0000000000720ce7 in handle_one_connection (arg=0x7fa0197e6060) at /5.5/sql/sql_connect.cc:1184
|
#32 0x0000000000cc3f5d in pfs_spawn_thread (arg=0x7fa018a9c300) at /5.5/storage/perfschema/pfs.cc:1015
|
#33 0x00007fa01dad46ba in start_thread (arg=0x7fa01e725700) at pthread_create.c:333
|
#34 0x00007fa01cf7b41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|