MonetDB: default - Approve some tests.
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.
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