Changeset: f1c867abfc60 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f1c867abfc60
Modified Files:
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        sql/backends/monet5/rel_bin.c
        sql/backends/monet5/sql.c
        sql/backends/monet5/sql_cat.c
        sql/server/rel_optimizer.c
        sql/server/rel_schema.c
        sql/test/SQLancer/Tests/sqlancer03.test
        sql/test/SQLancer/Tests/sqlancer07.test
Branch: nospare
Log Message:

merged ... oh so fun


diffs (truncated from 1918 to 300 lines):

diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -363,6 +363,7 @@ developer.
 %files client-tests
 %defattr(-,root,root)
 %{_bindir}/arraytest
+%{_bindir}/bincopydata
 %{_bindir}/odbcsample1
 %{_bindir}/sample0
 %{_bindir}/sample1
@@ -681,7 +682,11 @@ developer, but if you do want to test, t
 
 %files testing-python
 %defattr(-,root,root)
+%{_bindir}/Mconvert.py
 %{_bindir}/Mtest.py
+%{_bindir}/Mz.py
+%{_bindir}/mktest.py
+%{_bindir}/sqllogictest.py
 %dir %{python3_sitelib}/MonetDBtesting
 %{python3_sitelib}/MonetDBtesting/*
 
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
@@ -9514,19 +9514,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, 
X_6: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;",     ""      ]
@@ -9693,7 +9693,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;",  ""      ]
@@ -9701,12 +9701,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;",  ""      ]
@@ -9762,7 +9762,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;",  ""      ]
@@ -9770,12 +9770,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
@@ -12836,19 +12836,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, 
X_6: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;",     ""      ]
@@ -13016,7 +13016,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;",  ""      ]
@@ -13024,12 +13024,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;",  ""      ]
@@ -13085,7 +13085,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;",  ""      ]
@@ -13093,12 +13093,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/common/utils/CMakeLists.txt b/common/utils/CMakeLists.txt
--- a/common/utils/CMakeLists.txt
+++ b/common/utils/CMakeLists.txt
@@ -60,7 +60,7 @@ target_link_libraries(mcrypt
   monetdb_config_header)
 
 if(WIN32)
-  target_compile_definitions(mcrypt 
+  target_compile_definitions(mcrypt
     PRIVATE
     LIBMONETDB5
     LIBMAPI
@@ -179,7 +179,6 @@ install(EXPORT mstringTargets
 install(FILES
   matomic.h
   mstring.h
-  copybinary.h
   DESTINATION
   ${CMAKE_INSTALL_INCLUDEDIR}/monetdb
   COMPONENT
diff --git a/debian/monetdb-client-testing.install 
b/debian/monetdb-client-testing.install
--- a/debian/monetdb-client-testing.install
+++ b/debian/monetdb-client-testing.install
@@ -1,4 +1,5 @@
 debian/tmp/usr/bin/arraytest usr/bin
+debian/tmp/usr/bin/bincopydata usr/bin
 debian/tmp/usr/bin/odbcsample1 usr/bin
 debian/tmp/usr/bin/sample0 usr/bin
 debian/tmp/usr/bin/sample1 usr/bin
diff --git a/debian/monetdb-testing-python.install 
b/debian/monetdb-testing-python.install
--- a/debian/monetdb-testing-python.install
+++ b/debian/monetdb-testing-python.install
@@ -1,2 +1,2 @@
-debian/tmp/usr/bin/Mtest.py usr/bin
+debian/tmp/usr/bin/*.py usr/bin
 debian/tmp/usr/lib/python3*/*-packages/MonetDBtesting/*
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
@@ -5672,7 +5672,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;
@@ -5688,23 +5688,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));
 }
@@ -5715,7 +5716,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)
@@ -5736,6 +5737,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)
+                               return NULL;
+                       en = en->next;
+               }
+               append(l, kname);
+       }
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to