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;
>
> CREATE VIEW X AS
>
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
https://www.sqlite.org/src
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 'B',
3 matches
Mail list logo