diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-10-31 13:00:20 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-10-31 13:00:20 +0400 |
| commit | 5d3ed9acdda80828f7f3be8f7322b3e8366eab5f (patch) | |
| tree | f2b0c44e9429a0aaf0d4af63c9a66ae870b2ff35 /mysql-test/suite/perfschema/t/dml_handler.test | |
| parent | 835cbbcc7b797188a89671019f2b2844e1a14e0c (diff) | |
| download | mariadb-git-5d3ed9acdda80828f7f3be8f7322b3e8366eab5f.tar.gz | |
(Part#2) MDEV-13049 Querying INFORMATION_SCHEMA becomes slow in MariaDB 10.1
This is a 10.3 specific part of MDEV-13049.
It disables automatic sorting for
"SELECT .. FROM INFORMATION_SCHEMA.{SCHEMATA|TABLES}"
and adjusts the affected tests accordingly.
Diffstat (limited to 'mysql-test/suite/perfschema/t/dml_handler.test')
| -rw-r--r-- | mysql-test/suite/perfschema/t/dml_handler.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/suite/perfschema/t/dml_handler.test b/mysql-test/suite/perfschema/t/dml_handler.test index db74c85350a..f12cc82f22f 100644 --- a/mysql-test/suite/perfschema/t/dml_handler.test +++ b/mysql-test/suite/perfschema/t/dml_handler.test @@ -18,7 +18,8 @@ CREATE TEMPORARY TABLE table_list (id INT AUTO_INCREMENT, PRIMARY KEY (id)) AS SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES - WHERE TABLE_SCHEMA='performance_schema'; + WHERE TABLE_SCHEMA='performance_schema' + ORDER BY TABLE_NAME; SELECT COUNT(*) FROM table_list INTO @table_count; |