rel_2_0_33

版本发布时间: 2024-09-04 01:22:22

sqlalchemy/sqlalchemy最新发布版本:rel_2_0_36(2024-10-16 03:41:54)

2.0.33

Released: September 3, 2024

[general] [change] 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.

References: #11818

[orm] [bug] [regression] Fixed regression from 1.3 where the column key used for a hybrid property might be populated with that of the underlying column that it returns, for a property that returns an ORM mapped column directly, rather than the key used by the hybrid property itself.

This change is also backported to: 1.4.54

References: #11728
[orm] [bug] Correctly cleanup the internal top-level module registry when no inner modules or classes are registered into it.

References: #11788
[orm] [bug] 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.

References: #11814

[engine] [bug] 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.

References: #11687

[sql] [bug] [regression] Fixed regression in _sql.Select.with_statement_hint() and others where the generative behavior of the method stopped producing a copy of the object.

References: #11703

[schema] [bug] Fixed bug where the metadata element of an Enum datatype would not be transferred to the new MetaData object when the type had been copied via a Table.to_metadata() operation, leading to inconsistent behaviors within create/drop sequences.

References: #11802

[typing] [bug] Fixed typing issue with _sql.Select.with_only_columns().

References: #11782

[postgresql] [bug] Fixed critical issue in the asyncpg driver where a rollback or commit that fails specifically for the MissingGreenlet condition or any other error that is not raised by asyncpg itself would discard the asyncpg transaction in any case, even though the transaction were still idle, leaving to a server side condition with an idle transaction that then goes back into the connection pool. The flags for "transaction closed" are now not reset for errors that are raised outside of asyncpg itself. When asyncpg itself raises an error for .commit() or .rollback(), asyncpg does then discard of this transaction.

This change is also backported to: 1.4.54

References: #11819
[postgresql] [bug] Revising the asyncpg terminate() fix first made in #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().

References: #11821

[mysql] [bug] 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.

References: #11731

[sqlite] [bug] 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.

References: #11677
[sqlite] [bug] 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.

References: #11746

[mssql] [bug] 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.

References: #11822