Lines Matching refs:SELECT
14 # SELECT statements that use user-defined collation sequences. Also
26 # collate5-2.* - Compound SELECT
27 # collate5-3.* - ORDER BY on compound SELECT
58 SELECT DISTINCT a FROM collate5t1;
63 SELECT DISTINCT b FROM collate5t1;
68 SELECT DISTINCT a, b FROM collate5t1;
79 SELECT DISTINCT a FROM tkt3376;
89 SELECT DISTINCT a FROM tkt3376;
94 # The remainder of this file tests compound SELECT statements.
123 SELECT a FROM collate5t1 UNION select a FROM collate5t2;
128 SELECT a FROM collate5t2 UNION select a FROM collate5t1;
133 SELECT a, b FROM collate5t1 UNION select a, b FROM collate5t2;
138 SELECT a, b FROM collate5t2 UNION select a, b FROM collate5t1;
144 SELECT a FROM collate5t1 EXCEPT select a FROM collate5t2;
149 SELECT a FROM collate5t2 EXCEPT select a FROM collate5t1 WHERE a != 'a';
154 SELECT a, b FROM collate5t1 EXCEPT select a, b FROM collate5t2;
159 SELECT a, b FROM collate5t2 EXCEPT select a, b FROM collate5t1
166 SELECT a FROM collate5t1 INTERSECT select a FROM collate5t2;
171 SELECT a FROM collate5t2 INTERSECT select a FROM collate5t1 WHERE a != 'a';
176 SELECT a, b FROM collate5t1 INTERSECT select a, b FROM collate5t2;
181 SELECT a, b FROM collate5t2 INTERSECT select a, b FROM collate5t1;
188 # for the compound SELECT operators works with record lengths that lie
208 SELECT * FROM collate5t3 UNION SELECT * FROM collate5t3;
217 # These tests - collate5-3.* - focus on compound SELECT queries that
222 SELECT a FROM collate5t1 UNION ALL SELECT a FROM collate5t2 ORDER BY 1;
227 SELECT a FROM collate5t2 UNION ALL SELECT a FROM collate5t1 ORDER BY 1;
232 SELECT a FROM collate5t1 UNION ALL SELECT a FROM collate5t2
244 INSERT INTO collate5t_ct SELECT * FROM collate5t_cn;
249 SELECT a FROM collate5t_cn INTERSECT SELECT a FROM collate5t_ct ORDER BY 1;
254 SELECT a FROM collate5t_ct INTERSECT SELECT a FROM collate5t_cn ORDER BY 1;
278 SELECT a, count(*) FROM collate5t1 GROUP BY a;
283 SELECT a, b, count(*) FROM collate5t1 GROUP BY a, b ORDER BY a, b;
