db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen (JIRA) <j...@apache.org>
Subject [jira] Created: (DERBY-2085) Misleading error message for non-matching ORDER BY clause in queries with GROUP BY.
Date Wed, 15 Nov 2006 09:44:39 GMT
Misleading error message for non-matching ORDER BY clause in queries with GROUP BY.
-----------------------------------------------------------------------------------

                 Key: DERBY-2085
                 URL: http://issues.apache.org/jira/browse/DERBY-2085
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.2.1.6
         Environment: Any
            Reporter: Øystein Grøvlen
            Priority: Trivial


In 10.2, this query gives the following error message:

ij> SELECT i FROM t GROUP BY i ORDER BY j;
ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression.
If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and
valid aggregate expressions.  

This is misleading since there is no invalid expression in the SELECT
list.  It is the ORDER BY clause that is wrong.  

I have marked this as an regression since the error message in 10.1 is
more helpful (but still not correct):

ij> SELECT i FROM t GROUP BY i ORDER BY j;
ERROR 42Y36: Column reference 'J' is invalid.  For a SELECT list with a GROUP BY, the list
may only contain grouping columns and valid aggregate expressions.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

Mime
View raw message