diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-09-03 07:37:44 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-09-03 07:37:44 +0000 |
| commit | 09b58afa78a1784157d0f0a9db2e16531c9641e2 (patch) | |
| tree | 1f87edad5142630006941a5effbab36b131e6416 /tests/dialects/test_sqlite.py | |
| parent | Adding upstream version 25.16.1. (diff) | |
| download | sqlglot-upstream.tar.xz sqlglot-upstream.zip | |
Adding upstream version 25.18.0.upstream/25.18.0upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/dialects/test_sqlite.py')
| -rw-r--r-- | tests/dialects/test_sqlite.py | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/tests/dialects/test_sqlite.py b/tests/dialects/test_sqlite.py index 46bbadc..f2c9802 100644 --- a/tests/dialects/test_sqlite.py +++ b/tests/dialects/test_sqlite.py @@ -91,6 +91,10 @@ class TestSQLite(Validator): read={"snowflake": "LEAST(x, y, z)"}, write={"snowflake": "LEAST(x, y, z)"}, ) + self.validate_identity( + "SELECT * FROM station WHERE city IS NOT ''", + "SELECT * FROM station WHERE NOT city IS ''", + ) def test_strftime(self): self.validate_identity("SELECT STRFTIME('%Y/%m/%d', 'now')") |