Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
10.5
Explicit ROW definition does not allow rows with one member.
But anchored definitions using ROW TYPE OF (or using %ROWTYPE with sql_type=ORACLE) do allow creation of rows with a single member.
Such variables fail to compare:
CREATE OR REPLACE TABLE t1 (a INT );
INSERT INTO t1 VALUES (1);
DELIMITER $$
BEGIN NOT ATOMIC
DECLARE v1 ROW TYPE OF t1;
SELECT * FROM t1 INTO v1;
SELECT v1=v1;
END ;
$$
ERROR 1241 (21000): Operand should contain 1 column(s)
The expected result is to perform comparison like it's done for rows with two or more elements.
relates to
MDEV-34317
DECLARE TYPE type_name IS RECORD (..) with scalar members in stored routines
Closed
There are no comments yet on this issue.
{"report":{"fcp":1066.6999998092651,"ttfb":255.09999990463257,"pageVisibility":"visible","entityId":131378,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"18d62d12-3cc5-4790-b0f2-4b8a72b79b86","navigationType":0,"readyForUser":1143.5999999046326,"redirectCount":0,"resourceLoadedEnd":1581.2999997138977,"resourceLoadedStart":261,"resourceTiming":[{"duration":360.7999997138977,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":261,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":261,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":621.7999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":360.6000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":261.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":261.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":621.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":386.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/c54b129276d75dc2a3460e1d78f37913-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":261.40000009536743,"connectEnd":261.40000009536743,"connectStart":261.40000009536743,"domainLookupEnd":261.40000009536743,"domainLookupStart":261.40000009536743,"fetchStart":261.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":261.40000009536743,"responseEnd":648.0999999046326,"responseStart":648.0999999046326,"secureConnectionStart":261.40000009536743},{"duration":483.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/f867843cd2fdb209d4d1d4f760f86346-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":261.5,"connectEnd":261.5,"connectStart":261.5,"domainLookupEnd":261.5,"domainLookupStart":261.5,"fetchStart":261.5,"redirectEnd":0,"redirectStart":0,"requestStart":261.5,"responseEnd":744.5999999046326,"responseStart":744.5999999046326,"secureConnectionStart":261.5},{"duration":486.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/ffdb17665775c5b4d6f097f3974ee359-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":261.69999980926514,"connectEnd":261.69999980926514,"connectStart":261.69999980926514,"domainLookupEnd":261.69999980926514,"domainLookupStart":261.69999980926514,"fetchStart":261.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":261.69999980926514,"responseEnd":748.5,"responseStart":748.5,"secureConnectionStart":261.69999980926514},{"duration":487.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":261.69999980926514,"connectEnd":261.69999980926514,"connectStart":261.69999980926514,"domainLookupEnd":261.69999980926514,"domainLookupStart":261.69999980926514,"fetchStart":261.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":261.69999980926514,"responseEnd":748.9000000953674,"responseStart":748.9000000953674,"secureConnectionStart":261.69999980926514},{"duration":487.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":261.7999997138977,"connectEnd":261.7999997138977,"connectStart":261.7999997138977,"domainLookupEnd":261.7999997138977,"domainLookupStart":261.7999997138977,"fetchStart":261.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":261.7999997138977,"responseEnd":749.4000000953674,"responseStart":749.4000000953674,"secureConnectionStart":261.7999997138977},{"duration":488.2999997138977,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":261.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":261.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":750.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":487.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":262,"connectEnd":262,"connectStart":262,"domainLookupEnd":262,"domainLookupStart":262,"fetchStart":262,"redirectEnd":0,"redirectStart":0,"requestStart":262,"responseEnd":749.7999997138977,"responseStart":749.7999997138977,"secureConnectionStart":262},{"duration":488.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/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":262.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":262.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":750.5,"responseStart":0,"secureConnectionStart":0},{"duration":488.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/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":262.19999980926514,"connectEnd":262.19999980926514,"connectStart":262.19999980926514,"domainLookupEnd":262.19999980926514,"domainLookupStart":262.19999980926514,"fetchStart":262.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":262.19999980926514,"responseEnd":750.4000000953674,"responseStart":750.4000000953674,"secureConnectionStart":262.19999980926514},{"duration":1132.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":263,"connectEnd":263,"connectStart":263,"domainLookupEnd":263,"domainLookupStart":263,"fetchStart":263,"redirectEnd":0,"redirectStart":0,"requestStart":263,"responseEnd":1395.2999997138977,"responseStart":1395.2999997138977,"secureConnectionStart":263},{"duration":1318.1999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":263.09999990463257,"connectEnd":263.09999990463257,"connectStart":263.09999990463257,"domainLookupEnd":263.09999990463257,"domainLookupStart":263.09999990463257,"fetchStart":263.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":263.09999990463257,"responseEnd":1581.2999997138977,"responseStart":1581.2999997138977,"secureConnectionStart":263.09999990463257},{"duration":588.4000000953674,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":807.2999997138977,"connectEnd":807.2999997138977,"connectStart":807.2999997138977,"domainLookupEnd":807.2999997138977,"domainLookupStart":807.2999997138977,"fetchStart":807.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":807.2999997138977,"responseEnd":1395.6999998092651,"responseStart":1395.6999998092651,"secureConnectionStart":807.2999997138977},{"duration":545.6999998092651,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1060.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1060.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1605.7999997138977,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":123,"responseStart":255,"responseEnd":258,"domLoading":259,"domInteractive":1599,"domContentLoadedEventStart":1599,"domContentLoadedEventEnd":1638,"domComplete":2387,"loadEventStart":2387,"loadEventEnd":2388,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1582.7999997138977},{"name":"bigPipe.sidebar-id.end","time":1583.7999997138977},{"name":"bigPipe.activity-panel-pipe-id.start","time":1583.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1584.4000000953674},{"name":"activityTabFullyLoaded","time":1641.7999997138977}],"measures":[],"correlationId":"27e90757ae5275","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":68,"dbReadsTimeInMs":11,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}