How to use SQLITE_ENABLE_UPDATE_DELETE_LIMIT feature

Open Qendolin opened this issue 5 years ago • 3 comments

https://github.com/mattn/go-sqlite3/pull/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?

Feb 16 '20 21:02 Qendolin

Currently it does not work. So patch is welcome.

Feb 17 '20 01:02 mattn

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

Feb 17 '20 10:02 Qendolin

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.

Apr 14 '20 16:04 itizir