PROCEDURE clause is not allowed in UNION. Previously, an attempt to use it caused a decent error ER_WRONG_USAGE. But now it causes either a syntax error on a release build, or an assertion failure on a debug build:
Stack trace from 10.2 025c4ec191e46719d3c51af6ee7a0ecc7a7dd335
|
mysqld: /data/src/10.2/sql/sql_parse.cc:7489: bool mysql_new_select(LEX*, bool): Assertion `lex->proc_list.elements == 0' failed.
|
160912 15:05:21 [ERROR] mysqld got signal 6 ;
|
...
|
#6 0x00007fb45cd4c266 in __assert_fail_base (fmt=0x7fb45ce85238 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7fb45ff1eadd "lex->proc_list.elements == 0", file=file@entry=0x7fb45ff1d658 "/data/src/10.2/sql/sql_parse.cc", line=line@entry=7489, function=function@entry=0x7fb45ff1fd00 <mysql_new_select(LEX*, bool)::__PRETTY_FUNCTION__> "bool mysql_new_select(LEX*, bool)") at assert.c:92
|
#7 0x00007fb45cd4c312 in __GI___assert_fail (assertion=0x7fb45ff1eadd "lex->proc_list.elements == 0", file=0x7fb45ff1d658 "/data/src/10.2/sql/sql_parse.cc", line=7489, function=0x7fb45ff1fd00 <mysql_new_select(LEX*, bool)::__PRETTY_FUNCTION__> "bool mysql_new_select(LEX*, bool)") at assert.c:101
|
#8 0x00007fb45f5dc347 in mysql_new_select (lex=0x7fb454019a50, move_down=false) at /data/src/10.2/sql/sql_parse.cc:7489
|
#9 0x00007fb45f7a7bed in add_select_to_union_list (lex=0x7fb454019a50, is_union_distinct=true, is_top_level=true) at /data/src/10.2/sql/sql_yacc.yy:707
|
#10 0x00007fb45f7d176b in MYSQLparse (thd=0x7fb454016070) at /data/src/10.2/sql/sql_yacc.yy:16092
|
#11 0x00007fb45f5e15f3 in parse_sql (thd=0x7fb454016070, parser_state=0x7fb46052cdd0, creation_ctx=0x0, do_pfs_digest=true) at /data/src/10.2/sql/sql_parse.cc:9793
|
#12 0x00007fb45f5dcfd7 in mysql_parse (thd=0x7fb454016070, rawbuf=0x7fb454064088 "( SELECT * FROM t1 PROCEDURE ANALYSE( 10, 10 ) ) \nUNION\n( SELECT * FROM t1 PROCEDURE ANALYSE( 10, 10 ) )", length=104, parser_state=0x7fb46052cdd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7727
|
#13 0x00007fb45f5cb555 in dispatch_command (command=COM_QUERY, thd=0x7fb454016070, packet=0x7fb454058071 "( SELECT * FROM t1 PROCEDURE ANALYSE( 10, 10 ) ) \nUNION\n( SELECT * FROM t1 PROCEDURE ANALYSE( 10, 10 ) )", packet_length=104, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1805
|
#14 0x00007fb45f5c9f86 in do_command (thd=0x7fb454016070) at /data/src/10.2/sql/sql_parse.cc:1365
|
#15 0x00007fb45f705912 in do_handle_one_connection (connect=0x7fb45c46d410) at /data/src/10.2/sql/sql_connect.cc:1354
|
#16 0x00007fb45f70569f in handle_one_connection (arg=0x7fb45c46d410) at /data/src/10.2/sql/sql_connect.cc:1260
|
#17 0x00007fb45fa13ea4 in pfs_spawn_thread (arg=0x7fb45c4519f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#18 0x00007fb45ec4e0a4 in start_thread (arg=0x7fb46052e300) at pthread_create.c:309
|
#19 0x00007fb45ce0687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Test case
|
CREATE TABLE t1 (i INT);
|
|
--error ER_WRONG_USAGE
|
( SELECT * FROM t1 PROCEDURE ANALYSE( 10, 10 ) )
|
UNION
|
( SELECT * FROM t1 PROCEDURE ANALYSE( 10, 10 ) );
|
It started happening after recent merges.
{"report":{"fcp":814.4000000953674,"ttfb":120.20000004768372,"pageVisibility":"visible","entityId":58019,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"2839187b-3b55-4cd6-b793-c0518b37b701","navigationType":0,"readyForUser":875.4000000953674,"redirectCount":0,"resourceLoadedEnd":1153.5,"resourceLoadedStart":125.40000009536743,"resourceTiming":[{"duration":258.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":125.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":125.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":383.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":258,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":125.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":125.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":383.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":267,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":125.70000004768372,"connectEnd":125.70000004768372,"connectStart":125.70000004768372,"domainLookupEnd":125.70000004768372,"domainLookupStart":125.70000004768372,"fetchStart":125.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":125.70000004768372,"responseEnd":392.7000000476837,"responseStart":392.7000000476837,"secureConnectionStart":125.70000004768372},{"duration":291.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":125.79999995231628,"connectEnd":125.79999995231628,"connectStart":125.79999995231628,"domainLookupEnd":125.79999995231628,"domainLookupStart":125.79999995231628,"fetchStart":125.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":125.79999995231628,"responseEnd":417.59999990463257,"responseStart":417.59999990463257,"secureConnectionStart":125.79999995231628},{"duration":295.39999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":125.90000009536743,"connectEnd":125.90000009536743,"connectStart":125.90000009536743,"domainLookupEnd":125.90000009536743,"domainLookupStart":125.90000009536743,"fetchStart":125.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":125.90000009536743,"responseEnd":421.2999999523163,"responseStart":421.2999999523163,"secureConnectionStart":125.90000009536743},{"duration":295.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":126,"connectEnd":126,"connectStart":126,"domainLookupEnd":126,"domainLookupStart":126,"fetchStart":126,"redirectEnd":0,"redirectStart":0,"requestStart":126,"responseEnd":421.7000000476837,"responseStart":421.7000000476837,"secureConnectionStart":126},{"duration":296,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":126.09999990463257,"connectEnd":126.09999990463257,"connectStart":126.09999990463257,"domainLookupEnd":126.09999990463257,"domainLookupStart":126.09999990463257,"fetchStart":126.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":126.09999990463257,"responseEnd":422.09999990463257,"responseStart":422.09999990463257,"secureConnectionStart":126.09999990463257},{"duration":296.2000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":126.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":126.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":422.5,"responseStart":0,"secureConnectionStart":0},{"duration":296.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":126.29999995231628,"connectEnd":126.29999995231628,"connectStart":126.29999995231628,"domainLookupEnd":126.29999995231628,"domainLookupStart":126.29999995231628,"fetchStart":126.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":126.29999995231628,"responseEnd":422.5,"responseStart":422.5,"secureConnectionStart":126.29999995231628},{"duration":296.59999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":126.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":126.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":423.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":296.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":126.59999990463257,"connectEnd":126.59999990463257,"connectStart":126.59999990463257,"domainLookupEnd":126.59999990463257,"domainLookupStart":126.59999990463257,"fetchStart":126.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":126.59999990463257,"responseEnd":423.09999990463257,"responseStart":423.09999990463257,"secureConnectionStart":126.59999990463257},{"duration":467.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":131.70000004768372,"connectEnd":131.70000004768372,"connectStart":131.70000004768372,"domainLookupEnd":131.70000004768372,"domainLookupStart":131.70000004768372,"fetchStart":131.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":131.70000004768372,"responseEnd":598.9000000953674,"responseStart":598.9000000953674,"secureConnectionStart":131.70000004768372},{"duration":1021.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":131.70000004768372,"connectEnd":131.70000004768372,"connectStart":131.70000004768372,"domainLookupEnd":131.70000004768372,"domainLookupStart":131.70000004768372,"fetchStart":131.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":131.70000004768372,"responseEnd":1153.5,"responseStart":1153.5,"secureConnectionStart":131.70000004768372},{"duration":420.7999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":620.9000000953674,"connectEnd":620.9000000953674,"connectStart":620.9000000953674,"domainLookupEnd":620.9000000953674,"domainLookupStart":620.9000000953674,"fetchStart":620.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":620.9000000953674,"responseEnd":1041.7000000476837,"responseStart":1041.7000000476837,"secureConnectionStart":620.9000000953674},{"duration":414.40000009536743,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":793.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":793.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1208,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":120,"responseEnd":126,"domLoading":123,"domInteractive":1171,"domContentLoadedEventStart":1171,"domContentLoadedEventEnd":1204,"domComplete":1793,"loadEventStart":1793,"loadEventEnd":1794,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1155},{"name":"bigPipe.sidebar-id.end","time":1155.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1155.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1158.0999999046326},{"name":"activityTabFullyLoaded","time":1209.7000000476837}],"measures":[],"correlationId":"d61a411de1c453","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":66,"dbReadsTimeInMs":10,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}