From derby-dev-return-99467-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Fri Dec 7 10:15:56 2012 Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 71EB1E0C5 for ; Fri, 7 Dec 2012 10:15:27 +0000 (UTC) Received: (qmail 85847 invoked by uid 500); 7 Dec 2012 10:15:27 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 85527 invoked by uid 500); 7 Dec 2012 10:15:26 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 83816 invoked by uid 99); 7 Dec 2012 10:15:24 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Dec 2012 10:15:24 +0000 Date: Fri, 7 Dec 2012 10:15:24 +0000 (UTC) From: "Knut Anders Hatlen (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (DERBY-6009) Need stricter cheking of ORDER BY clause in VALUES expressions MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 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: 10.9.1.0 Reporter: Knut Anders Hatlen Priority: Minor We only support column numbers in ORDER BY clauses in VALUES expression, as seen by this error message: 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