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
|
# name: test/sql/binder/alias_qualification_errors.test
# description: Negative tests for alias.name resolution
# group: [binder]
# forward reference should error
statement error
SELECT alias.x + 1 AS y, 1 AS x
----
Binder Error: Column "x" referenced that exists in the SELECT clause - but this column cannot be referenced before it is defined
# unknown alias should error
statement error
SELECT alias.nope;
----
Binder Error:
# alias to a subquery should error
statement error
SELECT (SELECT 1) AS x, alias.x
----
Alias "x" referenced in a SELECT clause - but the expression has a subquery. This is not yet supported
# alias ref with non-string argument should error already in the parsing phase
statement error
SELECT 5 as x, alias.123;
----
Parser Error: syntax error at or near ".123"
|
