Hi! Your table definition has non-portable MySQL-specific syntax. If this is not your intention, you should use standard CONSTRAINT mdrIdProeprtyName UNIQUE(mdr_id, property_name) instead.
MySQL-specific features are only allowed in MySQL and MariaDB compatibility modes: https://h2database.com/html/features.html#compatibility If you use H2 for unit tests with Spring Boot, you also need to disable automatic configuration of databases with @AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE) annotation or in any other way. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/b82e8e0c-ab92-417d-9f40-58038c008bf0n%40googlegroups.com.
