MonetDB: default - Approve some tests.

2022-10-03 Thread Sjoerd Mullender
Changeset: 48a91df3613e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/48a91df3613e
Modified Files:
sql/test/BugTracker-2020/Tests/wrong-key-error.Bug-6982.test
sql/test/Dependencies/Tests/dependency_owner_schema_3.test
sql/test/Tests/regexp.test
sql/test/bincopy/Tests/bincopycollist.test.in
sql/test/mergetables/Tests/merge-tables-limitations.test
Branch: default
Log Message:

Approve some tests.


diffs (108 lines):

diff --git a/sql/test/BugTracker-2020/Tests/wrong-key-error.Bug-6982.test 
b/sql/test/BugTracker-2020/Tests/wrong-key-error.Bug-6982.test
--- a/sql/test/BugTracker-2020/Tests/wrong-key-error.Bug-6982.test
+++ b/sql/test/BugTracker-2020/Tests/wrong-key-error.Bug-6982.test
@@ -19,4 +19,3 @@ insert into c (a, b) values (1, 2)
 statement ok
 rollback
 
-
diff --git a/sql/test/Dependencies/Tests/dependency_owner_schema_3.test 
b/sql/test/Dependencies/Tests/dependency_owner_schema_3.test
--- a/sql/test/Dependencies/Tests/dependency_owner_schema_3.test
+++ b/sql/test/Dependencies/Tests/dependency_owner_schema_3.test
@@ -298,6 +298,9 @@ DEP_FUNC
 ms_trunc
 ms_round
 DEP_FUNC
+regexp_replace
+regexp_replace
+DEP_FUNC
 remote_table_credentials
 get_remote_table_expressions
 DEP_FUNC
diff --git a/sql/test/Tests/regexp.test b/sql/test/Tests/regexp.test
--- a/sql/test/Tests/regexp.test
+++ b/sql/test/Tests/regexp.test
@@ -59,3 +59,4 @@ query T rowsort
 select regexp_replace('foo', 'f o o', 'XYZ', 'x')
 
 XYZ
+
diff --git a/sql/test/bincopy/Tests/bincopycollist.test.in 
b/sql/test/bincopy/Tests/bincopycollist.test.in
--- a/sql/test/bincopy/Tests/bincopycollist.test.in
+++ b/sql/test/bincopy/Tests/bincopycollist.test.in
@@ -25,7 +25,7 @@ statement ok
 START TRANSACTION
 
 statement ok
