diff options
| author | mike bayer <mike_mp@zzzcomputing.com> | 2021-04-29 19:53:02 +0000 |
|---|---|---|
| committer | Gerrit Code Review <gerrit@ci3.zzzcomputing.com> | 2021-04-29 19:53:02 +0000 |
| commit | dc5485b7ecdbe1cbed34fcb8d748fbe975aee140 (patch) | |
| tree | 7f0456f166b53fecf881c6e214b69dc7db4944e3 /lib/sqlalchemy/dialects/sqlite | |
| parent | 28493bf4bc35a4802b57b02a8b389cec7b6dcbb6 (diff) | |
| parent | aba308868544b21bafa0b3435701ddc908654b0a (diff) | |
| download | sqlalchemy-dc5485b7ecdbe1cbed34fcb8d748fbe975aee140.tar.gz | |
Merge "Use non-subquery form for empty IN"
Diffstat (limited to 'lib/sqlalchemy/dialects/sqlite')
| -rw-r--r-- | lib/sqlalchemy/dialects/sqlite/base.py | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/lib/sqlalchemy/dialects/sqlite/base.py b/lib/sqlalchemy/dialects/sqlite/base.py index 59d40fef0..66a556ae0 100644 --- a/lib/sqlalchemy/dialects/sqlite/base.py +++ b/lib/sqlalchemy/dialects/sqlite/base.py @@ -1299,6 +1299,11 @@ class SQLiteCompiler(compiler.SQLCompiler): self.process(binary.right, **kw), ) + def visit_empty_set_op_expr(self, type_, expand_op): + # slightly old SQLite versions don't seem to be able to handle + # the empty set impl + return self.visit_empty_set_expr(type_) + def visit_empty_set_expr(self, element_types): return "SELECT %s FROM (SELECT %s) WHERE 1!=1" % ( ", ".join("1" for type_ in element_types or [INTEGER()]), |