COALESCE constraint

General Discussion
1

Hi,
How can I add COALESCE constraint for a table? I’m using YAML to declaring DB structure.
Eg. below is my table
CREATE TABLE AuditParameters
(
Id STRING(64) NOT NULL,
PartialMinimalAmount INT64,
PartialMaximalAmount INT64,
PartialMinimalCount INT64,
PartialMaximalCount INT64,
PartialPercentageAmount INT64,
PartialPercentageCount INT64,
CONSTRAINT CHK_AuditParameters_PartialRequirements CHECK (
COALESCE(PartialMinimalAmount, PartialMaximalAmount, PartialMinimalCount, PartialMaximalCount, PartialPercentageAmount, PartialPercentageCount) IS NOT NULL
)
) PRIMARY KEY (Id);

2

You will likely need to use the sql change-type and write a custom sql statement.

databaseChangeLog:
  - changeSet:
      id: insert_into_test_city
      author: BOB
      comment: Insert into the test_city table
      changes:
        - sql:
           sql: insert into test_city (id,city_name) values (1,'Columbus');
      rollback:
        - sql:
           sql: delete from test_city where id = 1;