am i doing something stupid, or should i file a bug report? this seems absurd :) thanks
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>
Le 17/12/2015 20:54, Anthony Damico a écrit :
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)
Doc: "An individual table can be protected using the READ ONLY mode. All attempts to *update*are flagged as a SQL error." As youdid not "update" the data, it seems normal I guess.
dropping it isn't updating it?
On Friday, December 18, 2015, Guillaume Savary < guillaume.savary@securactive.net> wrote:
Le 17/12/2015 20:54, Anthony Damico a écrit :
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)
Doc: "An individual table can be protected using the READ ONLY mode. All attempts to *update* are flagged as a SQL error." As you did not "update" the data, it seems normal I guess.
-- Guillaume Savary Securactive R&D
It is read-only, not write protected:)
I am joking, but we use the read-only property to create non-updatable indeces and perform other optimization that would be impossible to do if there could be updates, appends, inserts etc. into the table.
Now, if the read-only statement means also that you can not drop the table, that is debatable.
Trying creating a table, add one row of values, then make it a read-only and then try to drop it. My bet is it will not be dropped. Then try to delete the row while the table is still read-only, you should not be able.
Lefteris
On Fri, Dec 18, 2015 at 1:47 PM, Anthony Damico ajdamico@gmail.com wrote:
dropping it isn't updating it?
On Friday, December 18, 2015, Guillaume Savary < guillaume.savary@securactive.net> wrote:
Le 17/12/2015 20:54, Anthony Damico a écrit :
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)
Doc: "An individual table can be protected using the READ ONLY mode. All attempts to *update* are flagged as a SQL error." As you did not "update" the data, it seems normal I guess.
-- Guillaume Savary Securactive R&D
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
alright, that seems like a small bug then. if a table has zero records, it cannot be protected but if it has one record, it can. thanks all
https://www.monetdb.org/bugzilla/show_bug.cgi?id=3889
On Fri, Dec 18, 2015 at 7:59 AM, Lefteris lsidir@gmail.com wrote:
It is read-only, not write protected:)
I am joking, but we use the read-only property to create non-updatable indeces and perform other optimization that would be impossible to do if there could be updates, appends, inserts etc. into the table.
Now, if the read-only statement means also that you can not drop the table, that is debatable.
Trying creating a table, add one row of values, then make it a read-only and then try to drop it. My bet is it will not be dropped. Then try to delete the row while the table is still read-only, you should not be able.
Lefteris
On Fri, Dec 18, 2015 at 1:47 PM, Anthony Damico ajdamico@gmail.com wrote:
dropping it isn't updating it?
On Friday, December 18, 2015, Guillaume Savary < guillaume.savary@securactive.net> wrote:
Le 17/12/2015 20:54, Anthony Damico a écrit :
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)
Doc: "An individual table can be protected using the READ ONLY mode. All attempts to *update* are flagged as a SQL error." As you did not "update" the data, it seems normal I guess.
-- Guillaume Savary Securactive R&D
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Kind of yes, but then again you can not drop any table (not just the read-only ones) if it contains data.
On Fri, Dec 18, 2015 at 2:12 PM, Anthony Damico ajdamico@gmail.com wrote:
alright, that seems like a small bug then. if a table has zero records, it cannot be protected but if it has one record, it can. thanks all
https://www.monetdb.org/bugzilla/show_bug.cgi?id=3889
On Fri, Dec 18, 2015 at 7:59 AM, Lefteris lsidir@gmail.com wrote:
It is read-only, not write protected:)
I am joking, but we use the read-only property to create non-updatable indeces and perform other optimization that would be impossible to do if there could be updates, appends, inserts etc. into the table.
Now, if the read-only statement means also that you can not drop the table, that is debatable.
Trying creating a table, add one row of values, then make it a read-only and then try to drop it. My bet is it will not be dropped. Then try to delete the row while the table is still read-only, you should not be able.
Lefteris
On Fri, Dec 18, 2015 at 1:47 PM, Anthony Damico ajdamico@gmail.com wrote:
dropping it isn't updating it?
On Friday, December 18, 2015, Guillaume Savary < guillaume.savary@securactive.net> wrote:
Le 17/12/2015 20:54, Anthony Damico a écrit :
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)
Doc: "An individual table can be protected using the READ ONLY mode. All attempts to *update* are flagged as a SQL error." As you did not "update" the data, it seems normal I guess.
-- Guillaume Savary Securactive R&D
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
you can't drop a table if it contains data? i am confused
On Friday, December 18, 2015, Lefteris lsidir@gmail.com wrote:
Kind of yes, but then again you can not drop any table (not just the read-only ones) if it contains data.
On Fri, Dec 18, 2015 at 2:12 PM, Anthony Damico <ajdamico@gmail.com javascript:_e(%7B%7D,'cvml','ajdamico@gmail.com');> wrote:
alright, that seems like a small bug then. if a table has zero records, it cannot be protected but if it has one record, it can. thanks all
https://www.monetdb.org/bugzilla/show_bug.cgi?id=3889
On Fri, Dec 18, 2015 at 7:59 AM, Lefteris <lsidir@gmail.com javascript:_e(%7B%7D,'cvml','lsidir@gmail.com');> wrote:
It is read-only, not write protected:)
I am joking, but we use the read-only property to create non-updatable indeces and perform other optimization that would be impossible to do if there could be updates, appends, inserts etc. into the table.
Now, if the read-only statement means also that you can not drop the table, that is debatable.
Trying creating a table, add one row of values, then make it a read-only and then try to drop it. My bet is it will not be dropped. Then try to delete the row while the table is still read-only, you should not be able.
Lefteris
On Fri, Dec 18, 2015 at 1:47 PM, Anthony Damico <ajdamico@gmail.com javascript:_e(%7B%7D,'cvml','ajdamico@gmail.com');> wrote:
dropping it isn't updating it?
On Friday, December 18, 2015, Guillaume Savary < guillaume.savary@securactive.net javascript:_e(%7B%7D,'cvml','guillaume.savary@securactive.net');> wrote:
Le 17/12/2015 20:54, Anthony Damico a écrit :
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)
Doc: "An individual table can be protected using the READ ONLY mode. All attempts to *update* are flagged as a SQL error." As you did not "update" the data, it seems normal I guess.
-- Guillaume Savary Securactive R&D
users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
On 18/12/15 14:43, Anthony Damico wrote:
you can't drop a table if it contains data? i am confused
Of course you can. Lefteris is confused, I think.
On Friday, December 18, 2015, Lefteris <lsidir@gmail.com mailto:lsidir@gmail.com> wrote:
Kind of yes, but then again you can not drop any table (not just the read-only ones) if it contains data.
On Fri, Dec 18, 2015 at 2:12 PM, Anthony Damico <ajdamico@gmail.com javascript:_e(%7B%7D,'cvml','ajdamico@gmail.com');> wrote:
alright, that seems like a small bug then. if a table has zero records, it cannot be protected but if it has one record, it can. thanks all
https://www.monetdb.org/bugzilla/show_bug.cgi?id=3889
On Fri, Dec 18, 2015 at 7:59 AM, Lefteris <lsidir@gmail.com javascript:_e(%7B%7D,'cvml','lsidir@gmail.com');> wrote:
It is read-only, not write protected:)
I am joking, but we use the read-only property to create non-updatable indeces and perform other optimization that would be impossible to do if there could be updates, appends, inserts etc. into the table.
Now, if the read-only statement means also that you can not drop the table, that is debatable.
Trying creating a table, add one row of values, then make it a read-only and then try to drop it. My bet is it will not be dropped. Then try to delete the row while the table is still read-only, you should not be able.
Lefteris
On Fri, Dec 18, 2015 at 1:47 PM, Anthony Damico <ajdamico@gmail.com javascript:_e(%7B%7D,'cvml','ajdamico@gmail.com');> wrote:
dropping it isn't updating it?
On Friday, December 18, 2015, Guillaume Savary <guillaume.savary@securactive.net javascript:_e(%7B%7D,'cvml','guillaume.savary@securactive.net');>
wrote:
Le 17/12/2015 20:54, Anthony Damico a écrit :
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)
Doc: "An individual table can be protected using the READ ONLY mode. All attempts to *update*are flagged as a SQL error." As youdid not "update" the data, it seems normal I guess.
-- Guillaume Savary Securactive R&D
_______________________________________________ users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender
I was actually asking:) I had not tried it out.
But anyway, i did now,
sql>create table test (a int);operation successful (28.245ms)sql>insert into test values(5);1 affected row (10.268ms)sql>alter table test set read only;operation successful (13.967ms)sql>drop table test;operation successful (9.252ms)sql>
It turns out you can drop it even if it does contain data and it is read-only.
I am just trying to figure out if the proposition that a read-only table is not necessarily also a write-protected table is true.
On Fri, Dec 18, 2015 at 2:51 PM, Sjoerd Mullender sjoerd@acm.org wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
On 18/12/15 14:43, Anthony Damico wrote:
you can't drop a table if it contains data? i am confused
Of course you can. Lefteris is confused, I think.
On Friday, December 18, 2015, Lefteris <lsidir@gmail.com mailto:lsidir@gmail.com> wrote:
Kind of yes, but then again you can not drop any table (not just the read-only ones) if it contains data.
On Fri, Dec 18, 2015 at 2:12 PM, Anthony Damico <ajdamico@gmail.com javascript:_e(%7B%7D,'cvml','ajdamico@gmail.com');> wrote:
alright, that seems like a small bug then. if a table has zero records, it cannot be protected but if it has one record, it can. thanks all
https://www.monetdb.org/bugzilla/show_bug.cgi?id=3889
On Fri, Dec 18, 2015 at 7:59 AM, Lefteris <lsidir@gmail.com javascript:_e(%7B%7D,'cvml','lsidir@gmail.com');> wrote:
It is read-only, not write protected:)
I am joking, but we use the read-only property to create non-updatable indeces and perform other optimization that would be impossible to do if there could be updates, appends, inserts etc. into the table.
Now, if the read-only statement means also that you can not drop the table, that is debatable.
Trying creating a table, add one row of values, then make it a read-only and then try to drop it. My bet is it will not be dropped. Then try to delete the row while the table is still read-only, you should not be able.
Lefteris
On Fri, Dec 18, 2015 at 1:47 PM, Anthony Damico <ajdamico@gmail.com javascript:_e(%7B%7D,'cvml','ajdamico@gmail.com');> wrote:
dropping it isn't updating it?
On Friday, December 18, 2015, Guillaume Savary <guillaume.savary@securactive.net javascript:_e(%7B%7D,'cvml','guillaume.savary@securactive.net');>
wrote:
Le 17/12/2015 20:54, Anthony Damico a écrit :
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)
Doc: "An individual table can be protected using the READ ONLY mode. All attempts to *update*are flagged as a SQL error." As youdid not "update" the data, it seems normal I guess.
-- Guillaume Savary Securactive R&D
_______________________________________________ users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v2
iQEcBAEBCAAGBQJWdA9NAAoJEISMxT6LrWYgZ2YIAL6r8hgzpzQg514/2bzsCe5P 9vhfhIGAkoYQBBoWlSqFX6foml6cD1yU9yu7Sqv2MCa6iLr4ixxP+9eCMStbN4If Jd8LvpV0vubKeXaidJwXw9aeXYQgvoxpUtyWmFWh8LLfIrK+bsdBsHzHC3iLODKR R5ZN0uJzYRy2G4AyU1zqA4hN5CUciHoiinplkZOSmwR0vw+KrVl8I0/z/TyIZJMS Ch4MWQLkomtOB6JetUpiHL/jmwYTBHcWFoMGrz6xHq35Ay3TZOu0+MCrjboMIj5/ BsL6al3SCd3age+RRmL7rG93Wf6U3xWYrnzfd3mwbeDrxISnwnFvrxu6cE6He70= =ZX4o -----END PGP SIGNATURE----- _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
It's the same semantics as for files and directories in a filesystem with permissions: A file may be inaccessible to you for writing (i.e. read-only), but if you have read access to its directory you can still delete it.
(So if I were Anthony I would ask about making sys.schemas read-only etc.)
Eyal
On 12/18/2015 03:16 PM, Lefteris wrote:
I was actually asking:) I had not tried it out.
But anyway, i did now,
sql>create table test (a int); operation successful (28.245ms) sql>insert into test values(5); 1 affected row (10.268ms) sql>alter table test set read only; operation successful (13.967ms) sql>drop table test; operation successful (9.252ms) sql>It turns out you can drop it even if it does contain data and it is read-only.
I am just trying to figure out if the proposition that a read-only table is not necessarily also a write-protected table is true.
On Fri, Dec 18, 2015 at 2:51 PM, Sjoerd Mullender <sjoerd@acm.org mailto:sjoerd@acm.org> wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 On 18/12/15 14:43, Anthony Damico wrote: > you can't drop a table if it contains data? i am confused Of course you can. Lefteris is confused, I think. > On Friday, December 18, 2015, Lefteris <lsidir@gmail.com <mailto:lsidir@gmail.com> > <mailto:lsidir@gmail.com <mailto:lsidir@gmail.com>>> wrote: > > Kind of yes, but then again you can not drop any table (not just > the read-only ones) if it contains data. > > On Fri, Dec 18, 2015 at 2:12 PM, Anthony Damico > <ajdamico@gmail.com <mailto:ajdamico@gmail.com> > <javascript:_e(%7B%7D,'cvml','ajdamico@gmail.com <mailto:ajdamico@gmail.com>');>> wrote: > > alright, that seems like a small bug then. if a table has zero > records, it cannot be protected but if it has one record, it can. > thanks all > >https://www.monetdb.org/bugzilla/show_bug.cgi?id=3889 > > > > On Fri, Dec 18, 2015 at 7:59 AM, Lefteris <lsidir@gmail.com <mailto:lsidir@gmail.com> > <javascript:_e(%7B%7D,'cvml','lsidir@gmail.com <mailto:lsidir@gmail.com>');>> wrote: > > It is read-only, not write protected:) > > I am joking, but we use the read-only property to create > non-updatable indeces and perform other optimization that would be > impossible to do if there could be updates, appends, inserts etc. > into the table. > > Now, if the read-only statement means also that you can not drop > the table, that is debatable. > > Trying creating a table, add one row of values, then make it a > read-only and then try to drop it. My bet is it will not be > dropped. Then try to delete the row while the table is still > read-only, you should not be able. > > Lefteris > > > On Fri, Dec 18, 2015 at 1:47 PM, Anthony Damico > <ajdamico@gmail.com <mailto:ajdamico@gmail.com> > <javascript:_e(%7B%7D,'cvml','ajdamico@gmail.com <mailto:ajdamico@gmail.com>');>> wrote: > > dropping it isn't updating it? > > > On Friday, December 18, 2015, Guillaume Savary > <guillaume.savary@securactive.net <mailto:guillaume.savary@securactive.net> > <javascript:_e(%7B%7D,'cvml','guillaume.savary@securactive.net <mailto:guillaume.savary@securactive.net>');>> > > wrote: > > > Le 17/12/2015 20:54, Anthony Damico a écrit : >> 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) > > Doc: "An individual table can be protected using the READ ONLY > mode. All attempts to *update*are flagged as a SQL error." As > youdid not "update" the data, it seems normal I guess. > > -- Guillaume Savary Securactive R&D > > > _______________________________________________ users-list mailing > listusers-list@monetdb.org <mailto:users-list@monetdb.org> > <javascript:_e(%7B%7D,'cvml','users-list@monetdb.org <mailto:users-list@monetdb.org>');> >https://www.monetdb.org/mailman/listinfo/users-list > > > > _______________________________________________ users-list mailing > listusers-list@monetdb.org <mailto:users-list@monetdb.org> > <javascript:_e(%7B%7D,'cvml','users-list@monetdb.org <mailto:users-list@monetdb.org>');> >https://www.monetdb.org/mailman/listinfo/users-list > > > > _______________________________________________ users-list mailing > listusers-list@monetdb.org <mailto:users-list@monetdb.org> > <javascript:_e(%7B%7D,'cvml','users-list@monetdb.org <mailto:users-list@monetdb.org>');> >https://www.monetdb.org/mailman/listinfo/users-list > > > > > _______________________________________________ users-list mailing > listusers-list@monetdb.org <mailto:users-list@monetdb.org> >https://www.monetdb.org/mailman/listinfo/users-list > - -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBCAAGBQJWdA9NAAoJEISMxT6LrWYgZ2YIAL6r8hgzpzQg514/2bzsCe5P 9vhfhIGAkoYQBBoWlSqFX6foml6cD1yU9yu7Sqv2MCa6iLr4ixxP+9eCMStbN4If Jd8LvpV0vubKeXaidJwXw9aeXYQgvoxpUtyWmFWh8LLfIrK+bsdBsHzHC3iLODKR R5ZN0uJzYRy2G4AyU1zqA4hN5CUciHoiinplkZOSmwR0vw+KrVl8I0/z/TyIZJMS Ch4MWQLkomtOB6JetUpiHL/jmwYTBHcWFoMGrz6xHq35Ay3TZOu0+MCrjboMIj5/ BsL6al3SCd3age+RRmL7rG93Wf6U3xWYrnzfd3mwbeDrxISnwnFvrxu6cE6He70= =ZX4o -----END PGP SIGNATURE----- _______________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (5)
-
Anthony Damico -
Eyal Rozenberg -
Guillaume Savary -
Lefteris -
Sjoerd Mullender