8000 Release 2.0.41 · sqlalchemy/sqlalchemy · GitHub

2.0.41

Latest

Latest

sqla-tester released this 14 May 17:10

· 914 commits to main since this release

152aa55

2.0.41

Released: May 14, 2025

platform

[platform] [bug] Adjusted the test suite as well as the ORM's method of scanning classes for
annotations to work under current beta releases of Python 3.14 (currently
3.14.0b1) as part of an ongoing effort to support the production release of
this Python release. Further changes to Python's means of working with
annotations is expected in subsequent beta releases for which SQLAlchemy's
test suite will need further adjustments.

References: #12405

engine

[engine] [bug] The error message that is emitted when a URL cannot be parsed no longer
includes the URL itself within the error message.

References: #12579

typing

[typing] [bug] Removed __getattr__() rule from sqlalchemy/__init__.py that
appeared to be trying to correct for a previous typographical error in the
imports. This rule interferes with type checking and is removed.

References: #12588

postgresql

[postgresql] [usecase] Added support for postgresql_include keyword argument to
_schema.UniqueConstraint and _schema.PrimaryKeyConstraint.
Pull request courtesy Denis Laxalde.

References: #10665

mysql

[mysql] [bug] Fixed regression caused by the DEFAULT rendering changes in version 2.0.40
via #12425 where using lowercase on update in a MySQL server
default would incorrectly apply parenthesis, leading to errors when MySQL
interpreted the rendered DDL. Pull request courtesy Alexander Ruehe.

References: #12488

sqlite

[sqlite] [bug] Fixed and added test support for some SQLite SQL functions hardcoded into
the compiler, most notably the localtimestamp function which rendered
with incorrect internal quoting.

References: #12566

oracle

[oracle] [usecase] Added new datatype _oracle.VECTOR and accompanying DDL and DQL
support to fully support this type for Oracle Database. This change
includes the base _oracle.VECTOR type that adds new type-specific
methods l2_distance, cosine_distance, inner_product as well as
new parameters oracle_vector for the Index construct,
allowing vector indexes to be configured, and oracle_fetch_approximate
for the Select.fetch() clause. Pull request courtesy Suraj Shaw.

References: #12317, #12341

misc

[bug] [installation] Removed the "license classifier" from setup.cfg for SQLAlchemy 2.0, which
eliminates loud deprecation warnings when building the package. SQLAlchemy
2.1 will use a full PEP 639 configuration in pyproject.toml while
SQLAlchemy 2.0 remains using setup.cfg for setup.

Assets 58

0