diff options
Diffstat (limited to 'sqlglot/optimizer/unnest_subqueries.py')
-rw-r--r-- | sqlglot/optimizer/unnest_subqueries.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sqlglot/optimizer/unnest_subqueries.py b/sqlglot/optimizer/unnest_subqueries.py index 26f4159..b4c7475 100644 --- a/sqlglot/optimizer/unnest_subqueries.py +++ b/sqlglot/optimizer/unnest_subqueries.py @@ -248,7 +248,7 @@ def decorrelate(select, parent_select, external_columns, next_alias_name): key.replace(exp.to_identifier("_x")) parent_predicate = _replace( parent_predicate, - f'({parent_predicate} AND ARRAY_ANY({nested}, "_x" -> {predicate}))', + f"({parent_predicate} AND ARRAY_ANY({nested}, _x -> {predicate}))", ) parent_select.join( |