diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-07-05 12:48:41 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-07-05 18:30:25 -0400 |
| commit | f2ee514c757fc9ec33afaddc2a7b96d08b83a164 (patch) | |
| tree | 69d2d63b758529151bda77a04319f0092d82a3ce /doc/build | |
| parent | 7c8c124dbe71602daed471e43af45051c5626c09 (diff) | |
| download | sqlalchemy-f2ee514c757fc9ec33afaddc2a7b96d08b83a164.tar.gz | |
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
Diffstat (limited to 'doc/build')
| -rw-r--r-- | doc/build/changelog/changelog_10.rst | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/doc/build/changelog/changelog_10.rst b/doc/build/changelog/changelog_10.rst index 7240e8e68..724792174 100644 --- a/doc/build/changelog/changelog_10.rst +++ b/doc/build/changelog/changelog_10.rst @@ -29,6 +29,17 @@ rather than SERIAL. .. change:: + :tags: bug, oracle + :tickets: 3741 + :versions: 1.1.0b3 + + Fixed bug in :paramref:`.Select.with_for_update.of`, where the Oracle + "rownum" approach to LIMIT/OFFSET would fail to accomodate for the + expressions inside the "OF" clause, which must be stated at the topmost + level referring to expression within the subquery. The expressions are + now added to the subquery if needed. + + .. change:: :tags: bug, sql :tickets: 3735 :versions: 1.1.0b2 |