summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2020-10-12 18:22:01 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2020-10-12 18:22:01 -0400
commit6bf0e4ce35c0929e7e8dcb7c25fabe7f7c599f38 (patch)
treed077efbd4adef275a56ad86ede70ef4550a33cc8
parent1cda8e18bf4e9b36d07b9d54c04e1fe035977064 (diff)
downloadsqlalchemy-6bf0e4ce35c0929e7e8dcb7c25fabe7f7c599f38.tar.gz
changelog edits for 1.3.20
Change-Id: Ic053a30e9f0e6c99b638a0629e1192336bff3f76
-rw-r--r--doc/build/changelog/unreleased_13/4392.rst12
-rw-r--r--doc/build/changelog/unreleased_13/5462.rst5
-rw-r--r--doc/build/changelog/unreleased_13/5539.rst9
-rw-r--r--doc/build/changelog/unreleased_13/5541.rst6
-rw-r--r--doc/build/changelog/unreleased_13/5582.rst10
-rw-r--r--doc/build/changelog/unreleased_13/5618.rst9
-rw-r--r--doc/build/changelog/unreleased_13/5635.rst3
-rw-r--r--doc/build/changelog/unreleased_13/5644.rst4
-rw-r--r--lib/sqlalchemy/dialects/postgresql/psycopg2.py4
9 files changed, 32 insertions, 30 deletions
diff --git a/doc/build/changelog/unreleased_13/4392.rst b/doc/build/changelog/unreleased_13/4392.rst
index ecb10ca25..7d42bf692 100644
--- a/doc/build/changelog/unreleased_13/4392.rst
+++ b/doc/build/changelog/unreleased_13/4392.rst
@@ -1,7 +1,11 @@
.. change::
- :tags: engine, postgresql, usecase
+ :tags: postgresql, usecase
:tickets: 4392
- A :class:`.URL` connection now supports multiple hosts for PostgreSQL. Any
- query that contains multiple hosts will now group the hosts as a string
- instead of a tuple of strings. Pull request courtesy Ramon Williams.
+ The psycopg2 dialect now support PostgreSQL multiple host connections, by
+ passing host/port combinations to the query string. Pull request courtesy
+ Ramon Williams.
+
+ .. seealso::
+
+ :ref:`psycopg2_multi_host` \ No newline at end of file
diff --git a/doc/build/changelog/unreleased_13/5462.rst b/doc/build/changelog/unreleased_13/5462.rst
index 2832284eb..f2c7517bd 100644
--- a/doc/build/changelog/unreleased_13/5462.rst
+++ b/doc/build/changelog/unreleased_13/5462.rst
@@ -2,6 +2,5 @@
:tags: mysql, usecase
:tickets: 5462
- Adjusted the :meth:`MySQLDDLCompiler.visit_create_index` to implement
- indexing with expressions and functions on the MySQL dialect as accepted by
- MySQL 8. Pull request courtesy Ramon Williams.
+ Adjusted the MySQL dialect to correctly parenthesize functional index
+ expressions as accepted by MySQL 8. Pull request courtesy Ramon Williams.
diff --git a/doc/build/changelog/unreleased_13/5539.rst b/doc/build/changelog/unreleased_13/5539.rst
index 4010fca1f..3cb6b2128 100644
--- a/doc/build/changelog/unreleased_13/5539.rst
+++ b/doc/build/changelog/unreleased_13/5539.rst
@@ -2,9 +2,6 @@
:tags: change, mysql
:tickets: 5539
- Add new MySQL reserved words: `cube`, `lateral`.
-
- Reference https://dev.mysql.com/doc/refman/8.0/en/keywords.html :
-
- * CUBE (R); became reserved in 8.0.1
- * LATERAL (R); added in 8.0.14 (reserved)
+ Add new MySQL reserved words: ``cube``, ``lateral`` added in MySQL 8.0.1
+ and 8.0.14, respectively; this indicates that these terms will be quoted if
+ used as table or column identifier names.
diff --git a/doc/build/changelog/unreleased_13/5541.rst b/doc/build/changelog/unreleased_13/5541.rst
index 73bb4b69b..f3cdee424 100644
--- a/doc/build/changelog/unreleased_13/5541.rst
+++ b/doc/build/changelog/unreleased_13/5541.rst
@@ -2,7 +2,7 @@
:tags: bug, ext, associationproxy
:tickets: 5541, 5542
- It's not possible right now to use an association proxy element as a plain
- column expression to be SELECTed from or used in a SQL function. An
- informative error is now raised when this occurs.
+ An informative error is now raised when attempting to use an association
+ proxy element as a plain column expression to be SELECTed from or used in a
+ SQL function; this use case is not currently supported.
diff --git a/doc/build/changelog/unreleased_13/5582.rst b/doc/build/changelog/unreleased_13/5582.rst
index dca8855d6..9f8e2df38 100644
--- a/doc/build/changelog/unreleased_13/5582.rst
+++ b/doc/build/changelog/unreleased_13/5582.rst
@@ -2,8 +2,8 @@
:tags: bug, pool
:tickets: 5582
- The following pool parameters were not being propagated to the new pool
- created when :meth:`_engine.Engine.dispose` were called: ``pre_ping``,
- ``use_lifo``. Additionally the ``recycle`` and ``reset_on_return``
- parameters were not propagated for the :class:`_engine.AssertionPool`
- class. These issues have been fixed.
+ Fixed issue where the following pool parameters were not being propagated
+ to the new pool created when :meth:`_engine.Engine.dispose` were called:
+ ``pre_ping``, ``use_lifo``. Additionally the ``recycle`` and
+ ``reset_on_return`` parameter is now propagated for the
+ :class:`_engine.AssertionPool` class.
diff --git a/doc/build/changelog/unreleased_13/5618.rst b/doc/build/changelog/unreleased_13/5618.rst
index ab4d16359..93960201b 100644
--- a/doc/build/changelog/unreleased_13/5618.rst
+++ b/doc/build/changelog/unreleased_13/5618.rst
@@ -2,7 +2,8 @@
:tags: bug, sql
:tickets: 5618
- Fixed bug where an error was not raised for lower-case :func:`_sql.column`
- added to lower-case :func:`_sql.table` object. This now raises
- :class:`_exc.ArgumentError` which has always been the case for upper-case
- :class:`_schema.Column` and :class:`_schema.Table`. \ No newline at end of file
+ Fixed bug where an error was not raised in the case where a
+ :func:`_sql.column` were added to more than one :func:`_sql.table` at a
+ time. This raised correctly for the :class:`_schema.Column` and
+ :class:`_schema.Table` objects. An :class:`_exc.ArgumentError` is now
+ raised when this occurs. \ No newline at end of file
diff --git a/doc/build/changelog/unreleased_13/5635.rst b/doc/build/changelog/unreleased_13/5635.rst
index 08507c4da..90350a760 100644
--- a/doc/build/changelog/unreleased_13/5635.rst
+++ b/doc/build/changelog/unreleased_13/5635.rst
@@ -2,6 +2,5 @@
:tags: bug, tests
:tickets: 5635
- Fixed incompatibilities in the test suite that prevented the tests from
- working with Pytest 6.x.
+ Fixed incompatibilities in the test suite when running against Pytest 6.x.
diff --git a/doc/build/changelog/unreleased_13/5644.rst b/doc/build/changelog/unreleased_13/5644.rst
index d0e20492b..f9218489b 100644
--- a/doc/build/changelog/unreleased_13/5644.rst
+++ b/doc/build/changelog/unreleased_13/5644.rst
@@ -2,5 +2,5 @@
:tags: bug, sql
:tickets: 5644
- Fixed issue where a plain pickle dumps call of the :class:`_sql.Over`
- construct didn't work.
+ Fixed issue where the ``pickle.dumps()`` operation against
+ :class:`_expression.Over` construct would produce a recursion overflow.
diff --git a/lib/sqlalchemy/dialects/postgresql/psycopg2.py b/lib/sqlalchemy/dialects/postgresql/psycopg2.py
index 3f1e12dcc..f7e8bd45f 100644
--- a/lib/sqlalchemy/dialects/postgresql/psycopg2.py
+++ b/lib/sqlalchemy/dialects/postgresql/psycopg2.py
@@ -71,7 +71,9 @@ using ``host`` as an additional keyword argument::
`PQconnectdbParams \
<http://www.postgresql.org/docs/9.1/static/libpq-connect.html#LIBPQ-PQCONNECTDBPARAMS>`_
-Multiple Hosts in Connection String
+.. _psycopg2_multi_host:
+
+Specfiying mutiple fallback hosts
------------------------------------
psycopg2 supports multiple connection points in the connection string.