From f2ee514c757fc9ec33afaddc2a7b96d08b83a164 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 5 Jul 2016 12:48:41 -0400 Subject: 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 | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'doc') 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 @@ -28,6 +28,17 @@ to determine if SMALLSERIAL or BIGSERIAL needed to be rendered 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 -- cgit v1.2.1