search

LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
52 stars 24 forks source link

[FRG-94] Need to support empty set in GROUP BY #776

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[reporter="jack", created="Wed, 22 Mar 2006 13:01:16 -0500 (GMT-05:00)"] 2003 spec allows for an empty group set by using an empty set of parens. Ex. SELECT deptno FROM emps GROUP BY ()

------- Comment #1 From Jack Frost 2005-03-08 17:50 [reply] -------
2003 SQL allows for specification of an empty set in a GROUP BY clause. The empty set is specified using an empty set of parens.Ex. SELECT deptno FROM emps GROUP BY ()

------- Comment #2 From Julian Hyde 2005-03-08 23:04 [reply] -------
JVS, fyi. I had never heard of this feature! Pays to read the spec, I guess.

dynamobi-build commented 12 years ago

[author="jhyde", created="Wed, 14 Jun 2006 15:59:59 -0500 (GMT-05:00)"] Fixed in change 6908.