We're updating the issue view to help you get more done. 

dropAllForeignKeyConstraints not supported by MariaDB

Description

Using dropAllForeignKeyConstraints on MariaDB 10.3 fails with this exception:

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 app Caused by: liquibase.exception.UnexpectedLiquibaseException: Don't know how to query for sequences on root @ jdbc:mariadb://localhost:3306/empty_i_hope?useSSL=false (Default Schema: empty_i_hope) app at liquibase.snapshot.jvm.SequenceSnapshotGenerator.getSelectSequenceSql(SequenceSnapshotGenerator.java:244) app at liquibase.snapshot.jvm.SequenceSnapshotGenerator.addTo(SequenceSnapshotGenerator.java:44) app at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:79) app at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49) app at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:315) app at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:415) app at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:363) app at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:338) app at liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:106) app at liquibase.snapshot.DatabaseSnapshot.<init>(DatabaseSnapshot.java:59) app at liquibase.snapshot.JdbcDatabaseSnapshot.<init>(JdbcDatabaseSnapshot.java:39) app at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:217) app at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:246) app at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:230) app at liquibase.change.core.DropAllForeignKeyConstraintsChange.generateChildren(DropAllForeignKeyConstraintsChange.java:90) app at liquibase.change.core.DropAllForeignKeyConstraintsChange.generateStatements(DropAllForeignKeyConstraintsChange.java:59) app at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1253) app at liquibase.changelog.ChangeSet.execute(ChangeSet.java:609) app ... 18 common frames omitted

 

Presumably, by the error message, it's because it cannot deal with selecting sequences out of MariaDB. However, as far as I can tell, that's well supported in MariaDB: https://mariadb.com/kb/en/library/sequence-overview/ .

Environment

MariaDB 10.3, Flyway 3.7.0

Status

Assignee

Unassigned

Reporter

Oriol Muñoz Princep

Labels

None

Components

Affects versions

3.7.0

Priority

Major