summaryrefslogtreecommitdiff
path: root/mysql-test/main
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2022-02-17 14:57:00 +0200
committerMarko Mäkelä <marko.makela@mariadb.com>2022-02-17 14:57:00 +0200
commitc76bdc57ffb08043e7b509a188d4626d0f3063c9 (patch)
tree1a4661a54b48b20f500a2a37b8d87b1bec53ec5e /mysql-test/main
parent38a8ac19510b08ecea0b33cba887775b47a58267 (diff)
parentf04b459fb75b28dd57c7f22bc69588f087956373 (diff)
downloadmariadb-git-c76bdc57ffb08043e7b509a188d4626d0f3063c9.tar.gz
Merge 10.6 into 10.7
Diffstat (limited to 'mysql-test/main')
-rw-r--r--mysql-test/main/check_view_protocol.result19
-rw-r--r--mysql-test/main/check_view_protocol.test21
-rw-r--r--mysql-test/main/session_tracker_last_gtid.result1
-rw-r--r--mysql-test/main/session_tracker_last_gtid.test1
4 files changed, 42 insertions, 0 deletions
diff --git a/mysql-test/main/check_view_protocol.result b/mysql-test/main/check_view_protocol.result
new file mode 100644
index 00000000000..697bc759498
--- /dev/null
+++ b/mysql-test/main/check_view_protocol.result
@@ -0,0 +1,19 @@
+flush status;
+create table t1 (a int);
+insert into t1 (a) values (1);
+create table t2 (b int);
+insert into t2 (b) values (2);
+select * from t1;
+a
+1
+show status like 'Opened_views';
+Variable_name Value
+Opened_views 1
+flush status;
+select * from t2;
+b
+2
+show status like 'Opened_views';
+Variable_name Value
+Opened_views 0
+drop table t1, t2;
diff --git a/mysql-test/main/check_view_protocol.test b/mysql-test/main/check_view_protocol.test
new file mode 100644
index 00000000000..c4d5670669c
--- /dev/null
+++ b/mysql-test/main/check_view_protocol.test
@@ -0,0 +1,21 @@
+-- source include/have_view_protocol.inc
+
+flush status;
+
+create table t1 (a int);
+insert into t1 (a) values (1);
+create table t2 (b int);
+insert into t2 (b) values (2);
+select * from t1;
+show status like 'Opened_views';
+
+flush status;
+--disable_view_protocol
+select * from t2;
+--enable_view_protocol
+
+show status like 'Opened_views';
+
+drop table t1, t2;
+
+
diff --git a/mysql-test/main/session_tracker_last_gtid.result b/mysql-test/main/session_tracker_last_gtid.result
index 795d0aaa2a2..5a78d5f03ce 100644
--- a/mysql-test/main/session_tracker_last_gtid.result
+++ b/mysql-test/main/session_tracker_last_gtid.result
@@ -32,3 +32,4 @@ drop table t1;
-- last_gtid
-- 0-1-1002
+reset master;
diff --git a/mysql-test/main/session_tracker_last_gtid.test b/mysql-test/main/session_tracker_last_gtid.test
index 24cf2104a0c..58aee2de837 100644
--- a/mysql-test/main/session_tracker_last_gtid.test
+++ b/mysql-test/main/session_tracker_last_gtid.test
@@ -17,3 +17,4 @@ select @@last_gtid;
drop table t1;
--disable_session_track_info
+reset master;