54a995cd2206995f6dd675cabdce12a4b7ff7540
#3 <signal handler called>
#4 0x00007f88b7960ee4 in st_select_lex_unit::exec_recursive (this=0x7f88940128f0) at /data/src/10.2/sql/sql_union.cc:1265
#5 0x00007f88b784cdf8 in TABLE_LIST::fill_recursive (this=0x7f8894014f90, thd=0x7f8894000b00) at /data/src/10.2/sql/sql_derived.cc:973
#6 0x00007f88b784cfdc in mysql_derived_fill (thd=0x7f8894000b00, lex=0x7f8894004518, derived=0x7f8894014f90) at /data/src/10.2/sql/sql_derived.cc:1037
#7 0x00007f88b784b482 in mysql_handle_single_derived (lex=0x7f8894004518, derived=0x7f8894014f90, phases=96) at /data/src/10.2/sql/sql_derived.cc:197
#8 0x00007f88b78d99b5 in st_join_table::preread_init (this=0x7f889403bbe0) at /data/src/10.2/sql/sql_select.cc:11756
#9 0x00007f88b78e9a01 in sub_select (join=0x7f88940156b8, join_tab=0x7f889403bbe0, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18426
#10 0x00007f88b78e9137 in do_select (join=0x7f88940156b8, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18002
#11 0x00007f88b78c3d61 in JOIN::exec_inner (this=0x7f88940156b8) at /data/src/10.2/sql/sql_select.cc:3464
#12 0x00007f88b78c3266 in JOIN::exec (this=0x7f88940156b8) at /data/src/10.2/sql/sql_select.cc:3267
#13 0x00007f88b78c43d9 in mysql_select (thd=0x7f8894000b00, tables=0x7f8894014f90, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f8894015698, unit=0x7f88940045e0, select_lex=0x7f8894004d10) at /data/src/10.2/sql/sql_select.cc:3659
#14 0x00007f88b78b8ea2 in handle_select (thd=0x7f8894000b00, lex=0x7f8894004518, result=0x7f8894015698, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373
#15 0x00007f88b7885223 in execute_sqlcom_select (thd=0x7f8894000b00, all_tables=0x7f8894014f90) at /data/src/10.2/sql/sql_parse.cc:6431
#16 0x00007f88b787b262 in mysql_execute_command (thd=0x7f8894000b00) at /data/src/10.2/sql/sql_parse.cc:3448
#17 0x00007f88b7888bf6 in mysql_parse (thd=0x7f8894000b00, rawbuf=0x7f8894012348 "WITH RECURSIVE cte(f) AS ( SELECT i FROM t UNION SELECT f FROM t, cte WHERE 0 ) SELECT * FROM cte", length=97, parser_state=0x7f88b007d210, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7874
#18 0x00007f88b7876cce in dispatch_command (command=COM_QUERY, thd=0x7f8894000b00, packet=0x7f88940087a1 "", packet_length=97, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1812
#19 0x00007f88b787563e in do_command (thd=0x7f8894000b00) at /data/src/10.2/sql/sql_parse.cc:1362
#20 0x00007f88b79bfe05 in do_handle_one_connection (connect=0x7f88bac72260) at /data/src/10.2/sql/sql_connect.cc:1354
#21 0x00007f88b79bfb92 in handle_one_connection (arg=0x7f88bac72260) at /data/src/10.2/sql/sql_connect.cc:1260
#22 0x00007f88b7dd8eb8 in pfs_spawn_thread (arg=0x7f88bac4cb10) at /data/src/10.2/storage/perfschema/pfs.cc:1862
#23 0x00007f88b6e9b064 in start_thread (arg=0x7f88b007e700) at pthread_create.c:309
#24 0x00007f88b528b62d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
CREATE TABLE t (i INT );
INSERT INTO t VALUES (1),(2); # optional, fails either way
WITH RECURSIVE cte(f) AS ( SELECT i FROM t UNION SELECT f FROM t, cte WHERE 0 ) SELECT * FROM cte;
Elena Stepanova
made changes -
2017-04-21 23:58
Field
Original Value
New Value
Labels
10.2-ga
Igor Babaev (Inactive)
made changes -
2017-04-24 17:46
Fix Version/s
10.2.6
[ 22527
]
Fix Version/s
10.2
[ 14601
]
Resolution
Fixed
[ 1
]
Status
In Progress
[ 3
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2021-12-06 21:44
Workflow
MariaDB v3
[ 80415
]
MariaDB v4
[ 151987
]
{"report":{"fcp":1287.3000001907349,"ttfb":246.60000038146973,"pageVisibility":"visible","entityId":61006,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"57d2b8c5-ba1c-4340-9bd7-1d2f98cdab14","navigationType":0,"readyForUser":1381.1000003814697,"redirectCount":0,"resourceLoadedEnd":1493.8000001907349,"resourceLoadedStart":252.4000005722046,"resourceTiming":[{"duration":505,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":252.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":252.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":757.4000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":505,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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","startTime":252.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":252.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":757.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":515.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":252.80000019073486,"connectEnd":252.80000019073486,"connectStart":252.80000019073486,"domainLookupEnd":252.80000019073486,"domainLookupStart":252.80000019073486,"fetchStart":252.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":252.80000019073486,"responseEnd":768.4000005722046,"responseStart":768.4000005722046,"secureConnectionStart":252.80000019073486},{"duration":565.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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","startTime":253,"connectEnd":253,"connectStart":253,"domainLookupEnd":253,"domainLookupStart":253,"fetchStart":253,"redirectEnd":0,"redirectStart":0,"requestStart":253,"responseEnd":818.1000003814697,"responseStart":818.1000003814697,"secureConnectionStart":253},{"duration":569.0999994277954,"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":253.10000038146973,"connectEnd":253.10000038146973,"connectStart":253.10000038146973,"domainLookupEnd":253.10000038146973,"domainLookupStart":253.10000038146973,"fetchStart":253.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":253.10000038146973,"responseEnd":822.1999998092651,"responseStart":822.1999998092651,"secureConnectionStart":253.10000038146973},{"duration":569.3999996185303,"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":253.30000019073486,"connectEnd":253.30000019073486,"connectStart":253.30000019073486,"domainLookupEnd":253.30000019073486,"domainLookupStart":253.30000019073486,"fetchStart":253.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":253.30000019073486,"responseEnd":822.6999998092651,"responseStart":822.6999998092651,"secureConnectionStart":253.30000019073486},{"duration":569.5,"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":253.5,"connectEnd":253.5,"connectStart":253.5,"domainLookupEnd":253.5,"domainLookupStart":253.5,"fetchStart":253.5,"redirectEnd":0,"redirectStart":0,"requestStart":253.5,"responseEnd":823,"responseStart":823,"secureConnectionStart":253.5},{"duration":686.5,"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":253.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":253.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":940.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":569.5999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":253.9000005722046,"connectEnd":253.9000005722046,"connectStart":253.9000005722046,"domainLookupEnd":253.9000005722046,"domainLookupStart":253.9000005722046,"fetchStart":253.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":253.9000005722046,"responseEnd":823.5,"responseStart":823.5,"secureConnectionStart":253.9000005722046},{"duration":686.3000001907349,"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":254.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":254.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":940.4000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":570.1000003814697,"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":254.19999980926514,"connectEnd":254.19999980926514,"connectStart":254.19999980926514,"domainLookupEnd":254.19999980926514,"domainLookupStart":254.19999980926514,"fetchStart":254.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":254.19999980926514,"responseEnd":824.3000001907349,"responseStart":824.3000001907349,"secureConnectionStart":254.19999980926514},{"duration":782.8999996185303,"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":259.4000005722046,"connectEnd":259.4000005722046,"connectStart":259.4000005722046,"domainLookupEnd":259.4000005722046,"domainLookupStart":259.4000005722046,"fetchStart":259.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":259.4000005722046,"responseEnd":1042.3000001907349,"responseStart":1042.3000001907349,"secureConnectionStart":259.4000005722046},{"duration":1177.8999996185303,"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":264.4000005722046,"connectEnd":264.4000005722046,"connectStart":264.4000005722046,"domainLookupEnd":264.4000005722046,"domainLookupStart":264.4000005722046,"fetchStart":264.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":264.4000005722046,"responseEnd":1442.3000001907349,"responseStart":1442.3000001907349,"secureConnectionStart":264.4000005722046},{"duration":99.59999942779541,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":953.1000003814697,"connectEnd":953.1000003814697,"connectStart":953.1000003814697,"domainLookupEnd":953.1000003814697,"domainLookupStart":953.1000003814697,"fetchStart":953.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":953.1000003814697,"responseEnd":1052.6999998092651,"responseStart":1052.6999998092651,"secureConnectionStart":953.1000003814697},{"duration":255.60000038146973,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1238.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1238.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1493.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":224.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1239.1000003814697,"connectEnd":1239.1000003814697,"connectStart":1239.1000003814697,"domainLookupEnd":1239.1000003814697,"domainLookupStart":1239.1000003814697,"fetchStart":1239.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1239.1000003814697,"responseEnd":1464,"responseStart":1464,"secureConnectionStart":1239.1000003814697},{"duration":235.69999980926514,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1279,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1279,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1514.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":231.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":1239.6000003814697,"connectEnd":1239.6000003814697,"connectStart":1239.6000003814697,"domainLookupEnd":1239.6000003814697,"domainLookupStart":1239.6000003814697,"fetchStart":1239.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1239.6000003814697,"responseEnd":1471.1000003814697,"responseStart":1471.1000003814697,"secureConnectionStart":1239.6000003814697}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":75,"responseStart":246,"responseEnd":265,"domLoading":250,"domInteractive":1520,"domContentLoadedEventStart":1520,"domContentLoadedEventEnd":1570,"domComplete":2009,"loadEventStart":2009,"loadEventEnd":2009,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1495.1999998092651},{"name":"bigPipe.sidebar-id.end","time":1496.1000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":1496.3000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1498.1000003814697},{"name":"activityTabFullyLoaded","time":1593.5}],"measures":[],"correlationId":"d3d15ebaa73278","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":103,"dbReadsTimeInMs":15,"dbConnsTimeInMs":24,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}