- 1.4.3rel_1_4_3

14 files changed, 119 insertions, 107 deletions

diff --git a/doc/build/changelog/changelog_14.rst b/doc/build/changelog/changelog_14.rst
index c85f3c64d..5fa520d74 100644
--- a/doc/build/changelog/changelog_14.rst
+++ b/doc/build/changelog/changelog_14.rst
@@ -15,7 +15,123 @@ This document details individual issue-level changes made throughout
 
 .. changelog::
     :version: 1.4.3
-    :include_notes_from: unreleased_14
+    :released: March 25, 2021
+
+    .. change::
+        :tags: bug, orm
+        :tickets: 6069
+
+        Fixed a bug where python 2.7.5 (default on CentOS 7) wasn't able to import
+        sqlalchemy, because on this version of Python ``exec "statement"`` and
+        ``exec("statement")`` do not behave the same way.  The compatibility
+        ``exec_()`` function was used instead.
+
+    .. change::
+        :tags: sqlite, feature, asyncio
+        :tickets: 5920
+
+        Added support for the aiosqlite database driver for use with the
+        SQLAlchemy asyncio extension.
+
+        .. seealso::
+
+          :ref:`aiosqlite`
+
+    .. change::
+        :tags: bug, regression, orm, declarative
+        :tickets: 6128
+
+        Fixed regression where the ``.metadata`` attribute on a per class level
+        would not be honored, breaking the use case of per-class-hierarchy
+        :class:`.schema.MetaData` for abstract declarative classes and mixins.
+
+
+        .. seealso::
+
+          :ref:`declarative_metadata`
+
+    .. change::
+        :tags: bug, mypy
+
+        Added support for the Mypy extension to correctly interpret a declarative
+        base class that's generated using the :func:`_orm.as_declarative` function
+        as well as the :meth:`_orm.registry.as_declarative_base` method.
+
+    .. change::
+        :tags: bug, mypy
+        :tickets: 6109
+
+        Fixed bug in Mypy plugin where the Python type detection
+        for the :class:`_types.Boolean` column type would produce
+        an exception; additionally implemented support for :class:`_types.Enum`,
+        including detection of a string-based enum vs. use of Python ``enum.Enum``.
+
+    .. change::
+        :tags: bug, reflection, postgresql
+        :tickets: 6129
+
+        Fixed reflection of identity columns in tables with mixed case names
+        in PostgreSQL.
+
+    .. change::
+        :tags: bug, sqlite, regression
+        :tickets: 5848
+
+        Repaired the ``pysqlcipher`` dialect to connect correctly which had
+        regressed in 1.4, and added test + CI support to maintain the driver
+        in working condition.  The dialect now imports the ``sqlcipher3`` module
+        for Python 3 by default before falling back to ``pysqlcipher3`` which
+        is documented as now being unmaintained.
+
+        .. seealso::
+
+          :ref:`pysqlcipher`
+
+
+    .. change::
+        :tags: bug, orm
+        :tickets: 6060
+
+        Fixed bug where ORM queries using a correlated subquery in conjunction with
+        :func:`_orm.column_property` would fail to correlate correctly to an
+        enclosing subquery or to a CTE when :meth:`_sql.Select.correlate_except`
+        were used in the property to control correlation, in cases where the
+        subquery contained the same selectables as ones within the correlated
+        subquery that were intended to not be correlated.
+
+    .. change::
+        :tags: bug, orm
+        :tickets: 6131
+
+        Fixed bug where combinations of the new "relationship with criteria"
+        feature could fail in conjunction with features that make use of the new
+        "lambda SQL" feature, including loader strategies such as selectinload and
+        lazyload, for more complicated scenarios such as polymorphic loading.
+
+    .. change::
+        :tags: bug, orm
+        :tickets: 6124
+
+        Repaired support so that the :meth:`_sql.ClauseElement.params` method can
+        work correctly with a :class:`_sql.Select` object that includes joins
+        across ORM relationship structures, which is a new feature in 1.4.
+
+
+    .. change::
+        :tags: bug, engine, regression
+        :tickets: 6119
+
+        Restored the :class:`_engine.ResultProxy` name back to the
+        ``sqlalchemy.engine`` namespace. This name refers to the
+        :class:`_engine.LegacyCursorResult` object.
+
+    .. change::
+        :tags: bug, orm
+        :tickets: 6115
+
+        Fixed issue where a "removed in 2.0" warning were generated internally by
+        the relationship loader mechanics.
+
 
 .. changelog::
     :version: 1.4.2
