Lines Matching refs:count

42     SELECT count(*) FROM t1;
46 # Do an SQL statement.  Append the search count to the end of the result.
48 proc count sql {
55 # and Next operators in the VDBE.  By verifing that the search count is
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}