SQLite Forum

Bug report: a bug in VIEW
Login
When I am on [bed42116ad](https://sqlite.org/src/info/bed42116ad), which is later than [d794b34da6](https://sqlite.org/src/info/d794b34da6), SQLite prompts an error message:

> ~~~~
./sqlite3 test.db
SQLite version 3.8.6 2014-08-16 19:01:00
Enter ".help" for usage hints.
sqlite> CREATE TABLE t0(a , b INT);
sqlite> INSERT INTO t0 VALUES (NULL, 1);
sqlite> CREATE VIEW v0(c) AS SELECT b FROM t0 EXCEPT SELECT a FROM t0;
Error: near "(": syntax error
sqlite> CREATE VIEW v1 AS SELECT b AS 'c' FROM t0 EXCEPT SELECT a FROM t0;
sqlite> SELECT (c NOT BETWEEN '-1' AND c) AS 'x' FROM v0; -- 1
Error: no such table: v0
sqlite> SELECT (c NOT BETWEEN '-1' AND c) AS 'x' FROM v1; -- 0
0
> ~~~~

So I can't figure out exactly which check-in introduced the problem.