From 43f2c66ea7413cc0aaf6ca040ad33fb65ca4412d Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Mon, 17 Sep 2018 11:38:52 -0400 Subject: Adapt right side in join if lateral detected Fixed bug where use of :class:`.Lateral` construct in conjunction with :meth:`.Query.join` as well as :meth:`.Query.select_entity_from` would not apply clause adaption to the right side of the join. "lateral" introduces the use case of the right side of a join being correlatable. Previously, adaptation of this clause wasn't considered. Fixes: #4334 Change-Id: I3631e562092769d30069a2aa5e50a580f4661a23 --- lib/sqlalchemy/sql/selectable.py | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'lib/sqlalchemy/sql') diff --git a/lib/sqlalchemy/sql/selectable.py b/lib/sqlalchemy/sql/selectable.py index 5b665829b..64886b326 100644 --- a/lib/sqlalchemy/sql/selectable.py +++ b/lib/sqlalchemy/sql/selectable.py @@ -338,6 +338,8 @@ class FromClause(Selectable): _is_select = False _is_from_container = False + _is_lateral = False + _textual = False """a marker that allows us to easily distinguish a :class:`.TextAsFrom` or similar object from other kinds of :class:`.FromClause` objects.""" @@ -1329,6 +1331,7 @@ class Lateral(Alias): """ __visit_name__ = 'lateral' + _is_lateral = True class TableSample(Alias): @@ -3008,7 +3011,6 @@ class Select(HasPrefixes, HasSuffixes, GenerativeSelect): # contents, as this set is used for matching, not rendering. self._correlate = set(clone(f) for f in self._correlate).union(self._correlate) - # 4. clone other things. The difficulty here is that Column # objects are not actually cloned, and refer to their original # .table, resulting in the wrong "from" parent after a clone -- cgit v1.2.1