Hi
Evgenij Ryazanov ,
Thank you so much for your quick response and the suggestion. When changed
the constraint to a standard CONSTRAINT mdrIdProeprtyName UNIQUE(mdr_id,
property_name) the error is not shown.
Thanks,
Balamurali
On Friday, February 9, 2024 at 12:46:17 PM UTC+5:30 Evgenij Ryazanov wrote:
> 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.
>
--
This electronic communication and the information and any files transmitted
with it, or attached to it, are confidential and are intended solely for
the use of the individual or entity to whom it is addressed and may contain
information that is confidential, legally privileged, protected by privacy
laws, or otherwise restricted from disclosure to anyone else. If you are
not the intended recipient or the person responsible for delivering the
e-mail to the intended recipient, you are hereby notified that any use,
copying, distributing, dissemination, forwarding, printing, or copying of
this e-mail is strictly prohibited. If you received this e-mail in error,
please return the e-mail to the sender, delete it from your computer, and
destroy any printed copy of it.
--
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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/43ac8fb9-d5d2-4203-8d71-3ab63d20d07cn%40googlegroups.com.
