IGNITE-21923: Cover SQL E051-09(Basic query specification, Rename columns in the FROM clause) feature by tests (#3628)
diff --git a/modules/runner/src/integrationTest/java/org/apache/ignite/internal/runner/app/ItIgniteNodeRestartTest.java b/modules/runner/src/integrationTest/java/org/apache/ignite/internal/runner/app/ItIgniteNodeRestartTest.java
index f480404..56e0cd0 100644
--- a/modules/runner/src/integrationTest/java/org/apache/ignite/internal/runner/app/ItIgniteNodeRestartTest.java
+++ b/modules/runner/src/integrationTest/java/org/apache/ignite/internal/runner/app/ItIgniteNodeRestartTest.java
@@ -1294,7 +1294,7 @@
* metastorage group starts again.
*/
@Test
- @Disabled(value = "https://issues.apache.org/jira/browse/IGNITE-18919")
+ @Disabled("https://issues.apache.org/jira/browse/IGNITE-18919")
public void testMetastorageStop() throws NodeStoppingException {
int cfgGap = 4;
diff --git a/modules/sql-engine/src/integrationTest/java/org/apache/ignite/internal/sql/engine/ItMetadataTest.java b/modules/sql-engine/src/integrationTest/java/org/apache/ignite/internal/sql/engine/ItMetadataTest.java
index 2a91ae5..cc7d0c8 100644
--- a/modules/sql-engine/src/integrationTest/java/org/apache/ignite/internal/sql/engine/ItMetadataTest.java
+++ b/modules/sql-engine/src/integrationTest/java/org/apache/ignite/internal/sql/engine/ItMetadataTest.java
@@ -89,6 +89,12 @@
}
@Test
+ public void renameColumnsInFrom() {
+ assertQuery("select NEW_PERSON.NEW_ID, NEW_NAME, NEW_persON.New_salary from person NEW_PERSON(NeW_Id, NeW_NaMe, New_SaLaRy)")
+ .columnNames("NEW_ID", "NEW_NAME", "NEW_SALARY").check();
+ }
+
+ @Test
public void infixTypeCast() {
assertQuery("select id, id::tinyint as tid, id::smallint as sid, id::varchar as vid, id::interval hour, "
+ "id::interval year from person")
diff --git a/modules/sql-engine/src/integrationTest/sql/basic_queries/rename_columns_in_from.test b/modules/sql-engine/src/integrationTest/sql/basic_queries/rename_columns_in_from.test
new file mode 100644
index 0000000..702f5e7
--- /dev/null
+++ b/modules/sql-engine/src/integrationTest/sql/basic_queries/rename_columns_in_from.test
@@ -0,0 +1,79 @@
+# name: sql/basic_queries/rename_columns_in_from.test
+# description: SQL feature E051-9 (Basic query specification. Rename columns in the FROM clause)
+# feature: E051-09
+# group: [basic_queries]
+
+statement ok
+CREATE TABLE tab ( A INT PRIMARY KEY, B INT )
+
+statement ok
+INSERT INTO tab VALUES(1,13), (2,12), (3,11)
+
+# use alias with ALL
+query II
+SELECT ALL alias . X , Y FROM tab AS alias (X, Y) order by x
+----
+1 13
+2 12
+3 11
+
+# use alias with DISTINCT
+query II
+SELECT DISTINCT alias.Y, X FROM tab AS alias (X, Y) order by y
+----
+11 3
+12 2
+13 1
+
+# use alias for second field
+query II
+SELECT alias.X, Y FROM tab AS alias (X, Y) order by alias.x
+----
+1 13
+2 12
+3 11
+
+# use alias for second field
+query II
+SELECT X, alias.Y FROM tab AS alias (X, Y) order by x
+----
+1 13
+2 12
+3 11
+
+# inversion of column name by aliases
+query II
+SELECT alias.a, b FROM tab AS alias (b, a) order by b
+----
+13 1
+12 2
+11 3
+
+
+# no alias in projection
+query II
+SELECT X, Y FROM tab AS alias (X, Y) order by x
+----
+1 13
+2 12
+3 11
+
+# no AS keyword
+query II
+SELECT X, Y FROM tab alias (X, Y) order by x -- no AS
+----
+1 13
+2 12
+3 11
+
+# duplicate alias name
+statement error
+SELECT alias.b, b FROM tab AS alias (b, b)
+
+# number of aliases is less than number of columns
+statement error
+SELECT alias.X FROM tab AS alias (X)
+
+# number of aliases is bigger than number of columns
+statement error
+SELECT alias.X FROM tab AS alias (X, Y, Z)
diff --git a/modules/sql-engine/src/test/java/org/apache/ignite/internal/sql/engine/planner/JoinCommutePlannerTest.java b/modules/sql-engine/src/test/java/org/apache/ignite/internal/sql/engine/planner/JoinCommutePlannerTest.java
index d1f6fcd..1e21564 100644
--- a/modules/sql-engine/src/test/java/org/apache/ignite/internal/sql/engine/planner/JoinCommutePlannerTest.java
+++ b/modules/sql-engine/src/test/java/org/apache/ignite/internal/sql/engine/planner/JoinCommutePlannerTest.java
@@ -301,7 +301,6 @@
* The same as {@link #commuteIsDisabledForBigJoinsOfTables()}, but with table functions as source of data.
*/
@Test
- @Disabled("https://issues.apache.org/jira/browse/IGNITE-18937")
public void commuteIsDisabledForBigJoinsOfTableFunctions() throws Exception {
int joinSize = 50;