Re: [sqlite] BUG with unnecessary brackets in queries with IN ( SELECT .. )

Gesendet: Mittwoch, 11. Juni 2014 um 10:29 Uhr Von: RSmith An: sqlite-users@sqlite.org Betreff: Re: [sqlite] BUG with unnecessary brackets in queries with IN ( SELECT .. ) >On 2014/06/11 07:48, be...@web.de wrote: Simple example : Working (correct result)

Re: [sqlite] BUG with unnecessary brackets in queries with IN ( SELECT .. )

On 2014/06/11 07:48, be...@web.de wrote: Simple example : Working (correct result) select id from tbl where id in (select id from tbl) NOT working (incorrect result) : select id from tbl where id in ( ( select id from tbl) ) In the first query, SQLite looks for values of "id" that are in

[sqlite] BUG with unnecessary brackets in queries with IN ( SELECT .. )

>Von: "Richard Hipp" >An: "General Discussion of SQLite Database" >Betreff: Re: [sqlite] BUG with unnecessary brackets in queries with IN ( >SELECT .. ) >On Sun, Jun 8, 2014 at 7:52 PM, Martin Hristov wrote: > >> Simple example : >>

Re: [sqlite] BUG with unnecessary brackets in queries with IN ( SELECT .. )

On Sun, Jun 8, 2014 at 7:52 PM, Martin Hristov wrote: > Simple example : > > Working (correct result) > select id from tbl where id in (select id from tbl) > > NOT working (incorrect result) : > select id from tbl where id in ( ( select id from tbl) ) > In the first query,

[sqlite] BUG with unnecessary brackets in queries with IN ( SELECT .. )

Simple example : Working (correct result) select id from tbl where id in (select id from tbl) NOT working (incorrect result) : select id from tbl where id in ( ( select id from tbl) ) ___ sqlite-users mailing list sqlite-users@sqlite.org