summaryrefslogtreecommitdiffstats
path: root/tests/fixtures/optimizer/qualify_tables.sql
blob: 2cea85d40d39a8d1f25e98017e5fa793073a16ce (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
SELECT 1 FROM z;
SELECT 1 FROM c.db.z AS z;

SELECT 1 FROM y.z;
SELECT 1 FROM c.y.z AS z;

SELECT 1 FROM x.y.z;
SELECT 1 FROM x.y.z AS z;

SELECT 1 FROM x.y.z AS z;
SELECT 1 FROM x.y.z AS z;

WITH a AS (SELECT 1 FROM z) SELECT 1 FROM a;
WITH a AS (SELECT 1 FROM c.db.z AS z) SELECT 1 FROM a;

SELECT (SELECT y.c FROM y AS y) FROM x;
SELECT (SELECT y.c FROM c.db.y AS y) FROM c.db.x AS x;