Check constraint migration fails with syntax error
I made the following migration file and ran the migration:
And it results in this error:
ALTER TABLE "api_owner"
ADD CONSTRAINT "check_owner_one_null" CHECK (user_id IS NOT NULL AND organization_id IS NULL) OR (user_id IS NULL AND organization_id IS NOT NULL);
ALTER TABLE "api_entity"
ADD CONSTRAINT "check_non_self_parent" CHECK (parent_id <> id);ALTER TABLE "api_owner"
ADD CONSTRAINT "check_owner_one_null" CHECK (user_id IS NOT NULL AND organization_id IS NULL) OR (user_id IS NULL AND organization_id IS NOT NULL);
ALTER TABLE "api_entity"
ADD CONSTRAINT "check_non_self_parent" CHECK (parent_id <> id);And it results in this error:
Migration `20240404221624_check_constraints` failed to apply cleanly to the shadow database.
Error:
ERROR: syntax error at or near "OR"
0: sql_schema_connector::validate_migrations
with namespaces=None
at schema-engine\connectors\sql-schema-connector\src\lib.rs:324
1: schema_core::state::DevDiagnostic
at schema-engine\core\src\state.rs:267Migration `20240404221624_check_constraints` failed to apply cleanly to the shadow database.
Error:
ERROR: syntax error at or near "OR"
0: sql_schema_connector::validate_migrations
with namespaces=None
at schema-engine\connectors\sql-schema-connector\src\lib.rs:324
1: schema_core::state::DevDiagnostic
at schema-engine\core\src\state.rs:267