SELECT query with LIMIT clause but no WHERE clause fails to parse.

[ivanceras]

This passes

SELECT id, fname, lname FROM customer WHERE 1 = 1 LIMIT 5

But this one fails:

SELECT id, fname, lname FROM customer LIMIT 5

[ivanceras]

It looks like limit keyword is interpreted as table alias since this invalid query parses.

SELECT id, fname, lname FROM customer LIMIT LIMIT 5

However, adding LIMIT to the reserved for table alias did NOT fix the issue.

[ivanceras]

Turns out I'm using and testing an older version of the code.
Well, so much for rubberducking. :)

No wait, It was actually the adding the LIMIT clause that fixed it, but had a typo in the test.
Aarggh!..

[dvaldivia]

Will this fix be released soon?

[benesch]

Hi @dvaldivia, I'm afraid I don't have a concrete answer for you, but there is a general sense that it's time for a new release soon (some details). I'll launch a new issue so we have somewhere to centralize this discussion.

[benesch]

Ok, I've filed https://github.com/andygrove/sqlparser-rs/issues/117 to continue the discussion.