Hi, The same problem with functions in CONSTRAINS. In the INFOMRATION_SCHEMA.CONSTRAINS do not appear either. Regars, Jose
On Jun 11, 3:41 pm, Rami Ojares <[email protected]> wrote: > I was just about to report about exactly the same issue yesterday but > was too lazy. > Thanks Zvonko for doing it! > > - rami > > On 11.6.2010 15:21, Zvonko wrote: > > > 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.
