Alternative formulation: > ~~~~ CREATE TABLE t0(a , b INT); INSERT INTO t0 VALUES (NULL, 1); CREATE VIEW v0(c) AS SELECT b FROM t0 EXCEPT SELECT a FROM t0; CREATE VIEW v1 AS SELECT b AS 'c' FROM t0 EXCEPT SELECT a FROM t0; SELECT (c NOT BETWEEN '-1' AND c) AS 'x' FROM v0; -- 1 SELECT (c NOT BETWEEN '-1' AND c) AS 'x' FROM v1; -- 0 ~~~~ The problem bisects to [d794b34da6f9c77d] (2015-08-24) which is the check-in that introduced the ability to specify the column names of a view. First appeared in version 3.9.0.