Hi Thomas,
I am using h2 v 1.2.137 with h2.functionsInSchema activated.
There is a problem in a views which have subordinated functions in
schema.
Sample:
create view schema1.xxx as
select schema2.func() from dual
Create statement reports no errors. I can do "select * from
schema1.xxx" and it is working.
But, when I close database and open it again, or I run "alter view
schema1.xxx recompile", select is not working any more:
View "SCHEMA1.XXX" is invalid: "Function ""FUNC"" not
found [90022-137]";
because view is trying to execute PUBLIC.func() instead of
schema2.func().
Maybe is a problem table INFORMATION_SCHEMA.VIEWS, column
VIEW_DEFINITION which is containing create view statement where is
function without schema.
Regards, Zvonko
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
