Hello. If your database is in PageStore format you need to export it to SQL script with 1.4.196, create a new database with a new version and populate it with this script due to issue #1247. https://github.com/h2database/h2database/issues/1247 https://h2database.com/html/tutorial.html#upgrade_backup_restore
If your database is in MVStore format you need to do the same if you want to upgrade H2 to 1.4.197. If you want to upgrade directly to 1.4.199 it is not really required, because that issue was resolved (for MVStore only), but you may run into some other incompatibility, so you should have a backup copy of your database anyway. 1.4.197 and 1.4.199 have different known regressions that affect only some users. It's possible that one of these versions doesn't suitable for your application. Also there were many changes since 1.4.196. H2 is more standard-compliant now and has many new features. Some old tricks and workarounds may not work any more and should be replaced with correct syntax. For example, IN with row value was reimplemented properly for 1.4.198: https://github.com/h2database/h2database/issues/1760 You may need to change something in your application if you used some of such tricks. -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
