db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <knut.hat...@oracle.com>
Subject Re: Problems in using parentheses with UNION ALL STATEMENTS
Date Mon, 03 Jun 2013 21:24:02 GMT
smadin <ara.liyanage@gmail.com> writes:

> I use UNION ALL to join these statements. But my problem is, sql exception
> is thrown saying that there is a problem in ORDER clause when statements are
> separated using parentheses.
> " java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at
> line 1, column xxx." 

Hi smadin,

Which version of Derby are you using? ORDER BY in operands of UNION ALL
was not supported until very recently, in version 10.10.1.1.

-- 
Knut Anders

Mime
View raw message