(t *testing.T, db *sql.DB, tableName, columnName string)
| 467 | requireColumnAbsent(t, upgradedDB, "duckgres_managed_warehouses", "iceberg_enabled") |
| 468 | requireColumnDefault(t, upgradedDB, "duckgres_managed_warehouses", "metadata_proxy_enabled", "false") |
| 469 | requireColumnAbsent(t, upgradedDB, "duckgres_org_users", "default_catalog") |
| 470 | // Migration 000036 replays: the grants table exists and the old per-user |
| 471 | // mint clock (explicitly dropped in the downgrade fixture above) does not |
| 472 | // come back. |
| 473 | requireTablePresent(t, upgradedDB, "duckgres_service_grants") |
| 474 | requireColumnPresent(t, upgradedDB, "duckgres_service_grants", "credential_id") |
| 475 | requireColumnPresent(t, upgradedDB, "duckgres_service_grants", "password_hash") |
| 476 | requireColumnAbsent(t, upgradedDB, "duckgres_org_users", "service_grant_expires_at") |
| 477 | // Migration 000038 replays: the Trino tables come back on a schema that |
| 478 | // never had them (000002 dropped the pre-revert versions). |
| 479 | requireTablePresent(t, upgradedDB, "duckgres_managed_warehouse_trino") |
| 480 | requireColumnPresent(t, upgradedDB, "duckgres_managed_warehouse_trino", "trino_cell_id") |
| 481 | requireTablePresent(t, upgradedDB, "duckgres_trino_cluster_bootstrap") |
| 482 | } |
| 483 | |
| 484 | func TestConfigStoreSQLMigration34VersionsExistingAndNewOrgs(t *testing.T) { |
| 485 | _, connStr := newIsolatedConfigStoreSchema(t) |
| 486 | store, err := cpconfigStoreNew(connStr) |
| 487 | if err != nil { |
| 488 | t.Fatalf("create baseline config store: %v", err) |
| 489 | } |
| 490 | baselineDB := storeDB(t, store) |
no test coverage detected