Changeset: 38e6e0bc6d0c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=38e6e0bc6d0c
Branch: Oct2020
Log Message:

merged


diffs (truncated from 4902 to 300 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
@@ -9411,19 +9411,19 @@ stdout of test 'MAL-signatures` in direc
 [ "sqlcatalog",        "comment_on",   "pattern sqlcatalog.comment_on(X_1:int, 
X_2:str):void ",        "SQLcomment_on;",       ""      ]
 [ "sqlcatalog",        "create_function",      "pattern 
sqlcatalog.create_function(X_1:str, X_2:str, X_3:ptr):void ",  
"SQLcreate_function;",  ""      ]
 [ "sqlcatalog",        "create_role",  "pattern 
sqlcatalog.create_role(X_1:str, X_2:str, X_3:int):void ",      
"SQLcreate_role;",      ""      ]
-[ "sqlcatalog",        "create_schema",        "pattern 
sqlcatalog.create_schema(X_1:str, X_2:str, X_3:int, X_4:int):void ",   
"SQLcreate_schema;",    ""      ]
+[ "sqlcatalog",        "create_schema",        "pattern 
sqlcatalog.create_schema(X_1:str, X_2:str, X_3:int):void ",    
"SQLcreate_schema;",    ""      ]
 [ "sqlcatalog",        "create_seq",   "pattern sqlcatalog.create_seq(X_1:str, 
X_2:str, X_3:ptr, X_4:int):void ",      "SQLcreate_seq;",       ""      ]
 [ "sqlcatalog",        "create_table", "pattern 
sqlcatalog.create_table(X_1:str, X_2:str, X_3:ptr, X_4:int):void ",    
"SQLcreate_table;",     ""      ]
 [ "sqlcatalog",        "create_trigger",       "pattern 
sqlcatalog.create_trigger(X_1:str, X_2:str, X_3:str, X_4:int, X_5:int, X_6:int, 
X_7:str, X_8:str, X_9:str, X_10:str):void ",   "SQLcreate_trigger;",   ""      ]
 [ "sqlcatalog",        "create_type",  "pattern 
sqlcatalog.create_type(X_1:str, X_2:str, X_3:str):void ",      
"SQLcreate_type;",      ""      ]
 [ "sqlcatalog",        "create_user",  "pattern 
sqlcatalog.create_user(X_1:str, X_2:str, X_3:int, X_4:str, X_5:str):void ",    
"SQLcreate_user;",      ""      ]
 [ "sqlcatalog",        "create_view",  "pattern 
sqlcatalog.create_view(X_1:str, X_2:str, X_3:ptr, X_4:int):void ",     
"SQLcreate_view;",      ""      ]
-[ "sqlcatalog",        "drop_constraint",      "pattern 
sqlcatalog.drop_constraint(X_1:str, X_2:str, X_3:int, X_4:int):void ", 
"SQLdrop_constraint;",  ""      ]
+[ "sqlcatalog",        "drop_constraint",      "pattern 
sqlcatalog.drop_constraint(X_1:str, X_2:str, X_3:str, X_4:int, X_5:int):void ", 
       "SQLdrop_constraint;",  ""      ]
 [ "sqlcatalog",        "drop_function",        "pattern 
sqlcatalog.drop_function(X_1:str, X_2:str, X_3:int, X_4:int, X_5:int):void ",  
"SQLdrop_function;",    ""      ]
 [ "sqlcatalog",        "drop_index",   "pattern sqlcatalog.drop_index(X_1:str, 
X_2:str, X_3:int):void ",       "SQLdrop_index;",       ""      ]
 [ "sqlcatalog",        "drop_role",    "pattern sqlcatalog.drop_role(X_1:str, 
X_2:int):void ", "SQLdrop_role;",        ""      ]
 [ "sqlcatalog",        "drop_role",    "pattern sqlcatalog.drop_role(X_1:str, 
X_2:str, X_3:int):void ",        "SQLdrop_role;",        ""      ]
-[ "sqlcatalog",        "drop_schema",  "pattern 
sqlcatalog.drop_schema(X_1:str, X_2:str, X_3:int, X_4:int):void ",     
"SQLdrop_schema;",      ""      ]
+[ "sqlcatalog",        "drop_schema",  "pattern 
sqlcatalog.drop_schema(X_1:str, X_2:int, X_3:int):void ",      
"SQLdrop_schema;",      ""      ]
 [ "sqlcatalog",        "drop_seq",     "pattern sqlcatalog.drop_seq(X_1:str, 
X_2:str, X_3:int):void ", "SQLdrop_seq;", ""      ]
 [ "sqlcatalog",        "drop_table",   "pattern sqlcatalog.drop_table(X_1:str, 
X_2:str, X_3:int, X_4:int):void ",      "SQLdrop_table;",       ""      ]
 [ "sqlcatalog",        "drop_trigger", "pattern 
sqlcatalog.drop_trigger(X_1:str, X_2:str, X_3:int):void ",     
"SQLdrop_trigger;",     ""      ]
@@ -9591,7 +9591,7 @@ stdout of test 'MAL-signatures` in direc
 [ "wlc",       "commit",       "pattern wlc.commit():void ",   
"WLCcommitCmd;",        ""      ]
 [ "wlc",       "create_function",      "pattern wlc.create_function(X_1:str, 
X_2:str):void ",  "WLCgeneric;",  ""      ]
 [ "wlc",       "create_role",  "pattern wlc.create_role(X_1:str, X_2:str, 
X_3:int):void ",     "WLCgeneric;",  ""      ]
-[ "wlc",       "create_schema",        "pattern wlc.create_schema(X_1:str, 
X_2:str, X_3:int, X_4:int):void ",  "WLCgeneric;",  ""      ]
+[ "wlc",       "create_schema",        "pattern wlc.create_schema(X_1:str, 
X_2:str, X_3:int):void ",   "WLCgeneric;",  ""      ]
 [ "wlc",       "create_seq",   "pattern wlc.create_seq(X_1:str, X_2:str, 
X_3:int):void ",      "WLCgeneric;",  ""      ]
 [ "wlc",       "create_table", "pattern wlc.create_table(X_1:str, X_2:str, 
X_3:int):void ",    "WLCgeneric;",  ""      ]
 [ "wlc",       "create_trigger",       "pattern wlc.create_trigger(X_1:str, 
X_2:str, X_3:str, X_4:int, X_5:int, X_6:int, X_7:str, X_8:str, X_9:str, 
X_10:str):void ",  "WLCgeneric;",  ""      ]
@@ -9599,12 +9599,12 @@ stdout of test 'MAL-signatures` in direc
 [ "wlc",       "create_user",  "pattern wlc.create_user(X_1:str, X_2:str, 
X_3:int, X_4:str, X_5:str):void ",   "WLCgeneric;",  ""      ]
 [ "wlc",       "create_view",  "pattern wlc.create_view(X_1:str, X_2:str, 
X_3:int):void ",     "WLCgeneric;",  ""      ]
 [ "wlc",       "delete",       "pattern wlc.delete(X_1:str, X_2:str, 
X_3:any):int ",   "WLCdelete;",   ""      ]
-[ "wlc",       "drop_constraint",      "pattern wlc.drop_constraint(X_1:str, 
X_2:str, X_3:int, X_4:int):void ",        "WLCgeneric;",  ""      ]
+[ "wlc",       "drop_constraint",      "pattern wlc.drop_constraint(X_1:str, 
X_2:str, X_3:str, X_4:int, X_5:int):void ",       "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_function",        "pattern wlc.drop_function(X_1:str, 
X_2:str, X_3:int, X_4:int, X_5:int):void ", "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_index",   "pattern wlc.drop_index(X_1:str, X_2:str, 
X_3:int):void ",      "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_role",    "pattern wlc.drop_role(X_1:str, X_2:int):void 
",        "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_role",    "pattern wlc.drop_role(X_1:str, X_2:str, 
X_3:int):void ",       "WLCgeneric;",  ""      ]
-[ "wlc",       "drop_schema",  "pattern wlc.drop_schema(X_1:str, X_2:str, 
X_3:int, X_4:int):void ",    "WLCgeneric;",  ""      ]
+[ "wlc",       "drop_schema",  "pattern wlc.drop_schema(X_1:str, X_2:int, 
X_3:int):void ",     "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_seq",     "pattern wlc.drop_seq(X_1:str, X_2:str, 
X_3:int):void ",        "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_table",   "pattern wlc.drop_table(X_1:str, X_2:str, 
X_3:int, X_4:int):void ",     "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_trigger", "pattern wlc.drop_trigger(X_1:str, X_2:str, 
X_3:int):void ",    "WLCgeneric;",  ""      ]
@@ -9660,7 +9660,7 @@ stdout of test 'MAL-signatures` in direc
 [ "wlr",       "commit",       "pattern wlr.commit():void ",   "WLRcommit;",   
""      ]
 [ "wlr",       "create_function",      "pattern wlr.create_function(X_1:str, 
X_2:str):void ",  "WLRgeneric;",  ""      ]
 [ "wlr",       "create_role",  "pattern wlr.create_role(X_1:str, X_2:str, 
X_3:int):void ",     "WLRgeneric;",  ""      ]
-[ "wlr",       "create_schema",        "pattern wlr.create_schema(X_1:str, 
X_2:str, X_3:int, X_4:int):void ",  "WLRgeneric;",  ""      ]
+[ "wlr",       "create_schema",        "pattern wlr.create_schema(X_1:str, 
X_2:str, X_3:int):void ",   "WLRgeneric;",  ""      ]
 [ "wlr",       "create_seq",   "pattern wlr.create_seq(X_1:str, X_2:str, 
X_3:int):void ",      "WLRgeneric;",  ""      ]
 [ "wlr",       "create_table", "pattern wlr.create_table(X_1:str, X_2:str, 
X_3:int):void ",    "WLRgeneric;",  ""      ]
 [ "wlr",       "create_trigger",       "pattern wlr.create_trigger(X_1:str, 
X_2:str, X_3:str, X_4:int, X_5:int, X_6:int, X_7:str, X_8:str, X_9:str, 
X_10:str):void ",  "WLRgeneric;",  ""      ]
@@ -9668,12 +9668,12 @@ stdout of test 'MAL-signatures` in direc
 [ "wlr",       "create_user",  "pattern wlr.create_user(X_1:str, X_2:str, 
X_3:int, X_4:str, X_5:str):void ",   "WLRgeneric;",  ""      ]
 [ "wlr",       "create_view",  "pattern wlr.create_view(X_1:str, X_2:str, 
X_3:int):void ",     "WLRgeneric;",  ""      ]
 [ "wlr",       "delete",       "pattern wlr.delete(X_1:str, X_2:str, 
X_3:oid...):int ",        "WLRdelete;",   ""      ]
-[ "wlr",       "drop_constraint",      "pattern wlr.drop_constraint(X_1:str, 
X_2:str, X_3:int, X_4:int):void ",        "WLRgeneric;",  ""      ]
+[ "wlr",       "drop_constraint",      "pattern wlr.drop_constraint(X_1:str, 
X_2:str, X_3:str, X_4:int, X_5:int):void ",       "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_function",        "pattern wlr.drop_function(X_1:str, 
X_2:str, X_3:int, X_4:int, X_5:int):void ", "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_index",   "pattern wlr.drop_index(X_1:str, X_2:str, 
X_3:int):void ",      "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_role",    "pattern wlr.drop_role(X_1:str, X_2:int):void 
",        "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_role",    "pattern wlr.drop_role(X_1:str, X_2:str, 
X_3:int):void ",       "WLRgeneric;",  ""      ]
-[ "wlr",       "drop_schema",  "pattern wlr.drop_schema(X_1:str, X_2:str, 
X_3:int, X_4:int):void ",    "WLRgeneric;",  ""      ]
+[ "wlr",       "drop_schema",  "pattern wlr.drop_schema(X_1:str, X_2:int, 
X_3:int):void ",     "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_seq",     "pattern wlr.drop_seq(X_1:str, X_2:str, 
X_3:int):void ",        "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_table",   "pattern wlr.drop_table(X_1:str, X_2:str, 
X_3:int, X_4:int):void ",     "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_trigger", "pattern wlr.drop_trigger(X_1:str, X_2:str, 
X_3:int):void ",    "WLRgeneric;",  ""      ]
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
@@ -8150,8 +8150,8 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "rsh_noerror",  "pattern batcalc.rsh_noerror(X_1:sht, 
X_2:bat[:sht], X_3:bat[:oid]):bat[:sht] ",        "CMDbatRSH;",   ""      ]
 [ "batcalc",   "second_interval",      "pattern 
batcalc.second_interval(X_1:int, X_2:bat[:bte], X_3:bat[:oid], X_4:int, 
X_5:int):bat[:lng] ",  "bte_batdec2second_interval;",  ""      ]
 [ "batcalc",   "second_interval",      "pattern 
batcalc.second_interval(X_1:int, X_2:bat[:bte], X_3:int, X_4:int):bat[:lng] ", 
"bte_batdec2second_interval;",  ""      ]
-[ "batcalc",   "second_interval",      "command 
batcalc.second_interval(X_1:int, X_2:bat[:hge], X_3:int, X_4:int):bat[:lng] ", 
"hge_batdec2second_interval;",  ""      ]
 [ "batcalc",   "second_interval",      "pattern 
batcalc.second_interval(X_1:int, X_2:bat[:hge], X_3:bat[:oid], X_4:int, 
X_5:int):bat[:lng] ",  "hge_batdec2second_interval;",  ""      ]
+[ "batcalc",   "second_interval",      "pattern 
batcalc.second_interval(X_1:int, X_2:bat[:hge], X_3:int, X_4:int):bat[:lng] ", 
"hge_batdec2second_interval;",  ""      ]
 [ "batcalc",   "second_interval",      "pattern 
batcalc.second_interval(X_1:int, X_2:bat[:int], X_3:bat[:oid], X_4:int, 
X_5:int):bat[:lng] ",  "int_batdec2second_interval;",  ""      ]
 [ "batcalc",   "second_interval",      "pattern 
batcalc.second_interval(X_1:int, X_2:bat[:int], X_3:int, X_4:int):bat[:lng] ", 
"int_batdec2second_interval;",  ""      ]
 [ "batcalc",   "second_interval",      "pattern 
batcalc.second_interval(X_1:int, X_2:bat[:lng], X_3:bat[:oid], X_4:int, 
X_5:int):bat[:lng] ",  "lng_batdec2second_interval;",  ""      ]
@@ -12775,19 +12775,19 @@ stdout of test 'MAL-signatures` in direc
 [ "sqlcatalog",        "comment_on",   "pattern sqlcatalog.comment_on(X_1:int, 
X_2:str):void ",        "SQLcomment_on;",       ""      ]
 [ "sqlcatalog",        "create_function",      "pattern 
sqlcatalog.create_function(X_1:str, X_2:str, X_3:ptr):void ",  
"SQLcreate_function;",  ""      ]
 [ "sqlcatalog",        "create_role",  "pattern 
sqlcatalog.create_role(X_1:str, X_2:str, X_3:int):void ",      
"SQLcreate_role;",      ""      ]
-[ "sqlcatalog",        "create_schema",        "pattern 
sqlcatalog.create_schema(X_1:str, X_2:str, X_3:int, X_4:int):void ",   
"SQLcreate_schema;",    ""      ]
+[ "sqlcatalog",        "create_schema",        "pattern 
sqlcatalog.create_schema(X_1:str, X_2:str, X_3:int):void ",    
"SQLcreate_schema;",    ""      ]
 [ "sqlcatalog",        "create_seq",   "pattern sqlcatalog.create_seq(X_1:str, 
X_2:str, X_3:ptr, X_4:int):void ",      "SQLcreate_seq;",       ""      ]
 [ "sqlcatalog",        "create_table", "pattern 
sqlcatalog.create_table(X_1:str, X_2:str, X_3:ptr, X_4:int):void ",    
"SQLcreate_table;",     ""      ]
 [ "sqlcatalog",        "create_trigger",       "pattern 
sqlcatalog.create_trigger(X_1:str, X_2:str, X_3:str, X_4:int, X_5:int, X_6:int, 
X_7:str, X_8:str, X_9:str, X_10:str):void ",   "SQLcreate_trigger;",   ""      ]
 [ "sqlcatalog",        "create_type",  "pattern 
sqlcatalog.create_type(X_1:str, X_2:str, X_3:str):void ",      
"SQLcreate_type;",      ""      ]
 [ "sqlcatalog",        "create_user",  "pattern 
sqlcatalog.create_user(X_1:str, X_2:str, X_3:int, X_4:str, X_5:str):void ",    
"SQLcreate_user;",      ""      ]
 [ "sqlcatalog",        "create_view",  "pattern 
sqlcatalog.create_view(X_1:str, X_2:str, X_3:ptr, X_4:int):void ",     
"SQLcreate_view;",      ""      ]
-[ "sqlcatalog",        "drop_constraint",      "pattern 
sqlcatalog.drop_constraint(X_1:str, X_2:str, X_3:int, X_4:int):void ", 
"SQLdrop_constraint;",  ""      ]
+[ "sqlcatalog",        "drop_constraint",      "pattern 
sqlcatalog.drop_constraint(X_1:str, X_2:str, X_3:str, X_4:int, X_5:int):void ", 
       "SQLdrop_constraint;",  ""      ]
 [ "sqlcatalog",        "drop_function",        "pattern 
sqlcatalog.drop_function(X_1:str, X_2:str, X_3:int, X_4:int, X_5:int):void ",  
"SQLdrop_function;",    ""      ]
 [ "sqlcatalog",        "drop_index",   "pattern sqlcatalog.drop_index(X_1:str, 
X_2:str, X_3:int):void ",       "SQLdrop_index;",       ""      ]
 [ "sqlcatalog",        "drop_role",    "pattern sqlcatalog.drop_role(X_1:str, 
X_2:int):void ", "SQLdrop_role;",        ""      ]
 [ "sqlcatalog",        "drop_role",    "pattern sqlcatalog.drop_role(X_1:str, 
X_2:str, X_3:int):void ",        "SQLdrop_role;",        ""      ]
-[ "sqlcatalog",        "drop_schema",  "pattern 
sqlcatalog.drop_schema(X_1:str, X_2:str, X_3:int, X_4:int):void ",     
"SQLdrop_schema;",      ""      ]
+[ "sqlcatalog",        "drop_schema",  "pattern 
sqlcatalog.drop_schema(X_1:str, X_2:int, X_3:int):void ",      
"SQLdrop_schema;",      ""      ]
 [ "sqlcatalog",        "drop_seq",     "pattern sqlcatalog.drop_seq(X_1:str, 
X_2:str, X_3:int):void ", "SQLdrop_seq;", ""      ]
 [ "sqlcatalog",        "drop_table",   "pattern sqlcatalog.drop_table(X_1:str, 
X_2:str, X_3:int, X_4:int):void ",      "SQLdrop_table;",       ""      ]
 [ "sqlcatalog",        "drop_trigger", "pattern 
sqlcatalog.drop_trigger(X_1:str, X_2:str, X_3:int):void ",     
"SQLdrop_trigger;",     ""      ]
@@ -12956,7 +12956,7 @@ stdout of test 'MAL-signatures` in direc
 [ "wlc",       "commit",       "pattern wlc.commit():void ",   
"WLCcommitCmd;",        ""      ]
 [ "wlc",       "create_function",      "pattern wlc.create_function(X_1:str, 
X_2:str):void ",  "WLCgeneric;",  ""      ]
 [ "wlc",       "create_role",  "pattern wlc.create_role(X_1:str, X_2:str, 
X_3:int):void ",     "WLCgeneric;",  ""      ]
-[ "wlc",       "create_schema",        "pattern wlc.create_schema(X_1:str, 
X_2:str, X_3:int, X_4:int):void ",  "WLCgeneric;",  ""      ]
+[ "wlc",       "create_schema",        "pattern wlc.create_schema(X_1:str, 
X_2:str, X_3:int):void ",   "WLCgeneric;",  ""      ]
 [ "wlc",       "create_seq",   "pattern wlc.create_seq(X_1:str, X_2:str, 
X_3:int):void ",      "WLCgeneric;",  ""      ]
 [ "wlc",       "create_table", "pattern wlc.create_table(X_1:str, X_2:str, 
X_3:int):void ",    "WLCgeneric;",  ""      ]
 [ "wlc",       "create_trigger",       "pattern wlc.create_trigger(X_1:str, 
X_2:str, X_3:str, X_4:int, X_5:int, X_6:int, X_7:str, X_8:str, X_9:str, 
X_10:str):void ",  "WLCgeneric;",  ""      ]
@@ -12964,12 +12964,12 @@ stdout of test 'MAL-signatures` in direc
 [ "wlc",       "create_user",  "pattern wlc.create_user(X_1:str, X_2:str, 
X_3:int, X_4:str, X_5:str):void ",   "WLCgeneric;",  ""      ]
 [ "wlc",       "create_view",  "pattern wlc.create_view(X_1:str, X_2:str, 
X_3:int):void ",     "WLCgeneric;",  ""      ]
 [ "wlc",       "delete",       "pattern wlc.delete(X_1:str, X_2:str, 
X_3:any):int ",   "WLCdelete;",   ""      ]
-[ "wlc",       "drop_constraint",      "pattern wlc.drop_constraint(X_1:str, 
X_2:str, X_3:int, X_4:int):void ",        "WLCgeneric;",  ""      ]
+[ "wlc",       "drop_constraint",      "pattern wlc.drop_constraint(X_1:str, 
X_2:str, X_3:str, X_4:int, X_5:int):void ",       "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_function",        "pattern wlc.drop_function(X_1:str, 
X_2:str, X_3:int, X_4:int, X_5:int):void ", "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_index",   "pattern wlc.drop_index(X_1:str, X_2:str, 
X_3:int):void ",      "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_role",    "pattern wlc.drop_role(X_1:str, X_2:int):void 
",        "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_role",    "pattern wlc.drop_role(X_1:str, X_2:str, 
X_3:int):void ",       "WLCgeneric;",  ""      ]
-[ "wlc",       "drop_schema",  "pattern wlc.drop_schema(X_1:str, X_2:str, 
X_3:int, X_4:int):void ",    "WLCgeneric;",  ""      ]
+[ "wlc",       "drop_schema",  "pattern wlc.drop_schema(X_1:str, X_2:int, 
X_3:int):void ",     "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_seq",     "pattern wlc.drop_seq(X_1:str, X_2:str, 
X_3:int):void ",        "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_table",   "pattern wlc.drop_table(X_1:str, X_2:str, 
X_3:int, X_4:int):void ",     "WLCgeneric;",  ""      ]
 [ "wlc",       "drop_trigger", "pattern wlc.drop_trigger(X_1:str, X_2:str, 
X_3:int):void ",    "WLCgeneric;",  ""      ]
@@ -13025,7 +13025,7 @@ stdout of test 'MAL-signatures` in direc
 [ "wlr",       "commit",       "pattern wlr.commit():void ",   "WLRcommit;",   
""      ]
 [ "wlr",       "create_function",      "pattern wlr.create_function(X_1:str, 
X_2:str):void ",  "WLRgeneric;",  ""      ]
 [ "wlr",       "create_role",  "pattern wlr.create_role(X_1:str, X_2:str, 
X_3:int):void ",     "WLRgeneric;",  ""      ]
-[ "wlr",       "create_schema",        "pattern wlr.create_schema(X_1:str, 
X_2:str, X_3:int, X_4:int):void ",  "WLRgeneric;",  ""      ]
+[ "wlr",       "create_schema",        "pattern wlr.create_schema(X_1:str, 
X_2:str, X_3:int):void ",   "WLRgeneric;",  ""      ]
 [ "wlr",       "create_seq",   "pattern wlr.create_seq(X_1:str, X_2:str, 
X_3:int):void ",      "WLRgeneric;",  ""      ]
 [ "wlr",       "create_table", "pattern wlr.create_table(X_1:str, X_2:str, 
X_3:int):void ",    "WLRgeneric;",  ""      ]
 [ "wlr",       "create_trigger",       "pattern wlr.create_trigger(X_1:str, 
X_2:str, X_3:str, X_4:int, X_5:int, X_6:int, X_7:str, X_8:str, X_9:str, 
X_10:str):void ",  "WLRgeneric;",  ""      ]
@@ -13033,12 +13033,12 @@ stdout of test 'MAL-signatures` in direc
 [ "wlr",       "create_user",  "pattern wlr.create_user(X_1:str, X_2:str, 
X_3:int, X_4:str, X_5:str):void ",   "WLRgeneric;",  ""      ]
 [ "wlr",       "create_view",  "pattern wlr.create_view(X_1:str, X_2:str, 
X_3:int):void ",     "WLRgeneric;",  ""      ]
 [ "wlr",       "delete",       "pattern wlr.delete(X_1:str, X_2:str, 
X_3:oid...):int ",        "WLRdelete;",   ""      ]
-[ "wlr",       "drop_constraint",      "pattern wlr.drop_constraint(X_1:str, 
X_2:str, X_3:int, X_4:int):void ",        "WLRgeneric;",  ""      ]
+[ "wlr",       "drop_constraint",      "pattern wlr.drop_constraint(X_1:str, 
X_2:str, X_3:str, X_4:int, X_5:int):void ",       "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_function",        "pattern wlr.drop_function(X_1:str, 
X_2:str, X_3:int, X_4:int, X_5:int):void ", "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_index",   "pattern wlr.drop_index(X_1:str, X_2:str, 
X_3:int):void ",      "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_role",    "pattern wlr.drop_role(X_1:str, X_2:int):void 
",        "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_role",    "pattern wlr.drop_role(X_1:str, X_2:str, 
X_3:int):void ",       "WLRgeneric;",  ""      ]
-[ "wlr",       "drop_schema",  "pattern wlr.drop_schema(X_1:str, X_2:str, 
X_3:int, X_4:int):void ",    "WLRgeneric;",  ""      ]
+[ "wlr",       "drop_schema",  "pattern wlr.drop_schema(X_1:str, X_2:int, 
X_3:int):void ",     "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_seq",     "pattern wlr.drop_seq(X_1:str, X_2:str, 
X_3:int):void ",        "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_table",   "pattern wlr.drop_table(X_1:str, X_2:str, 
X_3:int, X_4:int):void ",     "WLRgeneric;",  ""      ]
 [ "wlr",       "drop_trigger", "pattern wlr.drop_trigger(X_1:str, X_2:str, 
X_3:int):void ",    "WLRgeneric;",  ""      ]
diff --git a/monetdb5/modules/atoms/xml.c b/monetdb5/modules/atoms/xml.c
--- a/monetdb5/modules/atoms/xml.c
+++ b/monetdb5/modules/atoms/xml.c
@@ -376,7 +376,7 @@ XMLparse(xml *x, str *doccont, str *val,
 }
 
 str
-XMLpi(str *ret, str *target, str *value)
+XMLpi(xml *ret, str *target, str *value)
 {
        size_t len;
        str buf;
diff --git a/monetdb5/modules/mal/mdb.c b/monetdb5/modules/mal/mdb.c
--- a/monetdb5/modules/mal/mdb.c
+++ b/monetdb5/modules/mal/mdb.c
@@ -735,7 +735,7 @@ static str MDBdump(Client cntxt, MalBlkP
 }
 
 static str
-MDBdummy(int *ret)
+MDBdummy(void *ret)
 {
        (void) ret;
        throw(MAL, "mdb.dummy", OPERATION_FAILED);
diff --git a/monetdb5/modules/mal/wlc.c b/monetdb5/modules/mal/wlc.c
--- a/monetdb5/modules/mal/wlc.c
+++ b/monetdb5/modules/mal/wlc.c
@@ -1100,13 +1100,13 @@ mel_func wlc_init_funcs[] = {
  pattern("wlc", "alter_seq", WLCgeneric, false, "Catalog operation alter_seq", 
args(0,3, arg("sname",str),arg("seqname",str),arg("val",lng))),
  pattern("wlc", "alter_seq", WLCgeneric, false, "Catalog operation alter_seq", 
args(0,4, 
arg("sname",str),arg("seqname",str),arg("seq",ptr),batarg("val",lng))),
  pattern("wlc", "drop_seq", WLCgeneric, false, "Catalog operation drop_seq", 
args(0,3, arg("sname",str),arg("nme",str),arg("action",int))),
- pattern("wlc", "create_schema", WLCgeneric, false, "Catalog operation 
create_schema", args(0,4, 
arg("sname",str),arg("auth",str),arg("ifnotexists",int),arg("action",int))),
- pattern("wlc", "drop_schema", WLCgeneric, false, "Catalog operation 
drop_schema", args(0,4, 
arg("sname",str),arg("s",str),arg("ifexists",int),arg("action",int))),
+ pattern("wlc", "create_schema", WLCgeneric, false, "Catalog operation 
create_schema", args(0,3, arg("sname",str),arg("auth",str),arg("action",int))),
+ pattern("wlc", "drop_schema", WLCgeneric, false, "Catalog operation 
drop_schema", args(0,3, 
arg("sname",str),arg("ifexists",int),arg("action",int))),
  pattern("wlc", "create_table", WLCgeneric, false, "Catalog operation 
create_table", args(0,3, arg("sname",str),arg("tname",str),arg("temp",int))),
  pattern("wlc", "create_view", WLCgeneric, false, "Catalog operation 
create_view", args(0,3, arg("sname",str),arg("tname",str),arg("temp",int))),
  pattern("wlc", "drop_table", WLCgeneric, false, "Catalog operation 
drop_table", args(0,4, 
arg("sname",str),arg("name",str),arg("action",int),arg("ifexists",int))),
  pattern("wlc", "drop_view", WLCgeneric, false, "Catalog operation drop_view", 
args(0,4, 
arg("sname",str),arg("name",str),arg("action",int),arg("ifexists",int))),
- pattern("wlc", "drop_constraint", WLCgeneric, false, "Catalog operation 
drop_constraint", args(0,4, 
arg("sname",str),arg("name",str),arg("action",int),arg("ifexists",int))),
+ pattern("wlc", "drop_constraint", WLCgeneric, false, "Catalog operation 
drop_constraint", args(0,5, 
arg("sname",str),arg("tname",str),arg("name",str),arg("action",int),arg("ifexists",int))),
  pattern("wlc", "alter_table", WLCgeneric, false, "Catalog operation 
alter_table", args(0,3, arg("sname",str),arg("tname",str),arg("action",int))),
  pattern("wlc", "create_type", WLCgeneric, false, "Catalog operation 
create_type", args(0,3, arg("sname",str),arg("nme",str),arg("impl",str))),
  pattern("wlc", "drop_type", WLCgeneric, false, "Catalog operation drop_type", 
args(0,3, arg("sname",str),arg("nme",str),arg("action",int))),
diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c
--- a/sql/backends/monet5/rel_bin.c
+++ b/sql/backends/monet5/rel_bin.c
@@ -2560,10 +2560,8 @@ rel2bin_semijoin(backend *be, sql_rel *r
                        int idx = 0, equality_only = 1;
 
                        jexps = get_equi_joins_first(sql, jexps, 
&equality_only);
-                       if (!equality_only || list_length(jexps) > 1) {
+                       if (!equality_only || list_length(jexps) > 1 || 
exp_has_func((sql_exp*)jexps->h->data))
                                left = subrel_project(be, left, refs, rel->l);
-                               equality_only = 0;
-                       }
                        right = subrel_project(be, right, refs, rel->r);
 
                        for( en = jexps->h; en; en = en->next ) {
@@ -2572,8 +2570,7 @@ rel2bin_semijoin(backend *be, sql_rel *r
                                stmt *s = NULL;
 
                                /* only handle simple joins here */
-                               if ((exp_has_func(e) && e->flag != cmp_filter) 
||
-                                       e->flag == cmp_or || (e->f && e->anti)) 
{
+                               if ((exp_has_func(e) && e->flag != cmp_filter) 
|| e->flag == cmp_or || (e->f && e->anti)) {
                                        if (!join && !list_length(lje)) {
                                                stmt *l = bin_first_column(be, 
left);
                                                stmt *r = bin_first_column(be, 
right);
@@ -3312,7 +3309,6 @@ rel2bin_select(backend *be, sql_rel *rel
                if ((p=find_prop(e->p, PROP_HASHCOL)) != NULL) {
                        sql_idx *i = p->value;
 
-                       assert(0);
                        sel = rel2bin_hash_lookup(be, rel, sub, NULL, i, en);
                }
        }
@@ -5648,7 +5644,7 @@ rel2bin_trans(backend *be, sql_rel *rel,
 }
 
 static stmt *
-rel2bin_catalog(backend *be, sql_rel *rel, list *refs)
+rel2bin_catalog_schema(backend *be, sql_rel *rel, list *refs)
 {
        mvc *sql = be->mvc;
        node *en = rel->exps->h;
@@ -5664,23 +5660,24 @@ rel2bin_catalog(backend *be, sql_rel *re
        sname = exp_bin(be, en->data, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 
0);
        if (!sname)
                return NULL;
-       if (en->next) {
-               name = exp_bin(be, en->next->data, NULL, NULL, NULL, NULL, 
NULL, NULL, 0, 0, 0);
-               if (!name)
-                       return NULL;
+       append(l, sname);
+       en = en->next;
+       if (rel->flag == ddl_create_schema) {
+               if (en) {
+                       name = exp_bin(be, en->data, NULL, NULL, NULL, NULL, 
NULL, NULL, 0, 0, 0);
+                       if (!name)
+                               return NULL;
+               } else {
+                       name = stmt_atom_string_nil(be);
+               }
+               append(l, name);
        } else {
-               name = stmt_atom_string_nil(be);
-       }
-       if (en->next && en->next->next) {
-               ifexists = exp_bin(be, en->next->next->data, NULL, NULL, NULL, 
NULL, NULL, NULL, 0, 0, 0);
+               assert(rel->flag == ddl_drop_schema);
+               ifexists = exp_bin(be, en->data, NULL, NULL, NULL, NULL, NULL, 
NULL, 0, 0, 0);
                if (!ifexists)
                        return NULL;
-       } else {
-               ifexists = stmt_atom_int(be, 0);
-       }
-       append(l, sname);
-       append(l, name);
-       append(l, ifexists);
+               append(l, ifexists);
+       }
        append(l, action);
        return stmt_catalog(be, rel->flag, stmt_list(be, l));
 }
@@ -5691,7 +5688,7 @@ rel2bin_catalog_table(backend *be, sql_r
        mvc *sql = be->mvc;
        node *en = rel->exps->h;
        stmt *action = exp_bin(be, en->data, NULL, NULL, NULL, NULL, NULL, 
NULL, 0, 0, 0);
-       stmt *table = NULL, *sname, *tname = NULL, *ifexists = NULL;
+       stmt *table = NULL, *sname, *tname = NULL, *kname = NULL, *ifexists = 
NULL;
        list *l = sa_list(sql->sa);
 
        if (!action)
@@ -5712,6 +5709,15 @@ rel2bin_catalog_table(backend *be, sql_r
        append(l, sname);
        assert(tname);
        append(l, tname);
+       if (rel->flag == ddl_drop_constraint) { /* needs extra string parameter 
for constraint name */
+               if (en) {
+                       kname = exp_bin(be, en->data, NULL, NULL, NULL, NULL, 
NULL, NULL, 0, 0, 0);
+                       if (!kname)
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to