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