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

Knut Anders

View raw message