From derby-user-return-12004-apmail-db-derby-user-archive=db.apache.org@db.apache.org Thu Dec 24 10:54:05 2009 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 71320 invoked from network); 24 Dec 2009 10:54:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 24 Dec 2009 10:54:05 -0000 Received: (qmail 98235 invoked by uid 500); 24 Dec 2009 10:54:04 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 98143 invoked by uid 500); 24 Dec 2009 10:54:03 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 98135 invoked by uid 99); 24 Dec 2009 10:54:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Dec 2009 10:54:03 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of gcaddu-derby-user@m.gmane.org designates 80.91.229.12 as permitted sender) Received: from [80.91.229.12] (HELO lo.gmane.org) (80.91.229.12) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Dec 2009 10:53:27 +0000 Received: from list by lo.gmane.org with local (Exim 4.50) id 1NNlJR-0006pV-Cy for derby-user@db.apache.org; Thu, 24 Dec 2009 11:52:57 +0100 Received: from p4FD3CA69.dip.t-dialin.net ([79.211.202.105]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 24 Dec 2009 11:52:57 +0100 Received: from Thomas.K.Hill by p4FD3CA69.dip.t-dialin.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 24 Dec 2009 11:52:57 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: derby-user@db.apache.org From: Thomas Hill Subject: ORDER BY in query when defining a VIEW Date: Thu, 24 Dec 2009 10:52:33 +0000 (UTC) Lines: 11 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: sea.gmane.org User-Agent: Loom/3.14 (http://gmane.org/) X-Loom-IP: 79.211.202.105 (Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6 (.NET CLR 3.5.30729)) Sender: news Hi, can anyone please confirm whether an order by clause is supported in derby 10.5.3 or not? The manuals contain no reference to this and reading through Jira I was under the impression that this should (now) be possible. However when trying to create a view using a select query which has an order by an error message Syntax Error: encountered "ORDER" is thrown. Omitting the Create View as and executing just the SQL query itself is working fine (so the SQL statement has no syntax problems). Thanks