Lines Matching refs:v4

296     CREATE VIEW v4 AS SELECT * FROM t4;
297     SELECT a FROM v4 ORDER BY 1;
302     SELECT b FROM v4 ORDER BY 1;
309     SELECT a FROM t4 UNION SELECT a FROM v4 ORDER BY 1;
314     SELECT b FROM t4 UNION SELECT a FROM v4 ORDER BY 1;
316 } {1 2 11 12 1 11 12 2}  ;# text from t4.b and numeric from v4.a
319     SELECT a FROM t4 UNION SELECT b FROM v4 ORDER BY 1;
321 } {1 2 11 12 1 11 12 2} ;# numeric from t4.a and text from v4.b
324     SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1;
333 #    SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE numeric;
338 #    SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE integer;
343 #    SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE text;
348 #    SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE blob;
353 #    SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE clob;
358 #    SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE varchar;