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

2018-01-17 Thread Simon Slavin
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. ___ sqlite-users mailing list

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

2018-01-17 Thread Christian Höhne
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, "lft" > INTEGER, "rgt" IN

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

2018-01-16 Thread Andreas Kupries
> 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 source constan

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

2018-01-16 Thread Peter Da Silva
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 compares a > target constant to a source condition versus comparing a target condit

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

2018-01-16 Thread Richard Hipp
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 source constant, as in "(wc

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

2018-01-16 Thread Don V Nielsen
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"? Th

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

2018-01-16 Thread Harald Klimach
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

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

2018-01-16 Thread Richard Hipp
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 https://www.sqlite.org/src/info/feb2c2b6f66b0f45 to w

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

2018-01-16 Thread Richard Hipp
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 observe with the followin

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

2018-01-16 Thread Harald Klimach
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