Changeset: a82249063ef9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a82249063ef9
Modified Files:
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
Branch: Jul2021
Log Message:

Properly approve signatures.


diffs (230 lines):

diff --git a/clients/Tests/MAL-signatures.stable.out 
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -1,65 +1,5 @@
 stdout of test 'MAL-signatures` in directory 'clients` itself:
 
-
-# 21:44:50 >  
-# 21:44:50 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=33053" "--set" 
"mapi_usock=/var/tmp/mtest-13793/.s.monetdb.33053" "--set" "monet_prompt=" 
"--forcemito" "--set" "mal_listing=2" 
"--dbpath=/home/sjoerd/Monet-devel/var/MonetDB/mTests_clients" "--set" 
"mal_listing=2" "--set" "embedded_r=yes"
-# 21:44:50 >  
-
-# MonetDB 5 server v11.32.0
-# This is an unreleased version
-# Serving database 'mTests_clients', using 8 threads
-# Compiled for x86_64-unknown-linux-gnu/64bit
-# Found 15.386 GiB available main-memory.
-# Copyright (c) 1993 - July 2008 CWI.
-# Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved
-# Visit https://www.monetdb.org/ for further information
-# Listening for connection requests on mapi:monetdb://xps13:39285/
-# Listening for UNIX domain connection requests on 
mapi:monetdb:///var/tmp/mtest-1158/.s.monetdb.39285
-# MonetDB/GIS module loaded
-# SQL catalog created, loading sql scripts once
-# loading sql script: 09_like.sql
-# loading sql script: 10_math.sql
-# loading sql script: 11_times.sql
-# loading sql script: 12_url.sql
-# loading sql script: 13_date.sql
-# loading sql script: 14_inet.sql
-# loading sql script: 15_querylog.sql
-# loading sql script: 16_tracelog.sql
-# loading sql script: 17_temporal.sql
-# loading sql script: 18_index.sql
-# loading sql script: 20_vacuum.sql
-# loading sql script: 21_dependency_functions.sql
-# loading sql script: 22_clients.sql
-# loading sql script: 23_skyserver.sql
-# loading sql script: 24_zorder.sql
-# loading sql script: 25_debug.sql
-# loading sql script: 26_sysmon.sql
-# loading sql script: 27_rejects.sql
-# loading sql script: 39_analytics.sql
-# loading sql script: 40_geom.sql
-# loading sql script: 40_json.sql
-# loading sql script: 41_md5sum.sql
-# loading sql script: 45_uuid.sql
-# loading sql script: 46_gsl.sql
-# loading sql script: 46_profiler.sql
-# loading sql script: 51_sys_schema_extension.sql
-# loading sql script: 72_fits.sql
-# loading sql script: 74_netcdf.sql
-# loading sql script: 75_shp.sql
-# loading sql script: 75_storagemodel.sql
-# loading sql script: 80_statistics.sql
-# loading sql script: 80_udf.sql
-# loading sql script: 85_bam.sql
-# loading sql script: 90_generator.sql
-# loading sql script: 99_system.sql
-# MonetDB/SQL module loaded
-# MonetDB/Python2 module loaded
-# MonetDB/R   module loaded
-
-# 16:19:19 >  
-# 16:19:19 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-28001" "--port=38663"
-# 16:19:19 >  
-
 #select * from sys.malfunctions() order by module, "function", address, 
signature, comment;
 % .%1, .%1,    .%1,    .%1,    .%1 # table_name
 % module,      function,       signature,      address,        comment # name
@@ -6390,9 +6330,9 @@ stdout of test 'MAL-signatures` in direc
 [ "batsql",    "lead", "pattern batsql.lead(X_0:bat[:any_1], X_1:bat[:any], 
X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1] ",      "SQLlead;",     ""   
   ]
 [ "batsql",    "max",  "pattern batsql.max(X_0:bat[:any_1], X_1:any, X_2:any, 
X_3:int, X_4:any, X_5:any):bat[:any_1] ",        "SQLmax;",      ""      ]
 [ "batsql",    "min",  "pattern batsql.min(X_0:bat[:any_1], X_1:any, X_2:any, 
X_3:int, X_4:any, X_5:any):bat[:any_1] ",        "SQLmin;",      ""      ]
-[ "batsql",    "next_value",   "unsafe pattern 
batsql.next_value(X_0:bat[:str], X_1:bat[:str]):bat[:lng] ",    
"mvc_bat_next_value;",  ""      ]
-[ "batsql",    "next_value",   "unsafe pattern 
batsql.next_value(X_0:bat[:str], X_1:str):bat[:lng] ",  "mvc_bat_next_value;",  
""      ]
-[ "batsql",    "next_value",   "unsafe pattern batsql.next_value(X_0:str, 
X_1:bat[:str]):bat[:lng] ",  "mvc_bat_next_value;",  ""      ]
+[ "batsql",    "next_value",   "pattern batsql.next_value(X_0:bat[:str], 
X_1:bat[:str]):bat[:lng] ",   "mvc_bat_next_value;",  ""      ]
+[ "batsql",    "next_value",   "pattern batsql.next_value(X_0:bat[:str], 
X_1:str):bat[:lng] ", "mvc_bat_next_value;",  ""      ]
+[ "batsql",    "next_value",   "pattern batsql.next_value(X_0:str, 
X_1:bat[:str]):bat[:lng] ", "mvc_bat_next_value;",  ""      ]
 [ "batsql",    "nth_value",    "pattern batsql.nth_value(X_0:any_1, 
X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ", 
"SQLnth_value;",        ""      ]
 [ "batsql",    "nth_value",    "pattern batsql.nth_value(X_0:bat[:any_1], 
X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ",   
"SQLnth_value;",        ""      ]
 [ "batsql",    "nth_value",    "pattern batsql.nth_value(X_0:bat[:any_1], 
X_1:lng, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ", 
"SQLnth_value;",        ""      ]
@@ -9324,9 +9264,9 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "db_users",     "pattern sql.db_users():bat[:str] ",    
"db_users_wrap;",       ""      ]
 [ "sql",       "delete",       "unsafe pattern sql.delete(X_0:int, X_1:str, 
X_2:str, X_3:any):int ",   "mvc_delete_wrap;",     ""      ]
 [ "sql",       "delta",        "command sql.delta(X_0:bat[:any_3], 
X_1:bat[:oid], X_2:bat[:any_3]):bat[:any_3] ",      "DELTAbat;",    ""      ]
-[ "sql",       "deltas",       "pattern sql.deltas(X_0:str) (X_1:bat[:int], 
X_2:bat[:bit], X_3:bat[:lng], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], 
X_7:bat[:int]) ",       "mvc_delta_values;",    ""      ]
-[ "sql",       "deltas",       "pattern sql.deltas(X_0:str, X_1:str) 
(X_2:bat[:int], X_3:bat[:bit], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], 
X_7:bat[:lng], X_8:bat[:int]) ",      "mvc_delta_values;",    ""      ]
-[ "sql",       "deltas",       "pattern sql.deltas(X_0:str, X_1:str, X_2:str) 
(X_3:bat[:int], X_4:bat[:bit], X_5:bat[:lng], X_6:bat[:lng], X_7:bat[:lng], 
X_8:bat[:lng], X_9:bat[:int]) ",     "mvc_delta_values;",    ""      ]
+[ "sql",       "deltas",       "pattern sql.deltas(X_0:str) (X_1:bat[:int], 
X_2:bat[:lng], X_3:bat[:lng], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], 
X_7:bat[:int]) ",       "mvc_delta_values;",    ""      ]
+[ "sql",       "deltas",       "pattern sql.deltas(X_0:str, X_1:str) 
(X_2:bat[:int], X_3:bat[:lng], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], 
X_7:bat[:lng], X_8:bat[:int]) ",      "mvc_delta_values;",    ""      ]
+[ "sql",       "deltas",       "pattern sql.deltas(X_0:str, X_1:str, X_2:str) 
(X_3:bat[:int], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], X_7:bat[:lng], 
X_8:bat[:lng], X_9:bat[:int]) ",     "mvc_delta_values;",    ""      ]
 [ "sql",       "dense_rank",   "pattern sql.dense_rank(X_0:any_1, X_1:bit, 
X_2:bit):int ",     "SQLdense_rank;",       ""      ]
 [ "sql",       "diff", "pattern sql.diff(X_0:any_1):bit ",     "SQLdiff;",     
""      ]
 [ "sql",       "diff", "pattern sql.diff(X_0:bit, X_1:any_1):bit ",    
"SQLdiff;",     ""      ]
@@ -9380,7 +9320,7 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "ms_trunc",     "command sql.ms_trunc(X_0:dbl, X_1:int):dbl ",  
"dbl_trunc_wrap;",      ""      ]
 [ "sql",       "ms_trunc",     "command sql.ms_trunc(X_0:flt, X_1:int):flt ",  
"flt_trunc_wrap;",      ""      ]
 [ "sql",       "mvc",  "pattern sql.mvc():int ",       "SQLmvc;",      ""      
]
-[ "sql",       "next_value",   "unsafe pattern sql.next_value(X_0:str, 
X_1:str):lng ", "mvc_next_value;",      ""      ]
+[ "sql",       "next_value",   "pattern sql.next_value(X_0:str, X_1:str):lng 
",        "mvc_next_value;",      ""      ]
 [ "sql",       "nth_value",    "pattern sql.nth_value(X_0:any_1, X_1:lng, 
X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):any_1 ",        "SQLnth_value;",   
     ""      ]
 [ "sql",       "ntile",        "pattern sql.ntile(X_0:any, X_1:any_1, X_2:bit, 
X_3:bit):any_1 ",       "SQLntile;",    ""      ]
 [ "sql",       "optimizer_updates",    "pattern sql.optimizer_updates():void 
",        "SQLoptimizersUpdate;", ""      ]
@@ -9820,8 +9760,3 @@ stdout of test 'MAL-signatures` in direc
 [ "xml",       "subaggr",      "command xml.subaggr(X_0:bat[:xml], 
X_1:bat[:oid], X_2:bat[:any_1], X_3:bat[:oid], X_4:bit):bat[:xml] ",        
"AGGRsubxmlcand;",      ""      ]
 [ "xml",       "text", "command xml.text(X_0:xml):str ",       "XMLxmltext;",  
""      ]
 [ "xml",       "xml",  "command xml.xml(X_0:str):xml ",        "XMLstr2xml;",  
""      ]
-
-# 14:47:14 >  
-# 14:47:14 >  "Done."
-# 14:47:14 >  
-
diff --git a/clients/Tests/MAL-signatures.stable.out.int128 
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -1,69 +1,5 @@
 stdout of test 'MAL-signatures` in directory 'clients` itself:
 
-
-# 21:44:50 >  
-# 21:44:50 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=33053" "--set" 
"mapi_usock=/var/tmp/mtest-13793/.s.monetdb.33053" "--set" "monet_prompt=" 
"--forcemito" "--set" "mal_listing=2" 
"--dbpath=/home/sjoerd/Monet-devel/var/MonetDB/mTests_clients" "--set" 
"mal_listing=2" "--set" "embedded_r=yes"
-# 21:44:50 >  
-
-# MonetDB 5 server v11.20.0
-# This is an unreleased version
-# Serving database 'mTests_clients', using 8 threads
-# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers
-# Found 15.386 GiB available main-memory.
-# Copyright (c) 1993 - July 2008 CWI.
-# Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved
-# Visit https://www.monetdb.org/ for further information
-# Listening for connection requests on mapi:monetdb://xps13:39285/
-# Listening for UNIX domain connection requests on 
mapi:monetdb:///var/tmp/mtest-1158/.s.monetdb.39285
-# MonetDB/GIS module loaded
-# SQL catalog created, loading sql scripts once
-# loading sql script: 09_like.sql
-# loading sql script: 10_math.sql
-# loading sql script: 11_times.sql
-# loading sql script: 12_url.sql
-# loading sql script: 13_date.sql
-# loading sql script: 14_inet.sql
-# loading sql script: 15_querylog.sql
-# loading sql script: 16_tracelog.sql
-# loading sql script: 17_temporal.sql
-# loading sql script: 18_index.sql
-# loading sql script: 20_vacuum.sql
-# loading sql script: 21_dependency_functions.sql
-# loading sql script: 22_clients.sql
-# loading sql script: 23_skyserver.sql
-# loading sql script: 24_zorder.sql
-# loading sql script: 25_debug.sql
-# loading sql script: 26_sysmon.sql
-# loading sql script: 27_rejects.sql
-# loading sql script: 39_analytics.sql
-# loading sql script: 39_analytics_hge.sql
-# loading sql script: 40_geom.sql
-# loading sql script: 40_json.sql
-# loading sql script: 40_json_hge.sql
-# loading sql script: 41_md5sum.sql
-# loading sql script: 45_uuid.sql
-# loading sql script: 46_gsl.sql
-# loading sql script: 46_profiler.sql
-# loading sql script: 51_sys_schema_extension.sql
-# loading sql script: 72_fits.sql
-# loading sql script: 74_netcdf.sql
-# loading sql script: 75_shp.sql
-# loading sql script: 75_storagemodel.sql
-# loading sql script: 80_statistics.sql
-# loading sql script: 80_udf.sql
-# loading sql script: 80_udf_hge.sql
-# loading sql script: 85_bam.sql
-# loading sql script: 90_generator.sql
-# loading sql script: 90_generator_hge.sql
-# loading sql script: 99_system.sql
-# MonetDB/SQL module loaded
-# MonetDB/Python2 module loaded
-# MonetDB/R   module loaded
-
-# 16:10:29 >  
-# 16:10:29 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-29643" "--port=32888"
-# 16:10:29 >  
-
 #select * from sys.malfunctions() order by module, "function", address, 
signature, comment;
 % .%1, .%1,    .%1,    .%1,    .%1 # table_name
 % module,      function,       signature,      address,        comment # name
@@ -8935,9 +8871,9 @@ stdout of test 'MAL-signatures` in direc
 [ "batsql",    "lead", "pattern batsql.lead(X_0:bat[:any_1], X_1:bat[:any], 
X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1] ",      "SQLlead;",     ""   
   ]
 [ "batsql",    "max",  "pattern batsql.max(X_0:bat[:any_1], X_1:any, X_2:any, 
X_3:int, X_4:any, X_5:any):bat[:any_1] ",        "SQLmax;",      ""      ]
 [ "batsql",    "min",  "pattern batsql.min(X_0:bat[:any_1], X_1:any, X_2:any, 
X_3:int, X_4:any, X_5:any):bat[:any_1] ",        "SQLmin;",      ""      ]
-[ "batsql",    "next_value",   "unsafe pattern 
batsql.next_value(X_0:bat[:str], X_1:bat[:str]):bat[:lng] ",    
"mvc_bat_next_value;",  ""      ]
-[ "batsql",    "next_value",   "unsafe pattern 
batsql.next_value(X_0:bat[:str], X_1:str):bat[:lng] ",  "mvc_bat_next_value;",  
""      ]
-[ "batsql",    "next_value",   "unsafe pattern batsql.next_value(X_0:str, 
X_1:bat[:str]):bat[:lng] ",  "mvc_bat_next_value;",  ""      ]
+[ "batsql",    "next_value",   "pattern batsql.next_value(X_0:bat[:str], 
X_1:bat[:str]):bat[:lng] ",   "mvc_bat_next_value;",  ""      ]
+[ "batsql",    "next_value",   "pattern batsql.next_value(X_0:bat[:str], 
X_1:str):bat[:lng] ", "mvc_bat_next_value;",  ""      ]
+[ "batsql",    "next_value",   "pattern batsql.next_value(X_0:str, 
X_1:bat[:str]):bat[:lng] ", "mvc_bat_next_value;",  ""      ]
 [ "batsql",    "nth_value",    "pattern batsql.nth_value(X_0:any_1, 
X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ", 
"SQLnth_value;",        ""      ]
 [ "batsql",    "nth_value",    "pattern batsql.nth_value(X_0:bat[:any_1], 
X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ",   
"SQLnth_value;",        ""      ]
 [ "batsql",    "nth_value",    "pattern batsql.nth_value(X_0:bat[:any_1], 
X_1:lng, X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ", 
"SQLnth_value;",        ""      ]
@@ -12634,9 +12570,9 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "db_users",     "pattern sql.db_users():bat[:str] ",    
"db_users_wrap;",       ""      ]
 [ "sql",       "delete",       "unsafe pattern sql.delete(X_0:int, X_1:str, 
X_2:str, X_3:any):int ",   "mvc_delete_wrap;",     ""      ]
 [ "sql",       "delta",        "command sql.delta(X_0:bat[:any_3], 
X_1:bat[:oid], X_2:bat[:any_3]):bat[:any_3] ",      "DELTAbat;",    ""      ]
-[ "sql",       "deltas",       "pattern sql.deltas(X_0:str) (X_1:bat[:int], 
X_2:bat[:bit], X_3:bat[:lng], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], 
X_7:bat[:int]) ",       "mvc_delta_values;",    ""      ]
-[ "sql",       "deltas",       "pattern sql.deltas(X_0:str, X_1:str) 
(X_2:bat[:int], X_3:bat[:bit], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], 
X_7:bat[:lng], X_8:bat[:int]) ",      "mvc_delta_values;",    ""      ]
-[ "sql",       "deltas",       "pattern sql.deltas(X_0:str, X_1:str, X_2:str) 
(X_3:bat[:int], X_4:bat[:bit], X_5:bat[:lng], X_6:bat[:lng], X_7:bat[:lng], 
X_8:bat[:lng], X_9:bat[:int]) ",     "mvc_delta_values;",    ""      ]
+[ "sql",       "deltas",       "pattern sql.deltas(X_0:str) (X_1:bat[:int], 
X_2:bat[:lng], X_3:bat[:lng], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], 
X_7:bat[:int]) ",       "mvc_delta_values;",    ""      ]
+[ "sql",       "deltas",       "pattern sql.deltas(X_0:str, X_1:str) 
(X_2:bat[:int], X_3:bat[:lng], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], 
X_7:bat[:lng], X_8:bat[:int]) ",      "mvc_delta_values;",    ""      ]
+[ "sql",       "deltas",       "pattern sql.deltas(X_0:str, X_1:str, X_2:str) 
(X_3:bat[:int], X_4:bat[:lng], X_5:bat[:lng], X_6:bat[:lng], X_7:bat[:lng], 
X_8:bat[:lng], X_9:bat[:int]) ",     "mvc_delta_values;",    ""      ]
 [ "sql",       "dense_rank",   "pattern sql.dense_rank(X_0:any_1, X_1:bit, 
X_2:bit):int ",     "SQLdense_rank;",       ""      ]
 [ "sql",       "diff", "pattern sql.diff(X_0:any_1):bit ",     "SQLdiff;",     
""      ]
 [ "sql",       "diff", "pattern sql.diff(X_0:bit, X_1:any_1):bit ",    
"SQLdiff;",     ""      ]
@@ -12690,7 +12626,7 @@ stdout of test 'MAL-signatures` in direc
 [ "sql",       "ms_trunc",     "command sql.ms_trunc(X_0:dbl, X_1:int):dbl ",  
"dbl_trunc_wrap;",      ""      ]
 [ "sql",       "ms_trunc",     "command sql.ms_trunc(X_0:flt, X_1:int):flt ",  
"flt_trunc_wrap;",      ""      ]
 [ "sql",       "mvc",  "pattern sql.mvc():int ",       "SQLmvc;",      ""      
]
-[ "sql",       "next_value",   "unsafe pattern sql.next_value(X_0:str, 
X_1:str):lng ", "mvc_next_value;",      ""      ]
+[ "sql",       "next_value",   "pattern sql.next_value(X_0:str, X_1:str):lng 
",        "mvc_next_value;",      ""      ]
 [ "sql",       "nth_value",    "pattern sql.nth_value(X_0:any_1, X_1:lng, 
X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):any_1 ",        "SQLnth_value;",   
     ""      ]
 [ "sql",       "ntile",        "pattern sql.ntile(X_0:any, X_1:any_1, X_2:bit, 
X_3:bit):any_1 ",       "SQLntile;",    ""      ]
 [ "sql",       "optimizer_updates",    "pattern sql.optimizer_updates():void 
",        "SQLoptimizersUpdate;", ""      ]
@@ -13147,8 +13083,3 @@ stdout of test 'MAL-signatures` in direc
 [ "xml",       "subaggr",      "command xml.subaggr(X_0:bat[:xml], 
X_1:bat[:oid], X_2:bat[:any_1], X_3:bat[:oid], X_4:bit):bat[:xml] ",        
"AGGRsubxmlcand;",      ""      ]
 [ "xml",       "text", "command xml.text(X_0:xml):str ",       "XMLxmltext;",  
""      ]
 [ "xml",       "xml",  "command xml.xml(X_0:str):xml ",        "XMLstr2xml;",  
""      ]
-
-# 12:57:40 >  
-# 12:57:40 >  "Done."
-# 12:57:40 >  
-
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to