diff options
Diffstat (limited to 'sqlglot/optimizer/merge_subqueries.py')
-rw-r--r-- | sqlglot/optimizer/merge_subqueries.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sqlglot/optimizer/merge_subqueries.py b/sqlglot/optimizer/merge_subqueries.py index b0b2b3d..a74bea7 100644 --- a/sqlglot/optimizer/merge_subqueries.py +++ b/sqlglot/optimizer/merge_subqueries.py @@ -186,13 +186,13 @@ def _mergeable(outer_scope, inner_scope, leave_tables_isolated, from_or_join): and not ( isinstance(from_or_join, exp.Join) and inner_select.args.get("where") - and from_or_join.side in {"FULL", "LEFT", "RIGHT"} + and from_or_join.side in ("FULL", "LEFT", "RIGHT") ) and not ( isinstance(from_or_join, exp.From) and inner_select.args.get("where") and any( - j.side in {"FULL", "RIGHT"} for j in outer_scope.expression.args.get("joins", []) + j.side in ("FULL", "RIGHT") for j in outer_scope.expression.args.get("joins", []) ) ) and not _outer_select_joins_on_inner_select_join() |