MDEV-6720 - enable connection log in mysqltest by default

1 files changed, 12 insertions, 10 deletions

diff --git a/mysql-test/r/consistent_snapshot.result b/mysql-test/r/consistent_snapshot.result
index 3a0227b1a1a..b978f1dd9d2 100644
--- a/mysql-test/r/consistent_snapshot.result
+++ b/mysql-test/r/consistent_snapshot.result
@@ -1,15 +1,15 @@
 DROP TABLE IF EXISTS t1;
-# Establish connection con1 (user=root)
-# Establish connection con2 (user=root)
+connect  con1,localhost,root,,;
+connect  con2,localhost,root,,;
 ### Test 1:
 ### - While a consistent snapshot transaction is executed,
 ###   no external inserts should be visible to the transaction.
-# Switch to connection con1
+connection con1;
 CREATE TABLE t1 (a INT) ENGINE=innodb;
 START TRANSACTION WITH CONSISTENT SNAPSHOT;
-# Switch to connection con2
+connection con2;
 INSERT INTO t1 VALUES(1);
-# Switch to connection con1
+connection con1;
 SELECT * FROM t1;
 a
 COMMIT;
@@ -18,9 +18,9 @@ COMMIT;
 ###   committed inserts should be visible to the transaction.
 DELETE FROM t1;
 START TRANSACTION;
-# Switch to connection con2
+connection con2;
 INSERT INTO t1 VALUES(1);
-# Switch to connection con1
+connection con1;
 SELECT * FROM t1;
 a
 1
@@ -31,12 +31,14 @@ COMMIT;
 START TRANSACTION WITH CONSISTENT SNAPSHOT;
 DELETE FROM t1;
 COMMIT WORK AND CHAIN;
-# Switch to connection con2
+connection con2;
 INSERT INTO t1 VALUES(1);
-# Switch to connection con1
+connection con1;
 SELECT * FROM t1;
 a
 1
 COMMIT;
-# Switch to connection default + close connections con1 and con2
+connection default;
+disconnect con1;
+disconnect con2;
 DROP TABLE t1;