Lines Matching refs:false
27 INSERT INTO t1 VALUES(1, true),(2, false),(3, null);
77 SELECT x FROM t1 WHERE false;
85 d BOOLEAN DEFAULT false,
86 e BOOLEAN DEFAULT(false)
96 c BOOLEAN DEFAULT(not false)
110 INSERT INTO t2 VALUES(1,true,false,null,null);
114 INSERT INTO t2 VALUES(2,false,false,null,null);
120 INSERT INTO t2 VALUES(2,true,false,true,null);
123 INSERT INTO t2 VALUES(2,true,false,null,false);
150 b BOOLEAN DEFAULT false,
154 INSERT INTO t7(a,b,c) VALUES(2,true,false);
155 ALTER TABLE t7 ADD COLUMN d BOOLEAN DEFAULT false;
157 INSERT INTO t7(a,b,c) VALUES(3,true,false);
158 INSERT INTO t7 VALUES(4,false,true,true,false);
180 SELECT 9 IN (false.false);
181 } {1 {no such column: false.false}}
183 CREATE TABLE t8(a INT, true INT, false INT, d INT);
184 INSERT INTO t8(a,true,false,d) VALUES(5,6,7,8),(4,3,2,1),('a','b','c','d');
185 SELECT * FROM t8 ORDER BY false;
188 SELECT 9 IN (false.false) FROM t8;
189 } {1 {no such column: false.false}}
191 CREATE TABLE false(true INT, false INT, x INT CHECK (5 IN (false.false)));
198 } {1 {CHECK constraint failed: 5 IN (false.false)}}
200 SELECT 9 IN (false.false) FROM false;
203 SELECT 5 IN (false.false) FROM false;