MonetDB: Nov2019 - Run tests within a single transaction

[Pedro Ferreira]

Changeset: 324d8c0e7c17 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=324d8c0e7c17
Modified Files:
        sql/test/Tests/bogus-auto-generated-keys.stable.out
        sql/test/Tests/copy-from-compressed.sql.in
        sql/test/Tests/copy-into-fwf.sql.in
        sql/test/Tests/copy-into-lz4.sql.in
        sql/test/Tests/copy_into.sql.in
        sql/test/Tests/zones.sql
        sql/test/bogus-auto-generated-keys.sql
        sql/test/like_tests.sql
Branch: Nov2019
Log Message:

Run tests within a single transaction


diffs (117 lines):

diff --git a/sql/test/Tests/bogus-auto-generated-keys.stable.out 
b/sql/test/Tests/bogus-auto-generated-keys.stable.out
--- a/sql/test/Tests/bogus-auto-generated-keys.stable.out
+++ b/sql/test/Tests/bogus-auto-generated-keys.stable.out
@@ -28,6 +28,8 @@ stdout of test 'bogus-auto-generated-key
 # 15:49:00 >  Mtimeout -timeout 60  java nl.cwi.monetdb.client.JdbcClient -h 
pegasus -p 37335 -d mTests_src_test -e -f 
"../../../../../../../../../../../net/volund.ins.cwi.nl/export/scratch1/fabian/monetdb/stable/sql/src/test/Tests/../bogus-auto-generated-keys.sql"
 # 15:49:00 >  
 
+START TRANSACTION;
+Operation successful
 -- generate a simple table with an auto-generated key (id)
 CREATE TABLE gen_keys (
        "id" serial,
@@ -54,10 +56,11 @@ 1 affected row, last generated key: 1
 UPDATE gen_keys SET "x" = 'bla' WHERE "id" = 12;
 0 affected rows, last generated key: 1
 
-
 -- ok, cleanup a bit
 DROP TABLE gen_keys;
 Operation successful
+ROLLBACK;
+Operation successful
 
 
 # 15:49:01 >  
diff --git a/sql/test/Tests/copy-from-compressed.sql.in 
b/sql/test/Tests/copy-from-compressed.sql.in
--- a/sql/test/Tests/copy-from-compressed.sql.in
+++ b/sql/test/Tests/copy-from-compressed.sql.in
@@ -1,3 +1,4 @@
+start transaction;
 create table compression_schemes (
        name varchar(20),
        extension varchar(5)
@@ -23,4 +24,4 @@ using delimiters ',', E'\n';
 
 select * from compression_schemes order by extension;
 
-drop table compression_schemes;
+rollback;
diff --git a/sql/test/Tests/copy-into-fwf.sql.in 
b/sql/test/Tests/copy-into-fwf.sql.in
--- a/sql/test/Tests/copy-into-fwf.sql.in
+++ b/sql/test/Tests/copy-into-fwf.sql.in
@@ -1,3 +1,4 @@
+START TRANSACTION;
 create table mtcars (
     mpg DOUBLE PRECISION,
     cyl DOUBLE PRECISION,
@@ -16,4 +17,4 @@ copy into mtcars from E'$QTSTSRCDIR/mtca
 
 select * from mtcars;
 
-drop table mtcars;
+ROLLBACK;
diff --git a/sql/test/Tests/copy-into-lz4.sql.in 
b/sql/test/Tests/copy-into-lz4.sql.in
--- a/sql/test/Tests/copy-into-lz4.sql.in
+++ b/sql/test/Tests/copy-into-lz4.sql.in
@@ -1,4 +1,5 @@
+START TRANSACTION;
 CREATE TABLE testlz4 (a bigint, b real, c clob, d varchar(64));
 COPY INTO testlz4 FROM E'$QTSTSRCDIR/testlz4.lz4' USING DELIMITERS 
',',E'\n','"' NULL AS '';
 SELECT a, b, c, d FROM testlz4 limit 1024;
-DROP TABLE testlz4;
+ROLLBACK;
diff --git a/sql/test/Tests/copy_into.sql.in b/sql/test/Tests/copy_into.sql.in
--- a/sql/test/Tests/copy_into.sql.in
+++ b/sql/test/Tests/copy_into.sql.in
@@ -1,3 +1,4 @@
+start transaction;
 create table copyouttest ( str VARCHAR(20), str2 VARCHAR(20));
 insert into copyouttest values ('', 'test');
 insert into copyouttest values ('test', '');
@@ -12,5 +13,4 @@ create table copyintest ( str VARCHAR(20
 copy into copyintest from E'$QTSTTRGDIR/x.dat' delimiters '[]', E'\n', '"';
 
 select * from copyintest;
-drop table copyintest;
-
+rollback;
diff --git a/sql/test/Tests/zones.sql b/sql/test/Tests/zones.sql
--- a/sql/test/Tests/zones.sql
+++ b/sql/test/Tests/zones.sql
@@ -1,3 +1,4 @@
+START TRANSACTION;
 declare epsilon double;
 set epsilon=0.00001;
 
@@ -153,3 +154,4 @@ drop table alphatest;
 drop table zonetest;
 drop table zoneindex;
 
+ROLLBACK;
diff --git a/sql/test/bogus-auto-generated-keys.sql 
b/sql/test/bogus-auto-generated-keys.sql
--- a/sql/test/bogus-auto-generated-keys.sql
+++ b/sql/test/bogus-auto-generated-keys.sql
@@ -1,3 +1,4 @@
+START TRANSACTION;
 -- generate a simple table with an auto-generated key (id)
 CREATE TABLE gen_keys (
        "id" serial,
@@ -17,3 +18,4 @@ UPDATE gen_keys SET "x" = 'bla' WHERE "i
 
 -- ok, cleanup a bit
 DROP TABLE gen_keys;
+ROLLBACK;
diff --git a/sql/test/like_tests.sql b/sql/test/like_tests.sql
--- a/sql/test/like_tests.sql
+++ b/sql/test/like_tests.sql
@@ -1,3 +1,4 @@
+START TRANSACTION;
 -- create our table to test with
 CREATE TABLE liketable (
        str varchar(20)
@@ -71,3 +72,4 @@ SELECT * FROM liketable WHERE str LIKE '
 
 -- clean up mess we made
 drop table liketable;
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list