Feature Requests item #2632114, was opened at 2009-02-24 01:56 Message generated for change (Comment added) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2632114&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 - general Group: Next Release (example) Status: Open Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) >Assigned to: Niels Nes (nielsnes) Summary: E121-03 Value expressions in ORDER BY clause Initial Comment: MonetDB currently does not support <http://monetdb.cwi.nl/SQL/Documentation/SQL-Features.html> E121-03 Value expressions in ORDER BY clause. This SQL99 syntax consist of for example: ORDER BY count(something) ASC ---------------------------------------------------------------------- >Comment By: Stefan de Konink (skinkie) Date: 2009-02-24 08:43 Message: Oh, I see...the TopCount function is generating this. Yes, E121-03 (Value expressions in ORDER BY clause) is the relevant feature. The <order by> scoping rules are subtle because of this feature; you can find them in SQL:2003 Part 2, Section 14.1 <declare cursor>. We think we have them correctly implemented in the Eigenbase validator. JVS ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2632114&group_id=56967 ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
