From 31f06cd4d7874b60520fe18d71d9ac04bedfc802 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 3 Sep 2024 13:22:38 -0400 Subject: [PATCH] cherry-pick changelog from 2.0.33 --- doc/build/changelog/changelog_20.rst | 127 +++++++++++++++++- doc/build/changelog/unreleased_20/11677.rst | 10 -- doc/build/changelog/unreleased_20/11687.rst | 7 - doc/build/changelog/unreleased_20/11703.rst | 7 - doc/build/changelog/unreleased_20/11731.rst | 10 -- doc/build/changelog/unreleased_20/11746.rst | 12 -- doc/build/changelog/unreleased_20/11782.rst | 5 - doc/build/changelog/unreleased_20/11788.rst | 6 - doc/build/changelog/unreleased_20/11802.rst | 8 -- doc/build/changelog/unreleased_20/11814.rst | 9 -- doc/build/changelog/unreleased_20/11818.rst | 15 --- doc/build/changelog/unreleased_20/11821.rst | 9 -- doc/build/changelog/unreleased_20/11822.rst | 9 -- .../changelog/unreleased_20/array_type.rst | 5 - 14 files changed, 126 insertions(+), 113 deletions(-) delete mode 100644 doc/build/changelog/unreleased_20/11677.rst delete mode 100644 doc/build/changelog/unreleased_20/11687.rst delete mode 100644 doc/build/changelog/unreleased_20/11703.rst delete mode 100644 doc/build/changelog/unreleased_20/11731.rst delete mode 100644 doc/build/changelog/unreleased_20/11746.rst delete mode 100644 doc/build/changelog/unreleased_20/11782.rst delete mode 100644 doc/build/changelog/unreleased_20/11788.rst delete mode 100644 doc/build/changelog/unreleased_20/11802.rst delete mode 100644 doc/build/changelog/unreleased_20/11814.rst delete mode 100644 doc/build/changelog/unreleased_20/11818.rst delete mode 100644 doc/build/changelog/unreleased_20/11821.rst delete mode 100644 doc/build/changelog/unreleased_20/11822.rst delete mode 100644 doc/build/changelog/unreleased_20/array_type.rst diff --git a/doc/build/changelog/changelog_20.rst b/doc/build/changelog/changelog_20.rst index 0fa618f4a2..40cd86afe9 100644 --- a/doc/build/changelog/changelog_20.rst +++ b/doc/build/changelog/changelog_20.rst @@ -10,7 +10,132 @@ .. changelog:: :version: 2.0.33 - :include_notes_from: unreleased_20 + :released: September 3, 2024 + + .. change:: + :tags: bug, sqlite + :tickets: 11677 + + Improvements to the regex used by the SQLite dialect to reflect the name + and contents of a CHECK constraint. Constraints with newline, tab, or + space characters in either or both the constraint text and constraint name + are now properly reflected. Pull request courtesy Jeff Horemans. + + + + .. change:: + :tags: bug, engine + :tickets: 11687 + + Fixed issue in internal reflection cache where particular reflection + scenarios regarding same-named quoted_name() constructs would not be + correctly cached. Pull request courtesy Felix Lüdin. + + .. change:: + :tags: bug, sql, regression + :tickets: 11703 + + Fixed regression in :meth:`_sql.Select.with_statement_hint` and others + where the generative behavior of the method stopped producing a copy of the + object. + + .. change:: + :tags: bug, mysql + :tickets: 11731 + + Fixed issue in MySQL dialect where using INSERT..FROM SELECT in combination + with ON DUPLICATE KEY UPDATE would erroneously render on MySQL 8 and above + the "AS new" clause, leading to syntax failures. This clause is required + on MySQL 8 to follow the VALUES clause if use of the "new" alias is + present, however is not permitted to follow a FROM SELECT clause. + + + .. change:: + :tags: bug, sqlite + :tickets: 11746 + + Improvements to the regex used by the SQLite dialect to reflect the name + and contents of a UNIQUE constraint that is defined inline within a column + definition inside of a SQLite CREATE TABLE statement, accommodating for tab + characters present within the column / constraint line. Pull request + courtesy John A Stevenson. + + + + + .. change:: + :tags: bug, typing + :tickets: 11782 + + Fixed typing issue with :meth:`_sql.Select.with_only_columns`. + + .. change:: + :tags: bug, orm + :tickets: 11788 + + Correctly cleanup the internal top-level module registry when no + inner modules or classes are registered into it. + + .. change:: + :tags: bug, schema + :tickets: 11802 + + Fixed bug where the ``metadata`` element of an ``Enum`` datatype would not + be transferred to the new :class:`.MetaData` object when the type had been + copied via a :meth:`.Table.to_metadata` operation, leading to inconsistent + behaviors within create/drop sequences. + + .. change:: + :tags: bug, orm + :tickets: 11814 + + Improvements to the ORM annotated declarative type map lookup dealing with + composed types such as ``dict[str, Any]`` linking to JSON (or others) with + or without "future annotations" mode. + + + + .. change:: + :tags: change, general + :tickets: 11818 + + The pin for ``setuptools<69.3`` in ``pyproject.toml`` has been removed. + This pin was to prevent a sudden change in setuptools to use :pep:`625` + from taking place, which would change the file name of SQLAlchemy's source + distribution on pypi to be an all lower case name, which is likely to cause + problems with various build environments that expected the previous naming + style. However, the presence of this pin is holding back environments that + otherwise want to use a newer setuptools, so we've decided to move forward + with this change, with the assumption that build environments will have + largely accommodated the setuptools change by now. + + + + .. change:: + :tags: bug, postgresql + :tickets: 11821 + + Revising the asyncpg ``terminate()`` fix first made in :ticket:`10717` + which improved the resiliency of this call under all circumstances, adding + ``asyncio.CancelledError`` to the list of exceptions that are intercepted + as failing for a graceful ``.close()`` which will then proceed to call + ``.terminate()``. + + .. change:: + :tags: bug, mssql + :tickets: 11822 + + Added error "The server failed to resume the transaction" to the list of + error strings for the pymssql driver in determining a disconnect scenario, + as observed by one user using pymssql under otherwise unknown conditions as + leaving an unusable connection in the connection pool which fails to ping + cleanly. + + .. change:: + :tags: bug, tests + + Added missing ``array_type`` property to the testing suite + ``SuiteRequirements`` class. .. changelog:: :version: 2.0.32 diff --git a/doc/build/changelog/unreleased_20/11677.rst b/doc/build/changelog/unreleased_20/11677.rst deleted file mode 100644 index b1ac39b436..0000000000 --- a/doc/build/changelog/unreleased_20/11677.rst +++ /dev/null @@ -1,10 +0,0 @@ -.. change:: - :tags: bug, sqlite - :tickets: 11677 - - Improvements to the regex used by the SQLite dialect to reflect the name - and contents of a CHECK constraint. Constraints with newline, tab, or - space characters in either or both the constraint text and constraint name - are now properly reflected. Pull request courtesy Jeff Horemans. - - diff --git a/doc/build/changelog/unreleased_20/11687.rst b/doc/build/changelog/unreleased_20/11687.rst deleted file mode 100644 index 734ed222cb..0000000000 --- a/doc/build/changelog/unreleased_20/11687.rst +++ /dev/null @@ -1,7 +0,0 @@ -.. change:: - :tags: bug, engine - :tickets: 11687 - - Fixed issue in internal reflection cache where particular reflection - scenarios regarding same-named quoted_name() constructs would not be - correctly cached. Pull request courtesy Felix Lüdin. diff --git a/doc/build/changelog/unreleased_20/11703.rst b/doc/build/changelog/unreleased_20/11703.rst deleted file mode 100644 index 5c703138a1..0000000000 --- a/doc/build/changelog/unreleased_20/11703.rst +++ /dev/null @@ -1,7 +0,0 @@ -.. change:: - :tags: bug, sql, regression - :tickets: 11703 - - Fixed regression in :meth:`_sql.Select.with_statement_hint` and others - where the generative behavior of the method stopped producing a copy of the - object. diff --git a/doc/build/changelog/unreleased_20/11731.rst b/doc/build/changelog/unreleased_20/11731.rst deleted file mode 100644 index 34ab8b48c5..0000000000 --- a/doc/build/changelog/unreleased_20/11731.rst +++ /dev/null @@ -1,10 +0,0 @@ -.. change:: - :tags: bug, mysql - :tickets: 11731 - - Fixed issue in MySQL dialect where using INSERT..FROM SELECT in combination - with ON DUPLICATE KEY UPDATE would erroneously render on MySQL 8 and above - the "AS new" clause, leading to syntax failures. This clause is required - on MySQL 8 to follow the VALUES clause if use of the "new" alias is - present, however is not permitted to follow a FROM SELECT clause. - diff --git a/doc/build/changelog/unreleased_20/11746.rst b/doc/build/changelog/unreleased_20/11746.rst deleted file mode 100644 index 36dc1a7393..0000000000 --- a/doc/build/changelog/unreleased_20/11746.rst +++ /dev/null @@ -1,12 +0,0 @@ -.. change:: - :tags: bug, sqlite - :tickets: 11746 - - Improvements to the regex used by the SQLite dialect to reflect the name - and contents of a UNIQUE constraint that is defined inline within a column - definition inside of a SQLite CREATE TABLE statement, accommodating for tab - characters present within the column / constraint line. Pull request - courtesy John A Stevenson. - - - diff --git a/doc/build/changelog/unreleased_20/11782.rst b/doc/build/changelog/unreleased_20/11782.rst deleted file mode 100644 index df8e1f5c3b..0000000000 --- a/doc/build/changelog/unreleased_20/11782.rst +++ /dev/null @@ -1,5 +0,0 @@ -.. change:: - :tags: bug, typing - :tickets: 11782 - - Fixed typing issue with :meth:`_sql.Select.with_only_columns`. diff --git a/doc/build/changelog/unreleased_20/11788.rst b/doc/build/changelog/unreleased_20/11788.rst deleted file mode 100644 index 736cbd3370..0000000000 --- a/doc/build/changelog/unreleased_20/11788.rst +++ /dev/null @@ -1,6 +0,0 @@ -.. change:: - :tags: bug, orm - :tickets: 11788 - - Correctly cleanup the internal top-level module registry when no - inner modules or classes are registered into it. diff --git a/doc/build/changelog/unreleased_20/11802.rst b/doc/build/changelog/unreleased_20/11802.rst deleted file mode 100644 index f6e7847ee2..0000000000 --- a/doc/build/changelog/unreleased_20/11802.rst +++ /dev/null @@ -1,8 +0,0 @@ -.. change:: - :tags: bug, schema - :tickets: 11802 - - Fixed bug where the ``metadata`` element of an ``Enum`` datatype would not - be transferred to the new :class:`.MetaData` object when the type had been - copied via a :meth:`.Table.to_metadata` operation, leading to inconsistent - behaviors within create/drop sequences. diff --git a/doc/build/changelog/unreleased_20/11814.rst b/doc/build/changelog/unreleased_20/11814.rst deleted file mode 100644 index a9feecb28c..0000000000 --- a/doc/build/changelog/unreleased_20/11814.rst +++ /dev/null @@ -1,9 +0,0 @@ -.. change:: - :tags: bug, orm - :tickets: 11814 - - Improvements to the ORM annotated declarative type map lookup dealing with - composed types such as ``dict[str, Any]`` linking to JSON (or others) with - or without "future annotations" mode. - - diff --git a/doc/build/changelog/unreleased_20/11818.rst b/doc/build/changelog/unreleased_20/11818.rst deleted file mode 100644 index c218f27dcc..0000000000 --- a/doc/build/changelog/unreleased_20/11818.rst +++ /dev/null @@ -1,15 +0,0 @@ -.. change:: - :tags: change, general - :tickets: 11818 - - The pin for ``setuptools<69.3`` in ``pyproject.toml`` has been removed. - This pin was to prevent a sudden change in setuptools to use :pep:`625` - from taking place, which would change the file name of SQLAlchemy's source - distribution on pypi to be an all lower case name, which is likely to cause - problems with various build environments that expected the previous naming - style. However, the presence of this pin is holding back environments that - otherwise want to use a newer setuptools, so we've decided to move forward - with this change, with the assumption that build environments will have - largely accommodated the setuptools change by now. - - diff --git a/doc/build/changelog/unreleased_20/11821.rst b/doc/build/changelog/unreleased_20/11821.rst deleted file mode 100644 index b72412f489..0000000000 --- a/doc/build/changelog/unreleased_20/11821.rst +++ /dev/null @@ -1,9 +0,0 @@ -.. change:: - :tags: bug, postgresql - :tickets: 11821 - - Revising the asyncpg ``terminate()`` fix first made in :ticket:`10717` - which improved the resiliency of this call under all circumstances, adding - ``asyncio.CancelledError`` to the list of exceptions that are intercepted - as failing for a graceful ``.close()`` which will then proceed to call - ``.terminate()``. diff --git a/doc/build/changelog/unreleased_20/11822.rst b/doc/build/changelog/unreleased_20/11822.rst deleted file mode 100644 index f6c91918f3..0000000000 --- a/doc/build/changelog/unreleased_20/11822.rst +++ /dev/null @@ -1,9 +0,0 @@ -.. change:: - :tags: bug, mssql - :tickets: 11822 - - Added error "The server failed to resume the transaction" to the list of - error strings for the pymssql driver in determining a disconnect scenario, - as observed by one user using pymssql under otherwise unknown conditions as - leaving an unusable connection in the connection pool which fails to ping - cleanly. diff --git a/doc/build/changelog/unreleased_20/array_type.rst b/doc/build/changelog/unreleased_20/array_type.rst deleted file mode 100644 index 23e0727fa2..0000000000 --- a/doc/build/changelog/unreleased_20/array_type.rst +++ /dev/null @@ -1,5 +0,0 @@ -.. change:: - :tags: bug, tests - - Added missing ``array_type`` property to the testing suite - ``SuiteRequirements`` class. -- 2.47.2