Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
CREATE TABLE t1 (c VARCHAR(3)); |
CREATE ALGORITHM=TEMPTABLE VIEW v1 AS SELECT * FROM t1; |
INSERT INTO t1 VALUES ('foo'),('bar'); |
|
CREATE TABLE t2 (c VARCHAR(3)); |
INSERT INTO t2 VALUES ('qux'),('xyz'); |
|
SELECT * FROM v1 WHERE v1.c IN ( SELECT MIN(c) FROM t2 WHERE 0 ); |
10.2 c35b8c46b404d035e54a23d667da5dff6502fc2e |
#3 <signal handler called>
|
#4 0x00007fd3e51d0f8a in charset (this=0x0) at /data/src/10.2/sql/sql_string.h:202
|
#5 Item_cache_str::convert_to_basic_const_item (this=0x7fd3d9d201c8, thd=0x7fd3d9c16070) at /data/src/10.2/sql/item.cc:9799
|
#6 0x00007fd3e51e0e49 in Item_cache::derived_field_transformer_for_where (this=<optimized out>, thd=<optimized out>, arg=<optimized out>) at /data/src/10.2/sql/item.h:5430
|
#7 0x00007fd3e51c7e1d in Item::transform (this=<optimized out>, thd=<optimized out>, transformer=<optimized out>, arg=<optimized out>) at /data/src/10.2/sql/item.cc:707
|
#8 0x00007fd3e522257f in Item_args::transform_args (this=this@entry=0x7fd3d9d20478, thd=0x7fd3d9c16070, transformer=<optimized out>, arg=arg@entry=0x7fd3d9c669e8 "\020\365\n\346\323\177") at /data/src/10.2/sql/item_func.cc:328
|
#9 0x00007fd3e5222634 in Item_func::transform (this=0x7fd3d9d203f0, thd=0x7fd3d9c16070, transformer=<optimized out>, argument=0x7fd3d9c669e8 "\020\365\n\346\323\177") at /data/src/10.2/sql/item_func.cc:364
|
#10 0x00007fd3e4faa4fb in pushdown_cond_for_derived (thd=0x7fd3d9c16070, cond=<optimized out>, derived=derived@entry=0x7fd3d9c642c0) at /data/src/10.2/sql/sql_derived.cc:1195
|
#11 0x00007fd3e5036e60 in JOIN::optimize_inner (this=this@entry=0x7fd3d9c68568) at /data/src/10.2/sql/sql_select.cc:1295
|
#12 0x00007fd3e503722f in JOIN::optimize (this=this@entry=0x7fd3d9c68568) at /data/src/10.2/sql/sql_select.cc:1076
|
#13 0x00007fd3e5037bd5 in mysql_select (thd=thd@entry=0x7fd3d9c16070, tables=0x7fd3d9c642c0, wild_num=1, fields=..., conds=0x7fd3d9c65e38, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fd3d9c68548, unit=0x7fd3d9c19b48, select_lex=0x7fd3d9c1a278) at /data/src/10.2/sql/sql_select.cc:3570
|
#14 0x00007fd3e5037e8d in handle_select (thd=thd@entry=0x7fd3d9c16070, lex=lex@entry=0x7fd3d9c19a80, result=result@entry=0x7fd3d9c68548, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.2/sql/sql_select.cc:373
|
#15 0x00007fd3e4fc8849 in execute_sqlcom_select (thd=thd@entry=0x7fd3d9c16070, all_tables=0x7fd3d9c642c0) at /data/src/10.2/sql/sql_parse.cc:6347
|
#16 0x00007fd3e4fd16d2 in mysql_execute_command (thd=thd@entry=0x7fd3d9c16070) at /data/src/10.2/sql/sql_parse.cc:3370
|
#17 0x00007fd3e4fdb2d2 in mysql_parse (thd=thd@entry=0x7fd3d9c16070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fd3e5fdd8e0, 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:7790
|
#18 0x00007fd3e4fdd55b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fd3d9c16070, packet=packet@entry=0x7fd3d9c58071 "SELECT * FROM v1 WHERE v1.c IN ( SELECT MIN(c) FROM t2 WHERE 0 )", packet_length=packet_length@entry=64, 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 0x00007fd3e4fe008d in do_command (thd=0x7fd3d9c16070) at /data/src/10.2/sql/sql_parse.cc:1359
|
#20 0x00007fd3e50cdf4a in do_handle_one_connection (connect=connect@entry=0x7fd3e2071410) at /data/src/10.2/sql/sql_connect.cc:1354
|
#21 0x00007fd3e50ce133 in handle_one_connection (arg=arg@entry=0x7fd3e2071410) at /data/src/10.2/sql/sql_connect.cc:1260
|
#22 0x00007fd3e537c1bf in pfs_spawn_thread (arg=0x7fd3e2015df0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#23 0x00007fd3e46cf0a4 in start_thread (arg=0x7fd3e5fdf300) at pthread_create.c:309
|
#24 0x00007fd3e2eef87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|