Hello. CAST in MySQL and its forks is not compliant with cast specification from the SQL Standard and is not compatible with other database systems. H2 cannot emulate this deviation.
You can replace it with something like case when sequence >= 0 then sequence else sequence + 18446744073709551616 end It should work in almost all database systems, including MySQL and H2. -- 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/095d1d69-f907-47d1-87d9-b6a2cdf68af9n%40googlegroups.com.