diff options
| author | Igor Babaev <igor@askmonty.org> | 2012-08-18 22:18:46 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2012-08-18 22:18:46 -0700 |
| commit | fd7059d20859863a146cd306b88ac6e9817622fd (patch) | |
| tree | 681350c033109ebff13aea42ec24a30074e89bdb /mysql-test/t/statistics.test | |
| parent | 584cfcbebd39981cc144f93cbfb007592e538989 (diff) | |
| download | mariadb-git-fd7059d20859863a146cd306b88ac6e9817622fd.tar.gz | |
Fixed the following problem: the syntax of the ANALYZE command did not
returned an error if the list of the specified index names contained
the name 'primary'.
Diffstat (limited to 'mysql-test/t/statistics.test')
| -rw-r--r-- | mysql-test/t/statistics.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/statistics.test b/mysql-test/t/statistics.test index 903cf27648c..30aa335e42d 100644 --- a/mysql-test/t/statistics.test +++ b/mysql-test/t/statistics.test @@ -353,6 +353,11 @@ SELECT * FROM mysql.table_stat; SELECT * FROM mysql.column_stat; SELECT * FROM mysql.index_stat; +DELETE FROM mysql.index_stat WHERE table_name='t1' AND index_name='primary'; +SELECT * FROM mysql.index_stat; +ANALYZE TABLE t1 PERSISTENT FOR COLUMNS() INDEXES(primary); +SELECT * FROM mysql.index_stat; + DELETE FROM mysql.table_stat; DELETE FROM mysql.column_stat; DELETE FROM mysql.index_stat; |