Add support for aggregate functions (COUNT, SUM, etc)

Confluence content

mentioned on

Web links

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

Reporter

Raised 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

Flag notifications