diff options
| author | Sergey Vojtovich <svoj@mariadb.org> | 2014-12-28 19:42:17 +0400 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@mariadb.org> | 2014-12-28 19:46:18 +0400 |
| commit | 6dbc48ca79e5fdd8d4022b00b862e08a4198155b (patch) | |
| tree | 1904e477f09dd958af2b6696d4b7c8dbb0a1772d /mysql-test/t/ps.test | |
| parent | 8883c54ac08a555bc7d9b09395f49893ad4d80b5 (diff) | |
| download | mariadb-git-6dbc48ca79e5fdd8d4022b00b862e08a4198155b.tar.gz | |
MDEV-7324 - Lock-free hash for table definition cache
Diffstat (limited to 'mysql-test/t/ps.test')
| -rw-r--r-- | mysql-test/t/ps.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test index 491594a3045..84c9874260a 100644 --- a/mysql-test/t/ps.test +++ b/mysql-test/t/ps.test @@ -2224,24 +2224,32 @@ deallocate prepare abc; create procedure proc_1() flush tables; flush tables; +--sorted_result show open tables from mysql; select Host, User from mysql.user limit 0; select Host, Db from mysql.host limit 0; +--sorted_result show open tables from mysql; call proc_1(); +--sorted_result show open tables from mysql; select Host, User from mysql.user limit 0; select Host, Db from mysql.host limit 0; +--sorted_result show open tables from mysql; call proc_1(); +--sorted_result show open tables from mysql; select Host, User from mysql.user limit 0; select Host, Db from mysql.host limit 0; +--sorted_result show open tables from mysql; call proc_1(); +--sorted_result show open tables from mysql; select Host, User from mysql.user limit 0; select Host, Db from mysql.host limit 0; +--sorted_result show open tables from mysql; flush tables; delimiter |; @@ -2261,24 +2269,31 @@ drop procedure proc_1; flush tables; select Host, User from mysql.user limit 0; select Host, Db from mysql.host limit 0; +--sorted_result show open tables from mysql; --enable_ps_protocol prepare abc from "flush tables"; execute abc; +--sorted_result show open tables from mysql; select Host, User from mysql.user limit 0; select Host, Db from mysql.host limit 0; +--sorted_result show open tables from mysql; execute abc; +--sorted_result show open tables from mysql; select Host, User from mysql.user limit 0; select Host, Db from mysql.host limit 0; +--sorted_result show open tables from mysql; execute abc; +--sorted_result show open tables from mysql; select Host, User from mysql.user limit 0; select Host, Db from mysql.host limit 0; +--sorted_result show open tables from mysql; flush tables; deallocate prepare abc; |