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.

Sign up for GitHub

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

Jump to bottom

How to use SQLITE_ENABLE_UPDATE_DELETE_LIMIT feature #787

Open
Qendolin opened this issue Feb 16, 2020 · 3 comments · May be fixed by #802
Open

How to use SQLITE_ENABLE_UPDATE_DELETE_LIMIT feature #787

Qendolin opened this issue Feb 16, 2020 · 3 comments · May be fixed by #802

Comments

@Qendolin
Copy link

#564 enabled the SQLITE_ENABLE_UPDATE_DELETE_LIMIT flag, however this comment mentions

Just adding the compile-time option is not sufficient. You would need a custom amalgamation.

so does this mean that #213 is not fixed?

How would I actually be able to use LIMIT and ORDER BY in an SQL statement now?
@Qendolin Qendolin changed the title How to use SQLITE_ENABLE_UPDATE_DELETE_LIMIT How to use SQLITE_ENABLE_UPDATE_DELETE_LIMIT feature Feb 16, 2020
@mattn
Copy link
Owner

mattn commented Feb 17, 2020 •
edited

Currently it does not work. So patch is welcome.

@Qendolin
Copy link
Author

I have no idea how to. I hope someone can help. 😃

@itizir
Copy link
Contributor

itizir commented Apr 14, 2020 •
edited

We've been using this for a while, but it involved us manually rebuilding the amalgamation indeed.

Seems like the easiest here would be to rewrite the upgrade.go script. I've had a go (sorry for the pun :( ) at rewriting it in bash: will push the change and make a PR.

@itizir itizir linked a pull request Apr 14, 2020 that will close this issue
Open
@joanlopez joanlopez mentioned this issue Sep 21, 2020
Closed
@aeneasr aeneasr mentioned this issue Jun 9, 2022
Merged
7 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Issue 787: enable SQLITE_ENABLE_UPDATE_DELETE_LIMIT itizir/go-sqlite3
3 participants
@mattn @itizir @Qendolin