diff options
Diffstat (limited to 'sqlglot/optimizer/optimize_joins.py')
-rw-r--r-- | sqlglot/optimizer/optimize_joins.py | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/sqlglot/optimizer/optimize_joins.py b/sqlglot/optimizer/optimize_joins.py index 7b3b2b1..9d401fc 100644 --- a/sqlglot/optimizer/optimize_joins.py +++ b/sqlglot/optimizer/optimize_joins.py @@ -72,8 +72,13 @@ def normalize(expression): if not any(join.args.get(k) for k in JOIN_ATTRS): join.set("kind", "CROSS") - if join.kind != "CROSS": + if join.kind == "CROSS": + join.set("on", None) + else: join.set("kind", None) + + if not join.args.get("on") and not join.args.get("using"): + join.set("on", exp.true()) return expression |