Lines Matching refs:w

33     CREATE TABLE t1(w, x, y);
34     CREATE INDEX i1wxy ON t1(w,x,y);
59   count {SELECT rowid FROM t1 WHERE w IS NULL}
63   count {SELECT rowid FROM t1 WHERE w IS $null}
66   count {SELECT rowid FROM t1 WHERE +w IS NULL}
69   count {SELECT rowid FROM t1 WHERE w=1 AND x IS NULL}
72   count {SELECT rowid FROM t1 WHERE w=1 AND +x IS NULL}
75   count {SELECT rowid FROM t1 WHERE w=1 AND x>0}
78   count {SELECT rowid FROM t1 WHERE w=1 AND x<9}
81   count {SELECT rowid FROM t1 WHERE w=1 AND x IS NULL AND y=3}
84   count {SELECT rowid FROM t1 WHERE w=1 AND x IS NULL AND y>2}
87   count {SELECT rowid FROM t1 WHERE w='a' AND x IS NULL AND y='c'}
90   count {SELECT rowid FROM t1 WHERE w=x'78' AND x IS NULL}
93   count {SELECT rowid FROM t1 WHERE w=x'78' AND x IS NULL AND y=123}
96   count {SELECT rowid FROM t1 WHERE w=x'78' AND x IS NULL AND y=x'7A'}
99   count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL}
102   count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL AND y IS NULL}
105   count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL AND y<0}
108   count {SELECT rowid FROM t1 WHERE w IS NULL AND x IS NULL AND y>=0}
112   execsql {SELECT rowid FROM t1 ORDER BY w, x, y}
115   execsql {SELECT rowid FROM t1 ORDER BY w DESC, x, y}
118   execsql {SELECT rowid FROM t1 ORDER BY w, x DESC, y}