ygerzhedovich commented on code in PR #3628: URL: https://github.com/apache/ignite-3/pull/3628#discussion_r1572188895
########## modules/sql-engine/src/integrationTest/sql/basic_queries/rename_columns_in _from.test: ########## @@ -0,0 +1,47 @@ +# 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) + +query II +SELECT ALL alias . X , Y FROM tab AS alias (X, Y) order by x +---- +1 13 +2 12 +3 11 + +query II +SELECT DISTINCT alias.Y, X FROM tab AS alias (X, Y) order by y +---- +11 3 +12 2 +13 1 + +query II +SELECT alias.X, Y FROM tab AS alias (X, Y) order by x Review Comment: added -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
