diff options
| author | Igor Babaev <igor@askmonty.org> | 2013-12-14 19:13:37 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2013-12-14 19:13:37 -0800 |
| commit | 8efaff4959efe32ff9bc47c1bf1710cfe9ab21b5 (patch) | |
| tree | 1271d94adfb6460c54ceb88d34e023516343f907 /mysql-test/t/selectivity.test | |
| parent | 4bce09c104f5c9ddc3600a77c9db44dfa7fd283c (diff) | |
| download | mariadb-git-8efaff4959efe32ff9bc47c1bf1710cfe9ab21b5.tar.gz | |
Fixed bug mdev-5415.
Do not calculate selectivity of conditions for the tables of the information schema.
Diffstat (limited to 'mysql-test/t/selectivity.test')
| -rw-r--r-- | mysql-test/t/selectivity.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/selectivity.test b/mysql-test/t/selectivity.test index 2b44d5157df..82baf7cf1af 100644 --- a/mysql-test/t/selectivity.test +++ b/mysql-test/t/selectivity.test @@ -739,3 +739,14 @@ DROP TABLE t1,t2,t3; set use_stat_tables=@save_use_stat_tables; +--echo # +--echo # Bug mdev-5415: query over an information schema table +--echo # when optimizer_use_condition_selectivity=3 +--echo # + +set optimizer_use_condition_selectivity = 3; + +SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE SQL_MODE != ''; + +set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity; + |