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:50000/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 -- [email protected]
To unsubscribe send an email to [email protected]
