Re: [sqlite] Infinite loop when updating indexed with case and where clause

Wow, > Bug fix is in. You can download the latest snapshot from > https://sqlite.org/download.html. > > Alternatively, you can apply the patch at > https://www.sqlite.org/src/info/feb2c2b6f66b0f45 to whatever prior > version of SQLite that you happen to be using. thanks a lot for this quick res

[sqlite] Infinite loop when updating indexed with case and where clause

Hi there, here is a weird behavior I observe with the following kind of setup: BEGIN TRANSACTION; CREATE TABLE simple("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "lft" INTEGER, "rgt" INTEGER); INSERT INTO simple VALUES(1,78,79); CREATE INDEX "index_on_lft" ON "simple" ("lft"); CREATE INDEX