As an extension to this, you can reproduce it in an even simpler case - you don't even need to use an old version of H2.
You can create the alias with the extension enabled - but if you disconnect from the database, even with the option enabled you will not be able to reconnect to the database. On Wednesday, 28 March 2018 10:59:45 UTC+1, Jack Green wrote: > > Noel, > > Thankyou for your reply. > > I've produced a minimised test case for this issue and I still can't get > it working. > > Instructions: > Create a test database in H2 (1.4.196), > Create an alias for date_trunc, > Upgrade H2 version (1.4.197), > Try to connect to test database - irrespective of whether option is or > isn't used, you can't connect. > > I've attached the sql to create the alias (it uses an inline function > declaration, so no dependencies), the database pre-upgrade and a screenshot > of the error I received. > > Are you able to give it a try in case I'm doing it wrong? > > Regards, > Jack. > > On Tuesday, 27 March 2018 20:54:35 UTC+1, Noel Grandin wrote: >> >> No, you should be able to load such a database, and then drop the user >> created alias​ >> >> SYSTEM aliases are always created first, then USER aliases are created as >> the DB is loaded, so the option only affects whether or not the USER alias >> in the DB is allowed to override the SYSTEM alias >> > -- 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.
