Re: [sqlite] unusual but trivially reproducible bug

but trivially reproducible bug Summary: Leaving out the space after the word 'limit' causes the limit clause to be ignored. I've reproduced it on version 3.19.2 2017-05-25 16:50:27 edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9 A sample output is below. On one hand

Re: [sqlite] unusual but trivially reproducible bug

On 6/18/17, Robert Cousins wrote: > Summary: > Leaving out the space after the word 'limit' causes the limit > clause to be ignored. Not a syntax error. Omitting the space makes the parser think that "limit1" is an alias for the final table name - the equivalent of:

Re: [sqlite] unusual but trivially reproducible bug

It's not a bug, you're setting up a table alias called "limit2". The "AS" keyword is optional, but this is the same as: select * from foo AS limit1; Ketil On 18 June 2017 at 21:19, Robert Cousins wrote: > Summary: > Leaving out the space after the word 'limit' causes

Re: [sqlite] unusual but trivially reproducible bug

Not a bug. Instead of a keyword, you've defined an alias for the table named "limit1". On Jun 19, 2017 4:00 AM, "Robert Cousins" wrote: > Summary: > Leaving out the space after the word 'limit' causes the limit > clause to be ignored. > I've reproduced it on version

[sqlite] unusual but trivially reproducible bug

Summary: Leaving out the space after the word 'limit' causes the limit clause to be ignored. I've reproduced it on version 3.19.2 2017-05-25 16:50:27 edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9 A sample output is below. On one hand, this is a failure to catch