From e4fbec1463bdf71482a2c9cd2b69b1a10b3c52ec Mon Sep 17 00:00:00 2001 From: Sergei Petrunia Date: Fri, 16 Dec 2022 13:33:05 +0300 Subject: Make tests work with --view-protocol --- mysql-test/main/partition_range.test | 3 +++ 1 file changed, 3 insertions(+) (limited to 'mysql-test/main/partition_range.test') diff --git a/mysql-test/main/partition_range.test b/mysql-test/main/partition_range.test index cfd2b42513f..a7073122bbb 100644 --- a/mysql-test/main/partition_range.test +++ b/mysql-test/main/partition_range.test @@ -981,6 +981,8 @@ ANALYZE TABLE t1_part,t2; EXPLAIN SELECT a, MAX(b) FROM t1_part WHERE a IN (10,100) GROUP BY a; EXPLAIN SELECT a, MAX(b) FROM t2 WHERE a IN (10,100) GROUP BY a; +# view protocol will cause changed table counters +--disable_view_protocol FLUSH status; SELECT a, MAX(b) FROM t1_part WHERE a IN (10, 100) GROUP BY a; SHOW status LIKE 'handler_read%'; @@ -989,6 +991,7 @@ FLUSH status; SELECT a, MAX(b) FROM t2 WHERE a IN (10, 100) GROUP BY a; SHOW status LIKE 'handler_read%'; +--enable_view_protocol insert into t2 select 100,seq from seq_1_to_100; EXPLAIN SELECT a, MAX(b) FROM t2 WHERE a IN (10,100) GROUP BY a; -- cgit v1.2.1