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

On 17 Jan 2018, at 8:40am, Christian Höhne wrote: > Please unsubscribe me. This list is run by computer. At the bottom of every post, including this one, is a link which will allow you to unsubscribe yourself. Simon. ___

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

Please unsubscribe me. Christian Hoehne Il 16 gen 2018 13:34, "Harald Klimach" ha scritto: > 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,

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

> On 1/16/18, Don V Nielsen wrote: > > Off topic question regarding fix: "0!=(wctrlFlags & WHERE_ONEPASS_MULTIROW)" > > > > Is there a performance bonus or compiler optimization if one compares a > > target constant to a source condition versus comparing a target condition

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

On 1/16/18, 8:12 AM, "sqlite-users on behalf of Don V Nielsen" wrote: > Off topic question regarding fix: "0!=(wctrlFlags & WHERE_ONEPASS_MULTIROW)" > Is there a performance bonus or compiler optimization if one

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

On 1/16/18, Don V Nielsen wrote: > Off topic question regarding fix: "0!=(wctrlFlags & WHERE_ONEPASS_MULTIROW)" > > Is there a performance bonus or compiler optimization if one compares a > target constant to a source condition versus comparing a target condition > to a

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

Off topic question regarding fix: "0!=(wctrlFlags & WHERE_ONEPASS_MULTIROW)" Is there a performance bonus or compiler optimization if one compares a target constant to a source condition versus comparing a target condition to a source constant, as in "(wctrlFlags & WHERE_ONEPASS_MULTIROW)!=0"?

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

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

On 1/16/18, Harald Klimach wrote: > > here is a weird behavior I observe with the following kind of setup: > Bug fix is in. You can download the latest snapshot from https://sqlite.org/download.html. Alternatively, you can apply the patch at

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

Thanks for the bug report! A ticket for this issue is here: https://www.sqlite.org/src/tktview/47b2581aa9bfececa7d95b2ef2aa433418c7a583 I will post another message as soon as we have it fixed. On 1/16/18, Harald Klimach wrote: > Hi there, > > here is a weird behavior I

[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