Hi, I assume Niels' comment in the bug report says it all. In my words: "READ ONLY" (in MonetDB) protects against table content changes, but not against schema changes (DDL). (The main (and only?) intention of READ ONLY is to make (read-only) queries simpler (and hence faster) by avoiding the need to take care of "deltas", i.e., changes to the tables content that have not yet been merged into the genuine table storage. (Content changes are not instantly applied on / merged into the genuine table storage to facilitate correct and efficient transaction management.)) Consequently, the bug should have been / was meant to be closed with "Won't fix" or "Invalid" rather than "Fixed". Best, Stefan ----- On Mar 7, 2016, at 12:00 AM, Anthony Damico ajdamico@gmail.com wrote:
hi, this bugzilla ticket is marked as resolved, but this behavior seems unintuitive to me.. is it ok? thanks team
CREATE TABLE my_table AS SELECT 1 AS my_column WITH DATA; ALTER TABLE my_table SET READ ONLY; SELECT COUNT(*) FROM my_table; DROP TABLE my_table;
from https://www.monetdb.org/bugzilla/show_bug.cgi?id=3895
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |