Mike Bayer 9f9d99928e cache key share; support correct traverse of 'of' ...

Fixed caching issue where the
:paramref:`_sql.Select.with_for_update.key_share` element of
:meth:`_sql.Select.with_for_update` was not considered as part of the cache
key, leading to incorrect caching if different variations of this parameter
were used with an otherwise identical statement.

Also repairs a traversal issue where the ``of`` element of
``ForUpdateArg`` when set to ``None`` cannot be compared against a
non-None element because the traversal defines it as a clauselist.
Traversal in this case is adjusted to accommodate for this case so that
we dont need to create a risky-to-backport change to ``ForUpdateArg``
itself.

Fixes: #11544
Change-Id: Ie8a50716df06977af58b0c22a8c10e1b64d972b9
(cherry picked from commit 6d2f43e14f)
(cherry picked from commit 522baa306f)

2024-06-27 18:24:37 -04:00

..

__init__.py

…

test_case_statement.py

use ExpressionElementRole for case targets in case()

2021-11-03 21:34:40 -04:00

test_compare.py

cache key share; support correct traverse of 'of'

2024-06-27 18:24:37 -04:00

test_compiler.py

dont mis-render value from previous loop iteration

2023-10-19 11:26:37 -04:00

test_computed.py

…

test_constraints.py

remove metadata.bind use from test suite

2021-01-03 13:22:29 -05:00

test_cte.py

Fix positional compiling bugs

2022-12-01 23:54:24 +01:00

test_ddlemit.py

…

test_defaults.py

dont use exception catches for warnings; modernize xdist detection

2022-01-22 19:18:37 -05:00

test_delete.py

…

test_deprecations.py

change the POSTCOMPILE/ SCHEMA symbols to not conflict w mssql quoting

2021-11-09 15:31:37 -05:00

test_external_traversal.py

ensure whereclause, returning copied as tuples

2022-12-28 14:24:29 -05:00

test_from_linter.py

add joins_implicitly to column_valued()

2022-12-20 10:56:55 -05:00

test_functions.py

Fix positional compiling bugs

2022-12-01 23:54:24 +01:00

test_identity_column.py

Fix rendering of order in sequences and identity columns.

2023-08-17 11:18:02 -04:00

test_insert_exec.py

generalize sql server check for id col to accommodate ORM cases

2022-07-05 22:02:43 -04:00

test_insert.py

fix ORM support for column-named bindparam() in crud .values()

2023-01-11 11:48:33 -05:00

test_inspect.py

…

test_labels.py

establish consistency for RETURNING column labels

2022-11-11 14:48:49 -05:00

test_lambdas.py

pass more contextual information to PyWrapper param create

2022-12-27 14:05:15 -05:00

test_lateral.py

Track a second from_linter for lateral subqueries

2021-02-05 13:54:37 -05:00

test_metadata.py

Correct #7664 to include DropSchema

2023-01-28 09:41:47 -05:00

test_operators.py

implement custom setstate to work around implicit type/comparator

2023-08-09 22:14:37 +00:00

test_query.py

open some compound tests for mysql 8.0.31

2022-10-28 02:11:34 -04:00

test_quote.py

Modernize tests - legacy_select

2021-07-21 16:14:43 -04:00

test_resultset.py

look out for extras=None in freeze

2022-12-09 15:58:04 -05:00

test_returning.py

establish consistency for RETURNING column labels

2022-11-11 14:48:49 -05:00

test_roles.py

Update black flak8 and zimports

2021-05-12 22:10:19 +02:00

test_select.py

Add Non linear CTE support

2021-11-16 14:45:35 -05:00

test_selectable.py

avoid putting annotated columns in sets

2022-11-14 13:43:02 -05:00

test_sequences.py

Fix rendering of order in sequences and identity columns.

2023-08-17 11:18:02 -04:00

test_tablesample.py

…

test_text.py

use ExpressionElementRole for case targets in case()

2021-11-03 21:34:40 -04:00

test_type_expressions.py

implement literal_binds with expanding + bind_expression

2022-12-15 10:34:05 -05:00

test_types.py

add informative exception context for literal render

2022-11-14 13:49:38 -05:00

test_update.py

fix ORM support for column-named bindparam() in crud .values()

2023-01-11 11:48:33 -05:00

test_utils.py

Fixes for lambda expressions and relationship loaders

2020-12-11 22:01:57 -05:00

test_values.py

add informative exception context for literal render

2022-11-14 13:49:38 -05:00