Changeset: 09ba66bc7e12 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/09ba66bc7e12
Added Files:
        sql/test/dict/Tests/SingleServer
Modified Files:
        sql/test/dict/Tests/dict01.test
Branch: default
Log Message:

Fixed test


diffs (58 lines):

diff --git a/sql/test/dict/Tests/SingleServer b/sql/test/dict/Tests/SingleServer
new file mode 100644
diff --git a/sql/test/dict/Tests/dict01.test b/sql/test/dict/Tests/dict01.test
--- a/sql/test/dict/Tests/dict01.test
+++ b/sql/test/dict/Tests/dict01.test
@@ -2,14 +2,19 @@ statement ok
 START TRANSACTION
 
 statement ok
-create or replace procedure "sys"."dict_compress"(sname string, tname string, 
cname string) external name "dict"."compress"
+create procedure "sys"."dict_compress"(sname string, tname string, cname 
string) external name "dict"."compress"
+
+statement ok
+create procedure "sys"."dict_compress"(sname string, tname string, cname 
string, ordered_values bool) external name "dict"."compress"
 
 statement ok
-create or replace procedure "sys"."dict_compress"(sname string, tname string, 
cname string, ordered_values bool) external name "dict"."compress"
+create procedure "sys"."for_compress"(sname string, tname string, cname 
string) external name "for"."compress"
 
 statement ok
-create or replace procedure "sys"."for_compress"(sname string, tname string, 
cname string) external name "for"."compress"
+COMMIT
 
+statement ok
+START TRANSACTION
 
 statement ok
 CREATE TABLE "mct20" ("c0" INTERVAL DAY,"c1" BIGINT,CONSTRAINT "mct20_c1_pkey" 
PRIMARY KEY ("c1"))
@@ -24,10 +29,28 @@ statement ok
 INSERT INTO "mct21" VALUES (INTERVAL '-2' SECOND, -6), (INTERVAL '86400' 
SECOND, 7), (INTERVAL '-2' SECOND, 8)
 
 statement ok
+COMMIT
+
+statement ok
 CALL "sys"."for_compress"('sys','mct20','c1')
 
 statement error GDK reported error: BATsubcross: more than one match
 UPDATE mct20 SET c1 = mct20.c1 FROM mct21
 
 statement ok
-ROLLBACK
+START TRANSACTION
+
+statement ok
+DROP ALL PROCEDURE "sys"."dict_compress"
+
+statement ok
+DROP ALL PROCEDURE "sys"."for_compress"
+
+statement ok
+DROP TABLE "mct20"
+
+statement ok
+DROP TABLE "mct21"
+
+statement ok
+COMMIT
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to