delta/python-packages/sqlalchemy.git/test/dialect/postgresql, branch workflow_test_aiosqlite

Qualify server version call in PostgreSQL

2021-08-24T20:37:08+00:00

Fixes: #6912
Closes: #6920
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/6920
Pull-request-sha: 79af75dfddef25435afd9623698354d280d7c879

Change-Id: Ib6b472452f978378d9f511d17a26988323a89459

fix linter JOIN logic; fix PostgreSQL ARRAY op comparison

2021-08-16T03:14:59+00:00

Adjusted the "from linter" warning feature to accommodate for a chain of
joins more than one level deep where the ON clauses don't explicitly match
up the targets, such as an expression such as "ON TRUE". This mode of use
is intended to cancel the cartesian product warning simply by the fact that
there's a JOIN from "a to b", which was not working for the case where the
chain of joins had more than one element.

this incurs a bit more compiler overhead that comes out in profiling
but is not extensive.

Added the "is_comparison" flag to the PostgreSQL "overlaps",
"contained_by", "contains" operators, so that they work in relevant ORM
contexts as well as in conjunction with the "from linter" feature.

Fixes: #6886
Change-Id: I078dc3fe6d4f7871ffe4ebac3e71e62f3f213d12

Modernize tests - dml_values

2021-07-26T20:00:53+00:00

Change-Id: Ida86ed40c43d91813151621b847376976773a5f9

Modernize tests - dml_whereclause

2021-07-26T16:08:30+00:00

Fixed issue where the unit of work would internally use a 2.0-deprecated
SQL expression form, emitting a deprecation warning when SQLALCHEMY_WARN_20
were enabled.

Fixes: #6812
Change-Id: I0a031e728527a1c3382848b6ddc793939362b128

Modernize tests - legacy_select

2021-07-21T20:14:43+00:00

Change-Id: I04057cc3d3f93de60b02999803e2ba6a23cdf68d

Merge "Extract format_constraint truncation rules to ON CONFLICT"

2021-07-13T15:09:05+00:00

Extract format_constraint truncation rules to ON CONFLICT

2021-07-13T14:15:07+00:00

Fixed issue where a too-long constraint name rendered as part of the "ON
CONFLICT ON CONSTRAINT" element of the :class:`_postgresql.Insert`
construct due to naming convention generation would not correctly truncate
the name in the same way that it normally renders within a CREATE TABLE
statement, thus producing a non-matching and too-long constraint name.

Fixes: #6755
Change-Id: Ib27014a5ecbc9cd5861a396f8bb49fbc60bf49fe

Merge "implement independent CTEs"

2021-07-12T21:53:11+00:00

Merge "Modernize tests - select(whereclause)"

2021-07-12T21:52:09+00:00

implement independent CTEs

2021-07-12T21:10:58+00:00

Added new method :meth:`_sql.HasCTE.add_cte` to each of the
:func:`_sql.select`, :func:`_sql.insert`, :func:`_sql.update` and
:func:`_sql.delete` constructs. This method will add the given
:class:`_sql.CTE` as an "independent" CTE of the statement, meaning it
renders in the WITH clause above the statement unconditionally even if it
is not otherwise referenced in the primary statement. This is a popular use
case on the PostgreSQL database where a CTE is used for a DML statement
that runs against database rows independently of the primary statement.

Fixes: #6752
Change-Id: Ibf635763e40269cbd10f4c17e208850d8e8d0188