MDEV-6720 - enable connection log in mysqltest by default

1 files changed, 33 insertions, 31 deletions

diff --git a/mysql-test/r/commit.result b/mysql-test/r/commit.result
index a62d2940d85..b501f5a8dd7 100644
--- a/mysql-test/r/commit.result
+++ b/mysql-test/r/commit.result
@@ -1,3 +1,4 @@
+connect  con1,localhost,root,,;
 #
 # Bug#20837 Apparent change of isolation level 
 #           during transaction
@@ -43,11 +44,11 @@ s1
 2
 -1
 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
-connection con1
+connection con1;
 START TRANSACTION;
 INSERT INTO t1 VALUES (1000);
 COMMIT;
-connection default
+connection default;
 We should not be able to read the '1000'
 SELECT * FROM t1;
 s1
@@ -65,23 +66,23 @@ s1
 1000
 COMMIT;
 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
-connection default
+connection default;
 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
 START TRANSACTION;
-connection con1
+connection con1;
 START TRANSACTION;
 INSERT INTO t1 VALUES (1001);
 COMMIT;
-connection default
+connection default;
 SELECT COUNT(*) FROM t1 WHERE s1 = 1001;
 COUNT(*)
 1
 Should be 1
 COMMIT AND CHAIN;
-connection con1
+connection con1;
 INSERT INTO t1 VALUES (1002);
 COMMIT;
-connection default
+connection default;
 SELECT COUNT(*) FROM t1 WHERE s1 = 1002;
 COUNT(*)
 1
@@ -97,23 +98,23 @@ s1
 1002
 DELETE FROM t1 WHERE s1 >= 1000;
 COMMIT;
-connection default
+connection default;
 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
 START TRANSACTION;
-connection con1
+connection con1;
 START TRANSACTION;
 INSERT INTO t1 VALUES (1001);
 COMMIT;
-connection default
+connection default;
 SELECT COUNT(*) FROM t1 WHERE s1 = 1001;
 COUNT(*)
 1
 Should be 1
 ROLLBACK AND CHAIN;
-connection con1
+connection con1;
 INSERT INTO t1 VALUES (1002);
 COMMIT;
-connection default
+connection default;
 SELECT COUNT(*) FROM t1 WHERE s1 = 1002;
 COUNT(*)
 1
@@ -129,33 +130,33 @@ s1
 DELETE FROM t1 WHERE s1 >= 1000;
 COMMIT;
 SET @@completion_type=1;
-connection default
+connection default;
 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
 START TRANSACTION;
-connection con1
+connection con1;
 START TRANSACTION;
 INSERT INTO t1 VALUES (1001);
 COMMIT;
-connection default
+connection default;
 SELECT * FROM t1 WHERE s1 >= 1000;
 s1
 1001
 Should see 1001
 COMMIT AND NO CHAIN;
 default transaction is now in REPEATABLE READ
-connection con1
+connection con1;
 INSERT INTO t1 VALUES (1002);
 COMMIT;
-connection default
+connection default;
 SELECT * FROM t1 WHERE s1 >= 1000;
 s1
 1001
 1002
 Should see 1001 and 1002
-connection con1
+connection con1;
 INSERT INTO t1 VALUES (1003);
 COMMIT;
-connection default
+connection default;
 SELECT * FROM t1 WHERE s1 >= 1000;
 s1
 1001
@@ -174,35 +175,35 @@ DELETE FROM t1 WHERE s1 >= 1000;
 COMMIT AND NO CHAIN;
 SET @@completion_type=0;
 COMMIT;
-connection default
+connection default;
 SET @@completion_type=1;
 COMMIT AND NO CHAIN;
 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
 START TRANSACTION;
-connection con1
+connection con1;
 START TRANSACTION;
 INSERT INTO t1 VALUES (1001);
 COMMIT;
-connection default
+connection default;
 SELECT * FROM t1 WHERE s1 >= 1000;
 s1
 1001
 Should see 1001
 ROLLBACK AND NO CHAIN;
 default transaction is now in REPEATABLE READ
-connection con1
+connection con1;
 INSERT INTO t1 VALUES (1002);
 COMMIT;
-connection default
+connection default;
 SELECT * FROM t1 WHERE s1 >= 1000;
 s1
 1001
 1002
 Should see 1001 and 1002
-connection con1
+connection con1;
 INSERT INTO t1 VALUES (1003);
 COMMIT;
-connection default
+connection default;
 SELECT * FROM t1 WHERE s1 >= 1000;
 s1
 1001
@@ -221,7 +222,7 @@ DELETE FROM t1 WHERE s1 >= 1000;
 COMMIT AND NO CHAIN;
 SET @@completion_type=0;
 COMMIT;
-connection default
+connection default;
 SET TRANSACTION ISOLATION LEVEL	READ COMMITTED;
 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
 START TRANSACTION;
@@ -230,10 +231,10 @@ s1
 1
 2
 -1
-connection con1
+connection con1;
 INSERT INTO t1 VALUES (1000);
 COMMIT;
-connection default
+connection default;
 SELECT * FROM t1;
 s1
 1
@@ -253,10 +254,10 @@ SELECT * FROM t1;
 s1
 1000
 Should read '1000'
-connection con1
+connection con1;
 INSERT INTO t1 VALUES (1001);
 COMMIT;
-connection default
+connection default;
 SELECT * FROM t1;
 s1
 1000
@@ -266,6 +267,7 @@ SET @@completion_type=0;
 COMMIT AND NO CHAIN;
 SET @@autocommit=1;
 COMMIT;
+disconnect con1;
 DROP TABLE t1;
 #
 # End of test cases for Bug#20837