Changeset: cc2f19d16285 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cc2f19d16285 Modified Files: sql/test/BugTracker-2018/Tests/truncate_bam_tables.Bug-6543.stable.err sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.stable.err sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.stable.err sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.stable.out Branch: Mar2018 Log Message:
Approve tests. New error messages and error selecting from some tables as non monetdb user. diffs (298 lines): diff --git a/sql/test/BugTracker-2018/Tests/truncate_bam_tables.Bug-6543.stable.err b/sql/test/BugTracker-2018/Tests/truncate_bam_tables.Bug-6543.stable.err --- a/sql/test/BugTracker-2018/Tests/truncate_bam_tables.Bug-6543.stable.err +++ b/sql/test/BugTracker-2018/Tests/truncate_bam_tables.Bug-6543.stable.err @@ -31,23 +31,23 @@ stderr of test 'truncate_bam_tables.Bug- MAPI = (monetdb) /var/tmp/mtest-20187/.s.monetdb.39345 QUERY = TRUNCATE TABLE bam.sq; -ERROR = !TRUNCATE: cannot truncate system table 'sq' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'sq' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-20187/.s.monetdb.39345 QUERY = TRUNCATE TABLE bam.rg; -ERROR = !TRUNCATE: cannot truncate system table 'rg' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'rg' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-20187/.s.monetdb.39345 QUERY = TRUNCATE TABLE bam.pg; -ERROR = !TRUNCATE: cannot truncate system table 'pg' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'pg' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-20187/.s.monetdb.39345 QUERY = TRUNCATE TABLE bam.export; -ERROR = !TRUNCATE: cannot truncate system table 'export' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'export' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-20187/.s.monetdb.39345 QUERY = TRUNCATE TABLE bam.files; -ERROR = !TRUNCATE: cannot truncate system table 'files' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'files' CODE = 42000 # 17:33:23 > diff --git a/sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.stable.err b/sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.stable.err --- a/sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.stable.err +++ b/sql/test/BugTracker-2018/Tests/truncate_sys_netcdf_tables.Bug-6543.stable.err @@ -29,23 +29,23 @@ stderr of test 'truncate_sys_netcdf_tabl MAPI = (monetdb) /var/tmp/mtest-20187/.s.monetdb.39345 QUERY = TRUNCATE TABLE sys.netcdf_vars; -ERROR = !TRUNCATE: cannot truncate system table 'netcdf_vars' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'netcdf_vars' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-20187/.s.monetdb.39345 QUERY = TRUNCATE TABLE sys.netcdf_vardim; -ERROR = !TRUNCATE: cannot truncate system table 'netcdf_vardim' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'netcdf_vardim' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-20187/.s.monetdb.39345 QUERY = TRUNCATE TABLE sys.netcdf_files; -ERROR = !TRUNCATE: cannot truncate system table 'netcdf_files' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'netcdf_files' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-20187/.s.monetdb.39345 QUERY = TRUNCATE TABLE sys.netcdf_dims; -ERROR = !TRUNCATE: cannot truncate system table 'netcdf_dims' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'netcdf_dims' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-20187/.s.monetdb.39345 QUERY = TRUNCATE TABLE sys.netcdf_attrs; -ERROR = !TRUNCATE: cannot truncate system table 'netcdf_attrs' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'netcdf_attrs' CODE = 42000 # 17:32:24 > diff --git a/sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.stable.err b/sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.stable.err --- a/sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.stable.err +++ b/sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.stable.err @@ -54,119 +54,143 @@ CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.user_role; -ERROR = !TRUNCATE: cannot truncate system table 'user_role' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'user_role' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.types; -ERROR = !TRUNCATE: cannot truncate system table 'types' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'types' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.triggers; -ERROR = !TRUNCATE: cannot truncate system table 'triggers' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'triggers' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.table_types; -ERROR = !TRUNCATE: cannot truncate system table 'table_types' +ERROR = !TRUNCATE: cannot truncate read or append only table 'table_types' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.systemfunctions; -ERROR = !TRUNCATE: cannot truncate system table 'systemfunctions' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'systemfunctions' +CODE = 42000 +MAPI = (testuser) /var/tmp/mtest-7177/.s.monetdb.32793 +QUERY = SELECT (COUNT(*) > 0) AS has_rows FROM sys.storagemodelinput; +ERROR = !SELECT: access denied for testuser to table 'sys.storagemodelinput' CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 +MAPI = (testuser) /var/tmp/mtest-7177/.s.monetdb.32793 QUERY = TRUNCATE TABLE sys.storagemodelinput; -ERROR = !TRUNCATE: cannot truncate system table 'storagemodelinput' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'storagemodelinput' +CODE = 42000 +MAPI = (testuser) /var/tmp/mtest-7177/.s.monetdb.32793 +QUERY = SELECT (COUNT(*) > 0) AS has_rows FROM sys.storagemodelinput; +ERROR = !SELECT: access denied for testuser to table 'sys.storagemodelinput' CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-20187/.s.monetdb.39345 +MAPI = (testuser) /var/tmp/mtest-7177/.s.monetdb.32793 +QUERY = SELECT (COUNT(*) > 0) AS has_rows FROM sys.statistics; +ERROR = !SELECT: access denied for testuser to table 'sys.statistics' +CODE = 42000 +MAPI = (testuser) /var/tmp/mtest-7177/.s.monetdb.32793 QUERY = TRUNCATE TABLE sys.statistics; -ERROR = !TRUNCATE: cannot truncate system table 'statistics' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'statistics' CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 +MAPI = (testuser) /var/tmp/mtest-7177/.s.monetdb.32793 +QUERY = SELECT (COUNT(*) > 0) AS has_rows FROM sys.statistics; +ERROR = !SELECT: access denied for testuser to table 'sys.statistics' +CODE = 42000 +MAPI = (testuser) /var/tmp/mtest-7177/.s.monetdb.32793 QUERY = TRUNCATE TABLE sys.spatial_ref_sys; -ERROR = !TRUNCATE: cannot truncate system table 'spatial_ref_sys' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'spatial_ref_sys' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.sequences; -ERROR = !TRUNCATE: cannot truncate system table 'sequences' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'sequences' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.schemas; -ERROR = !TRUNCATE: cannot truncate system table 'schemas' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'schemas' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.privileges; -ERROR = !TRUNCATE: cannot truncate system table 'privileges' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'privileges' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.privilege_codes; -ERROR = !TRUNCATE: cannot truncate system table 'privilege_codes' +ERROR = !TRUNCATE: cannot truncate read or append only table 'privilege_codes' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.objects; -ERROR = !TRUNCATE: cannot truncate system table 'objects' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'objects' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.keywords; -ERROR = !TRUNCATE: cannot truncate system table 'keywords' +ERROR = !TRUNCATE: cannot truncate read or append only table 'keywords' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.keys; -ERROR = !TRUNCATE: cannot truncate system table 'keys' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'keys' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.key_types; -ERROR = !TRUNCATE: cannot truncate system table 'key_types' +ERROR = !TRUNCATE: cannot truncate read or append only table 'key_types' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.index_types; -ERROR = !TRUNCATE: cannot truncate system table 'index_types' +ERROR = !TRUNCATE: cannot truncate read or append only table 'index_types' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.idxs; -ERROR = !TRUNCATE: cannot truncate system table 'idxs' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'idxs' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.functions; -ERROR = !TRUNCATE: cannot truncate system table 'functions' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'functions' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.function_types; -ERROR = !TRUNCATE: cannot truncate system table 'function_types' +ERROR = !TRUNCATE: cannot truncate read or append only table 'function_types' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.function_languages; -ERROR = !TRUNCATE: cannot truncate system table 'function_languages' +ERROR = !TRUNCATE: cannot truncate read or append only table 'function_languages' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.dependency_types; -ERROR = !TRUNCATE: cannot truncate system table 'dependency_types' +ERROR = !TRUNCATE: cannot truncate read or append only table 'dependency_types' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.dependencies; -ERROR = !TRUNCATE: cannot truncate system table 'dependencies' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'dependencies' CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 +MAPI = (testuser) /var/tmp/mtest-7177/.s.monetdb.32793 +QUERY = SELECT (COUNT(*) > 0) AS has_rows FROM sys.db_user_info; +ERROR = !SELECT: access denied for testuser to table 'sys.db_user_info' +CODE = 42000 +MAPI = (testuser) /var/tmp/mtest-7177/.s.monetdb.32793 QUERY = TRUNCATE TABLE sys.db_user_info; -ERROR = !TRUNCATE: cannot truncate system table 'db_user_info' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'db_user_info' CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 +MAPI = (testuser) /var/tmp/mtest-7177/.s.monetdb.32793 +QUERY = SELECT (COUNT(*) > 0) AS has_rows FROM sys.db_user_info; +ERROR = !SELECT: access denied for testuser to table 'sys.db_user_info' +CODE = 42000 +MAPI = (testuser) /var/tmp/mtest-7177/.s.monetdb.32793 QUERY = TRUNCATE TABLE sys.comments; -ERROR = !TRUNCATE: cannot truncate system table 'comments' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'comments' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.auths; -ERROR = !TRUNCATE: cannot truncate system table 'auths' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'auths' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys.args; -ERROR = !TRUNCATE: cannot truncate system table 'args' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table 'args' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys._tables; -ERROR = !TRUNCATE: cannot truncate system table '_tables' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table '_tables' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-9985/.s.monetdb.31828 QUERY = TRUNCATE TABLE sys._columns; -ERROR = !TRUNCATE: cannot truncate system table '_columns' +ERROR = !TRUNCATE: insufficient privileges for user 'testuser' to truncate table '_columns' CODE = 42000 # 17:47:14 > diff --git a/sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.stable.out b/sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.stable.out --- a/sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.stable.out +++ b/sql/test/BugTracker-2018/Tests/truncate_sys_tables.Bug-6543.stable.out @@ -156,30 +156,6 @@ Ready. % boolean # type % 5 # length [ true ] -#SELECT (COUNT(*) > 0) AS has_rows FROM sys.storagemodelinput; -% sys.L4 # table_name -% has_rows # name -% boolean # type -% 5 # length -[ false ] -#SELECT (COUNT(*) > 0) AS has_rows FROM sys.storagemodelinput; -% sys.L4 # table_name -% has_rows # name -% boolean # type -% 5 # length -[ false ] -#SELECT (COUNT(*) > 0) AS has_rows FROM sys.statistics; -% sys.L4 # table_name -% has_rows # name -% boolean # type -% 5 # length -[ false ] -#SELECT (COUNT(*) > 0) AS has_rows FROM sys.statistics; -% sys.L4 # table_name -% has_rows # name -% boolean # type -% 5 # length -[ false ] #SELECT (COUNT(*) > 0) AS has_rows FROM sys.spatial_ref_sys; % sys.L4 # table_name % has_rows # name @@ -372,18 +348,6 @@ Ready. % boolean # type % 5 # length [ true ] -#SELECT (COUNT(*) > 0) AS has_rows FROM sys.db_user_info; -% sys.L4 # table_name -% has_rows # name -% boolean # type -% 5 # length -[ true ] -#SELECT (COUNT(*) > 0) AS has_rows FROM sys.db_user_info; -% sys.L4 # table_name -% has_rows # name -% boolean # type -% 5 # length -[ true ] #SELECT (COUNT(*) > 0) AS has_rows FROM sys.comments; % sys.L4 # table_name % has_rows # name _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
