Details
Description
CREATE TABLE t1 (d DATE NULL); |
INSERT INTO t1 VALUES ('1984-12-05'),('2021-03-27'); |
SELECT * FROM t1 WHERE '2017-09-01' IN ( d, NAME_CONST( 'tm', NULL ) ); |
|
# Cleanup
|
DROP TABLE t1; |
5.5 debug d947d1bf6e1ebd |
mysqld: /data/src/5.5/sql/item_cmpfunc.cc:4208: virtual longlong Item_func_in::val_int(): Assertion `in_item' failed.
|
170916 1:45:42 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007efd86602ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00000000007ea74c in Item_func_in::val_int (this=0x7efd81148d10) at /data/src/5.5/sql/item_cmpfunc.cc:4208
|
#9 0x0000000000658bb5 in evaluate_join_record (join=0x7efd81148f00, join_tab=0x7efd81180078, error=0) at /data/src/5.5/sql/sql_select.cc:17154
|
#10 0x00000000006587ff in sub_select (join=0x7efd81148f00, join_tab=0x7efd81180078, end_of_records=false) at /data/src/5.5/sql/sql_select.cc:17059
|
#11 0x000000000065806b in do_select (join=0x7efd81148f00, fields=0x7efd82267b80, table=0x0, procedure=0x0) at /data/src/5.5/sql/sql_select.cc:16721
|
#12 0x00000000006365a2 in JOIN::exec (this=0x7efd81148f00) at /data/src/5.5/sql/sql_select.cc:2882
|
#13 0x0000000000636d7e in mysql_select (thd=0x7efd82264060, rref_pointer_array=0x7efd82267cf0, tables=0x7efd811482c8, wild_num=1, fields=..., conds=0x7efd81148d10, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7efd81148ee0, unit=0x7efd82267388, select_lex=0x7efd82267a68) at /data/src/5.5/sql/sql_select.cc:3103
|
#14 0x000000000062d5a2 in handle_select (thd=0x7efd82264060, lex=0x7efd822672d8, result=0x7efd81148ee0, setup_tables_done_option=0) at /data/src/5.5/sql/sql_select.cc:319
|
#15 0x00000000006069bf in execute_sqlcom_select (thd=0x7efd82264060, all_tables=0x7efd811482c8) at /data/src/5.5/sql/sql_parse.cc:4685
|
#16 0x00000000005ffd32 in mysql_execute_command (thd=0x7efd82264060) at /data/src/5.5/sql/sql_parse.cc:2233
|
#17 0x000000000060958a in mysql_parse (thd=0x7efd82264060, rawbuf=0x7efd81148078 "SELECT * FROM t1 WHERE '2017-09-01' IN ( d, NAME_CONST( 'tm', NULL ) )", length=70, parser_state=0x7efd88075640) at /data/src/5.5/sql/sql_parse.cc:5930
|
#18 0x00000000005fd28d in dispatch_command (command=COM_QUERY, thd=0x7efd82264060, packet=0x7efd85f5b061 "", packet_length=70) at /data/src/5.5/sql/sql_parse.cc:1075
|
#19 0x00000000005fc499 in do_command (thd=0x7efd82264060) at /data/src/5.5/sql/sql_parse.cc:793
|
#20 0x00000000006ff17f in do_handle_one_connection (thd_arg=0x7efd82264060) at /data/src/5.5/sql/sql_connect.cc:1268
|
#21 0x00000000006fef0c in handle_one_connection (arg=0x7efd82264060) at /data/src/5.5/sql/sql_connect.cc:1184
|
#22 0x0000000000a0c94b in pfs_spawn_thread (arg=0x7efd82f76fc0) at /data/src/5.5/storage/perfschema/pfs.cc:1015
|
#23 0x00007efd87ca9494 in start_thread (arg=0x7efd88076700) at pthread_create.c:333
|
#24 0x00007efd866bf93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
5.5.56 non-debug |
#2 <signal handler called>
|
#3 val_int (this=0x7f35ca102cb0) at /home/buildbot/buildbot/build/sql/item_cmpfunc.cc:4211
|
#4 Item_func_in::val_int (this=0x7f35ca102cb0) at /home/buildbot/buildbot/build/sql/item_cmpfunc.cc:4183
|
#5 0x00000000005c3024 in evaluate_join_record (join=join@entry=0x7f35ca102ea0, join_tab=join_tab@entry=0x7f35ca0f7018, error=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_select.cc:17079
|
#6 0x00000000005c34c6 in sub_select (join=0x7f35ca102ea0, join_tab=0x7f35ca0f7018, end_of_records=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_select.cc:16984
|
#7 0x00000000005da65d in do_select (join=join@entry=0x7f35ca102ea0, fields=fields@entry=0x7f35cfe13980, table=table@entry=0x0, procedure=0x0) at /home/buildbot/buildbot/build/sql/sql_select.cc:16646
|
#8 0x00000000005efd94 in JOIN::exec (this=this@entry=0x7f35ca102ea0) at /home/buildbot/buildbot/build/sql/sql_select.cc:2878
|
#9 0x00000000005eb0a5 in mysql_select (thd=thd@entry=0x7f35cfe10000, rref_pointer_array=rref_pointer_array@entry=0x7f35cfe13ad8, tables=0x7f35ca102268, wild_num=<optimized out>, fields=..., conds=<optimized out>, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=result@entry=0x7f35ca102e80, unit=0x7f35cfe13188, select_lex=select_lex@entry=0x7f35cfe13868) at /home/buildbot/buildbot/build/sql/sql_select.cc:3099
|
#10 0x00000000005f1cc3 in handle_select (thd=thd@entry=0x7f35cfe10000, lex=lex@entry=0x7f35cfe130d8, result=result@entry=0x7f35ca102e80, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/buildbot/buildbot/build/sql/sql_select.cc:319
|
#11 0x000000000059bd18 in execute_sqlcom_select (thd=thd@entry=0x7f35cfe10000, all_tables=0x7f35ca102268) at /home/buildbot/buildbot/build/sql/sql_parse.cc:4686
|
#12 0x00000000005a3ba3 in mysql_execute_command (thd=thd@entry=0x7f35cfe10000) at /home/buildbot/buildbot/build/sql/sql_parse.cc:2234
|
#13 0x00000000005a74c4 in mysql_parse (thd=thd@entry=0x7f35cfe10000, parser_state=parser_state@entry=0x7f35d8eac6e0, length=<optimized out>, rawbuf=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:5931
|
#14 0x00000000005a9983 in dispatch_command (command=COM_QUERY, thd=0x7f35cfe10000, packet=<optimized out>, packet_length=70) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1245
|
#15 0x00000000005a9afe in do_command (thd=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:793
|
#16 0x000000000065c58b in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f35cfe10000) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1268
|
#17 0x000000000065c60c in handle_one_connection (arg=arg@entry=0x7f35cfe10000) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1184
|
#18 0x0000000000979828 in pfs_spawn_thread (arg=0x7f35d5fff6d0) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:1015
|
#19 0x00007f35d84a5494 in start_thread (arg=0x7f35d8ead700) at pthread_create.c:333
|
#20 0x00007f35d7b6293f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
10.3 doesn't seem to be affected.
Attachments
Issue Links
- links to