I am having an issue with a User Defined function in an integration test
with an embedded H2 database that shares the same name as an H2 Function.
I am using version 1.4.199 of H2.
CREATE SCHEMA DBMS_LOB;
CREATE ALIAS DBMS_LOB.SUBSTR AS '
String substring(String value, Long max, Long start) {
return "value";
}
';
The error I get is Function Alias SUBSTR already exists. If I change the
alias to DBMS_LOB.SUBSTRR, then the code works as expected. However, I
then have to change my query which will cause it to not work against my
real oracle database. I would have thought giving the Alias a schema would
not cause issues with the SUBSTR, but that doesn't seem to be the case.
Any tips on how to work around this issue?
--
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/d6fa9672-2a7b-4198-8ae6-8e73ae307a42%40googlegroups.com.
