diff options
| author | Sebastian Bank <sebastian.bank@uni-leipzig.de> | 2016-04-11 23:16:32 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-06-06 15:53:25 -0400 |
| commit | 3351f5f93ca1968653becbed7f1ddef7afb96077 (patch) | |
| tree | 0bc2a08dd5809522e23eed7a47b9f11bf95ad4b2 /test/dialect/test_sqlite.py | |
| parent | a5f92314edd45a2e411b0f5b3c4d4bec0c7d92f8 (diff) | |
| download | sqlalchemy-3351f5f93ca1968653becbed7f1ddef7afb96077.tar.gz | |
Add IS (NOT) DISTINCT FROM operators
None / True / False render as literals.
For SQLite, "IS" is used as SQLite lacks
"IS DISTINCT FROM" but its "IS" operator acts
this way for NULL.
Doctext-author: Mike Bayer <mike_mp@zzzcomputing.com>
Change-Id: I9227b81f7207b42627a0349d14d40b46aa756cce
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/248
Diffstat (limited to 'test/dialect/test_sqlite.py')
| -rw-r--r-- | test/dialect/test_sqlite.py | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py index 697f21585..473f4f462 100644 --- a/test/dialect/test_sqlite.py +++ b/test/dialect/test_sqlite.py @@ -670,6 +670,17 @@ class SQLTest(fixtures.TestBase, AssertsCompiledSQL): "1" ) + def test_is_distinct_from(self): + self.assert_compile( + sql.column('x').is_distinct_from(None), + "x IS NOT NULL" + ) + + self.assert_compile( + sql.column('x').isnot_distinct_from(False), + "x IS 0" + ) + def test_localtime(self): self.assert_compile( func.localtimestamp(), |