Justification is different between Columnstore
To reproduce:
connect with mysql client.
|
Columnstore 1.1
|
|
MariaDB [(none)]> select 'blub',sum(3454435+43244);
|
+------+--------------------+
|
| blub | sum(3454435+43244) |
|
+------+--------------------+
|
| blub | 3497679 |
|
|
MariaDB 10.1
|
|
MariaDB [mysql]> select 'blub',sum(3454435+43244);
|
+------+--------------------+
|
| blub | sum(3454435+43244) |
|
+------+--------------------+
|
| blub | 3497679 |
|
+------+--------------------+
|
- duplicates
-
MDEV-15459
Window Functions seems to return string instead of numbers
-
-
Closed
{"report":{"fcp":1139.4000000059605,"ttfb":396.2000000178814,"pageVisibility":"visible","entityId":65813,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"ba83f51e-8a9f-426d-abff-4e8371060fcc","navigationType":0,"readyForUser":1213.6000000238419,"redirectCount":0,"resourceLoadedEnd":1661.1000000238419,"resourceLoadedStart":401.5,"resourceTiming":[{"duration":228.30000001192093,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":401.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":401.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":629.8000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":228.19999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":401.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":401.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":630,"responseStart":0,"secureConnectionStart":0},{"duration":287.40000000596046,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":402,"connectEnd":402,"connectStart":402,"domainLookupEnd":402,"domainLookupStart":402,"fetchStart":402,"redirectEnd":0,"redirectStart":0,"requestStart":402,"responseEnd":689.4000000059605,"responseStart":689.4000000059605,"secureConnectionStart":402},{"duration":353.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":402.10000002384186,"connectEnd":402.10000002384186,"connectStart":402.10000002384186,"domainLookupEnd":402.10000002384186,"domainLookupStart":402.10000002384186,"fetchStart":402.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":402.10000002384186,"responseEnd":755.6000000238419,"responseStart":755.6000000238419,"secureConnectionStart":402.10000002384186},{"duration":357,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":402.30000001192093,"connectEnd":402.30000001192093,"connectStart":402.30000001192093,"domainLookupEnd":402.30000001192093,"domainLookupStart":402.30000001192093,"fetchStart":402.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":402.30000001192093,"responseEnd":759.3000000119209,"responseStart":759.3000000119209,"secureConnectionStart":402.30000001192093},{"duration":357.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":402.5,"connectEnd":402.5,"connectStart":402.5,"domainLookupEnd":402.5,"domainLookupStart":402.5,"fetchStart":402.5,"redirectEnd":0,"redirectStart":0,"requestStart":402.5,"responseEnd":759.8000000119209,"responseStart":759.8000000119209,"secureConnectionStart":402.5},{"duration":357.40000000596046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":402.7000000178814,"connectEnd":402.7000000178814,"connectStart":402.7000000178814,"domainLookupEnd":402.7000000178814,"domainLookupStart":402.7000000178814,"fetchStart":402.7000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":402.7000000178814,"responseEnd":760.1000000238419,"responseStart":760.1000000238419,"secureConnectionStart":402.7000000178814},{"duration":427.40000000596046,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":402.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":402.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":830.2000000178814,"responseStart":0,"secureConnectionStart":0},{"duration":357.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":403,"connectEnd":403,"connectStart":403,"domainLookupEnd":403,"domainLookupStart":403,"fetchStart":403,"redirectEnd":0,"redirectStart":0,"requestStart":403,"responseEnd":760.6000000238419,"responseStart":760.6000000238419,"secureConnectionStart":403},{"duration":427.2999999821186,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":403.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":403.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":830.4000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":357.7000000178814,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":403.40000000596046,"connectEnd":403.40000000596046,"connectStart":403.40000000596046,"domainLookupEnd":403.40000000596046,"domainLookupStart":403.40000000596046,"fetchStart":403.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":403.40000000596046,"responseEnd":761.1000000238419,"responseStart":761.1000000238419,"secureConnectionStart":403.40000000596046},{"duration":850.3999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":408.60000002384186,"connectEnd":408.60000002384186,"connectStart":408.60000002384186,"domainLookupEnd":408.60000002384186,"domainLookupStart":408.60000002384186,"fetchStart":408.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":408.60000002384186,"responseEnd":1259,"responseStart":1259,"secureConnectionStart":408.60000002384186},{"duration":1252.4000000059605,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":408.7000000178814,"connectEnd":408.7000000178814,"connectStart":408.7000000178814,"domainLookupEnd":408.7000000178814,"domainLookupStart":408.7000000178814,"fetchStart":408.7000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":408.7000000178814,"responseEnd":1661.1000000238419,"responseStart":1661.1000000238419,"secureConnectionStart":408.7000000178814},{"duration":421.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":841.4000000059605,"connectEnd":841.4000000059605,"connectStart":841.4000000059605,"domainLookupEnd":841.4000000059605,"domainLookupStart":841.4000000059605,"fetchStart":841.4000000059605,"redirectEnd":0,"redirectStart":0,"requestStart":841.4000000059605,"responseEnd":1262.9000000059605,"responseStart":1262.9000000059605,"secureConnectionStart":841.4000000059605},{"duration":544.2999999821186,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1133.1000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1133.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1677.4000000059605,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":225,"responseStart":396,"responseEnd":403,"domLoading":399,"domInteractive":1679,"domContentLoadedEventStart":1679,"domContentLoadedEventEnd":1719,"domComplete":2146,"loadEventStart":2146,"loadEventEnd":2146,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1665.7000000178814},{"name":"bigPipe.sidebar-id.end","time":1666.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1666.7000000178814},{"name":"bigPipe.activity-panel-pipe-id.end","time":1667.7000000178814},{"name":"activityTabFullyLoaded","time":1732.1000000238419}],"measures":[],"correlationId":"ef6fe09923dad6","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":108,"dbReadsTimeInMs":17,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
