Dear developer team.
We have the following situation:
- exists main database A which allows access to user B:
CREATE OR REPLACE EDITIONABLE SYNONYM DATABASECHANGELOG FOR A.DATABASECHANGELOG;
CREATE OR REPLACE EDITIONABLE SYNONYM DATABASECHANGELOGLOCK FOR A.DATABASECHANGELOGLOCK;
Now on starting liquibase it does not see those tables (synonyms) and allows to create new tables DATABASECHANGELOG and DATABASECHANGELOGLOC. And sure we have exception like "object already exists".
I think it would be nice feature to interpret table synonyms as tables.
CREATE OR REPLACE EDITIONABLE SYNONYM DATABASECHANGELOG FOR A.DATABASECHANGELOG;
CREATE OR REPLACE EDITIONABLE SYNONYM DATABASECHANGELOGLOCK FOR A.DATABASECHANGELOGLOCK;
Now on starting liquibase it does not see those tables (synonyms) and allows to create new tables DATABASECHANGELOG and DATABASECHANGELOGLOC. And sure we have exception like "object already exists".
I think it would be nice feature to interpret table synonyms as tables.