Schema Compare doesn't support unique indexes which contain CASE statements
We have a unique index that contains a case statement:
ADD UNIQUE INDEX uk__phone__org_id__phone_number(org_id, ((case when (`org_id` <> 2) then `phone_number` end)));
We added this index to our database project and when we perform a schema compare between the project and an actual database, it reduces the project's unique index to:
ADD UNIQUE INDEX uk__phone__org_id__phone_number(org_id);
Is it possible to allow the schema compare to support indexes that contain case statements?