MariaDB [test]> select distinct apply_time from test ORDER BY id limit 1;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2022: ORDER BY column not in DISTINCT list.
MariaDB ColumnStore is a columnar orientated storage engine instead of row orientated. `id` isn't referenced in the query so that column isn't accessed and there is no data for it to process. It therefore cannot execute an ORDER BY on that column. Whereas if it was row orientated that column would be available in the intermediate results.
Andrew Hutchings (Inactive)
added a comment - MariaDB ColumnStore is a columnar orientated storage engine instead of row orientated. `id` isn't referenced in the query so that column isn't accessed and there is no data for it to process. It therefore cannot execute an ORDER BY on that column. Whereas if it was row orientated that column would be available in the intermediate results.
Re-opening as this is valid SQL, we don't support today but i think it's reasonable to consider this as a future improvement.
David Thompson (Inactive)
added a comment - Re-opening as this is valid SQL, we don't support today but i think it's reasonable to consider this as a future improvement.
People
Kirill Perov (Inactive)
hiller1
Votes:
0Vote for this issue
Watchers:
5Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":872.5999999046326,"ttfb":226,"pageVisibility":"visible","entityId":64334,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"a59462a9-4b2a-40f5-8a1e-ae336b52a85c","navigationType":0,"readyForUser":940.1999999284744,"redirectCount":0,"resourceLoadedEnd":569.6999999284744,"resourceLoadedStart":237.89999997615814,"resourceTiming":[{"duration":6.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":237.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":237.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":244.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":6.600000023841858,"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":238.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":238.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":244.69999992847443,"responseStart":0,"secureConnectionStart":0},{"duration":204.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":238.29999995231628,"connectEnd":238.29999995231628,"connectStart":238.29999995231628,"domainLookupEnd":238.29999995231628,"domainLookupStart":238.29999995231628,"fetchStart":238.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":250.69999992847443,"responseEnd":442.5,"responseStart":272.89999997615814,"secureConnectionStart":238.29999995231628},{"duration":331.39999997615814,"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":238.29999995231628,"connectEnd":238.29999995231628,"connectStart":238.29999995231628,"domainLookupEnd":238.29999995231628,"domainLookupStart":238.29999995231628,"fetchStart":238.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":250.79999995231628,"responseEnd":569.6999999284744,"responseStart":273.39999997615814,"secureConnectionStart":238.29999995231628},{"duration":8.699999928474426,"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":238.5,"connectEnd":238.5,"connectStart":238.5,"domainLookupEnd":238.5,"domainLookupStart":238.5,"fetchStart":238.5,"redirectEnd":0,"redirectStart":0,"requestStart":238.5,"responseEnd":247.19999992847443,"responseStart":247.19999992847443,"secureConnectionStart":238.5},{"duration":45.89999997615814,"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":238.5,"connectEnd":238.5,"connectStart":238.5,"domainLookupEnd":238.5,"domainLookupStart":238.5,"fetchStart":238.5,"redirectEnd":0,"redirectStart":0,"requestStart":251.89999997615814,"responseEnd":284.39999997615814,"responseStart":282.2999999523163,"secureConnectionStart":238.5},{"duration":45.5,"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":238.69999992847443,"connectEnd":238.69999992847443,"connectStart":238.69999992847443,"domainLookupEnd":238.69999992847443,"domainLookupStart":238.69999992847443,"fetchStart":238.69999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":253.09999990463257,"responseEnd":284.1999999284744,"responseStart":281.5,"secureConnectionStart":238.69999992847443},{"duration":12.5,"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":238.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":238.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":251.29999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":47.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":238.89999997615814,"connectEnd":238.89999997615814,"connectStart":238.89999997615814,"domainLookupEnd":238.89999997615814,"domainLookupStart":238.89999997615814,"fetchStart":238.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":260.5,"responseEnd":286.39999997615814,"responseStart":282.89999997615814,"secureConnectionStart":238.89999997615814},{"duration":14,"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":239,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":239,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":253,"responseStart":0,"secureConnectionStart":0},{"duration":47.60000002384186,"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":239.09999990463257,"connectEnd":239.09999990463257,"connectStart":239.09999990463257,"domainLookupEnd":239.09999990463257,"domainLookupStart":239.09999990463257,"fetchStart":239.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":261.59999990463257,"responseEnd":286.6999999284744,"responseStart":284.6999999284744,"secureConnectionStart":239.09999990463257},{"duration":324.7000000476837,"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":239.79999995231628,"connectEnd":239.79999995231628,"connectStart":239.79999995231628,"domainLookupEnd":239.79999995231628,"domainLookupStart":239.79999995231628,"fetchStart":239.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":314,"responseEnd":564.5,"responseStart":559.0999999046326,"secureConnectionStart":239.79999995231628},{"duration":323.5,"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":241.89999997615814,"connectEnd":241.89999997615814,"connectStart":241.89999997615814,"domainLookupEnd":241.89999997615814,"domainLookupStart":241.89999997615814,"fetchStart":241.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":324.6999999284744,"responseEnd":565.3999999761581,"responseStart":560.1999999284744,"secureConnectionStart":241.89999997615814},{"duration":54.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":587.2999999523163,"connectEnd":587.2999999523163,"connectStart":587.2999999523163,"domainLookupEnd":587.2999999523163,"domainLookupStart":587.2999999523163,"fetchStart":587.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":607.5,"responseEnd":641.7999999523163,"responseStart":641,"secureConnectionStart":587.2999999523163},{"duration":96.10000002384186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":792.7999999523163,"connectEnd":792.7999999523163,"connectStart":792.7999999523163,"domainLookupEnd":792.7999999523163,"domainLookupStart":792.7999999523163,"fetchStart":792.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":792.7999999523163,"responseEnd":888.8999999761581,"responseStart":888.8999999761581,"secureConnectionStart":792.7999999523163},{"duration":136.20000004768372,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":865.6999999284744,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":865.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1001.8999999761581,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":44,"domainLookupEnd":53,"connectStart":53,"connectEnd":73,"secureConnectionStart":62,"requestStart":73,"responseStart":226,"responseEnd":237,"domLoading":229,"domInteractive":987,"domContentLoadedEventStart":987,"domContentLoadedEventEnd":1025,"domComplete":1205,"loadEventStart":1205,"loadEventEnd":1205,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":970.0999999046326},{"name":"bigPipe.sidebar-id.end","time":970.8999999761581},{"name":"bigPipe.activity-panel-pipe-id.start","time":971.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":972.0999999046326},{"name":"activityTabFullyLoaded","time":1040.5}],"measures":[],"correlationId":"57c1cfc70e40e6","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":90,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
New Feature
Major
MariaDB ColumnStore is a columnar orientated storage engine instead of row orientated. `id` isn't referenced in the query so that column isn't accessed and there is no data for it to process. It therefore cannot execute an ORDER BY on that column. Whereas if it was row orientated that column would be available in the intermediate results.