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
