Re: ORDER BY in sub-query

Hello Hadley and list,

ORDER BY (and LIMIT/OFFSET for that matter) only control the overall shape of the query result set. Hence, they are indeed not supported within subqueries in MonetDB.

Best,

Hannes

On 10/04/2013 04:22 PM, Hadley Wickham wrote:

Currently, monetdb fails on this query:

SELECT * FROM (SELECT * FROM "Batting" ORDER BY "playerID")

with

syntax error, unexpected ORDER, expecting INTERSECT or EXCEPT or UNION or ')' in: "select * from (select *

(obviously that query isn't very useful, but it makes it harder to automatically generate sql)

In case it matters, that query (with minor escaping variations) works in sqlite, postgres and mysql.

Hadley