Intermediate changes

commit_hash:e6cca97ec9c9627f1ba82a11abf454518fc90972

1 files changed, 32 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/pg/select_join_left_const.yql b/yql/essentials/tests/sql/suites/pg/select_join_left_const.yql
new file mode 100644
index 00000000000..225541d3a87
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg/select_join_left_const.yql
@@ -0,0 +1,32 @@
+--!syntax_pg
+select * from (values (1,2),(3,4)) as a(x,y)
+left join (values (1,2),(2,5)) as b(u,v)
+on 1+1=2;
+
+select * from (select * from (values (1,2),(3,4)) as a(x,y) limit 0) a
+left join (values (1,2),(2,5)) as b(u,v)
+on 1+1=2;
+
+select * from (values (1,2),(3,4)) as a(x,y)
+left join (select * from (values (1,2),(2,5)) as b(u,v) limit 0) b
+on 1+1=2;
+
+select * from (select * from (values (1,2),(3,4)) as a(x,y) limit 0) a
+left join (select * from (values (1,2),(2,5)) as b(u,v) limit 0) b
+on 1+1=2;
+
+select * from (values (1,2),(3,4)) as a(x,y)
+left join (values (1,2),(2,5)) as b(u,v)
+on 1+1=3;
+
+select * from (select * from (values (1,2),(3,4)) as a(x,y) limit 0) a
+left join (values (1,2),(2,5)) as b(u,v)
+on 1+1=3;
+
+select * from (values (1,2),(3,4)) as a(x,y)
+left join (select * from (values (1,2),(2,5)) as b(u,v) limit 0) b
+on 1+1=3;
+
+select * from (select * from (values (1,2),(3,4)) as a(x,y) limit 0) a
+left join (select * from (values (1,2),(2,5)) as b(u,v) limit 0) b
+on 1+1=3;