Hello. Yes, there are known issues and most likely they will not be fixed, development of legacy PageStore backend was stopped many years ago, only few changes were applied since then.
Versions before 1.4.197 use incorrect indexes for referential constraints in some cases, this issue was fixed in 1.4.197, but old databases in PageStore format with this issue can't be opened by newer versions due to these changes. Some very old versions from 1.3 series of releases use experimental format for datetime values, this format was removed, because it caused database corruption in some cases. H2 can read old data, but it still can cause corruption. I guess there are others. You need to use the recommended migration procedure and use SQL script as intermediate format. https://h2database.com/html/tutorial.html#upgrade_backup_restore Unfortunately, you may run into some issue with it too, if you used some SQL keywords as identifiers; old versions of H2 don't quote all identifiers in exported SQL scripts. H2 1.4.200 has more keywords than archaic versions, but most of them are from SQL-92. -- 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/07449065-939b-455b-a250-b5adffb69019o%40googlegroups.com.
