|Title:||OFFSET ignored if there is no FROM clause|
|Last Modified:||2014-03-21 18:16:34|
|Version Found In:||18.104.22.168|
drh added on 2014-03-21 18:04:05:
The following SQL unexpectedly gives a single row of output: <blockquote><verbatim> SELECT 1,2,3 LIMIT 1 OFFSET 25; </verbatim></blockquote> This problem was discovered during internal testing and analysis and has not been observed in the wild. The problem is believed to have been in the code for a very long time.