]> 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:29:24 +0000 (18:29 -0400)
commitd99ec752c752cad9b6d8fa9c61c97611d72dcfd5
tree12656a3b135267530815ac1fbdba2a5306bb5924
parent421fa6b8bf9f0c3c5041579c89ec405ce0f5e0b0
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
(cherry picked from commit d23797943786914cced58ed71ffb7b749e64c449)
doc/build/changelog/changelog_10.rst
lib/sqlalchemy/dialects/oracle/base.py
test/dialect/test_oracle.py