Lines Matching refs:a1
927 CREATE TABLE a1(one PRIMARY KEY, two);
928 INSERT INTO a1 VALUES(1, 1);
929 INSERT INTO a1 VALUES(2, 3);
930 INSERT INTO a1 VALUES(3, 6);
931 INSERT INTO a1 VALUES(4, 10);
940 1 "SELECT one, two, count(*) FROM a1" {1 1 4}
941 2 "SELECT one, two, count(*) FROM a1 WHERE one<3" {1 1 2}
942 3 "SELECT one, two, count(*) FROM a1 WHERE one>3" {4 10 1}
943 4 "SELECT *, count(*) FROM a1 JOIN a2" {1 1 1 1 16}
944 5 "SELECT *, sum(three) FROM a1 NATURAL JOIN a2" {1 1 1 3}
945 6 "SELECT *, sum(three) FROM a1 NATURAL JOIN a2" {1 1 1 3}
946 7 "SELECT group_concat(three, ''), a1.* FROM a1 NATURAL JOIN a2" {12 1 1}
954 1 "SELECT one, two, count(*) FROM a1 WHERE 0" {{} {} 0}
955 2 "SELECT sum(two), * FROM a1, a2 WHERE three>5" {{} {} {} {} {}}
956 3 "SELECT max(one) IS NULL, one IS NULL, two IS NULL FROM a1 WHERE two=7" {
966 8.1 "SELECT count(*) FROM a1"
967 8.2 "SELECT count(*) FROM a1 WHERE 0"
968 8.3 "SELECT count(*) FROM a1 WHERE 1"
969 8.4 "SELECT max(a1.one)+min(two), a1.one, two, * FROM a1, a2 WHERE 1"
970 8.5 "SELECT max(a1.one)+min(two), a1.one, two, * FROM a1, a2 WHERE 0"