Comment 2 for bug 1134305

Revision history for this message
Andrew McDonnell (andymc73) wrote :

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.