db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: ORDER BY in query when defining a VIEW
Date Thu, 24 Dec 2009 22:05:58 GMT
Thomas Hill <Thomas.K.Hill@t-online.de> writes:

> 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).

Hi Thomas,

Derby 10.5.3 does not support ORDER BY in sub-queries or views. Support
for this was recently added to the development source tree, and it will
be supported in Derby 10.6.

Knut Anders

View raw message