[sqlite] Incorrect query result

2019-08-14 Thread Eric Boudaillier
Hi, I am experiencing incorrect query result with SQLite 3.25.2 and 3.28. Attached are the database and a Tcl script running 3 queries. The database and the queries have been reduced to the minimum, so they are not really relevant, but demonstrates better where is the problem. Also note that the r

[sqlite] Incorrect query result

2019-09-27 Thread Eric Boudaillier
Hi, I am experiencing incorrect query result with SQLite 3.25.2 and 3.28. The database and the queries have been reduced to the minimum, so they are not really relevant, but demonstrates better where is the problem. Also note that the result is correct using SQLite 3.15.2. Using the following tab

Re: [sqlite] Incorrect query result

2019-08-14 Thread Jay Kreibich
Alas, the mailing list does not allow attachments. -j > On Aug 14, 2019, at 8:24 AM, Eric Boudaillier > wrote: > > Hi, > > I am experiencing incorrect query result with SQLite 3.25.2 and 3.28. > Attached are the database and a Tcl script running 3 queries. > The database and the queries ha

Re: [sqlite] Incorrect query result

2019-09-27 Thread Richard Hipp
On 9/27/19, Eric Boudaillier wrote: > > I am experiencing incorrect query result with SQLite 3.25.2 and 3.28. This problem was resolved by check-in https://sqlite.org/src/info/74ef97bf51dd531a which was included in release 3.29.0. The same fix is also found in on branch-3.28 (https://sqlite.org/