# E051-08: Correlation names in the FROM clause

# statement ok
# CREATE TABLE TABLE_E051_08_01_01 ( ID INT PRIMARY KEY, A INT, B INT );

# sqlparser-rs unsupported
# query III
# SELECT * AS ( C, D, E ) FROM TABLE_E051_08_01_01 AS MYTEMP

statement ok
CREATE TABLE TABLE_E051_08_01_02 ( ID INT PRIMARY KEY, A INT, B INT );

query III
SELECT * FROM TABLE_E051_08_01_02 AS MYTEMP

# statement ok
# CREATE TABLE TABLE_E051_08_01_03 ( ID INT PRIMARY KEY, A INT, B INT );

# sqlparser-rs unsupported
# query III
# SELECT ALL * AS ( C, D, E ) FROM TABLE_E051_08_01_03 AS MYTEMP

statement ok
CREATE TABLE TABLE_E051_08_01_04 ( ID INT PRIMARY KEY, A INT, B INT );

query III
SELECT ALL * FROM TABLE_E051_08_01_04 AS MYTEMP

# statement ok
# CREATE TABLE TABLE_E051_08_01_05 ( ID INT PRIMARY KEY, A INT, B INT );

# sqlparser-rs unsupported
# query III
# SELECT ALL MYTEMP . * AS ( C, D, E ) FROM TABLE_E051_08_01_05 AS MYTEMP

statement ok
CREATE TABLE TABLE_E051_08_01_06 ( ID INT PRIMARY KEY, A INT, B INT );

query III
SELECT ALL MYTEMP . * FROM TABLE_E051_08_01_06 AS MYTEMP

# statement ok
# CREATE TABLE TABLE_E051_08_01_07 ( ID INT PRIMARY KEY, A INT, B INT );

# sqlparser-rs unsupported
# query III
# SELECT DISTINCT * AS ( C, D, E ) FROM TABLE_E051_08_01_07 AS MYTEMP

statement ok
CREATE TABLE TABLE_E051_08_01_08 ( ID INT PRIMARY KEY, A INT, B INT );

query III
SELECT DISTINCT * FROM TABLE_E051_08_01_08 AS MYTEMP

# statement ok
# CREATE TABLE TABLE_E051_08_01_09 ( ID INT PRIMARY KEY, A INT, B INT );

# sqlparser-rs unsupported
# query III
# SELECT DISTINCT MYTEMP . * AS ( C, D, E ) FROM TABLE_E051_08_01_09 AS MYTEMP

statement ok
CREATE TABLE TABLE_E051_08_01_10 ( ID INT PRIMARY KEY, A INT, B INT );

query III
SELECT DISTINCT MYTEMP . * FROM TABLE_E051_08_01_10 AS MYTEMP

# statement ok
# CREATE TABLE TABLE_E051_08_01_11 ( ID INT PRIMARY KEY, A INT, B INT );

# sqlparser-rs unsupported
# query III
# SELECT MYTEMP . * AS ( C, D, E ) FROM TABLE_E051_08_01_11 AS MYTEMP

statement ok
CREATE TABLE TABLE_E051_08_01_12 ( ID INT PRIMARY KEY, A INT, B INT );

query III
SELECT MYTEMP . * FROM TABLE_E051_08_01_12 AS MYTEMP
