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
|
{"report":{"fcp":998.4000000953674,"ttfb":186.5,"pageVisibility":"visible","entityId":57899,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"acd4fdd5-ff2f-4033-b8df-2803606f790d","navigationType":0,"readyForUser":1110.4000000953674,"redirectCount":0,"resourceLoadedEnd":844.3000001907349,"resourceLoadedStart":203.30000019073486,"resourceTiming":[{"duration":60.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":203.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":203.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":264,"responseStart":0,"secureConnectionStart":0},{"duration":61.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":203.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":203.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":264.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":282,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":203.80000019073486,"connectEnd":203.80000019073486,"connectStart":203.80000019073486,"domainLookupEnd":203.80000019073486,"domainLookupStart":203.80000019073486,"fetchStart":203.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":271.90000009536743,"responseEnd":485.80000019073486,"responseStart":291,"secureConnectionStart":203.80000019073486},{"duration":376.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":204,"connectEnd":204,"connectStart":204,"domainLookupEnd":204,"domainLookupStart":204,"fetchStart":204,"redirectEnd":0,"redirectStart":0,"requestStart":271.59999990463257,"responseEnd":580.4000000953674,"responseStart":295.80000019073486,"secureConnectionStart":204},{"duration":99.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":204.09999990463257,"connectEnd":204.09999990463257,"connectStart":204.09999990463257,"domainLookupEnd":204.09999990463257,"domainLookupStart":204.09999990463257,"fetchStart":204.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":272.09999990463257,"responseEnd":303.40000009536743,"responseStart":295.09999990463257,"secureConnectionStart":204.09999990463257},{"duration":102,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":204.30000019073486,"connectEnd":204.30000019073486,"connectStart":204.30000019073486,"domainLookupEnd":204.30000019073486,"domainLookupStart":204.30000019073486,"fetchStart":204.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":272.19999980926514,"responseEnd":306.30000019073486,"responseStart":297.5,"secureConnectionStart":204.30000019073486},{"duration":102.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":204.40000009536743,"connectEnd":204.40000009536743,"connectStart":204.40000009536743,"domainLookupEnd":204.40000009536743,"domainLookupStart":204.40000009536743,"fetchStart":204.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":272.40000009536743,"responseEnd":306.59999990463257,"responseStart":298.5,"secureConnectionStart":204.40000009536743},{"duration":61.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":204.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":204.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":266.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":102,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":204.80000019073486,"connectEnd":204.80000019073486,"connectStart":204.80000019073486,"domainLookupEnd":204.80000019073486,"domainLookupStart":204.80000019073486,"fetchStart":204.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":272.5,"responseEnd":306.80000019073486,"responseStart":299.59999990463257,"secureConnectionStart":204.80000019073486},{"duration":62.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":205,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":267.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":102,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":205.09999990463257,"connectEnd":205.09999990463257,"connectStart":205.09999990463257,"domainLookupEnd":205.09999990463257,"domainLookupStart":205.09999990463257,"fetchStart":205.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":272.80000019073486,"responseEnd":307.09999990463257,"responseStart":301.5,"secureConnectionStart":205.09999990463257},{"duration":637.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":205.80000019073486,"connectEnd":205.80000019073486,"connectStart":205.80000019073486,"domainLookupEnd":205.80000019073486,"domainLookupStart":205.80000019073486,"fetchStart":205.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":310.69999980926514,"responseEnd":843.3000001907349,"responseStart":837.8000001907349,"secureConnectionStart":205.80000019073486},{"duration":638.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":205.90000009536743,"connectEnd":205.90000009536743,"connectStart":205.90000009536743,"domainLookupEnd":205.90000009536743,"domainLookupStart":205.90000009536743,"fetchStart":205.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":320.40000009536743,"responseEnd":844.3000001907349,"responseStart":839.0999999046326,"secureConnectionStart":205.90000009536743},{"duration":198.7999997138977,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":721.9000000953674,"connectEnd":721.9000000953674,"connectStart":721.9000000953674,"domainLookupEnd":721.9000000953674,"domainLookupStart":721.9000000953674,"fetchStart":721.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":883.5999999046326,"responseEnd":920.6999998092651,"responseStart":919.5,"secureConnectionStart":721.9000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":31,"responseStart":186,"responseEnd":201,"domLoading":198,"domInteractive":1225,"domContentLoadedEventStart":1225,"domContentLoadedEventEnd":1264,"domComplete":1779,"loadEventStart":1779,"loadEventEnd":1779,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1154.6999998092651},{"name":"bigPipe.sidebar-id.end","time":1155.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1155.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1156.3000001907349},{"name":"activityTabFullyLoaded","time":1277.9000000953674}],"measures":[],"correlationId":"10e89d1f5da5c9","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":85,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
The fix for this bug was pushed into the 10.2 tree