-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution:
Fixed
-
Affects Version/s:
None
-
-
-
-
-
Proposal:
Hide
The output set is constructed by copying the instances of the input set and adding one dynamic property per compute expression to each instance of the input output set. The name of the added property is the alias following the as keyword. The value of the property is the value of the compute expression evaluated relative to that instance. Services MAY support expressions that address dynamic properties added by other expressions within the same compute transformation, provided that the service can determine an evaluation sequence.
Show
The output set is constructed by copying the instances of the input set and adding one dynamic property per compute expression to each instance of the input output set. The name of the added property is the alias following the as keyword. The value of the property is the value of the compute expression evaluated relative to that instance. Services MAY support expressions that address dynamic properties added by other expressions within the same compute transformation, provided that the service can determine an evaluation sequence.
-
Resolution:
Show
https://www.oasis-open.org/apps/org/workgroup/odata/download.php/70489/odata-data-aggregation-ext-v4.0-csd04.docx
It seems warranted that compute expressions can use dynamic properties that were computed by previous compute expressions, as in compute(A add B as C, C mul 2 as D).
And the sequence of the compute expressions should not matter, therefore compute(C mul 2 as D, A add B as C) should produce the same result. The server must determine an appropriate sequence in which to evaluate the compute expressions, or fail if a cycle is detected.
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"d6c2b596-8266-4dcf-95c8-9442c59db199","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":3155.5,"redirectCount":0,"resourceLoadedEnd":2972.7000002861023,"resourceLoadedStart":198.30000019073486,"resourceTiming":[{"duration":119.90000009536743,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":198.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":198.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":318.2000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":120.30000019073486,"initiatorType":"link","name":"https://issues.oasis-open.org/s/7d2823769c2e7b66e860863fe879b7f8-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/9aebb1c0aaa4c36289529757ec9dbb54/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":198.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":198.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":318.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":121.09999990463257,"initiatorType":"link","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/8.0.5/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":198.7000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":198.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":319.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":123.90000009536743,"initiatorType":"link","name":"https://issues.oasis-open.org/s/645acc233eb869f48a571293b8358a7d-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":198.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":198.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":322.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":123.90000009536743,"initiatorType":"link","name":"https://issues.oasis-open.org/s/a0dd6509771c1de0667aae5429c04cda-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":199,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":199,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":322.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":1000.7999997138977,"initiatorType":"script","name":"https://issues.oasis-open.org/s/e5479157e7a0c08b005e6522f2f04104-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":199.2000002861023,"connectEnd":963.6000003814697,"connectStart":915.9000000953674,"domainLookupEnd":915.9000000953674,"domainLookupStart":915.9000000953674,"fetchStart":199.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":963.8000001907349,"responseEnd":1200,"responseStart":1006.8000001907349,"secureConnectionStart":939.3000001907349},{"duration":2773.300000190735,"initiatorType":"script","name":"https://issues.oasis-open.org/s/83514d5d4e8543747b02042eafcdc99c-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/9aebb1c0aaa4c36289529757ec9dbb54/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":199.40000009536743,"connectEnd":1105.6000003814697,"connectStart":1057.9000000953674,"domainLookupEnd":1057.9000000953674,"domainLookupStart":1057.8000001907349,"fetchStart":199.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":1105.6000003814697,"responseEnd":2972.7000002861023,"responseStart":1133.3000001907349,"secureConnectionStart":1081.4000000953674},{"duration":1075.7000002861023,"initiatorType":"script","name":"https://issues.oasis-open.org/s/70bb2263e59e7e1f04fbd137c80b895b-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":199.5,"connectEnd":1248.3000001907349,"connectStart":1199.9000000953674,"domainLookupEnd":1199.9000000953674,"domainLookupStart":1199.9000000953674,"fetchStart":199.5,"redirectEnd":0,"redirectStart":0,"requestStart":1248.6000003814697,"responseEnd":1275.2000002861023,"responseStart":1274.3000001907349,"secureConnectionStart":1223.9000000953674},{"duration":1151.7999997138977,"initiatorType":"script","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":199.7000002861023,"connectEnd":1324,"connectStart":1275.1000003814697,"domainLookupEnd":1275.1000003814697,"domainLookupStart":1275.1000003814697,"fetchStart":199.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1324.2000002861023,"responseEnd":1351.5,"responseStart":1350.5,"secureConnectionStart":1299.2000002861023},{"duration":1227.4000000953674,"initiatorType":"script","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":199.90000009536743,"connectEnd":1400,"connectStart":1351.5,"domainLookupEnd":1351.5,"domainLookupStart":1351.4000000953674,"fetchStart":199.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":1400.1000003814697,"responseEnd":1427.3000001907349,"responseStart":1426.4000000953674,"secureConnectionStart":1375.5},{"duration":1302.7999997138977,"initiatorType":"script","name":"https://issues.oasis-open.org/s/cda37faab827dbdf305de8efe8282062-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/8.0.5/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":200.10000038146973,"connectEnd":1475.3000001907349,"connectStart":1427.2000002861023,"domainLookupEnd":1427.2000002861023,"domainLookupStart":1427.2000002861023,"fetchStart":200.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":1475.4000000953674,"responseEnd":1502.9000000953674,"responseStart":1501.9000000953674,"secureConnectionStart":1450.9000000953674},{"duration":126.7999997138977,"initiatorType":"link","name":"https://issues.oasis-open.org/s/07245784f53abc49bad9d9d4d36c577a-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/cadc4f20cc5c138dee060d42cf85f220/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":200.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":200.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":327,"responseStart":0,"secureConnectionStart":0},{"duration":1378.3000001907349,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":200.5,"connectEnd":1551.6000003814697,"connectStart":1502.8000001907349,"domainLookupEnd":1502.8000001907349,"domainLookupStart":1502.7000002861023,"fetchStart":200.5,"redirectEnd":0,"redirectStart":0,"requestStart":1551.6000003814697,"responseEnd":1578.8000001907349,"responseStart":1578,"secureConnectionStart":1526.9000000953674},{"duration":151.5,"initiatorType":"link","name":"https://issues.oasis-open.org/s/f77fd89aa211a76b20e9b0e63564383c-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/4a9288299d147101bf66484f4be48925/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":239.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":239.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":391,"responseStart":0,"secureConnectionStart":0},{"duration":1795,"initiatorType":"script","name":"https://issues.oasis-open.org/s/41525c48ddceeb9b11e54085268fc285-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/4a9288299d147101bf66484f4be48925/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":239.7000002861023,"connectEnd":2005.9000000953674,"connectStart":1957.1000003814697,"domainLookupEnd":1957.1000003814697,"domainLookupStart":1957.1000003814697,"fetchStart":239.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":2006,"responseEnd":2034.7000002861023,"responseStart":2033.1000003814697,"secureConnectionStart":1981},{"duration":2264.5999999046326,"initiatorType":"script","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":251.30000019073486,"connectEnd":2489.6000003814697,"connectStart":2441.4000000953674,"domainLookupEnd":2441.4000000953674,"domainLookupStart":2441.4000000953674,"fetchStart":251.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":2489.6000003814697,"responseEnd":2515.9000000953674,"responseStart":2514.800000190735,"secureConnectionStart":2465.300000190735},{"duration":2309.5,"initiatorType":"script","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":270.90000009536743,"connectEnd":2553.5,"connectStart":2505.2000002861023,"domainLookupEnd":2505.2000002861023,"domainLookupStart":2505.2000002861023,"fetchStart":270.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":2553.5,"responseEnd":2580.4000000953674,"responseStart":2579.4000000953674,"secureConnectionStart":2529},{"duration":965.8000001907349,"initiatorType":"xmlhttprequest","name":"https://issues.oasis-open.org/rest/webResources/1.0/resources","startTime":1325.4000000953674,"connectEnd":2261.7000002861023,"connectStart":2213.6000003814697,"domainLookupEnd":2213.6000003814697,"domainLookupStart":2213.6000003814697,"fetchStart":1325.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":2262.1000003814697,"responseEnd":2291.2000002861023,"responseStart":2290.2000002861023,"secureConnectionStart":2237.4000000953674}],"threshold":1000,"fetchStart":0,"domainLookupStart":11,"domainLookupEnd":23,"connectStart":23,"connectEnd":108,"secureConnectionStart":48,"requestStart":108,"responseStart":192,"responseEnd":271,"domLoading":197,"domInteractive":3207,"domContentLoadedEventStart":3207,"domContentLoadedEventEnd":3255,"domComplete":3584,"loadEventStart":3584,"loadEventEnd":3586,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"acf113742047d4","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":124,"dbReadsTimeInMs":16,"dbConnsTimeInMs":28,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
Note that SQL seems to require something like a subselect in order to reference a previously computed value. i.e., given a "users" table with firstName, lastName, and prefix columns, the following does not work:
though you could do something like: