diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-02-17 14:57:00 +0200 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-02-17 14:57:00 +0200 |
commit | c76bdc57ffb08043e7b509a188d4626d0f3063c9 (patch) | |
tree | 1a4661a54b48b20f500a2a37b8d87b1bec53ec5e /mysql-test/main | |
parent | 38a8ac19510b08ecea0b33cba887775b47a58267 (diff) | |
parent | f04b459fb75b28dd57c7f22bc69588f087956373 (diff) | |
download | mariadb-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.result | 19 | ||||
-rw-r--r-- | mysql-test/main/check_view_protocol.test | 21 | ||||
-rw-r--r-- | mysql-test/main/session_tracker_last_gtid.result | 1 | ||||
-rw-r--r-- | mysql-test/main/session_tracker_last_gtid.test | 1 |
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; |