zstan commented on code in PR #3642: URL: https://github.com/apache/ignite-3/pull/3642#discussion_r1580508874
########## modules/sql-engine/src/integrationTest/sql/join/inner/test_table_from_outer_join_used_in_inner.test: ########## @@ -0,0 +1,55 @@ +# name: sql/join/inner/test_table_from_outer_join_used_in_inner.test +# description: SQL feature F041-07 (The inner table in a left or right outer join can also be used in an inner join) +# group: [Basic joined table] + +statement ok +PRAGMA enable_verification + +statement ok +CREATE TABLE t1(c11 INTEGER, c12 INTEGER, c13 CHAR); + +statement ok +INSERT INTO t1 VALUES (1, 2, 'a'), (2, 3, 'b'), (3, 4, 'c') + +statement ok +CREATE TABLE t2 (c21 INTEGER, c22 INTEGER, c23 CHAR); + +statement ok +INSERT INTO t2 VALUES (2, 3, 'a'), (3, 4, 'b'), (4, 3, 'c') + +query II rowsort +select j.c21, j.c22 from (SELECT c21, c22 from t2 LEFT OUTER JOIN t1 ON (t2.c21 = t1.c11)) j INNER JOIN t2 t22 ON (t22.c21 = j.c22); Review Comment: thanks, done -- 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: notifications-unsubscr...@ignite.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
