Thanks for responding , I am migration my code from H2 1.3.176 to H2 2.1.214 These are the queries that are already being used in the original code . But now as I have upgraded the version of H2 it started to throw this exception .
Thanks you. On Monday, 18 July 2022 at 14:06:55 UTC+5:30 Evgenij Ryazanov wrote: > Hello. > > Where did you find that syntax? There are no unsigned numeric data types > in the SQL Standard and in the most of database systems including the H2. > This is a feature of MySQL. H2 silently accepts UNSIGNED only in MySQL and > MariaDB compatibility modes, but this declaration is ignored by H2 anyway. > https://h2database.com/html/features.html#compatibility > Also the real MySQL doesn't have the ARRAY data type, so if you use H2 as > an replacement of MySQL for unit tests, you shouldn't try to use it. > > If you use H2 as a primary database, you can use standard-compliant ARRAY > data type safely: > https://h2database.com/html/datatypes.html#array_type > You cannot declare your column as UNSIGNED, but you can add a check > constraint to it if you wish. > -- 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/eb41da36-3e47-483d-8a7a-899d72a3aec3n%40googlegroups.com.
