sql-tests/inputs/table-aliases.sql

0001 -- Test data.
0002 CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES (1, 1), (1, 2), (2, 1) AS testData(a, b);
0003
0004 -- Table column aliases in FROM clause
0005 SELECT * FROM testData AS t(col1, col2) WHERE col1 = 1;
0006
0007 SELECT * FROM testData AS t(col1, col2) WHERE col1 = 2;
0008
0009 SELECT col1 AS k, SUM(col2) FROM testData AS t(col1, col2) GROUP BY k;
0010
0011 -- Aliasing the wrong number of columns in the FROM clause
0012 SELECT * FROM testData AS t(col1, col2, col3);
0013
0014 SELECT * FROM testData AS t(col1);
0015
0016 -- Check alias duplication
0017 SELECT a AS col1, b AS col2 FROM testData AS t(c, d);
0018
0019 -- Subquery aliases in FROM clause
0020 SELECT * FROM (SELECT 1 AS a, 1 AS b) t(col1, col2);
0021
0022 -- Aliases for join relations in FROM clause
0023 CREATE OR REPLACE TEMPORARY VIEW src1 AS SELECT * FROM VALUES (1, "a"), (2, "b"), (3, "c") AS src1(id, v1);
0024
0025 CREATE OR REPLACE TEMPORARY VIEW src2 AS SELECT * FROM VALUES (2, 1.0), (3, 3.2), (1, 8.5) AS src2(id, v2);
0026
0027 SELECT * FROM (src1 s1 INNER JOIN src2 s2 ON s1.id = s2.id) dst(a, b, c, d);