Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 16 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/pg/select_join_full_one.sql b/yql/essentials/tests/sql/suites/pg/select_join_full_one.sql
new file mode 100644
index 0000000000..b5cdcb6967
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg/select_join_full_one.sql
@@ -0,0 +1,16 @@
+--!syntax_pg
+select * from (values (1,2),(3,4)) as a(x,y)
+full join (values (1,2),(2,5)) as b(u,v)
+on a.x = 1;
+
+select * from (values (1,2),(3,4)) as a(x,y)
+full join (values (1,2),(2,5)) as b(u,v)
+on a.x = 0;
+
+select * from (values (1,2),(3,4)) as a(x,y)
+full join (values (1,2),(2,5)) as b(u,v)
+on b.u = 1;
+
+select * from (values (1,2),(3,4)) as a(x,y)
+full join (values (1,2),(2,5)) as b(u,v)
+on b.u = 0;