-CREATE TABLE intvals(x INTEGER, y INTEGER);
+CREATE TABLE intvals(x INTEGER, y INTEGER)
 
 statement ok
 COPY BIG ENDIAN BINARY INTO intvals FROM (E'$QTSTTRGDIR/be123.bin', 
E'$QTSTTRGDIR/be456.bin')
@@ -76,7 +76,6 @@ COPY BINARY INTO intvals (a) FROM (E'$QT
 statement ok
 ROLLBACK
 
-
 statement ok
 START TRANSACTION
 
@@ -89,7 +88,6 @@ COPY BINARY INTO intvals FROM (E'$QTSTTR
 statement ok
 ROLLBACK
 
-
 statement ok
 START TRANSACTION
 
diff --git a/sql/test/mergetables/Tests/merge-tables-limitations.test 
b/sql/test/mergetables/Tests/merge-tables-limitations.test
--- a/sql/test/mergetables/Tests/merge-tables-limitations.test
+++ b/sql/test/mergetables/Tests/merge-tables-limitations.test
@@ -72,7 +72,6 @@ ALTER TABLE tst.mtbl ADD TABLE tmp.mtbl
 statement error 42000!ALTER TABLE: a MERGE TABLE can't be a child of itself
 ALTER TABLE tst.mtbl ADD TABLE tst.mtbl
 
-
 statement ok
 CREATE REPLICA TABLE tmp.rtbl (c1 int)
 -- this succeeds strangely
@@ -136,7 +135,6 @@ select * from tst.mtbl
 statement ok
 ALTER TABLE tst.mtbl DROP TABLE tst.rtbl
 
-
 statement ok
 CREATE UNLOGGED TABLE tmp.utbl (c1 int)
 -- this succeeds strangely
@@ -200,7 +198,6 @@ select * from tst.mtbl
 statement ok
 ALTER TABLE tst.mtbl DROP TABLE tst.utbl
 
-
 statement ok
 CREATE REMOTE TABLE tmp.rmtbl (c1 int) ON 'mapi:monetdb://localhost:5/demo'
 -- this succeeds strangely
@@ -264,7 +261,6 @@ select * from tst.mtbl
 statement ok
 ALTER TABLE tst.mtbl DROP TABLE tst.rmtbl
 
-
 statement ok
 CREATE LOCAL TEMP TABLE tmp.lttbl (c1 int) ON COMMIT PRESERVE ROWS
 
@@ -293,7 +289,6 @@ ALTER TABLE tmp.mtbl ADD TABLE tmp.lttbl
 statement error 42000!ALTER TABLE: can't add/drop a temporary table into a 
MERGE TABLE
 ALTER TABLE tst.mtbl ADD TABLE tmp.lttbl
 
-
 statement ok
 CREATE GLOBAL TEMP TABLE tmp.gttbl (c1 int) ON COMMIT PRESERVE ROWS
 
@@ -322,7 +317,6 @@ ALTER TABLE tmp.mtbl ADD TABLE tmp.gttbl
 statement error 42000!ALTER TABLE: can't add/drop a temporary table into a 
MERGE TABLE
 ALTER TABLE tst.mtbl ADD TABLE tmp.gttbl
 
-
 --cleanup
 query TT rowsort
 select schema, name from tst.my_tables order by 1,2
___
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org


MonetDB: default - Approve some tests.

2022-10-03 Thread Sjoerd Mullender
Changeset: a08134adfa53 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a08134adfa53
Modified Files:
clients/Tests/MAL-signatures-hge.test
clients/Tests/MAL-signatures.test
sql/test/Dependencies/Tests/dependency_functions.test
Branch: default
Log Message:

Approve some tests.


diffs (81 lines):

diff --git a/clients/Tests/MAL-signatures-hge.test 
b/clients/Tests/MAL-signatures-hge.test
--- a/clients/Tests/MAL-signatures-hge.test
+++ b/clients/Tests/MAL-signatures-hge.test
@@ -48544,6 +48544,16 @@ unsafe pattern sql.exportResult(X_0:stre
 mvc_export_result_wrap;
 Export a result (in order) to stream s
 sql
+export_bin_column
+unsafe pattern sql.export_bin_column(X_0:any_1, X_1:bit, X_2:str, X_3:int):lng 
+mvc_bin_export_column_wrap;
+export column as binary
+sql
+export_bin_column
+unsafe pattern sql.export_bin_column(X_0:bat[:any_1], X_1:bit, X_2:str, 
X_3:int):lng 
+mvc_bin_export_column_wrap;
+export column as binary
+sql
 export_table
 unsafe pattern sql.export_table(X_0:str, X_1:str, X_2:str, X_3:str, X_4:str, 
X_5:str, X_6:int, X_7:bat[:str], X_8:bat[:str], X_9:bat[:str], X_10:bat[:int], 
X_11:bat[:int], X_12:any...):int 
 mvc_export_row_wrap;
@@ -48590,7 +48600,7 @@ SQLhot_snapshot_wrap;
 Write db snapshot to the given tar(.gz/.lz4/.bz/.xz) file on either server or 
client
 sql
 importColumn
-pattern sql.importColumn(X_0:str, X_1:bit, X_2:str, X_3:int, X_4:oid) 
(X_5:bat[:any], X_6:oid) 
+pattern sql.importColumn(X_0:str, X_1:int, X_2:bit, X_3:str, X_4:int, X_5:oid) 
(X_6:bat[:any], X_7:oid) 
 mvc_bin_import_column_wrap;
 Import a column from the given file
 sql
diff --git a/clients/Tests/MAL-signatures.test 
b/clients/Tests/MAL-signatures.test
--- a/clients/Tests/MAL-signatures.test
+++ b/clients/Tests/MAL-signatures.test
@@ -36944,6 +36944,16 @@ unsafe pattern sql.exportResult(X_0:stre
 mvc_export_result_wrap;
 Export a result (in order) to stream s
 sql
+export_bin_column
+unsafe pattern sql.export_bin_column(X_0:any_1, X_1:bit, X_2:str, X_3:int):lng 
+mvc_bin_export_column_wrap;
+export column as binary
+sql
+export_bin_column
+unsafe pattern sql.export_bin_column(X_0:bat[:any_1], X_1:bit, X_2:str, 
X_3:int):lng 
+mvc_bin_export_column_wrap;
+export column as binary
+sql
 export_table
 unsafe pattern sql.export_table(X_0:str, X_1:str, X_2:str, X_3:str, X_4:str, 
X_5:str, X_6:int, X_7:bat[:str], X_8:bat[:str], X_9:bat[:str], X_10:bat[:int], 
X_11:bat[:int], X_12:any...):int 
 mvc_export_row_wrap;
@@ -36990,7 +37000,7 @@ SQLhot_snapshot_wrap;
 Write db snapshot to the given tar(.gz/.lz4/.bz/.xz) file on either server or 
client
 sql
 importColumn
-pattern sql.importColumn(X_0:str, X_1:bit, X_2:str, X_3:int, X_4:oid) 
(X_5:bat[:any], X_6:oid) 
+pattern sql.importColumn(X_0:str, X_1:int, X_2:bit, X_3:str, X_4:int, X_5:oid) 
(X_6:bat[:any], X_7:oid) 
 mvc_bin_import_column_wrap;
 Import a column from the given file
 sql
diff --git a/sql/test/Dependencies/Tests/dependency_functions.test 
b/sql/test/Dependencies/Tests/dependency_functions.test
--- a/sql/test/Dependencies/Tests/dependency_functions.test
+++ b/sql/test/Dependencies/Tests/dependency_functions.test
@@ -76,6 +76,9 @@ DEP_FUNC
 ms_trunc
 ms_round
 DEP_FUNC
+regexp_replace
+regexp_replace
+DEP_FUNC
 remote_table_credentials
 get_remote_table_expressions
 DEP_FUNC
@@ -128,6 +131,9 @@ DEP_FUNC
 ms_trunc
 ms_round
 DEP_FUNC
+regexp_replace
+regexp_replace
+DEP_FUNC
 remote_table_credentials
 get_remote_table_expressions
 DEP_FUNC
___
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org