Invalid syntax near OFFSET

Question

Invalid syntax near OFFSET

AdamSLevy opened this issue 6 years ago · 5 comments

If SelectStmt.OffsetCount is >= 0 but SelectStmt.LimitCount is = -1, then OFFSET will be added to the SQL statement when interpolated.

This is invalid SQL syntax because OFFSET may only be used following a LIMIT clause.

Answer 1 · 2019-06-22T16:00:57.000Z

could you create a separate PR for this? thanks!

Answer 2 · 2019-06-23T00:40:09.000Z

I'm sorry but are you asking me to have a separate PR for each individual issue? Because my PR solves more than one issue... which is pretty common.

Answer 3 · 2019-08-22T01:17:30.000Z

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

Answer 4 · 2019-08-22T01:18:13.000Z

It is not stale.

…

On Wed, Aug 21, 2019, 5:17 PM stale[bot] ***@***.***> wrote: This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#173?email_source=notifications&email_token=ABOZO4HQXDR3YMFJJHXKVKLQFXSKZA5CNFSM4HJA6F22YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD43SH5A#issuecomment-523707380>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABOZO4HCYAE7AUOB4MK3ZZDQFXSKZANCNFSM4HJA6F2Q> .

Answer 5 · 2019-10-15T17:03:16.000Z

This is allowed in postgres but not in mysql, and it is a weird design choice that mysql cannot have offset without limit. The current code is good enough.