diff options
| author | Sergei Petrunia <sergey@mariadb.com> | 2022-12-16 13:33:05 +0300 |
|---|---|---|
| committer | Sergei Petrunia <sergey@mariadb.com> | 2023-02-03 14:33:18 +0300 |
| commit | e4fbec1463bdf71482a2c9cd2b69b1a10b3c52ec (patch) | |
| tree | d10fc69080cbe166082229fbda0bc72cc14e9f4e /mysql-test/main/partition_range.test | |
| parent | 15298815954c88a22e5b6b3967f79cd89d23cb21 (diff) | |
| download | mariadb-git-e4fbec1463bdf71482a2c9cd2b69b1a10b3c52ec.tar.gz | |
Make tests work with --view-protocol
Diffstat (limited to 'mysql-test/main/partition_range.test')
| -rw-r--r-- | mysql-test/main/partition_range.test | 3 |
1 files changed, 3 insertions, 0 deletions
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; |