From a5e10cbd5339d42c49a3d37bb92471800d1ef252 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Mon, 15 Feb 2021 14:49:10 -0500 Subject: [PATCH] - 1.4.0b3 --- doc/build/changelog/changelog_14.rst | 87 ++++++++++++++++++- doc/build/changelog/unreleased_14/5924.rst | 7 -- doc/build/changelog/unreleased_14/5933.rst | 14 --- doc/build/changelog/unreleased_14/5934.rst | 6 -- doc/build/changelog/unreleased_14/5935.rst | 9 -- doc/build/changelog/unreleased_14/5939.rst | 7 -- doc/build/changelog/unreleased_14/5941.rst | 22 ----- .../unreleased_14/orm_from_returning.rst | 13 --- doc/build/conf.py | 4 +- 9 files changed, 88 insertions(+), 81 deletions(-) delete mode 100644 doc/build/changelog/unreleased_14/5924.rst delete mode 100644 doc/build/changelog/unreleased_14/5933.rst delete mode 100644 doc/build/changelog/unreleased_14/5934.rst delete mode 100644 doc/build/changelog/unreleased_14/5935.rst delete mode 100644 doc/build/changelog/unreleased_14/5939.rst delete mode 100644 doc/build/changelog/unreleased_14/5941.rst delete mode 100644 doc/build/changelog/unreleased_14/orm_from_returning.rst diff --git a/doc/build/changelog/changelog_14.rst b/doc/build/changelog/changelog_14.rst index 32ac1d488f..a50e6ed57d 100644 --- a/doc/build/changelog/changelog_14.rst +++ b/doc/build/changelog/changelog_14.rst @@ -15,7 +15,92 @@ This document details individual issue-level changes made throughout .. changelog:: :version: 1.4.0b3 - :include_notes_from: unreleased_14 + :released: February 15, 2021 + + .. change:: + :tags: bug, orm + :tickets: 5933 + + Fixed issue in new 1.4/2.0 style ORM queries where a statement-level label + style would not be preserved in the keys used by result rows; this has been + applied to all combinations of Core/ORM columns / session vs. connection + etc. so that the linkage from statement to result row is the same in all + cases. As part of this change, the labeling of column expressions + in rows has been improved to retain the original name of the ORM + attribute even if used in a subquery. + + + + + .. change:: + :tags: bug, sql + :tickets: 5924 + + Fixed bug where the "cartesian product" assertion was not correctly + accommodating for joins between tables that relied upon the use of LATERAL + to connect from a subquery to another subquery in the enclosing context. + + .. change:: + :tags: bug, sql + :tickets: 5934 + + Fixed 1.4 regression where the :meth:`_functions.Function.in_` method was + not covered by tests and failed to function properly in all cases. + + .. change:: + :tags: bug, engine, postgresql + :tickets: 5941 + + Continued with the improvement made as part of :ticket:`5653` to further + support bound parameter names, including those generated against column + names, for names that include colons, parenthesis, and question marks, as + well as improved test support, so that bound parameter names even if they + are auto-derived from column names should have no problem including for + parenthesis in psycopg2's "pyformat" style. + + As part of this change, the format used by the asyncpg DBAPI adapter (which + is local to SQLAlchemy's asyncpg dialect) has been changed from using + "qmark" paramstyle to "format", as there is a standard and internally + supported SQL string escaping style for names that use percent signs with + "format" style (i.e. to double percent signs), as opposed to names that use + question marks with "qmark" style (where an escaping system is not defined + by pep-249 or Python). + + .. seealso:: + + :ref:`change_5941` + + .. change:: + :tags: sql, usecase, postgresql, sqlite + :tickets: 5939 + + Enhance ``set_`` keyword of :class:`.OnConflictDoUpdate` to accept a + :class:`.ColumnCollection`, such as the ``.c.`` collection from a + :class:`Selectable`, or the ``.excluded`` contextual object. + + .. change:: + :tags: feature, orm + + The ORM used in :term:`2.0 style` can now return ORM objects from the rows + returned by an UPDATE..RETURNING or INSERT..RETURNING statement, by + supplying the construct to :meth:`_sql.Select.from_statement` in an ORM + context. + + .. seealso:: + + :ref:`orm_dml_returning_objects` + + + + .. change:: + :tags: bug, sql + :tickets: 5935 + + Fixed regression where use of an arbitrary iterable with the + :func:`_sql.select` function was not working, outside of plain lists. The + forwards/backwards compatibility logic here now checks for a wider range of + incoming "iterable" types including that a ``.c`` collection from a + selectable can be passed directly. Pull request compliments of Oliver Rice. .. changelog:: :version: 1.4.0b2 diff --git a/doc/build/changelog/unreleased_14/5924.rst b/doc/build/changelog/unreleased_14/5924.rst deleted file mode 100644 index f0ec874c6d..0000000000 --- a/doc/build/changelog/unreleased_14/5924.rst +++ /dev/null @@ -1,7 +0,0 @@ -.. change:: - :tags: bug, sql - :tickets: 5924 - - Fixed bug where the "cartesian product" assertion was not correctly - accommodating for joins between tables that relied upon the use of LATERAL - to connect from a subquery to another subquery in the enclosing context. \ No newline at end of file diff --git a/doc/build/changelog/unreleased_14/5933.rst b/doc/build/changelog/unreleased_14/5933.rst deleted file mode 100644 index 15409cde4f..0000000000 --- a/doc/build/changelog/unreleased_14/5933.rst +++ /dev/null @@ -1,14 +0,0 @@ -.. change:: - :tags: bug, orm - :tickets: 5933 - - Fixed issue in new 1.4/2.0 style ORM queries where a statement-level label - style would not be preserved in the keys used by result rows; this has been - applied to all combinations of Core/ORM columns / session vs. connection - etc. so that the linkage from statement to result row is the same in all - cases. As part of this change, the labeling of column expressions - in rows has been improved to retain the original name of the ORM - attribute even if used in a subquery. - - - diff --git a/doc/build/changelog/unreleased_14/5934.rst b/doc/build/changelog/unreleased_14/5934.rst deleted file mode 100644 index 10d09aeb0b..0000000000 --- a/doc/build/changelog/unreleased_14/5934.rst +++ /dev/null @@ -1,6 +0,0 @@ -.. change:: - :tags: bug, sql - :tickets: 5934 - - Fixed 1.4 regression where the :meth:`_functions.Function.in_` method was - not covered by tests and failed to function properly in all cases. diff --git a/doc/build/changelog/unreleased_14/5935.rst b/doc/build/changelog/unreleased_14/5935.rst deleted file mode 100644 index f7d06301a9..0000000000 --- a/doc/build/changelog/unreleased_14/5935.rst +++ /dev/null @@ -1,9 +0,0 @@ -.. change:: - :tags: bug, sql - :tickets: 5935 - - Fixed regression where use of an arbitrary iterable with the - :func:`_sql.select` function was not working, outside of plain lists. The - forwards/backwards compatibility logic here now checks for a wider range of - incoming "iterable" types including that a ``.c`` collection from a - selectable can be passed directly. Pull request compliments of Oliver Rice. diff --git a/doc/build/changelog/unreleased_14/5939.rst b/doc/build/changelog/unreleased_14/5939.rst deleted file mode 100644 index 2552cb2c1b..0000000000 --- a/doc/build/changelog/unreleased_14/5939.rst +++ /dev/null @@ -1,7 +0,0 @@ -.. change:: - :tags: sql, usecase, postgresql, sqlite - :tickets: 5939 - - Enhance ``set_`` keyword of :class:`.OnConflictDoUpdate` to accept a - :class:`.ColumnCollection`, such as the ``.c.`` collection from a - :class:`Selectable`, or the ``.excluded`` contextual object. diff --git a/doc/build/changelog/unreleased_14/5941.rst b/doc/build/changelog/unreleased_14/5941.rst deleted file mode 100644 index 103db5412f..0000000000 --- a/doc/build/changelog/unreleased_14/5941.rst +++ /dev/null @@ -1,22 +0,0 @@ -.. change:: - :tags: bug, engine, postgresql - :tickets: 5941 - - Continued with the improvement made as part of :ticket:`5653` to further - support bound parameter names, including those generated against column - names, for names that include colons, parenthesis, and question marks, as - well as improved test support, so that bound parameter names even if they - are auto-derived from column names should have no problem including for - parenthesis in psycopg2's "pyformat" style. - - As part of this change, the format used by the asyncpg DBAPI adapter (which - is local to SQLAlchemy's asyncpg dialect) has been changed from using - "qmark" paramstyle to "format", as there is a standard and internally - supported SQL string escaping style for names that use percent signs with - "format" style (i.e. to double percent signs), as opposed to names that use - question marks with "qmark" style (where an escaping system is not defined - by pep-249 or Python). - - .. seealso:: - - :ref:`change_5941` \ No newline at end of file diff --git a/doc/build/changelog/unreleased_14/orm_from_returning.rst b/doc/build/changelog/unreleased_14/orm_from_returning.rst deleted file mode 100644 index c3e720a009..0000000000 --- a/doc/build/changelog/unreleased_14/orm_from_returning.rst +++ /dev/null @@ -1,13 +0,0 @@ -.. change:: - :tags: feature, orm - - The ORM used in :term:`2.0 style` can now return ORM objects from the rows - returned by an UPDATE..RETURNING or INSERT..RETURNING statement, by - supplying the construct to :meth:`_sql.Select.from_statement` in an ORM - context. - - .. seealso:: - - :ref:`orm_dml_returning_objects` - - diff --git a/doc/build/conf.py b/doc/build/conf.py index 8bea12c3d6..505647708a 100644 --- a/doc/build/conf.py +++ b/doc/build/conf.py @@ -193,9 +193,9 @@ copyright = u"2007-2021, the SQLAlchemy authors and contributors" # noqa # The short X.Y version. version = "1.4" # The full version, including alpha/beta/rc tags. -release = "1.4.0b2" +release = "1.4.0b3" -release_date = "February 3, 2021" +release_date = "February 15, 2021" site_base = os.environ.get("RTD_SITE_BASE", "http://www.sqlalchemy.org") site_adapter_template = "docs_adapter.mako" -- 2.47.2