diff options
Diffstat (limited to '')
-rw-r--r-- | sqlglot/optimizer/unnest_subqueries.py | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sqlglot/optimizer/unnest_subqueries.py b/sqlglot/optimizer/unnest_subqueries.py index 242fc87..4d35175 100644 --- a/sqlglot/optimizer/unnest_subqueries.py +++ b/sqlglot/optimizer/unnest_subqueries.py @@ -65,6 +65,8 @@ def unnest(select, parent_select, next_alias_name): ) ): column = exp.Max(this=column) + elif not isinstance(select.parent, exp.Subquery): + return _replace(select.parent, column) parent_select.join(select, join_type="CROSS", join_alias=alias, copy=False) |