]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Support tuple IN VALUES for SQLite, others
authorMike Bayer <mike_mp@zzzcomputing.com>
Tue, 16 Jul 2019 16:41:09 +0000 (12:41 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Fri, 19 Jul 2019 17:10:23 +0000 (13:10 -0400)
commit19b6c152118229971492192ef29edb9d81078822
treea3c096bdfa20dfd0fcc7f6900e2c6fe68798c18e
parent11ca002ac4329ef5af97666598ac96543e4efca4
Support tuple IN VALUES for SQLite, others

Added support for composite (tuple) IN operators with SQLite, by rendering
the VALUES keyword for this backend.  As other backends such as DB2 are
known to use the same syntax, the syntax is enabled in the base compiler
using a dialect-level flag ``tuple_in_values``.   The change also includes
support for "empty IN tuple" expressions for SQLite when using "in_()"
between a tuple value and an empty set.

Fixes: #4766
Change-Id: I416e1af29b31d78f9ae06ec3c3a48ef6d6e813f5
(cherry picked from commit 88168db8e9a51ce438e06bfe792e758ed9297ab8)
doc/build/changelog/unreleased_13/4766.rst [new file with mode: 0644]
doc/build/orm/loading_relationships.rst
lib/sqlalchemy/dialects/sqlite/base.py
lib/sqlalchemy/engine/default.py
lib/sqlalchemy/sql/compiler.py
lib/sqlalchemy/sql/default_comparator.py
lib/sqlalchemy/sql/elements.py
test/dialect/test_sqlite.py
test/requirements.py
test/sql/test_compiler.py