[MonetDB-users] LIMIT clause not recognized in nested query in FROM clause

7 Feb 2012

      Hi,

it appears that clauses like LIMIT or OFFSET are not allowed if the
query is used inside a FROM clause. The following query throws an error:

    SELECT *
    FROM 
      (
        SELECT id
        FROM corpus
        LIMIT 10
      ) AS inner_table;

The error message is:

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

Cheers,
Viktor

Viktor Rosenfeld