summaryrefslogtreecommitdiffstats
path: root/tests/dialects/test_sqlite.py
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-06-17 09:15:19 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-06-17 09:15:19 +0000
commit5ac403c53fc7e610ee679587187546a61e2e342b (patch)
tree819e7e322201cb0206e429e6590ae85f3676e68d /tests/dialects/test_sqlite.py
parentReleasing debian version 25.0.3-1. (diff)
downloadsqlglot-5ac403c53fc7e610ee679587187546a61e2e342b.tar.xz
sqlglot-5ac403c53fc7e610ee679587187546a61e2e342b.zip
Merging upstream version 25.1.0.
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.py1
1 files changed, 1 insertions, 0 deletions
diff --git a/tests/dialects/test_sqlite.py b/tests/dialects/test_sqlite.py
index f3cde0b..46bbadc 100644
--- a/tests/dialects/test_sqlite.py
+++ b/tests/dialects/test_sqlite.py
@@ -202,6 +202,7 @@ class TestSQLite(Validator):
"CREATE TABLE z (a INTEGER UNIQUE PRIMARY KEY AUTOINCREMENT)",
read={
"mysql": "CREATE TABLE z (a INT UNIQUE PRIMARY KEY AUTO_INCREMENT)",
+ "postgres": "CREATE TABLE z (a INT GENERATED BY DEFAULT AS IDENTITY NOT NULL UNIQUE PRIMARY KEY)",
},
write={
"sqlite": "CREATE TABLE z (a INTEGER UNIQUE PRIMARY KEY AUTOINCREMENT)",