Fix NormalizeEqualityFilterOverJoin with optionals

commit_hash:dbf1a2fd200d2699cbc984fd4da357fb79ca3bd9

1 files changed, 10 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/optimizers/normalize_eq_filter_opts.yql b/yql/essentials/tests/sql/suites/optimizers/normalize_eq_filter_opts.yql
new file mode 100644
index 00000000000..faae968d1fd
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/optimizers/normalize_eq_filter_opts.yql
@@ -0,0 +1,10 @@
+PRAGMA config.flags("OptimizerFlags", "NormalizeEqualityFilterOverJoin");
+
+$left = [<|x:Just(1), y:2|>, <|x:2, y:3|>, <|x:3, y:4|>];
+$right = [<|a:2, b:3|>, <|a:3, b:4|>, <|a:4, b:5|>];
+
+select * from (
+select * from as_table($left) as l
+left join as_table($right) as r on l.y = r.b
+)
+where ((x > 0) ?? false) = ((a > 0) ?? false);