Hi I have migrated away from HSQLDB mostly with success, save for 1 issue.
We create some database views that use a function in order to control their results. E.g: CREATE ALIAS GET_MAX_REV FOR "net.foo.bar.getMaxRev" CREATE VIEW THINGY AS SELECT * FROM WIDGETS WHERE REV <= GET_MAX_REV() This works, but with one shortcoming. The getMaxRev function is volatile, so successive calls to SELECT * FROM THINGY Ought to potentially return dramatically different results. But I can see by setting a breakpoint in getMaxRev that periodically it is not being called. I assume that either the function result, or the query result has been cached somewhere. Is there a way to declare that the function is volatile (perhaps by passing an unused timestamp parameter) ? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
