[MDEV-10736] Server crashes in select_union_recursive::create_result_table Created: 2016-09-04  Updated: 2016-09-23  Resolved: 2016-09-23

Status: Closed
Project: MariaDB Server
Component/s: Optimizer - CTE
Affects Version/s: 10.2
Fix Version/s: 10.2.2

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates

 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



 Comments   
Comment by Igor Babaev [ 2016-09-23 ]

The fix for this bug was pushed into the 10.2 tree

Generated at Thu Feb 08 07:44:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.