1.4.47

Released: March 18, 2023

sql

• [sql] [bug] Fixed bug / regression where using bindparam() with the same name as a column in the Update.values() method of Update, as well as the Insert.values() method of Insert in 2.0 only, would in some cases silently fail to honor the SQL expression in which the parameter were presented, replacing the expression with a new parameter of the same name and discarding any other elements of the SQL expression, such as SQL functions, etc. The specific case would be statements that were constructed against ORM entities rather than plain Table instances, but would occur if the statement were invoked with a Session or a Connection.

  Update part of the issue was present in both 2.0 and 1.4 and is backported to 1.4.

  References: #9075

• [sql] [bug] Fixed stringify for a the CreateSchema and DropSchema DDL constructs, which would fail with an AttributeError when stringified without a dialect.

  References: #7664

• [sql] [bug] Fixed critical SQL caching issue where use of the _sql.Operators.op() custom operator function would not produce an appropriate cache key, leading to reduce the effectiveness of the SQL cache.

  References: #9506

mypy

• [mypy] [bug] Adjustments made to the mypy plugin to accommodate for some potential changes being made for issue #236 sqlalchemy2-stubs when using SQLAlchemy 1.4. These changes are being kept in sync within SQLAlchemy 2.0. The changes are also backwards compatible with older versions of sqlalchemy2-stubs.

• [mypy] [bug] Fixed crash in mypy plugin which could occur on both 1.4 and 2.0 versions if a decorator for the _orm.registry.mapped() decorator were used that was referenced in an expression with more than two components (e.g. @Backend.mapper_registry.mapped). This scenario is now ignored; when using the plugin, the decorator expression needs to be two components (i.e. @reg.mapped).

  References: #9102

postgresql

• [postgresql] [bug] Added support to the asyncpg dialect to return the cursor.rowcount value for SELECT statements when available. While this is not a typical use for cursor.rowcount, the other PostgreSQL dialects generally provide this value. Pull request courtesy Michael Gorven.

  References: #9048

mysql

• [mysql] [usecase] Added support to MySQL index reflection to correctly reflect the mysql_length dictionary, which previously was being ignored.

  References: #9047

mssql

• [mssql] [bug] Fixed bug where a schema name given with brackets, but no dots inside the name, for parameters such as _schema.Table.schema would not be interpreted within the context of the SQL Server dialect's documented behavior of interpreting explicit brackets as token delimiters, first added in 1.2 for #2626, when referring to the schema name in reflection operations. The original assumption for #2626's behavior was that the special interpretation of brackets was only significant if dots were present, however in practice, the brackets are not included as part of the identifier name for all SQL rendering operations since these are not valid characters within regular or delimited identifiers. Pull request courtesy Shan.

  References: #9133

oracle

• [oracle] [bug] Added _oracle.ROWID to reflected types as this type may be used in a "CREATE TABLE" statement.

  References: #5047