Add support for aggregate functions (COUNT, SUM, etc)
Raise CR
Analysis
Execution
Raise CR
Analysis
Execution
Description
causes
relates to
Activity
Show:
Pieter Bos January 25, 2021 at 12:47 PM
In fact, the RM model has a notion of ordered objects - every DV_ORDERED for example. But I guess it’s ok not to support that here.
Matija Polajnar January 13, 2021 at 5:48 AM
Typo in multiple places: “Integer of Real”; you meant “Integer or Real”.
Diego Bosca January 11, 2021 at 7:24 PM
Funny thing is that most SQL implementations support min and max over strings (maybe just an alias of 'Select stringvalue from table order by stringvalue ASC|DESC limit 1')
In XQuery, min and max functions can be applied over any atomic type, i.e number types dates, times, string and even boolean
Thomas Beale January 11, 2021 at 7:02 PM
I would suggest that if MIN() and MAX() can be used with Strings in real world SQL implementations, then it’s ok for us (although weird for me!); but if not, I wouldn’t do it.
Diego Bosca January 11, 2021 at 12:43 PM
In fact as we use ISO dates order is directly related to string order
Done
Details
Details
Reporter
Sebastian Iancu
Sebastian IancuRaised By
Diego Bosca
Original estimate
Components
Affects versions
Created September 24, 2020 at 7:53 AM
Updated March 5, 2021 at 8:59 AM
Resolved March 5, 2021 at 8:59 AM
See https://discourse.openehr.org/t/aggregation-functions-count-sum-etc/989/2