liquibase / liquibase-mongodb

MongoDB extension for Liquibase
Apache License 2.0
54 stars 46 forks source link

liquibase-mongodb smash-up with createIndex on relational Databases #275

Open LeBezout opened 2 years ago

LeBezout commented 2 years ago

2 issues on relational database (h2 for the example) when liquibase-mongodb is in the classpath

Hi, i have installed the liquibase-mongodb extension 4.12.0 to the liquibase (also 4.12.0) "lib" folder with the following dependencies :

When I execute liquibase commands against a non-Mongo project i'm facing two kinds of issue :

  1. [liquibase.integration] dropIndex is not supported on h2
  2. Validation Failed: 3 change sets check sum

The 2 issues seems to be relative to the createIndex change.

Samples projects to reproduce

  1. https://github.com/LeBezout/liquibase-mongodbext-issue-rollback
  2. https://github.com/LeBezout/liquibase-mongodbext-issue-checksums

Bonus : different sizes for the same artifact

Version 4.12.0

What could explain this?

kabroxiko commented 2 years ago

I found the problem with version 4.15.0. the mongodb createIndex method override the core method

without plugin against mariadb: image

with plugin against mariadb: image

LeBezout commented 1 year ago

It also fail on (auto)rollback (here against MySQL) :

liquibase.exception.RollbackImpossibleException: liquibase.exception.RollbackImpossibleException: dropIndex is not supported on mysql