]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Adapt "FOR UPDATE OF" with Oracle limit/offset
authorMike Bayer <mike_mp@zzzcomputing.com>
Tue, 5 Jul 2016 16:48:41 +0000 (12:48 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Tue, 5 Jul 2016 22:30:25 +0000 (18:30 -0400)
commitf2ee514c757fc9ec33afaddc2a7b96d08b83a164
tree69d2d63b758529151bda77a04319f0092d82a3ce
parent7c8c124dbe71602daed471e43af45051c5626c09
Adapt "FOR UPDATE OF" with Oracle limit/offset

This modifies the Oracle ROWNUM limit/offset approach
to accommodate for the "OF" clause in a "FOR UPDATE"
phrase.  The column expressions must be added to the selected
subquery if necessary and adapted on the outside.

Change-Id: Ia71b5fc4df6d326e73863f8ae9f96e8f1a5acfc1
Fixes: #3741
doc/build/changelog/changelog_10.rst
lib/sqlalchemy/dialects/oracle/base.py
test/dialect/test_oracle.py