subject:"\[sqlite\] SQL logic anomaly"

Re: [sqlite] SQL logic anomaly

2016-12-01 Thread Richard Hipp

On 12/1/16, Mark Brand wrote: > Hi, > > Using SQLite version 3.15.2, the following SQL returns 0 rows, whereas > I believe it should return 1 row. Any of the commented out alternatives > produces the expected 1 row. > > Mark > > CREATE VIEW W AS > SELECT 0 show_a; > >

Re: [sqlite] SQL logic anomaly

2016-12-01 Thread Richard Hipp

On 12/1/16, Mark Brand wrote: > > Using SQLite version 3.15.2, the following SQL returns 0 rows, whereas > I believe it should return 1 row. Any of the commented out alternatives > produces the expected 1 row. Thanks for the clear and concise bug report. The ticket is

[sqlite] SQL logic anomaly

2016-12-01 Thread Mark Brand

Hi, Using SQLite version 3.15.2, the following SQL returns 0 rows, whereas I believe it should return 1 row. Any of the commented out alternatives produces the expected 1 row. Mark CREATE VIEW W AS SELECT 0 show_a; CREATE VIEW X AS SELECT 'A' a, 1 v UNION SELECT