Type:
Priority:
Resolution:
Fixed
sql_yacc.yy has this grammar:
join_table:
...
| table_ref NATURAL inner_join table_factor
| table_ref LEFT opt_outer JOIN_SYM table_factor USING ...
| table_ref NATURAL LEFT opt_outer JOIN_SYM table_factor
| table_ref RIGHT opt_outer JOIN_SYM table_factor USING ...
| table_ref NATURAL RIGHT opt_outer JOIN_SYM table_factor ...
table_factor:
table_ident opt_use_partition opt_table_alias opt_key_definition
| select_derived_init get_select_lex select_derived2
| '('opt_with_clause get_select_lex select_derived_union ')' opt_table_alias
The branch in table_factor that starts with "select_derived" represents a non-parenthesized SELECT query and cannot appear in the rights side of "join_table". For example, this query is syntactically incorrect:
SELECT * FROM t1 NATURAL JOIN SELECT * FROM t2;
There must be parentheses around the right SELECT.
Under term of this task we'll remove the impossible part from table_factor.
There are no comments yet on this issue.
{"report":{"fcp":730.4000000953674,"ttfb":227.59999990463257,"pageVisibility":"visible","entityId":56752,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"68287629-1412-42e1-a417-7f0d742a1ac1","navigationType":0,"readyForUser":785.5,"redirectCount":0,"resourceLoadedEnd":393.30000019073486,"resourceLoadedStart":234.80000019073486,"resourceTiming":[{"duration":5.699999809265137,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":234.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":234.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":240.5,"responseStart":0,"secureConnectionStart":0},{"duration":7.800000190734863,"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":235.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":235.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":242.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":58.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":235.19999980926514,"connectEnd":235.19999980926514,"connectStart":235.19999980926514,"domainLookupEnd":235.19999980926514,"domainLookupStart":235.19999980926514,"fetchStart":235.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":243.90000009536743,"responseEnd":294,"responseStart":256.40000009536743,"secureConnectionStart":235.19999980926514},{"duration":74.09999990463257,"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":235.40000009536743,"connectEnd":235.40000009536743,"connectStart":235.40000009536743,"domainLookupEnd":235.40000009536743,"domainLookupStart":235.40000009536743,"fetchStart":235.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":244.69999980926514,"responseEnd":309.5,"responseStart":262.59999990463257,"secureConnectionStart":235.40000009536743},{"duration":35.200000286102295,"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":235.59999990463257,"connectEnd":235.59999990463257,"connectStart":235.59999990463257,"domainLookupEnd":235.59999990463257,"domainLookupStart":235.59999990463257,"fetchStart":235.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":245.69999980926514,"responseEnd":270.80000019073486,"responseStart":270.09999990463257,"secureConnectionStart":235.59999990463257},{"duration":35.80000019073486,"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":235.69999980926514,"connectEnd":235.69999980926514,"connectStart":235.69999980926514,"domainLookupEnd":235.69999980926514,"domainLookupStart":235.69999980926514,"fetchStart":235.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":246.5,"responseEnd":271.5,"responseStart":270.90000009536743,"secureConnectionStart":235.69999980926514},{"duration":40.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":235.90000009536743,"connectEnd":235.90000009536743,"connectStart":235.90000009536743,"domainLookupEnd":235.90000009536743,"domainLookupStart":235.90000009536743,"fetchStart":235.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":248.09999990463257,"responseEnd":276.09999990463257,"responseStart":275.59999990463257,"secureConnectionStart":235.90000009536743},{"duration":10.800000190734863,"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":236,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":236,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":246.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":12.199999809265137,"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":236.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":236.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":248.5,"responseStart":0,"secureConnectionStart":0},{"duration":39.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":236.30000019073486,"connectEnd":236.30000019073486,"connectStart":236.30000019073486,"domainLookupEnd":236.30000019073486,"domainLookupStart":236.30000019073486,"fetchStart":236.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":250.19999980926514,"responseEnd":275.5,"responseStart":274.90000009536743,"secureConnectionStart":236.30000019073486},{"duration":43.59999990463257,"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":236.5,"connectEnd":236.5,"connectStart":236.5,"domainLookupEnd":236.5,"domainLookupStart":236.5,"fetchStart":236.5,"redirectEnd":0,"redirectStart":0,"requestStart":251.30000019073486,"responseEnd":280.09999990463257,"responseStart":279.30000019073486,"secureConnectionStart":236.5},{"duration":139.7000002861023,"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":253.59999990463257,"connectEnd":253.59999990463257,"connectStart":253.59999990463257,"domainLookupEnd":253.59999990463257,"domainLookupStart":253.59999990463257,"fetchStart":253.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":265,"responseEnd":393.30000019073486,"responseStart":389.90000009536743,"secureConnectionStart":253.59999990463257},{"duration":138.89999961853027,"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":253.80000019073486,"connectEnd":253.80000019073486,"connectStart":253.80000019073486,"domainLookupEnd":253.80000019073486,"domainLookupStart":253.80000019073486,"fetchStart":253.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":268.90000009536743,"responseEnd":392.69999980926514,"responseStart":388.69999980926514,"secureConnectionStart":253.80000019073486},{"duration":158.30000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":496,"connectEnd":496,"connectStart":496,"domainLookupEnd":496,"domainLookupStart":496,"fetchStart":496,"redirectEnd":0,"redirectStart":0,"requestStart":615.5,"responseEnd":654.3000001907349,"responseStart":653.3000001907349,"secureConnectionStart":496},{"duration":112.40000009536743,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":703.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":703.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":815.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":149.69999980926514,"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":834,"responseEnd":871.5999999046326,"responseStart":870.6999998092651,"secureConnectionStart":721.9000000953674}],"fetchStart":0,"domainLookupStart":4,"domainLookupEnd":47,"connectStart":47,"connectEnd":68,"secureConnectionStart":56,"requestStart":68,"responseStart":228,"responseEnd":253,"domLoading":231,"domInteractive":833,"domContentLoadedEventStart":833,"domContentLoadedEventEnd":866,"domComplete":1302,"loadEventStart":1302,"loadEventEnd":1302,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":817.4000000953674},{"name":"bigPipe.sidebar-id.end","time":818.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":818.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":819},{"name":"activityTabFullyLoaded","time":872.8000001907349}],"measures":[],"correlationId":"9485cdf7e34e97","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":93,"dbReadsTimeInMs":11,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Task
Major
