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
On 10/26/18, Sebastian Zwack wrote:
>
> Out of curiosity, why do in-memory and file based differ here? Are these
> query optimizations only done for the in-memory db?
>
I observe the problem regardless of whether the database is on-disk or
in-memory. Perhaps your system is somehow using a differ
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
A preliminary fix for this problem is here:
https://www.sqlite.org/src/info/5d5b596f152bb278
I have more testing and analysis to do before I close the ticket, but
my current belief is that this is the correct fix. I don't know yet
whether or not this justifies a patched 3.25.3 release.
Seba
On 10/25/18, R Smith wrote:
>
> CREATE TABLE x(a, b, c);
> CREATE TABLE y(a, b);
> INSERT INTO x VALUES (1, 0, 1);
> INSERT INTO y VALUES (1, 2);
>
> SELECT x.a FROM x JOIN y ON x.c = y.a WHERE x.b = 1 AND x.b = 1;
It also starts working if you remove the redundant x.b=1 constraint:
SELECT x.a
In case it helps...
This problem can be distilled to simply:
CREATE TABLE x(a, b, c);
CREATE TABLE y(a, b);
INSERT INTO x VALUES (1, 0, 1);
INSERT INTO y VALUES (1, 2);
SELECT x.a FROM x JOIN y ON x.c = y.a WHERE x.b = 1 AND x.b = 1;
-- a
--
-- 1 (Not excpected)
On 10/25/18, Sebastian Zwack wrote:
> Hi,
>
> when performing a simple join and duplicating the where clause I get invalid
> rows back.
Thanks for the bug report and test case. The ticket for this issue is
here: https://www.sqlite.org/src/tktview/cf5ed20fc8621b165
>
> SQLite version 3.25.2
>
>
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
8 matches
Mail list logo
