From e3b9d4c19ec0a77556c630660eb3809dc3cc775d Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 5 Jul 2023 14:47:58 -0400 Subject: [PATCH] - 2.0.18 --- doc/build/changelog/changelog_20.rst | 101 +++++++++++++++++++- doc/build/changelog/unreleased_20/10004.rst | 11 --- doc/build/changelog/unreleased_20/10013.rst | 10 -- doc/build/changelog/unreleased_20/10025.rst | 17 ---- doc/build/changelog/unreleased_20/10028.rst | 7 -- doc/build/changelog/unreleased_20/10054.rst | 6 -- doc/build/changelog/unreleased_20/10061.rst | 9 -- doc/build/changelog/unreleased_20/7340.rst | 7 -- doc/build/changelog/unreleased_20/9932.rst | 7 -- doc/build/changelog/unreleased_20/9945.rst | 16 ---- doc/build/conf.py | 4 +- 11 files changed, 102 insertions(+), 93 deletions(-) delete mode 100644 doc/build/changelog/unreleased_20/10004.rst delete mode 100644 doc/build/changelog/unreleased_20/10013.rst delete mode 100644 doc/build/changelog/unreleased_20/10025.rst delete mode 100644 doc/build/changelog/unreleased_20/10028.rst delete mode 100644 doc/build/changelog/unreleased_20/10054.rst delete mode 100644 doc/build/changelog/unreleased_20/10061.rst delete mode 100644 doc/build/changelog/unreleased_20/7340.rst delete mode 100644 doc/build/changelog/unreleased_20/9932.rst delete mode 100644 doc/build/changelog/unreleased_20/9945.rst diff --git a/doc/build/changelog/changelog_20.rst b/doc/build/changelog/changelog_20.rst index 6ca07b8650..a10af2c99a 100644 --- a/doc/build/changelog/changelog_20.rst +++ b/doc/build/changelog/changelog_20.rst @@ -10,7 +10,106 @@ .. changelog:: :version: 2.0.18 - :include_notes_from: unreleased_20 + :released: July 5, 2023 + + .. change:: + :tags: usecase, typing + :tickets: 10054 + + Improved typing when using standalone operator functions from + ``sqlalchemy.sql.operators`` such as ``sqlalchemy.sql.operators.eq``. + + .. change:: + :tags: usecase, mariadb, reflection + :tickets: 10028 + + Allowed reflecting :class:`_types.UUID` columns from MariaDB. This allows + Alembic to properly detect the type of such columns in existing MariaDB + databases. + + .. change:: + :tags: bug, postgresql + :tickets: 9945 + + Added new parameter ``native_inet_types=False`` to all PostgreSQL + dialects, which indicates converters used by the DBAPI to + convert rows from PostgreSQL :class:`.INET` and :class:`.CIDR` columns + into Python ``ipaddress`` datatypes should be disabled, returning strings + instead. This allows code written to work with strings for these datatypes + to be migrated to asyncpg, psycopg, or pg8000 without code changes + other than adding this parameter to the :func:`_sa.create_engine` + or :func:`_asyncio.create_async_engine` function call. + + .. seealso:: + + :ref:`postgresql_network_datatypes` + + .. change:: + :tags: usecase, extensions + :tickets: 10013 + + Added new option to :func:`.association_proxy` + :paramref:`.association_proxy.create_on_none_assignment`; when an + association proxy which refers to a scalar relationship is assigned the + value ``None``, and the referenced object is not present, a new object is + created via the creator. This was apparently an undefined behavior in the + 1.2 series that was silently removed. + + .. change:: + :tags: bug, typing + :tickets: 10061 + + Fixed some of the typing within the :func:`_orm.aliased` construct to + correctly accept a :class:`.Table` object that's been aliased with + :meth:`.Table.alias`, as well as general support for :class:`.FromClause` + objects to be passed as the "selectable" argument, since this is all + supported. + + .. change:: + :tags: bug, engine + :tickets: 10025 + + Adjusted the :paramref:`_sa.create_engine.schema_translate_map` feature + such that **all** schema names in the statement are now tokenized, + regardless of whether or not a specific name is in the immediate schema + translate map given, and to fallback to substituting the original name when + the key is not in the actual schema translate map at execution time. These + two changes allow for repeated use of a compiled object with schema + schema_translate_maps that include or dont include various keys on each + run, allowing cached SQL constructs to continue to function at runtime when + schema translate maps with different sets of keys are used each time. In + addition, added detection of schema_translate_map dictionaries which gain + or lose a ``None`` key across calls for the same statement, which affects + compilation of the statement and is not compatible with caching; an + exception is raised for these scenarios. + + .. change:: + :tags: bug, mssql, sql + :tickets: 9932 + + Fixed issue where performing :class:`.Cast` to a string type with an + explicit collation would render the COLLATE clause inside the CAST + function, which resulted in a syntax error. + + .. change:: + :tags: usecase, mssql + :tickets: 7340 + + Added support for creation and reflection of COLUMNSTORE + indexes in MSSQL dialect. Can be specified on indexes + specifying ``mssql_columnstore=True``. + + .. change:: + :tags: usecase, postgresql + :tickets: 10004 + + Added multi-host support for the asyncpg dialect. General improvements and + error checking added to the PostgreSQL URL routines for the "multihost" use + case added as well. Pull request courtesy Ilia Dmitriev. + + .. seealso:: + + :ref:`asyncpg_multihost` .. changelog:: :version: 2.0.17 diff --git a/doc/build/changelog/unreleased_20/10004.rst b/doc/build/changelog/unreleased_20/10004.rst deleted file mode 100644 index cb7d9951f3..0000000000 --- a/doc/build/changelog/unreleased_20/10004.rst +++ /dev/null @@ -1,11 +0,0 @@ -.. change:: - :tags: usecase, postgresql - :tickets: 10004 - - Added multi-host support for the asyncpg dialect. General improvements and - error checking added to the PostgreSQL URL routines for the "multihost" use - case added as well. Pull request courtesy Ilia Dmitriev. - - .. seealso:: - - :ref:`asyncpg_multihost` diff --git a/doc/build/changelog/unreleased_20/10013.rst b/doc/build/changelog/unreleased_20/10013.rst deleted file mode 100644 index cb01599388..0000000000 --- a/doc/build/changelog/unreleased_20/10013.rst +++ /dev/null @@ -1,10 +0,0 @@ -.. change:: - :tags: usecase, extensions - :tickets: 10013 - - Added new option to :func:`.association_proxy` - :paramref:`.association_proxy.create_on_none_assignment`; when an - association proxy which refers to a scalar relationship is assigned the - value ``None``, and the referenced object is not present, a new object is - created via the creator. This was apparently an undefined behavior in the - 1.2 series that was silently removed. diff --git a/doc/build/changelog/unreleased_20/10025.rst b/doc/build/changelog/unreleased_20/10025.rst deleted file mode 100644 index ee7fad1d6e..0000000000 --- a/doc/build/changelog/unreleased_20/10025.rst +++ /dev/null @@ -1,17 +0,0 @@ -.. change:: - :tags: bug, engine - :tickets: 10025 - - Adjusted the :paramref:`_sa.create_engine.schema_translate_map` feature - such that **all** schema names in the statement are now tokenized, - regardless of whether or not a specific name is in the immediate schema - translate map given, and to fallback to substituting the original name when - the key is not in the actual schema translate map at execution time. These - two changes allow for repeated use of a compiled object with schema - schema_translate_maps that include or dont include various keys on each - run, allowing cached SQL constructs to continue to function at runtime when - schema translate maps with different sets of keys are used each time. In - addition, added detection of schema_translate_map dictionaries which gain - or lose a ``None`` key across calls for the same statement, which affects - compilation of the statement and is not compatible with caching; an - exception is raised for these scenarios. diff --git a/doc/build/changelog/unreleased_20/10028.rst b/doc/build/changelog/unreleased_20/10028.rst deleted file mode 100644 index 6c075abaae..0000000000 --- a/doc/build/changelog/unreleased_20/10028.rst +++ /dev/null @@ -1,7 +0,0 @@ -.. change:: - :tags: usecase, mariadb, reflection - :tickets: 10028 - - Allowed reflecting :class:`_types.UUID` columns from MariaDB. This allows - Alembic to properly detect the type of such columns in existing MariaDB - databases. diff --git a/doc/build/changelog/unreleased_20/10054.rst b/doc/build/changelog/unreleased_20/10054.rst deleted file mode 100644 index 1e72273ecf..0000000000 --- a/doc/build/changelog/unreleased_20/10054.rst +++ /dev/null @@ -1,6 +0,0 @@ -.. change:: - :tags: usecase, typing - :tickets: 10054 - - Improved typing when using standalone operator functions from - ``sqlalchemy.sql.operators`` such as ``sqlalchemy.sql.operators.eq``. diff --git a/doc/build/changelog/unreleased_20/10061.rst b/doc/build/changelog/unreleased_20/10061.rst deleted file mode 100644 index a8cbaec29d..0000000000 --- a/doc/build/changelog/unreleased_20/10061.rst +++ /dev/null @@ -1,9 +0,0 @@ -.. change:: - :tags: bug, typing - :tickets: 10061 - - Fixed some of the typing within the :func:`_orm.aliased` construct to - correctly accept a :class:`.Table` object that's been aliased with - :meth:`.Table.alias`, as well as general support for :class:`.FromClause` - objects to be passed as the "selectable" argument, since this is all - supported. diff --git a/doc/build/changelog/unreleased_20/7340.rst b/doc/build/changelog/unreleased_20/7340.rst deleted file mode 100644 index 13b6f2475c..0000000000 --- a/doc/build/changelog/unreleased_20/7340.rst +++ /dev/null @@ -1,7 +0,0 @@ -.. change:: - :tags: usecase, mssql - :tickets: 7340 - - Added support for creation and reflection of COLUMNSTORE - indexes in MSSQL dialect. Can be specified on indexes - specifying ``mssql_columnstore=True``. diff --git a/doc/build/changelog/unreleased_20/9932.rst b/doc/build/changelog/unreleased_20/9932.rst deleted file mode 100644 index 71f395c651..0000000000 --- a/doc/build/changelog/unreleased_20/9932.rst +++ /dev/null @@ -1,7 +0,0 @@ -.. change:: - :tags: bug, mssql, sql - :tickets: 9932 - - Fixed issue where performing :class:`.Cast` to a string type with an - explicit collation would render the COLLATE clause inside the CAST - function, which resulted in a syntax error. diff --git a/doc/build/changelog/unreleased_20/9945.rst b/doc/build/changelog/unreleased_20/9945.rst deleted file mode 100644 index c059ca581a..0000000000 --- a/doc/build/changelog/unreleased_20/9945.rst +++ /dev/null @@ -1,16 +0,0 @@ -.. change:: - :tags: bug, postgresql - :tickets: 9945 - - Added new parameter ``native_inet_types=False`` to all PostgreSQL - dialects, which indicates converters used by the DBAPI to - convert rows from PostgreSQL :class:`.INET` and :class:`.CIDR` columns - into Python ``ipaddress`` datatypes should be disabled, returning strings - instead. This allows code written to work with strings for these datatypes - to be migrated to asyncpg, psycopg, or pg8000 without code changes - other than adding this parameter to the :func:`_sa.create_engine` - or :func:`_asyncio.create_async_engine` function call. - - .. seealso:: - - :ref:`postgresql_network_datatypes` diff --git a/doc/build/conf.py b/doc/build/conf.py index 986fed4a11..dbc696e398 100644 --- a/doc/build/conf.py +++ b/doc/build/conf.py @@ -242,9 +242,9 @@ copyright = "2007-2023, the SQLAlchemy authors and contributors" # noqa # The short X.Y version. version = "2.0" # The full version, including alpha/beta/rc tags. -release = "2.0.17" +release = "2.0.18" -release_date = "June 23, 2023" +release_date = "July 5, 2023" site_base = os.environ.get("RTD_SITE_BASE", "https://www.sqlalchemy.org") site_adapter_template = "docs_adapter.mako" -- 2.39.5