OK i succeded in starting the database with BUILTIN_ALIASES_OVERRIDE=1 BUT then I cannot see or access any objects from a user therefore cannot get rid of a function alias created by the user.
I did have a UUID function created and the database startup complains that it already exists. Can you help please. Robert I found this data in the SCHEMATA table SELECT * FROM INFORMATION_SCHEMA.SCHEMATA; CATALOG_NAME <http://127.0.1.1:8082/query.do?jsessionid=c958ae7f78e980129cde5101cff5e651#> SCHEMA_NAME <http://127.0.1.1:8082/query.do?jsessionid=c958ae7f78e980129cde5101cff5e651#> SCHEMA_OWNER <http://127.0.1.1:8082/query.do?jsessionid=c958ae7f78e980129cde5101cff5e651#> DEFAULT_CHARACTER_SET_NAME <http://127.0.1.1:8082/query.do?jsessionid=c958ae7f78e980129cde5101cff5e651#> DEFAULT_COLLATION_NAME <http://127.0.1.1:8082/query.do?jsessionid=c958ae7f78e980129cde5101cff5e651#> IS_DEFAULT <http://127.0.1.1:8082/query.do?jsessionid=c958ae7f78e980129cde5101cff5e651#> REMARKS <http://127.0.1.1:8082/query.do?jsessionid=c958ae7f78e980129cde5101cff5e651#> ID <http://127.0.1.1:8082/query.do?jsessionid=c958ae7f78e980129cde5101cff5e651#> BUILTIN_ALIASES_OVERRIDE=1 INFORMATION_SCHEMA ROBERT Unicode OFF FALSE -1 BUILTIN_ALIASES_OVERRIDE=1 PUBLIC ROBERT Unicode OFF TRUE 0 On Friday, March 30, 2018 at 2:03:50 AM UTC-4, Evgenij Ryazanov wrote: > > Hello. > > You're right, there were different issues with BUILTIN_ALIAS_OVERRIDE=1. > They are now fixed, these fixes will be in the next release. > > Also it's possible to drop such alias in an old version that does not have > builtin function with such name. > -- 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.
