Changeset: 5634ca11476b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5634ca11476b Modified Files: sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit Branch: Aug2024 Log Message:
Approve output. diffs (78 lines): diff --git a/sql/test/emptydb/Tests/check.stable.out b/sql/test/emptydb/Tests/check.stable.out --- a/sql/test/emptydb/Tests/check.stable.out +++ b/sql/test/emptydb/Tests/check.stable.out @@ -461,7 +461,7 @@ select 'null in fkeys.delete_action', de [ "sys._tables", "sys", "_tables", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] [ "sys._tables", "sys", "args", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] [ "sys._tables", "sys", "auths", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] -[ "sys._tables", "sys", "clientinfo_properties", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] +[ "sys._tables", "sys", "clientinfo_properties", NULL, "TABLE", true, "COMMIT", "READONLY", NULL ] [ "sys._tables", "sys", "columns", "SELECT * FROM (SELECT p.* FROM \"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t) AS columns;", "VIEW", true, "COMMIT", "WRITABLE", NULL ] [ "sys._tables", "sys", "comments", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] [ "sys._tables", "sys", "db_user_info", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] @@ -934,8 +934,8 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "auths", "id", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "auths", "name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "auths", "grantor", "int", 31, 0, NULL, true, 2, NULL, NULL ] -[ "sys._columns", "sys", "clientinfo_properties", "prop", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] -[ "sys._columns", "sys", "clientinfo_properties", "session_attr", "varchar", 0, 0, NULL, true, 1, NULL, NULL ] +[ "sys._columns", "sys", "clientinfo_properties", "prop", "varchar", 40, 0, NULL, false, 0, NULL, NULL ] +[ "sys._columns", "sys", "clientinfo_properties", "session_attr", "varchar", 40, 0, NULL, false, 1, NULL, NULL ] [ "sys._columns", "sys", "columns", "id", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "columns", "name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "columns", "type", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] @@ -4579,6 +4579,7 @@ select 'null in fkeys.delete_action', de [ "grant on table", "auths", "public", "SELECT", NULL, 0 ] [ "grant on table", "character_sets", "public", "SELECT", "monetdb", 1 ] [ "grant on table", "check_constraints", "public", "SELECT", "monetdb", 1 ] +[ "grant on table", "clientinfo_properties", "public", "SELECT", "monetdb", 0 ] [ "grant on table", "columns", "public", "SELECT", NULL, 0 ] [ "grant on table", "columns", "public", "SELECT", "monetdb", 1 ] [ "grant on table", "comments", "public", "SELECT", NULL, 0 ] @@ -4659,6 +4660,7 @@ select 'null in fkeys.delete_action', de [ "grant on table", "schemata", "public", "SELECT", "monetdb", 1 ] [ "grant on table", "sequences", "public", "SELECT", NULL, 0 ] [ "grant on table", "sequences", "public", "SELECT", "monetdb", 1 ] +[ "grant on table", "sessions", "public", "SELECT", "monetdb", 0 ] [ "grant on table", "spatial_ref_sys", "public", "SELECT", "monetdb", 0 ] [ "grant on table", "statistics", "public", "SELECT", "monetdb", 0 ] [ "grant on table", "table_constraints", "public", "SELECT", "monetdb", 1 ] diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit b/sql/test/emptydb/Tests/check.stable.out.32bit --- a/sql/test/emptydb/Tests/check.stable.out.32bit +++ b/sql/test/emptydb/Tests/check.stable.out.32bit @@ -461,7 +461,7 @@ select 'null in fkeys.delete_action', de [ "sys._tables", "sys", "_tables", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] [ "sys._tables", "sys", "args", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] [ "sys._tables", "sys", "auths", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] -[ "sys._tables", "sys", "clientinfo_properties", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] +[ "sys._tables", "sys", "clientinfo_properties", NULL, "TABLE", true, "COMMIT", "READONLY", NULL ] [ "sys._tables", "sys", "columns", "SELECT * FROM (SELECT p.* FROM \"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t) AS columns;", "VIEW", true, "COMMIT", "WRITABLE", NULL ] [ "sys._tables", "sys", "comments", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] [ "sys._tables", "sys", "db_user_info", NULL, "TABLE", true, "COMMIT", "WRITABLE", NULL ] @@ -934,8 +934,8 @@ select 'null in fkeys.delete_action', de [ "sys._columns", "sys", "auths", "id", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "auths", "name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "auths", "grantor", "int", 31, 0, NULL, true, 2, NULL, NULL ] -[ "sys._columns", "sys", "clientinfo_properties", "prop", "varchar", 0, 0, NULL, true, 0, NULL, NULL ] -[ "sys._columns", "sys", "clientinfo_properties", "session_attr", "varchar", 0, 0, NULL, true, 1, NULL, NULL ] +[ "sys._columns", "sys", "clientinfo_properties", "prop", "varchar", 40, 0, NULL, false, 0, NULL, NULL ] +[ "sys._columns", "sys", "clientinfo_properties", "session_attr", "varchar", 40, 0, NULL, false, 1, NULL, NULL ] [ "sys._columns", "sys", "columns", "id", "int", 31, 0, NULL, true, 0, NULL, NULL ] [ "sys._columns", "sys", "columns", "name", "varchar", 1024, 0, NULL, true, 1, NULL, NULL ] [ "sys._columns", "sys", "columns", "type", "varchar", 1024, 0, NULL, true, 2, NULL, NULL ] @@ -4579,6 +4579,7 @@ select 'null in fkeys.delete_action', de [ "grant on table", "auths", "public", "SELECT", NULL, 0 ] [ "grant on table", "character_sets", "public", "SELECT", "monetdb", 1 ] [ "grant on table", "check_constraints", "public", "SELECT", "monetdb", 1 ] +[ "grant on table", "clientinfo_properties", "public", "SELECT", "monetdb", 0 ] [ "grant on table", "columns", "public", "SELECT", NULL, 0 ] [ "grant on table", "columns", "public", "SELECT", "monetdb", 1 ] [ "grant on table", "comments", "public", "SELECT", NULL, 0 ] @@ -4659,6 +4660,7 @@ select 'null in fkeys.delete_action', de [ "grant on table", "schemata", "public", "SELECT", "monetdb", 1 ] [ "grant on table", "sequences", "public", "SELECT", NULL, 0 ] [ "grant on table", "sequences", "public", "SELECT", "monetdb", 1 ] +[ "grant on table", "sessions", "public", "SELECT", "monetdb", 0 ] [ "grant on table", "spatial_ref_sys", "public", "SELECT", "monetdb", 0 ] [ "grant on table", "statistics", "public", "SELECT", "monetdb", 0 ] [ "grant on table", "table_constraints", "public", "SELECT", "monetdb", 1 ] _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
