diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2015-12-16 19:33:41 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2016-01-22 18:07:11 +0100 |
| commit | 825f51d1aab51d363dc07ec9fe0829af33063883 (patch) | |
| tree | 3e9da3522d9f532799207f23b3e4cc0e1a41a04c /mysql-test/t/statistics.test | |
| parent | 45920d3d4a8ee28af8ca64b281db95ae3876bb70 (diff) | |
| download | mariadb-git-825f51d1aab51d363dc07ec9fe0829af33063883.tar.gz | |
MDEV-9118 ANALYZE TABLE for Engine independent status fetchs blob/text columns without use
Do not include BLOB fields by default.
Diffstat (limited to 'mysql-test/t/statistics.test')
| -rw-r--r-- | mysql-test/t/statistics.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/statistics.test b/mysql-test/t/statistics.test index 2c8dec307cc..3b57b8f2c52 100644 --- a/mysql-test/t/statistics.test +++ b/mysql-test/t/statistics.test @@ -494,6 +494,17 @@ DELETE FROM mysql.table_stats; DELETE FROM mysql.column_stats; DELETE FROM mysql.index_stats; + +ANALYZE TABLE t1 PERSISTENT FOR COLUMNS(b) INDEXES(); +ANALYZE TABLE t1 PERSISTENT FOR columns(a,b) INDEXES(); +ANALYZE TABLE t1 PERSISTENT FOR columns(b) indexes(idx2); +ANALYZE TABLE t1 PERSISTENT FOR columns() indexes(idx2); + +DELETE FROM mysql.table_stats; +DELETE FROM mysql.column_stats; +DELETE FROM mysql.index_stats; + + DROP TABLE t1,t2; set names utf8; |