On 10/25/18, Sebastian Zwack <[email protected]> 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 > > 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) ); > INSERT INTO user VALUES (1, 0, 1); > INSERT INTO account VALUES (1, 'test'); > > -- returns user 1, expecting no results > SELECT user.id FROM user INNER JOIN account ON user.account = account.id > WHERE user.active = 1 AND user.active = 1; > -- returns user 1, expecting no results > SELECT user.id FROM user INNER JOIN account ON user.account = account.id > WHERE user.active = True AND user.active = True; > -- returns no results, expecting no results > SELECT user.id FROM user INNER JOIN account ON user.account = account.id > WHERE user.active is True AND user.active is True; > > INSERT INTO user VALUES (2, 1, 2); > INSERT INTO account VALUES (2, ''); > > -- returns [1, 2], expecting 1 > SELECT user.id FROM user INNER JOIN account ON user.account = account.id > WHERE user.active = 1 AND user.active = 1; > > This only affects the in-memory db, file based is working correctly. Do I > miss something? > > Regards > Sebastian > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