diff --git a/doc/build/changelog/unreleased_14/5848.rst b/doc/build/changelog/unreleased_14/5848.rst
deleted file mode 100644
index e8fd34102..000000000
--- a/doc/build/changelog/unreleased_14/5848.rst
+++ /dev/null
@@ -1,14 +0,0 @@
-.. change::
-    :tags: bug, sqlite, regression
-    :tickets: 5848
-
-    Repaired the ``pysqlcipher`` dialect to connect correctly which had
-    regressed in 1.4, and added test + CI support to maintain the driver
-    in working condition.  The dialect now imports the ``sqlcipher3`` module
-    for Python 3 by default before falling back to ``pysqlcipher3`` which
-    is documented as now being unmaintained.
-
-    .. seealso::
-
-      :ref:`pysqlcipher`
-
diff --git a/doc/build/changelog/unreleased_14/5920.rst b/doc/build/changelog/unreleased_14/5920.rst
deleted file mode 100644
index a44148c81..000000000
--- a/doc/build/changelog/unreleased_14/5920.rst
+++ /dev/null
@@ -1,10 +0,0 @@
-.. change::
-    :tags: sqlite, feature, asyncio
-    :tickets: 5920
-
-    Added support for the aiosqlite database driver for use with the
-    SQLAlchemy asyncio extension.
-
-    .. seealso::
-
-      :ref:`aiosqlite`
diff --git a/doc/build/changelog/unreleased_14/6060.rst b/doc/build/changelog/unreleased_14/6060.rst
deleted file mode 100644
index a133a2493..000000000
--- a/doc/build/changelog/unreleased_14/6060.rst
+++ /dev/null
@@ -1,10 +0,0 @@
-.. change::
-    :tags: bug, orm
-    :tickets: 6060
-
-    Fixed bug where ORM queries using a correlated subquery in conjunction with
-    :func:`_orm.column_property` would fail to correlate correctly to an
-    enclosing subquery or to a CTE when :meth:`_sql.Select.correlate_except`
-    were used in the property to control correlation, in cases where the
-    subquery contained the same selectables as ones within the correlated
-    subquery that were intended to not be correlated.
diff --git a/doc/build/changelog/unreleased_14/6069.rst b/doc/build/changelog/unreleased_14/6069.rst
deleted file mode 100644
index 6cebdf44a..000000000
--- a/doc/build/changelog/unreleased_14/6069.rst
+++ /dev/null
@@ -1,8 +0,0 @@
-.. change::
-    :tags: bug, orm
-    :tickets: 6069
-
-    Fixed a bug where python 2.7.5 (default on CentOS 7) wasn't able to import
-    sqlalchemy, because on this version of Python ``exec "statement"`` and
-    ``exec("statement")`` do not behave the same way.  The compatibility
-    ``exec_()`` function was used instead.
\ No newline at end of file
diff --git a/doc/build/changelog/unreleased_14/6109.rst b/doc/build/changelog/unreleased_14/6109.rst
deleted file mode 100644
index b4e609984..000000000
--- a/doc/build/changelog/unreleased_14/6109.rst
+++ /dev/null
@@ -1,8 +0,0 @@
-.. change::
-    :tags: bug, mypy
-    :tickets: 6109
-
-    Fixed bug in Mypy plugin where the Python type detection
-    for the :class:`_types.Boolean` column type would produce
-    an exception; additionally implemented support for :class:`_types.Enum`,
-    including detection of a string-based enum vs. use of Python ``enum.Enum``.
diff --git a/doc/build/changelog/unreleased_14/6115.rst b/doc/build/changelog/unreleased_14/6115.rst
deleted file mode 100644
index f866f9bce..000000000
--- a/doc/build/changelog/unreleased_14/6115.rst
+++ /dev/null
@@ -1,7 +0,0 @@
-.. change::
-    :tags: bug, orm
-    :tickets: 6115
-
-    Fixed issue where a "removed in 2.0" warning were generated internally by
-    the relationship loader mechanics.
-
diff --git a/doc/build/changelog/unreleased_14/6119.rst b/doc/build/changelog/unreleased_14/6119.rst
deleted file mode 100644
index 7fa60aec5..000000000
--- a/doc/build/changelog/unreleased_14/6119.rst
+++ /dev/null
@@ -1,7 +0,0 @@
-.. change::
-    :tags: bug, engine, regression
-    :tickets: 6119
-
-    Restored the :class:`_engine.ResultProxy` name back to the
-    ``sqlalchemy.engine`` namespace. This name refers to the
-    :class:`_engine.LegacyCursorResult` object.
diff --git a/doc/build/changelog/unreleased_14/6124.rst b/doc/build/changelog/unreleased_14/6124.rst
deleted file mode 100644
index c10de7c61..000000000
--- a/doc/build/changelog/unreleased_14/6124.rst
+++ /dev/null
@@ -1,8 +0,0 @@
-.. change::
-    :tags: bug, orm
-    :tickets: 6124
-
-    Repaired support so that the :meth:`_sql.ClauseElement.params` method can
-    work correctly with a :class:`_sql.Select` object that includes joins
-    across ORM relationship structures, which is a new feature in 1.4.
-
diff --git a/doc/build/changelog/unreleased_14/6128.rst b/doc/build/changelog/unreleased_14/6128.rst
deleted file mode 100644
index 5eb7f4a6f..000000000
--- a/doc/build/changelog/unreleased_14/6128.rst
+++ /dev/null
@@ -1,12 +0,0 @@
-.. change::
-    :tags: bug, regression, orm, declarative
-    :tickets: 6128
-
-    Fixed regression where the ``.metadata`` attribute on a per class level
-    would not be honored, breaking the use case of per-class-hierarchy
-    :class:`.schema.MetaData` for abstract declarative classes and mixins.
-
-
-    .. seealso::
-
-      :ref:`declarative_metadata`
\ No newline at end of file
diff --git a/doc/build/changelog/unreleased_14/6129.rst b/doc/build/changelog/unreleased_14/6129.rst
deleted file mode 100644
index 458f4a652..000000000
--- a/doc/build/changelog/unreleased_14/6129.rst
+++ /dev/null
@@ -1,6 +0,0 @@
-.. change::
-    :tags: bug, reflection, postgresql
-    :tickets: 6129
-
-    Fixed reflection of identity columns in tables with mixed case names
-    in PostgreSQL.
\ No newline at end of file
diff --git a/doc/build/changelog/unreleased_14/6131.rst b/doc/build/changelog/unreleased_14/6131.rst
deleted file mode 100644
index ceba91453..000000000
--- a/doc/build/changelog/unreleased_14/6131.rst
+++ /dev/null
@@ -1,8 +0,0 @@
-.. change::
-    :tags: bug, orm
-    :tickets: 6131
-
-    Fixed bug where combinations of the new "relationship with criteria"
-    feature could fail in conjunction with features that make use of the new
-    "lambda SQL" feature, including loader strategies such as selectinload and
-    lazyload, for more complicated scenarios such as polymorphic loading.
diff --git a/doc/build/changelog/unreleased_14/asdecl_mypy.rst b/doc/build/changelog/unreleased_14/asdecl_mypy.rst
deleted file mode 100644
index 170b39f5e..000000000
--- a/doc/build/changelog/unreleased_14/asdecl_mypy.rst
+++ /dev/null
@@ -1,6 +0,0 @@
-.. change::
-    :tags: bug, mypy
-
-    Added support for the Mypy extension to correctly interpret a declarative
-    base class that's generated using the :func:`_orm.as_declarative` function
-    as well as the :meth:`_orm.registry.as_declarative_base` method.
diff --git a/doc/build/conf.py b/doc/build/conf.py
index a6cfd59b2..b253e0779 100644
--- a/doc/build/conf.py
+++ b/doc/build/conf.py
@@ -195,9 +195,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.2"
+release = "1.4.3"
 
-release_date = "March 19, 2021"
+release_date = "March 25, 2021"
 
 site_base = os.environ.get("RTD_SITE_BASE", "http://www.sqlalchemy.org")
 site_adapter_template = "docs_adapter.mako"