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/t/sp.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/t/sp.test')
| -rw-r--r-- | mysql-test/t/sp.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 94d779de203..7d4758403ad 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -5722,8 +5722,10 @@ create procedure bug18344_2() begin end| use test| +--sorted_result select schema_name from information_schema.schemata where schema_name like 'bug18344%'| +--sorted_result select routine_name,routine_schema from information_schema.routines where routine_schema like 'bug18344%'| |