db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6009) Need stricter cheking of ORDER BY clause in VALUES expressions
Date Fri, 07 Dec 2012 10:15:24 GMT
Knut Anders Hatlen created DERBY-6009:

             Summary: Need stricter cheking of ORDER BY clause in VALUES expressions
                 Key: DERBY-6009
                 URL: https://issues.apache.org/jira/browse/DERBY-6009
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions:
            Reporter: Knut Anders Hatlen
            Priority: Minor

We only support column numbers in ORDER BY clauses in VALUES expression, as seen by this error

ij> values 1,2 order by 1+2;
ERROR 42878: The ORDER BY clause of a SELECT UNION statement only supports unqualified column
references and column position numbers. Other expressions are not currently supported. (errorCode
= 30000)

However, the checks let some unsupported expressions through and produce strange results.
For example:

ij> values 1 order by 1+2;
1          |2          
1          |3          

1 row selected

It should probably have raised the same exception as the first query. And if not, the result
should only have had one column.

And the next example should probably have raised a syntax error too, instead of a NullPointerException:

ij> values 1 order by int(1);
ERROR XJ001: Java exception: ': java.lang.NullPointerException'. (errorCode = 0)

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message