From da4e4cb1c67230abd67e487cfb1bda8cd6910029 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Mon, 17 Aug 2020 15:59:44 -0400 Subject: [PATCH] - 1.3.19 --- doc/build/changelog/changelog_13.rst | 120 ++++++++++++++++++++- doc/build/changelog/unreleased_13/4733.rst | 8 -- doc/build/changelog/unreleased_13/5357.rst | 8 -- doc/build/changelog/unreleased_13/5411.rst | 6 -- doc/build/changelog/unreleased_13/5456.rst | 9 -- doc/build/changelog/unreleased_13/5467.rst | 6 -- doc/build/changelog/unreleased_13/5470.rst | 11 -- doc/build/changelog/unreleased_13/5476.rst | 11 -- doc/build/changelog/unreleased_13/5481.rst | 8 -- doc/build/changelog/unreleased_13/5493.rst | 7 -- doc/build/changelog/unreleased_13/5494.rst | 13 --- doc/build/changelog/unreleased_13/5500.rst | 10 -- doc/build/changelog/unreleased_13/5513.rst | 9 -- doc/build/conf.py | 4 +- 14 files changed, 121 insertions(+), 109 deletions(-) delete mode 100644 doc/build/changelog/unreleased_13/4733.rst delete mode 100644 doc/build/changelog/unreleased_13/5357.rst delete mode 100644 doc/build/changelog/unreleased_13/5411.rst delete mode 100644 doc/build/changelog/unreleased_13/5456.rst delete mode 100644 doc/build/changelog/unreleased_13/5467.rst delete mode 100644 doc/build/changelog/unreleased_13/5470.rst delete mode 100644 doc/build/changelog/unreleased_13/5476.rst delete mode 100644 doc/build/changelog/unreleased_13/5481.rst delete mode 100644 doc/build/changelog/unreleased_13/5493.rst delete mode 100644 doc/build/changelog/unreleased_13/5494.rst delete mode 100644 doc/build/changelog/unreleased_13/5500.rst delete mode 100644 doc/build/changelog/unreleased_13/5513.rst diff --git a/doc/build/changelog/changelog_13.rst b/doc/build/changelog/changelog_13.rst index 140c36ad65..ca06ad553b 100644 --- a/doc/build/changelog/changelog_13.rst +++ b/doc/build/changelog/changelog_13.rst @@ -12,7 +12,125 @@ .. changelog:: :version: 1.3.19 - :include_notes_from: unreleased_13 + :released: August 17, 2020 + + .. change:: + :tags: usecase, py3k + :tickets: #5357 + + Added a ``**kw`` argument to the :meth:`.DeclarativeMeta.__init__` method. + This allows a class to support the :pep:`487` metaclass hook + ``__init_subclass__``. Pull request courtesy Ewen Gillies. + + + .. change:: + :tags: bug, sql + :tickets: 5470 + + Repaired an issue where the "ORDER BY" clause rendering a label name rather + than a complete expression, which is particularly important for SQL Server, + would fail to occur if the expression were enclosed in a parenthesized + grouping in some cases. This case has been added to test support. The + change additionally adjusts the "automatically add ORDER BY columns when + DISTINCT is present" behavior of ORM query, deprecated in 1.4, to more + accurately detect column expressions that are already present. + + .. change:: + :tags: usecase, mysql + :tickets: 5481 + + The MySQL dialect will render FROM DUAL for a SELECT statement that has no + FROM clause but has a WHERE clause. This allows things like "SELECT 1 WHERE + EXISTS (subquery)" kinds of queries to be used as well as other use cases. + + + .. change:: + :tags: bug, mssql, sql + :tickets: 5467 + + Fixed bug where the mssql dialect incorrectly escaped object names that + contained ']' character(s). + + .. change:: + :tags: bug, reflection, sqlite, mssql + :tickets: 5456 + + Applied a sweep through all included dialects to ensure names that contain + single or double quotes are properly escaped when querying system tables, + for all :class:`.Inspector` methods that accept object names as an argument + (e.g. table names, view names, etc). SQLite and MSSQL contained two + quoting issues that were repaired. + + .. change:: + :tags: bug, mysql + :tickets: 5411 + + Fixed an issue where CREATE TABLE statements were not specifying the + COLLATE keyword correctly. + + .. change:: + :tags: bug, datatypes, sql + :tickets: 4733 + + The ``LookupError`` message will now provide the user with up to four + possible values that a column is constrained to via the :class:`.Enum`. + Values longer than 11 characters will be truncated and replaced with + ellipses. Pull request courtesy Ramon Williams. + + .. change:: + :tags: bug, postgresql + :tickets: 5476 + + Fixed issue where the return type for the various RANGE comparison + operators would itself be the same RANGE type rather than BOOLEAN, which + would cause an undesirable result in the case that a + :class:`.TypeDecorator` that defined result-processing behavior were in + use. Pull request courtesy Jim Bosch. + + + + .. change:: + :tags: bug, mysql + :tickets: 5493 + + Added MariaDB code 1927 to the list of "disconnect" codes, as recent + MariaDB versions apparently use this code when the database server was + stopped. + + .. change:: + :tags: usecase, declarative, orm + :tickets: 5513 + + The name of the virtual column used when using the + :class:`_declarative.AbstractConcreteBase` and + :class:`_declarative.ConcreteBase` classes can now be customized, to allow + for models that have a column that is actually named ``type``. Pull + request courtesy Jesse-Bakker. + + .. change:: + :tags: usecase, orm + :tickets: 5494 + + Adjusted the workings of the :meth:`_orm.Mapper.all_orm_descriptors` + accessor to represent the attributes in the order that they are located in + a deterministic way, assuming the use of Python 3.6 or higher which + maintains the sorting order of class attributes based on how they were + declared. This sorting is not guaranteed to match the declared order of + attributes in all cases however; see the method documentation for the exact + scheme. + + + + .. change:: + :tags: bug, sql + :tickets: 5500 + + Fixed issue where the + :paramref:`_engine.Connection.execution_options.schema_translate_map` + feature would not take effect when the :meth:`_schema.Sequence.next_value` + function function for a :class:`_schema.Sequence` were used in the + :paramref:`_schema.Column.server_default` parameter and the create table + DDL were emitted. .. changelog:: :version: 1.3.18 diff --git a/doc/build/changelog/unreleased_13/4733.rst b/doc/build/changelog/unreleased_13/4733.rst deleted file mode 100644 index fb8580041c..0000000000 --- a/doc/build/changelog/unreleased_13/4733.rst +++ /dev/null @@ -1,8 +0,0 @@ -.. change:: - :tags: bug, datatypes, sql - :tickets: 4733 - - The ``LookupError`` message will now provide the user with up to four - possible values that a column is constrained to via the :class:`.Enum`. - Values longer than 11 characters will be truncated and replaced with - ellipses. Pull request courtesy Ramon Williams. diff --git a/doc/build/changelog/unreleased_13/5357.rst b/doc/build/changelog/unreleased_13/5357.rst deleted file mode 100644 index 4503b13862..0000000000 --- a/doc/build/changelog/unreleased_13/5357.rst +++ /dev/null @@ -1,8 +0,0 @@ -.. change:: - :tags: usecase, py3k - :tickets: #5357 - - Added a ``**kw`` argument to the :meth:`.DeclarativeMeta.__init__` method. - This allows a class to support the :pep:`487` metaclass hook - ``__init_subclass__``. Pull request courtesy Ewen Gillies. - diff --git a/doc/build/changelog/unreleased_13/5411.rst b/doc/build/changelog/unreleased_13/5411.rst deleted file mode 100644 index 8389278e27..0000000000 --- a/doc/build/changelog/unreleased_13/5411.rst +++ /dev/null @@ -1,6 +0,0 @@ -.. change:: - :tags: bug, mysql - :tickets: 5411 - - Fixed an issue where CREATE TABLE statements were not specifying the - COLLATE keyword correctly. \ No newline at end of file diff --git a/doc/build/changelog/unreleased_13/5456.rst b/doc/build/changelog/unreleased_13/5456.rst deleted file mode 100644 index 823f3731b9..0000000000 --- a/doc/build/changelog/unreleased_13/5456.rst +++ /dev/null @@ -1,9 +0,0 @@ -.. change:: - :tags: bug, reflection, sqlite, mssql - :tickets: 5456 - - Applied a sweep through all included dialects to ensure names that contain - single or double quotes are properly escaped when querying system tables, - for all :class:`.Inspector` methods that accept object names as an argument - (e.g. table names, view names, etc). SQLite and MSSQL contained two - quoting issues that were repaired. diff --git a/doc/build/changelog/unreleased_13/5467.rst b/doc/build/changelog/unreleased_13/5467.rst deleted file mode 100644 index 241bdb7ff7..0000000000 --- a/doc/build/changelog/unreleased_13/5467.rst +++ /dev/null @@ -1,6 +0,0 @@ -.. change:: - :tags: bug, mssql, sql - :tickets: 5467 - - Fixed bug where the mssql dialect incorrectly escaped object names that - contained ']' character(s). diff --git a/doc/build/changelog/unreleased_13/5470.rst b/doc/build/changelog/unreleased_13/5470.rst deleted file mode 100644 index 69d948e5ae..0000000000 --- a/doc/build/changelog/unreleased_13/5470.rst +++ /dev/null @@ -1,11 +0,0 @@ -.. change:: - :tags: bug, sql - :tickets: 5470 - - Repaired an issue where the "ORDER BY" clause rendering a label name rather - than a complete expression, which is particularly important for SQL Server, - would fail to occur if the expression were enclosed in a parenthesized - grouping in some cases. This case has been added to test support. The - change additionally adjusts the "automatically add ORDER BY columns when - DISTINCT is present" behavior of ORM query, deprecated in 1.4, to more - accurately detect column expressions that are already present. diff --git a/doc/build/changelog/unreleased_13/5476.rst b/doc/build/changelog/unreleased_13/5476.rst deleted file mode 100644 index abbf9b7bde..0000000000 --- a/doc/build/changelog/unreleased_13/5476.rst +++ /dev/null @@ -1,11 +0,0 @@ -.. change:: - :tags: bug, postgresql - :tickets: 5476 - - Fixed issue where the return type for the various RANGE comparison - operators would itself be the same RANGE type rather than BOOLEAN, which - would cause an undesirable result in the case that a - :class:`.TypeDecorator` that defined result-processing behavior were in - use. Pull request courtesy Jim Bosch. - - diff --git a/doc/build/changelog/unreleased_13/5481.rst b/doc/build/changelog/unreleased_13/5481.rst deleted file mode 100644 index 7d7666a72f..0000000000 --- a/doc/build/changelog/unreleased_13/5481.rst +++ /dev/null @@ -1,8 +0,0 @@ -.. change:: - :tags: usecase, mysql - :tickets: 5481 - - The MySQL dialect will render FROM DUAL for a SELECT statement that has no - FROM clause but has a WHERE clause. This allows things like "SELECT 1 WHERE - EXISTS (subquery)" kinds of queries to be used as well as other use cases. - diff --git a/doc/build/changelog/unreleased_13/5493.rst b/doc/build/changelog/unreleased_13/5493.rst deleted file mode 100644 index a1f9f44b2c..0000000000 --- a/doc/build/changelog/unreleased_13/5493.rst +++ /dev/null @@ -1,7 +0,0 @@ -.. change:: - :tags: bug, mysql - :tickets: 5493 - - Added MariaDB code 1927 to the list of "disconnect" codes, as recent - MariaDB versions apparently use this code when the database server was - stopped. diff --git a/doc/build/changelog/unreleased_13/5494.rst b/doc/build/changelog/unreleased_13/5494.rst deleted file mode 100644 index a9b594eb28..0000000000 --- a/doc/build/changelog/unreleased_13/5494.rst +++ /dev/null @@ -1,13 +0,0 @@ -.. change:: - :tags: usecase, orm - :tickets: 5494 - - Adjusted the workings of the :meth:`_orm.Mapper.all_orm_descriptors` - accessor to represent the attributes in the order that they are located in - a deterministic way, assuming the use of Python 3.6 or higher which - maintains the sorting order of class attributes based on how they were - declared. This sorting is not guaranteed to match the declared order of - attributes in all cases however; see the method documentation for the exact - scheme. - - diff --git a/doc/build/changelog/unreleased_13/5500.rst b/doc/build/changelog/unreleased_13/5500.rst deleted file mode 100644 index c93a869499..0000000000 --- a/doc/build/changelog/unreleased_13/5500.rst +++ /dev/null @@ -1,10 +0,0 @@ -.. change:: - :tags: bug, sql - :tickets: 5500 - - Fixed issue where the - :paramref:`_engine.Connection.execution_options.schema_translate_map` - feature would not take effect when the :meth:`_schema.Sequence.next_value` - function function for a :class:`_schema.Sequence` were used in the - :paramref:`_schema.Column.server_default` parameter and the create table - DDL were emitted. diff --git a/doc/build/changelog/unreleased_13/5513.rst b/doc/build/changelog/unreleased_13/5513.rst deleted file mode 100644 index 50e74046be..0000000000 --- a/doc/build/changelog/unreleased_13/5513.rst +++ /dev/null @@ -1,9 +0,0 @@ -.. change:: - :tags: usecase, declarative, orm - :tickets: 5513 - - The name of the virtual column used when using the - :class:`_declarative.AbstractConcreteBase` and - :class:`_declarative.ConcreteBase` classes can now be customized, to allow - for models that have a column that is actually named ``type``. Pull - request courtesy Jesse-Bakker. diff --git a/doc/build/conf.py b/doc/build/conf.py index 210aa4c2fd..6bcd5428b2 100644 --- a/doc/build/conf.py +++ b/doc/build/conf.py @@ -167,9 +167,9 @@ copyright = u"2007-2020, the SQLAlchemy authors and contributors" # noqa # The short X.Y version. version = "1.3" # The full version, including alpha/beta/rc tags. -release = "1.3.18" +release = "1.3.19" -release_date = "June 25, 2020" +release_date = "August 17, 2020" site_base = os.environ.get("RTD_SITE_BASE", "http://www.sqlalchemy.org") site_adapter_template = "docs_adapter.mako" -- 2.47.2