To be properly consistent with VIEW behaviour, somehow OQGRAPH needs to detect attempts to change the underlying table structure and attributes and act accordingly.
We have to choices:
1) go through and make sure that if the user does do this, it cant cause a crash somewhere - this should be checked anyway
2) and, detect if ALTER TABLE changing the referenced attributes in the same way as for a VIEW
For example, if a table referenced by a view is renamed, then the following happens:
ERROR 1356 (HY000): View 'test.x' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
But if DATA_TABLE is renamed, then SELECT * from oqgraph_table appears to still work as before...
If the column referenced is renamed, SELECT * from oqgraph_table appears to still work as before...
Need to decide correct behaviour in this instance.
To be properly consistent with VIEW behaviour, somehow OQGRAPH needs to detect attempts to change the underlying table structure and attributes and act accordingly.
We have to choices:
1) go through and make sure that if the user does do this, it cant cause a crash somewhere - this should be checked anyway
2) and, detect if ALTER TABLE changing the referenced attributes in the same way as for a VIEW
For example, if a table referenced by a view is renamed, then the following happens:
ERROR 1356 (HY000): View 'test.x' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
But if DATA_TABLE is renamed, then SELECT * from oqgraph_table appears to still work as before...
If the column referenced is renamed, SELECT * from oqgraph_table appears to still work as before...
Need to decide correct behaviour in this instance.