]> 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:08:06 +0000 (13:08 -0400)
commit88168db8e9a51ce438e06bfe792e758ed9297ab8
treee9ce458fdcc4f43c288e1c823476af21bb350d9a
parentc01f90de584f50f036c5b6d0c44074b4b3014da4
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
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/coercions.py
lib/sqlalchemy/sql/compiler.py
lib/sqlalchemy/sql/elements.py
test/dialect/test_sqlite.py
test/requirements.py
test/sql/test_compiler.py