YQL-20341 handle missing table in the join subtree

init
commit_hash:7169a3cfe8408c4baff8524a8022b5b219900b94

2 files changed, 33 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/sql2yql/canondata/result.json b/yql/essentials/tests/sql/sql2yql/canondata/result.json
index 6601fbe40ac..7710d0c54b8 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/result.json
+++ b/yql/essentials/tests/sql/sql2yql/canondata/result.json
@@ -4402,6 +4402,13 @@
             "uri": "https://{canondata_backend}/1924537/ff990ab7def5cabc141ccc68eee760fe4f19ab8b/resource.tar.gz#test_sql2yql.test_join-yql-20085-rename_/sql.yql"
         }
     ],
+    "test_sql2yql.test[join-yql-20341]": [
+        {
+            "checksum": "169c5c0ce4fdbfff4fc3bbfb401837d9",
+            "size": 3103,
+            "uri": "https://{canondata_backend}/1903280/9f134a2554012efbe6418ee6d16ca68e3063e519/resource.tar.gz#test_sql2yql.test_join-yql-20341_/sql.yql"
+        }
+    ],
     "test_sql2yql.test[join-yql-6199]": [
         {
             "checksum": "5421f92ec269e5d76133e1ca54b6d0d0",
@@ -11215,6 +11222,11 @@
             "uri": "file://test_sql_format.test_join-yql-20085-rename_/formatted.sql"
         }
     ],
+    "test_sql_format.test[join-yql-20341]": [
+        {
+            "uri": "file://test_sql_format.test_join-yql-20341_/formatted.sql"
+        }
+    ],
     "test_sql_format.test[join-yql-6199]": [
         {
             "uri": "file://test_sql_format.test_join-yql-6199_/formatted.sql"
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-yql-20341_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-yql-20341_/formatted.sql
new file mode 100644
index 00000000000..a02ea2ad813
--- /dev/null
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_join-yql-20341_/formatted.sql
@@ -0,0 +1,21 @@
+SELECT
+    *
+FROM (
+    SELECT
+        1 AS x,
+        0 AS p
+) AS a
+CROSS JOIN (
+    SELECT
+        1 AS y
+) AS b
+INNER JOIN (
+    SELECT
+        1 AS z,
+        0 AS q
+) AS c
+ON
+    a.x == c.z
+WHERE
+    a.p == c.q
+;