Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"LIMIT %%limit int%%" in MySQL #394

Open
ras0q opened this issue Jun 16, 2023 · 0 comments
Open

"LIMIT %%limit int%%" in MySQL #394

ras0q opened this issue Jun 16, 2023 · 0 comments

Comments

@ras0q
Copy link

ras0q commented Jun 16, 2023

ref: #123

In #123, you mentioned that it is impossible to use LIMIT %%limit int%% (same for OFFSET %%offset int%%) on MySQL, can you fix it in the following way? Maybe these methods involve breaking changes.

  • Change the regular expression in ParseQueryFields to, for example, [^%]+%%[^%]+%% so that LIMIT %%limit int%% can be detected
  • Replace LIMIT in introspection query's nth with 0 instead of NULL when LIMIT is forward
  • Add a syntax like %%limit int,as_limit%%
  • and so on...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant