Re: [sqlite] Invalid results on join and duplicate where clause (in-memory db only)

2018-10-29 Thread Sebastian Zwack
On 10/26/18, Richard Hipp wrote: > I observe the problem regardless of whether the database is on-disk or > in-memory. Perhaps your system is somehow using a different (older) > version of SQLite that predates the problem when accessing database > file from disk? Yes, was using an UI which connec

Re: [sqlite] Invalid results on join and duplicate where clause (in-memory db only)

2018-10-26 Thread Sebastian Zwack
On Thu, Oct 25, 2018, at 16:20, Richard Hipp wrote: > Sebastian: Presumably this problem arose for you in a much larger and > more complex application. Can you please apply the patch from the > check-in above (or recompile using the latest trunk version of SQLite) > and verify for us that this fi

[sqlite] Invalid results on join and duplicate where clause (in-memory db only)

2018-10-25 Thread Sebastian Zwack
Hi, when performing a simple join and duplicating the where clause I get invalid rows back. SQLite version 3.25.2 CREATE TABLE user ( id INTEGER NOT NULL, active INTEGER NOT NULL, account INTEGER, PRIMARY KEY(id) ); CREATE TABLE account ( id INTEGER NOT NULL, name TEXT, PRIMARY KEY(id) ); INSE