Is there a way to force a virtual table to be deleted from a database
file (other than to rebuild the whole database without the table)?
When the interface of a virtual table changes, drop table on a table
created with the old interface might not work, since drop table will
call the constructor
Hi all,
In Skrooge (http://skrooge.org), we use extensively views, and views based on
views. However, it seems that in such a case, the linked views are computed
several times. To better explain the issue, Stephane, our main developper,
created a small use case, explaining the issue :
CREATE
On Fri, Jun 1, 2012 at 10:33 AM, Guillaume DE BURE
guillaume.deb...@gmail.com wrote:
Hi all,
In Skrooge (http://skrooge.org), we use extensively views, and views
based on
views. However, it seems that in such a case, the linked views are computed
several times. To better explain the issue,
Perhaps the query flattener should ignore any nondeterministic functions? Are
there any others besides random() or date/time functions?
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems