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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
# name: test/sql/subquery/table/test_unnamed_subquery.test
# description: Test unnamed subqueries
# group: [table]
statement ok
PRAGMA enable_verification
query I
SELECT a FROM (SELECT 42 a)
----
42
query II
SELECT * FROM (SELECT 42 a), (SELECT 43 b)
----
42 43
query II
SELECT * FROM (VALUES (42, 43))
----
42 43
# longer chains
query IIII
SELECT * FROM (SELECT 42 a), (SELECT 43 b), (SELECT 44 c), (SELECT 45 d)
----
42 43 44 45
# nested
query IIII
SELECT * FROM (FROM (SELECT 42 a), (SELECT 43 b)) JOIN (SELECT 44 c) ON (true) JOIN (SELECT 45 d) ON (true)
----
42 43 44 45
# names are predictable
query II
SELECT * FROM (SELECT unnamed_subquery.a FROM (SELECT 42 a)), (SELECT unnamed_subquery.b FROM (SELECT 43 b))
----
42 43
# names are predictable
query II
SELECT unnamed_subquery.a, unnamed_subquery2.b FROM (SELECT 42 a), (SELECT 43 b)
----
42 43
|
