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.
CREATE ALIAS DATE_TRUNC AS $$
String DATE_TRUNC(String str, java.sql.Date date) {
return "somevalue";
}
$$;
test_db.mv.db
Description: Binary data
