Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
CREATE TABLE t1 (f VARCHAR(1024)); |
WITH RECURSIVE cte(f) AS ( |
SELECT t1.f FROM t1 |
UNION ALL |
SELECT cte.f FROM cte |
)
|
SELECT * FROM cte; |
Stack trace from 10.2 1da21cd4a58 |
#3 <signal handler called>
|
#4 0x00007f0fd09d2792 in ha_maria::extra (this=0x7f0fc488a888, operation=HA_EXTRA_WRITE_CACHE) at /data/src/10.2/storage/maria/ha_maria.cc:2550
|
#5 0x00007f0fd036e182 in select_union_recursive::create_result_table (this=0x7f0fc49242d0, thd_arg=0x7f0fc4852070, column_types=0x7f0fc4921cc8, is_union_distinct=false, options=2416188160, alias=0x7f0fc4922d68 "cte", bit_fields_as_long=false, create_table=true, keep_row_order=false) at /data/src/10.2/sql/sql_union.cc:242
|
#6 0x00007f0fd036f76e in st_select_lex_unit::prepare (this=0x7f0fc4921628, thd_arg=0x7f0fc4852070, sel_result=0x7f0fc4924200, additional_options=0) at /data/src/10.2/sql/sql_union.cc:649
|
#7 0x00007f0fd026ae77 in mysql_derived_prepare (thd=0x7f0fc4852070, lex=0x7f0fc4855a20, derived=0x7f0fc4922d70) at /data/src/10.2/sql/sql_derived.cc:724
|
#8 0x00007f0fd0269f5e in mysql_handle_single_derived (lex=0x7f0fc4855a20, derived=0x7f0fc4922d70, phases=2) at /data/src/10.2/sql/sql_derived.cc:197
|
#9 0x00007f0fd03953ef in TABLE_LIST::handle_derived (this=0x7f0fc4922d70, lex=0x7f0fc4855a20, phases=2) at /data/src/10.2/sql/table.cc:7606
|
#10 0x00007f0fd0288a1e in st_select_lex::handle_derived (this=0x7f0fc49224d0, lex=0x7f0fc4855a20, phases=2) at /data/src/10.2/sql/sql_lex.cc:3868
|
#11 0x00007f0fd03953b0 in TABLE_LIST::handle_derived (this=0x7f0fc49235b8, lex=0x7f0fc4855a20, phases=2) at /data/src/10.2/sql/table.cc:7603
|
#12 0x00007f0fd0288a1e in st_select_lex::handle_derived (this=0x7f0fc4856220, lex=0x7f0fc4855a20, phases=2) at /data/src/10.2/sql/sql_lex.cc:3868
|
#13 0x00007f0fd02d1deb in JOIN::prepare (this=0x7f0fc4923cc0, tables_init=0x7f0fc49235b8, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f0fc4856220, unit_arg=0x7f0fc4855ae8) at /data/src/10.2/sql/sql_select.cc:712
|
#14 0x00007f0fd02db809 in mysql_select (thd=0x7f0fc4852070, tables=0x7f0fc49235b8, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f0fc4923ca0, unit=0x7f0fc4855ae8, select_lex=0x7f0fc4856220) at /data/src/10.2/sql/sql_select.cc:3518
|
#15 0x00007f0fd02d107b in handle_select (thd=0x7f0fc4852070, lex=0x7f0fc4855a20, result=0x7f0fc4923ca0, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373
|
#16 0x00007f0fd02a0c2b in execute_sqlcom_select (thd=0x7f0fc4852070, all_tables=0x7f0fc49235b8) at /data/src/10.2/sql/sql_parse.cc:6333
|
#17 0x00007f0fd0296a61 in mysql_execute_command (thd=0x7f0fc4852070) at /data/src/10.2/sql/sql_parse.cc:3364
|
#18 0x00007f0fd02a43e5 in mysql_parse (thd=0x7f0fc4852070, rawbuf=0x7f0fc4921088 "WITH RECURSIVE cte(f) AS (\nSELECT t1.f FROM t1\nUNION ALL\nSELECT cte.f FROM cte \n) \nSELECT * FROM cte", length=100, parser_state=0x7f0fd1216dd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7765
|
#19 0x00007f0fd02927b8 in dispatch_command (command=COM_QUERY, thd=0x7f0fc4852070, packet=0x7f0fc4915071 "WITH RECURSIVE cte(f) AS (\nSELECT t1.f FROM t1\nUNION ALL\nSELECT cte.f FROM cte \n) \nSELECT * FROM cte", packet_length=100, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1793
|
#20 0x00007f0fd02911e9 in do_command (thd=0x7f0fc4852070) at /data/src/10.2/sql/sql_parse.cc:1353
|
#21 0x00007f0fd03cb926 in do_handle_one_connection (connect=0x7f0fcd06d410) at /data/src/10.2/sql/sql_connect.cc:1354
|
#22 0x00007f0fd03cb6b3 in handle_one_connection (arg=0x7f0fcd06d410) at /data/src/10.2/sql/sql_connect.cc:1260
|
#23 0x00007f0fd06c0722 in pfs_spawn_thread (arg=0x7f0fcd0519f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#24 0x00007f0fcf9520a4 in start_thread (arg=0x7f0fd1218300) at pthread_create.c:309
|
#25 0x00007f0fcdb0a87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|