diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-09-07 11:39:48 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-09-07 11:39:48 +0000 |
| commit | f73e9af131151f1e058446361c35b05c4c90bf10 (patch) | |
| tree | ed425b89f12d3f5e4709290bdc03d876f365bc97 /sqlglot/optimizer/optimize_joins.py | |
| parent | Releasing debian version 17.12.0-1. (diff) | |
| download | sqlglot-f73e9af131151f1e058446361c35b05c4c90bf10.tar.xz sqlglot-f73e9af131151f1e058446361c35b05c4c90bf10.zip | |
Merging upstream version 18.2.0.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
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 |