From 7721c4dec437d4b3d7133f76010011bde11c22f2 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 18 Jun 2024 17:39:11 -0400 Subject: [PATCH] cherry-pick changelog from 2.0.31 --- doc/build/changelog/changelog_20.rst | 98 ++++++++++++++++++++- doc/build/changelog/unreleased_20/11285.rst | 7 -- doc/build/changelog/unreleased_20/11361.rst | 6 -- doc/build/changelog/unreleased_20/11365.rst | 9 -- doc/build/changelog/unreleased_20/11374.rst | 7 -- doc/build/changelog/unreleased_20/11417.rst | 7 -- doc/build/changelog/unreleased_20/11422.rst | 6 -- doc/build/changelog/unreleased_20/11423.rst | 6 -- doc/build/changelog/unreleased_20/11426.rst | 8 -- doc/build/changelog/unreleased_20/11446.rst | 8 -- doc/build/changelog/unreleased_20/11449.rst | 12 --- doc/build/changelog/unreleased_20/11509.rst | 9 -- 12 files changed, 97 insertions(+), 86 deletions(-) delete mode 100644 doc/build/changelog/unreleased_20/11285.rst delete mode 100644 doc/build/changelog/unreleased_20/11361.rst delete mode 100644 doc/build/changelog/unreleased_20/11365.rst delete mode 100644 doc/build/changelog/unreleased_20/11374.rst delete mode 100644 doc/build/changelog/unreleased_20/11417.rst delete mode 100644 doc/build/changelog/unreleased_20/11422.rst delete mode 100644 doc/build/changelog/unreleased_20/11423.rst delete mode 100644 doc/build/changelog/unreleased_20/11426.rst delete mode 100644 doc/build/changelog/unreleased_20/11446.rst delete mode 100644 doc/build/changelog/unreleased_20/11449.rst delete mode 100644 doc/build/changelog/unreleased_20/11509.rst diff --git a/doc/build/changelog/changelog_20.rst b/doc/build/changelog/changelog_20.rst index b0194baa5b..44a9480d41 100644 --- a/doc/build/changelog/changelog_20.rst +++ b/doc/build/changelog/changelog_20.rst @@ -10,7 +10,103 @@ .. changelog:: :version: 2.0.31 - :include_notes_from: unreleased_20 + :released: June 18, 2024 + + .. change:: + :tags: usecase, reflection, mysql + :tickets: 11285 + + Added missing foreign key reflection option ``SET DEFAULT`` + in the MySQL and MariaDB dialects. + Pull request courtesy of Quentin Roche. + + .. change:: + :tags: usecase, orm + :tickets: 11361 + + Added missing parameter :paramref:`_orm.with_polymorphic.name` that + allows specifying the name of returned :class:`_orm.AliasedClass`. + + .. change:: + :tags: bug, orm + :tickets: 11365 + + Fixed issue where a :class:`.MetaData` collection would not be + serializable, if an :class:`.Enum` or :class:`.Boolean` datatype were + present which had been adapted. This specific scenario in turn could occur + when using the :class:`.Enum` or :class:`.Boolean` within ORM Annotated + Declarative form where type objects frequently get copied. + + .. change:: + :tags: schema, usecase + :tickets: 11374 + + Added :paramref:`_schema.Column.insert_default` as an alias of + :paramref:`_schema.Column.default` for compatibility with + :func:`_orm.mapped_column`. + + .. change:: + :tags: bug, general + :tickets: 11417 + + Set up full Python 3.13 support to the extent currently possible, repairing + issues within internal language helpers as well as the serializer extension + module. + + .. change:: + :tags: bug, sql + :tickets: 11422 + + Fixed issue when serializing an :func:`_sql.over` clause with + unbounded range or rows. + + .. change:: + :tags: bug, sql + :tickets: 11423 + + Added missing methods :meth:`_sql.FunctionFilter.within_group` + and :meth:`_sql.WithinGroup.filter` + + .. change:: + :tags: bug, sql + :tickets: 11426 + + Fixed bug in :meth:`_sql.FunctionFilter.filter` that would mutate + the existing function in-place. It now behaves like the rest of the + SQLAlchemy API, returning a new instance instead of mutating the + original one. + + .. change:: + :tags: bug, orm + :tickets: 11446 + + Fixed issue where the :func:`_orm.selectinload` and + :func:`_orm.subqueryload` loader options would fail to take effect when + made against an inherited subclass that itself included a subclass-specific + :paramref:`_orm.Mapper.with_polymorphic` setting. + + .. change:: + :tags: bug, orm + :tickets: 11449 + + Fixed very old issue involving the :paramref:`_orm.joinedload.innerjoin` + parameter where making use of this parameter mixed into a query that also + included joined eager loads along a self-referential or other cyclical + relationship, along with complicating factors like inner joins added for + secondary tables and such, would have the chance of splicing a particular + inner join to the wrong part of the query. Additional state has been added + to the internal method that does this splice to make a better decision as + to where splicing should proceed. + + .. change:: + :tags: bug, orm, regression + :tickets: 11509 + + Fixed bug in ORM Declarative where the ``__table__`` directive could not be + declared as a class function with :func:`_orm.declared_attr` on a + superclass, including an ``__abstract__`` class as well as coming from the + declarative base itself. This was a regression since 1.4 where this was + working, and there were apparently no tests for this particular use case. .. changelog:: :version: 2.0.30 diff --git a/doc/build/changelog/unreleased_20/11285.rst b/doc/build/changelog/unreleased_20/11285.rst deleted file mode 100644 index a965799c17..0000000000 --- a/doc/build/changelog/unreleased_20/11285.rst +++ /dev/null @@ -1,7 +0,0 @@ -.. change:: - :tags: usecase, reflection, mysql - :tickets: 11285 - - Added missing foreign key reflection option ``SET DEFAULT`` - in the MySQL and MariaDB dialects. - Pull request courtesy of Quentin Roche. diff --git a/doc/build/changelog/unreleased_20/11361.rst b/doc/build/changelog/unreleased_20/11361.rst deleted file mode 100644 index bd9fe1d3ff..0000000000 --- a/doc/build/changelog/unreleased_20/11361.rst +++ /dev/null @@ -1,6 +0,0 @@ -.. change:: - :tags: usecase, orm - :tickets: 11361 - - Added missing parameter :paramref:`_orm.with_polymorphic.name` that - allows specifying the name of returned :class:`_orm.AliasedClass`. diff --git a/doc/build/changelog/unreleased_20/11365.rst b/doc/build/changelog/unreleased_20/11365.rst deleted file mode 100644 index d2b353e912..0000000000 --- a/doc/build/changelog/unreleased_20/11365.rst +++ /dev/null @@ -1,9 +0,0 @@ -.. change:: - :tags: bug, orm - :tickets: 11365 - - Fixed issue where a :class:`.MetaData` collection would not be - serializable, if an :class:`.Enum` or :class:`.Boolean` datatype were - present which had been adapted. This specific scenario in turn could occur - when using the :class:`.Enum` or :class:`.Boolean` within ORM Annotated - Declarative form where type objects frequently get copied. diff --git a/doc/build/changelog/unreleased_20/11374.rst b/doc/build/changelog/unreleased_20/11374.rst deleted file mode 100644 index d52da2e767..0000000000 --- a/doc/build/changelog/unreleased_20/11374.rst +++ /dev/null @@ -1,7 +0,0 @@ -.. change:: - :tags: schema, usecase - :tickets: 11374 - - Added :paramref:`_schema.Column.insert_default` as an alias of - :paramref:`_schema.Column.default` for compatibility with - :func:`_orm.mapped_column`. diff --git a/doc/build/changelog/unreleased_20/11417.rst b/doc/build/changelog/unreleased_20/11417.rst deleted file mode 100644 index 8e27d05923..0000000000 --- a/doc/build/changelog/unreleased_20/11417.rst +++ /dev/null @@ -1,7 +0,0 @@ -.. change:: - :tags: bug, general - :tickets: 11417 - - Set up full Python 3.13 support to the extent currently possible, repairing - issues within internal language helpers as well as the serializer extension - module. diff --git a/doc/build/changelog/unreleased_20/11422.rst b/doc/build/changelog/unreleased_20/11422.rst deleted file mode 100644 index bde7879338..0000000000 --- a/doc/build/changelog/unreleased_20/11422.rst +++ /dev/null @@ -1,6 +0,0 @@ -.. change:: - :tags: bug, sql - :tickets: 11422 - - Fixed issue when serializing an :func:`_sql.over` clause with - unbounded range or rows. diff --git a/doc/build/changelog/unreleased_20/11423.rst b/doc/build/changelog/unreleased_20/11423.rst deleted file mode 100644 index ed6f988460..0000000000 --- a/doc/build/changelog/unreleased_20/11423.rst +++ /dev/null @@ -1,6 +0,0 @@ -.. change:: - :tags: bug, sql - :tickets: 11423 - - Added missing methods :meth:`_sql.FunctionFilter.within_group` - and :meth:`_sql.WithinGroup.filter` diff --git a/doc/build/changelog/unreleased_20/11426.rst b/doc/build/changelog/unreleased_20/11426.rst deleted file mode 100644 index c9018b02f4..0000000000 --- a/doc/build/changelog/unreleased_20/11426.rst +++ /dev/null @@ -1,8 +0,0 @@ -.. change:: - :tags: bug, sql - :tickets: 11426 - - Fixed bug in :meth:`_sql.FunctionFilter.filter` that would mutate - the existing function in-place. It now behaves like the rest of the - SQLAlchemy API, returning a new instance instead of mutating the - original one. diff --git a/doc/build/changelog/unreleased_20/11446.rst b/doc/build/changelog/unreleased_20/11446.rst deleted file mode 100644 index 747230b869..0000000000 --- a/doc/build/changelog/unreleased_20/11446.rst +++ /dev/null @@ -1,8 +0,0 @@ -.. change:: - :tags: bug, orm - :tickets: 11446 - - Fixed issue where the :func:`_orm.selectinload` and - :func:`_orm.subqueryload` loader options would fail to take effect when - made against an inherited subclass that itself included a subclass-specific - :paramref:`_orm.Mapper.with_polymorphic` setting. diff --git a/doc/build/changelog/unreleased_20/11449.rst b/doc/build/changelog/unreleased_20/11449.rst deleted file mode 100644 index f7974cfd76..0000000000 --- a/doc/build/changelog/unreleased_20/11449.rst +++ /dev/null @@ -1,12 +0,0 @@ -.. change:: - :tags: bug, orm - :tickets: 11449 - - Fixed very old issue involving the :paramref:`_orm.joinedload.innerjoin` - parameter where making use of this parameter mixed into a query that also - included joined eager loads along a self-referential or other cyclical - relationship, along with complicating factors like inner joins added for - secondary tables and such, would have the chance of splicing a particular - inner join to the wrong part of the query. Additional state has been added - to the internal method that does this splice to make a better decision as - to where splicing should proceed. diff --git a/doc/build/changelog/unreleased_20/11509.rst b/doc/build/changelog/unreleased_20/11509.rst deleted file mode 100644 index 1761c2bf7a..0000000000 --- a/doc/build/changelog/unreleased_20/11509.rst +++ /dev/null @@ -1,9 +0,0 @@ -.. change:: - :tags: bug, orm, regression - :tickets: 11509 - - Fixed bug in ORM Declarative where the ``__table__`` directive could not be - declared as a class function with :func:`_orm.declared_attr` on a - superclass, including an ``__abstract__`` class as well as coming from the - declarative base itself. This was a regression since 1.4 where this was - working, and there were apparently no tests for this particular use case. -- 2.47.2