Merge pull request #1316 from sqlancer/fix/postgres-alter-table-pk-not-null

mrigger · web-flow · commit 5789b2ac3f93 · 2026-04-07T11:08:56.000+08:00
PostgreSQL: Add expected error for PRIMARY KEY on column with DROP NO…
diff --git a/src/sqlancer/postgres/gen/PostgresAlterTableGenerator.java b/src/sqlancer/postgres/gen/PostgresAlterTableGenerator.java
@@ -304,6 +304,7 @@ public SQLQueryAdapter generate() {
                 errors.add("multiple primary keys for table");
                 errors.add("could not create unique index");
                 errors.add("contains null values");
+                errors.add("is not marked NOT NULL");
                 errors.add("cannot cast type");
                 errors.add("unsupported PRIMARY KEY constraint with partition key definition");
                 errors.add("unsupported UNIQUE constraint with partition key definition");
@@ -342,6 +343,7 @@ public SQLQueryAdapter generate() {
                 errors.add("appears twice in unique constraint");
                 errors.add("appears twice in primary key constraint");
                 errors.add("contains null values");
+                errors.add("is not marked NOT NULL");
                 errors.add("insufficient columns in PRIMARY KEY constraint definition");
                 errors.add("which is part of the partition key");
                 break;
