Bugs item #2872902, was opened at 2009-10-05 12:30
Message generated for change (Settings changed) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2872902&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
>Status: Closed
>Resolution: Rejected
Priority: 5
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: group by extract(day from date) fails
Initial Comment:
CREATE TABLE "sys"."test" (
"date" TIMESTAMP
);
INSERT INTO test VALUES ('2000-01-01 01:00:00.000000');
The following query return in an error:
select extract(year from date) from test group by extract(year from date) limit
10;
syntax error, unexpected EXTRACT in: "select extract(year from date) from test
group by extract"
While grouping over an alias in fact works:
select extract(year from date) as x from test group by x limit 10;
I would expect that the group by would allow the same kind of operations
without the actual column.
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2009-10-05 19:43
Message:
We don't allow for expressions in the group by.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2872902&group_id=56967
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
