Released: November 3, 2017change:
:tags: bug, sqlite
Fixed bug where SQLite CHECK constraint reflection would fail
if the referenced table were in a remote schema, e.g. on SQLite a
remote database referred to by ATTACH.
[orm] [bug] [ext] Fixed bug where the association proxy would inadvertently link itself
AliasedClassobject if it were called first with
AliasedClassas a parent, causing errors upon subsequent
[orm] [bug] Fixed bug where ORM relationship would warn against conflicting sync
targets (e.g. two relationships would both write to the same column) for
sibling classes in an inheritance hierarchy, where the two relationships
would never actually conflict during writes.
[orm] [bug] Fixed bug where correlated select used against single-table inheritance
entity would fail to render correctly in the outer query, due to adjustment
for single inheritance discriminator criteria inappropriately re-applying
the criteria to the outer query.
[bug] [declarative] [orm] Fixed bug where a descriptor that is elsewhere a mapped column
or relationship within a hierarchy based on
would be referred towards during a refresh operation, causing an error
as the attribute is not mapped as a mapper property.
A similar issue can arise for other attributes like the "type" column
AbstractConcreteBaseif the class fails to include
"concrete=True" in its mapper, however the check here should also
prevent that scenario from causing a problem.
[sql] [bug] Fixed bug where
if the argument were a tuple. Pull request courtesy Nicolas Caniart.
[sql] [bug] Fixed bug where the recently added
ColumnOperators.all_()methods didn't work when called
as methods, as opposed to using the standalone functions
added documentation examples for these relatively unintuitive
[postgresql] [bug] Made further fixes to the
ARRAYclass in conjunction with
COLLATE, as the fix made in #4006 failed to accommodate
for a multidimensional array.
[postgresql] [bug] Fixed bug in
array_aggfunction where passing an argument
that is already of type
ARRAY, such as a PostgreSQL
postgresql.arrayconstruct, would produce a
to the function attempting to nest the arrays.
[postgresql] [bug] Fixed bug in PostgreSQL
which would prevent the insert statement from being used as a CTE,
Insert.cte(), within another statement.
[mysql] [bug] Warning emitted when MariaDB 10.2.8 or earlier in the 10.2
series is detected as there are major issues with CHECK
constraints within these versions that were resolved as of
Note that this changelog message was NOT released with
SQLAlchemy 1.2.0b3 and was added retroactively.
[mysql] [bug] MySQL 5.7.20 now warns for use of the @tx_isolation variable; a version
check is now performed and uses @transaction_isolation instead
to prevent this warning.
[mssql] [bug] Added a full range of "connection closed" exception codes to the
PyODBC dialect for SQL Server, including '08S01', '01002', '08003',
'08007', '08S02', '08001', 'HYT00', 'HY010'. Previously, only '08S01'