[Sqlalchemy-tickets] Issue #4284: SQLite only dialect to enforce an offset with a limit clause (zzzeek/sqlalchemy)

[John B. <iss...@bi...>]

New issue 4284: SQLite only dialect to enforce an offset with a limit clause
https://bitbucket.org/zzzeek/sqlalchemy/issues/4284/sqlite-only-dialect-to-enforce-an-offset

John Bodley:

It seems that some dialects which support a limit offset (like [MySQL](https://bitbucket.org/zzzeek/sqlalchemy/src/c352257070e17baada280befd2beae15ee26f4d0/lib/sqlalchemy/dialects/mysql/base.py?at=master&fileviewer=file-view-default#base.py-1101)) only define it when the provided offset is non-None, however in the case of SQLite the generated SQL always includes an offset (default of zero) if a limit clause is present per [here](https://bitbucket.org/zzzeek/sqlalchemy/src/c352257070e17baada280befd2beae15ee26f4d0/lib/sqlalchemy/dialects/sqlite/base.py?at=master&fileviewer=file-view-default#base.py-843).

I was wondering why this was especially as in SQLite an offset is deemed optional.