diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-02-08 05:38:42 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-02-08 05:38:42 +0000 |
| commit | c66e4a33e1a07c439f03fe47f146a6c6482bf6df (patch) | |
| tree | cfdf01111c063b3e50841695e6c2768833aea4dc /tests/dialects/test_sqlite.py | |
| parent | Releasing debian version 20.11.0-1. (diff) | |
| download | sqlglot-c66e4a33e1a07c439f03fe47f146a6c6482bf6df.tar.xz sqlglot-c66e4a33e1a07c439f03fe47f146a6c6482bf6df.zip | |
Merging upstream version 21.0.1.
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 | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/tests/dialects/test_sqlite.py b/tests/dialects/test_sqlite.py index 3df74c8..f7a3dd7 100644 --- a/tests/dialects/test_sqlite.py +++ b/tests/dialects/test_sqlite.py @@ -10,12 +10,10 @@ class TestSQLite(Validator): self.validate_identity("INSERT OR IGNORE INTO foo (x, y) VALUES (1, 2)") self.validate_identity("INSERT OR REPLACE INTO foo (x, y) VALUES (1, 2)") self.validate_identity("INSERT OR ROLLBACK INTO foo (x, y) VALUES (1, 2)") + self.validate_identity("CREATE TABLE foo (id INTEGER PRIMARY KEY ASC)") + self.validate_identity("CREATE TEMPORARY TABLE foo (id INTEGER)") self.validate_all( - "CREATE TABLE foo (id INTEGER PRIMARY KEY ASC)", - write={"sqlite": "CREATE TABLE foo (id INTEGER PRIMARY KEY ASC)"}, - ) - self.validate_all( """ CREATE TABLE "Track" ( @@ -73,6 +71,9 @@ class TestSQLite(Validator): self.validate_identity("SELECT UNIXEPOCH('now', 'subsec')") self.validate_identity("SELECT TIMEDIFF('now', '1809-02-12')") self.validate_identity( + "SELECT JSON_EXTRACT('[10, 20, [30, 40]]', '$[2]', '$[0]', '$[1]')", + ) + self.validate_identity( """SELECT item AS "item", some AS "some" FROM data WHERE (item = 'value_1' COLLATE NOCASE) AND (some = 't' COLLATE NOCASE) ORDER BY item ASC LIMIT 1 OFFSET 0""" ) |