SQLite Forum

Bug report: a bug in VIEW
Login
Thanks for the information.

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
> ~~~~

It seems that after introduced the ability to specify the column names of a view, the ability disappeared. So I can't figure out exactly which check-in introduced the problem.

Besides, there are some chech-in that can't compile, like [227bb8a181](https://sqlite.org/src/info/227bb8a181).

> ~~~~
sqlite3.c: In function ‘pagerFreeBitvecs’:
sqlite3.c:44125:30: error: ‘Pager’ {aka ‘struct Pager’} has no member named ‘pAllRead’
make: *** [Makefile:631:sqlite3.lo] error 1
> ~~~~