Changeset: 14a1523e2cc3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/14a1523e2cc3
Modified Files:
        sql/test/emptydb/Tests/check.stable.out.32bit
Branch: Dec2025
Log Message:

Approve 32 bit output.


diffs (57 lines):

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
@@ -560,7 +560,7 @@ select 'null in fkeys.delete_action', de
 [ "sys._tables",       "sys",  "range_partitions",     NULL,   "TABLE",        
true,   "COMMIT",       "WRITABLE",     NULL    ]
 [ "sys._tables",       "sys",  "rejects",      "create view sys.rejects as 
select * from sys.rejects();",      "VIEW", true,   "COMMIT",       "WRITABLE", 
    NULL    ]
 [ "sys._tables",       "sys",  "remote_user_info",     NULL,   "TABLE",        
true,   "COMMIT",       "WRITABLE",     NULL    ]
-[ "sys._tables",       "sys",  "roles",        "create view sys.roles as 
select id, name, grantor from sys.auths a where a.name not in (select u.name 
from sys.db_user_info u);",      "VIEW", true,   "COMMIT",       "WRITABLE",    
 NULL    ]
+[ "sys._tables",       "sys",  "roles",        "create view sys.roles as 
select id, name, grantor from sys.auths;",    "VIEW", true,   "COMMIT",       
"WRITABLE",     NULL    ]
 [ "sys._tables",       "sys",  "schemas",      NULL,   "TABLE",        true,   
"COMMIT",       "WRITABLE",     NULL    ]
 [ "sys._tables",       "sys",  "schemastorage",        "create view 
sys.\"schemastorage\" as select \"schema\", count(*) as \"storages\", 
sum(columnsize) as columnsize, sum(heapsize) as heapsize, sum(hashes) as 
hashsize, sum(\"imprints\") as imprintsize, sum(orderidx) as orderidxsize from 
sys.\"storage\" group by \"schema\" order by \"schema\";",   "VIEW", true,   
"COMMIT",       "WRITABLE",     NULL    ]
 [ "sys._tables",       "sys",  "sequences",    NULL,   "TABLE",        true,   
"COMMIT",       "WRITABLE",     NULL    ]
@@ -584,6 +584,7 @@ select 'null in fkeys.delete_action', de
 [ "sys._tables",       "sys",  "var_values",   "create view sys.var_values 
(var_name, value) as select 'current_role', current_role union all select 
'current_schema', current_schema union all select 'current_timezone', 
current_timezone union all select 'current_user', current_user union all select 
'debug', debug union all select 'last_id', last_id union all select 
'optimizer', optimizer union all select 'pi', pi() union all select 'rowcnt', 
rowcnt;", "VIEW", true,   "COMMIT",       "WRITABLE",     NULL    ]
 [ "sys._tables",       "tmp",  "_columns",     NULL,   "TABLE",        true,   
"PRESERVE",     "WRITABLE",     NULL    ]
 [ "sys._tables",       "tmp",  "_tables",      NULL,   "TABLE",        true,   
"PRESERVE",     "WRITABLE",     NULL    ]
+[ "sys._tables",       "tmp",  "dependencies", NULL,   "TABLE",        true,   
"PRESERVE",     "WRITABLE",     NULL    ]
 [ "sys._tables",       "tmp",  "idxs", NULL,   "TABLE",        true,   
"PRESERVE",     "WRITABLE",     NULL    ]
 [ "sys._tables",       "tmp",  "keys", NULL,   "TABLE",        true,   
"PRESERVE",     "WRITABLE",     NULL    ]
 [ "sys._tables",       "tmp",  "objects",      NULL,   "TABLE",        true,   
"PRESERVE",     "WRITABLE",     NULL    ]
@@ -1666,6 +1667,9 @@ select 'null in fkeys.delete_action', de
 [ "sys._columns",      "tmp",  "_tables",      "system",       "boolean",      
1,      0,      NULL,   true,   5,      NULL,   NULL    ]
 [ "sys._columns",      "tmp",  "_tables",      "commit_action",        
"smallint",     15,     0,      NULL,   true,   6,      NULL,   NULL    ]
 [ "sys._columns",      "tmp",  "_tables",      "access",       "smallint",     
15,     0,      NULL,   true,   7,      NULL,   NULL    ]
+[ "sys._columns",      "tmp",  "dependencies", "id",   "int",  31,     0,      
NULL,   true,   0,      NULL,   NULL    ]
+[ "sys._columns",      "tmp",  "dependencies", "depend_id",    "int",  31,     
0,      NULL,   true,   1,      NULL,   NULL    ]
+[ "sys._columns",      "tmp",  "dependencies", "depend_type",  "smallint",     
15,     0,      NULL,   true,   2,      NULL,   NULL    ]
 [ "sys._columns",      "tmp",  "idxs", "id",   "int",  31,     0,      NULL,   
true,   0,      NULL,   NULL    ]
 [ "sys._columns",      "tmp",  "idxs", "table_id",     "int",  31,     0,      
NULL,   true,   1,      NULL,   NULL    ]
 [ "sys._columns",      "tmp",  "idxs", "type", "int",  31,     0,      NULL,   
true,   2,      NULL,   NULL    ]
@@ -3457,7 +3461,6 @@ select 'null in fkeys.delete_action', de
 [ "table used by view",        "tmp",  "keys", "sys",  "ids",  "VIEW"  ]
 [ "table used by view",        "tmp",  "triggers",     "sys",  "ids",  "VIEW"  
]
 [ "table used by view",        "sys",  "auths",        "sys",  "roles",        
"VIEW"  ]
-[ "table used by view",        "sys",  "db_user_info", "sys",  "roles",        
"VIEW"  ]
 [ "table used by view",        "sys",  "storage",      "sys",  
"schemastorage",        "VIEW"  ]
 [ "table used by view",        "sys",  "schemas",      "sys",  "statistics",   
"VIEW"  ]
 [ "table used by view",        "sys",  "tables",       "sys",  "statistics",   
"VIEW"  ]
@@ -4324,7 +4327,6 @@ select 'null in fkeys.delete_action', de
 [ "column used by view",       "sys",  "auths",        "grantor",      "sys",  
"roles",        "VIEW"  ]
 [ "column used by view",       "sys",  "auths",        "id",   "sys",  
"roles",        "VIEW"  ]
 [ "column used by view",       "sys",  "auths",        "name", "sys",  
"roles",        "VIEW"  ]
-[ "column used by view",       "sys",  "db_user_info", "name", "sys",  
"roles",        "VIEW"  ]
 [ "column used by view",       "sys",  "storage",      "columnsize",   "sys",  
"schemastorage",        "VIEW"  ]
 [ "column used by view",       "sys",  "storage",      "hashes",       "sys",  
"schemastorage",        "VIEW"  ]
 [ "column used by view",       "sys",  "storage",      "heapsize",     "sys",  
"schemastorage",        "VIEW"  ]
@@ -6118,8 +6120,8 @@ select 'null in fkeys.delete_action', de
 % %7,  role_id,        login_id,       role_id # name
 % varchar,     int,    int,    int # type
 % 0,   1,      1,      1 # length
-% .%7, sys.user_role,  sys.user_role,  sys.user_role # table_name
-% %7,  role_id,        login_id,       role_id # name
+% .%4, sys.user_role,  sys.user_role,  sys.user_role # table_name
+% %4,  role_id,        login_id,       role_id # name
 % varchar,     int,    int,    int # type
 % 0,   1,      1,      1 # length
 % .%4, sys.privileges, sys.privileges, sys.privileges, sys.privileges, 
sys.privileges, sys.privileges # table_name
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to