diff options
| author | Federico Caselli <cfederico87@gmail.com> | 2021-03-30 23:15:04 +0200 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2021-03-31 22:13:30 -0400 |
| commit | a357baec856bb73c511f8f8484d316f19a29252a (patch) | |
| tree | bcc2f6c4da109191e93e74bfb5558d9ab09b8c7f /lib/sqlalchemy/sql/selectable.py | |
| parent | 62e68beea671215e98cb939bb87af95d6d9f35ee (diff) | |
| download | sqlalchemy-a357baec856bb73c511f8f8484d316f19a29252a.tar.gz | |
Fix MSSQL / Oracle limit/offset regressions
Fixed a regression in MSSQL 2012+ that prevented the order clause
to be rendered when ``offset=0`` is used in a subquery.
Fixed critical regression where the Oracle compiler would not maintain the
correct parameter values in the LIMIT/OFFSET for a select due to a caching
issue.
Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
Fixes: #6163
Fixes: #6173
Change-Id: Ieb12354271d09ad935d684ee0db4fa0128837215
Diffstat (limited to 'lib/sqlalchemy/sql/selectable.py')
| -rw-r--r-- | lib/sqlalchemy/sql/selectable.py | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/lib/sqlalchemy/sql/selectable.py b/lib/sqlalchemy/sql/selectable.py index 7c53f437c..d28ac7753 100644 --- a/lib/sqlalchemy/sql/selectable.py +++ b/lib/sqlalchemy/sql/selectable.py @@ -69,6 +69,14 @@ class _OffsetLimitParam(BindParameter): def _limit_offset_value(self): return self.effective_value + def _render_literal_execute(self): + return _OffsetLimitParam( + self.key, + self.value, + type_=self.type, + literal_execute=True, + ) + @util.deprecated( "1.4", |