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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
# name: test/sql/prepared/prepared_select.test
# description: Test order of unmarked prepared statements in select
# group: [prepared]
# select - from - where with subquery
statement ok
PREPARE s1 AS SELECT ?::VARCHAR FROM (SELECT ?::INTEGER) tbl(i) WHERE i > ?::INTEGER
query I
EXECUTE s1('hello', 2, 1)
----
hello
# select - from - where - groupby - having
statement ok
PREPARE s2 AS
SELECT FIRST(?::VARCHAR)
FROM (VALUES (?::INTEGER)) tbl(i)
WHERE i > ?::INTEGER
GROUP BY i % ?::INTEGER
HAVING SUM(i)::VARCHAR <> ?::VARCHAR
query I
EXECUTE s2('hello', 2, 1, 2, 'blabla')
----
hello
query I
EXECUTE s2('hello', 2, 1, 2, '2')
----
# union
statement ok
PREPARE s3 AS
SELECT LENGTH(?::VARCHAR)
UNION ALL
SELECT ?::INTEGER
ORDER BY 1
query I
EXECUTE s3('hello', 3)
----
3
5
# IN clause
statement ok
PREPARE s4 AS SELECT ?::INTEGER IN (?::INTEGER, ?::INTEGER, ?::INTEGER)
query I
EXECUTE s4(1, 2, 3, 1)
----
1
# IN clause with subquery
statement ok
PREPARE s5 AS SELECT ?::INTEGER IN (SELECT i FROM (VALUES (?::INTEGER), (?::INTEGER), (?::INTEGER)) tbl(i))
query I
EXECUTE s5(1, 2, 3, 1)
----
1
|
