Date: 2015-12-18 14:11:42 +0100
From: Anthony Damico <>
To: SQL devs <>
Version: 11.21.11 (Jul2015-SP1)
CC: ajdamico, @njnes

Last updated: 2016-01-15 11:37:39 +0100

Comment 21674

Date: 2015-12-18 14:11:42 +0100
From: Anthony Damico <>

User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:42.0) Gecko/20100101 Firefox/42.0
Build Identifier:

simple reproduction below, thanks!

Reproducible: Always

Steps to Reproduce:

sql>create table my_table as select 1 with data;
operation successful (57.729ms)
sql>alter table my_table set read only;
operation successful (5.488ms)
sql>alter table my_table add column my_column integer;
operation successful (10.563ms)
sql>drop table my_table;
operation successful (6.075ms)
sql>

Comment 21683

Date: 2015-12-22 22:21:00 +0100
From: @njnes

read only only protects content of a table.

Comment 21685

Date: 2015-12-22 22:58:33 +0100
From: Anthony Damico <>

hi niels,

sorry, is there a changeset associated with this bug? or are you saying that tables with zero records cannot be protected?

here's an example of a table with one record as well--

https://www.monetdb.org/bugzilla/show_bug.cgi?id=3895

thanks, and sorry if i'm misunderstanding something