1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
PRAGMA YqlSelect = 'force';
WITH x (a) AS (SELECT 1)
SELECT * FROM x;
WITH x (a, b) AS (SELECT 1, '2')
SELECT * FROM x;
WITH x (a, b) AS (SELECT 1 AS a, '2' AS b)
SELECT * FROM x;
WITH x (a, b) AS (SELECT 1 AS b, '2' AS a)
SELECT * FROM x;
WITH x (a, b) AS (SELECT 1 AS c, '2' AS d)
SELECT * FROM x;
WITH x (a, b) AS (
SELECT 1 AS a, '2' AS b
UNION ALL
SELECT 11 AS a, '22' AS b
)
SELECT * FROM x;
WITH x (a, b) AS (
SELECT 1, '2'
UNION ALL
SELECT 11, '22'
)
SELECT * FROM x;
|
