From c8d4d4ead5df1c84966431eec8b88e974414dafc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Fri, 14 Jul 2023 07:43:02 +0200 Subject: Merging upstream version 17.4.1. Signed-off-by: Daniel Baumann --- sqlglot/optimizer/optimize_joins.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sqlglot/optimizer/optimize_joins.py') diff --git a/sqlglot/optimizer/optimize_joins.py b/sqlglot/optimizer/optimize_joins.py index d51276f..7b3b2b1 100644 --- a/sqlglot/optimizer/optimize_joins.py +++ b/sqlglot/optimizer/optimize_joins.py @@ -59,7 +59,7 @@ def reorder_joins(expression): dag = {name: other_table_names(join) for name, join in joins.items()} parent.set( "joins", - [joins[name] for name in tsort(dag) if name != from_.alias_or_name], + [joins[name] for name in tsort(dag) if name != from_.alias_or_name and name in joins], ) return expression -- cgit v1.2.3