summaryrefslogtreecommitdiff
path: root/mysql-test/r/ps.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/ps.result')
-rw-r--r--mysql-test/r/ps.result21
1 files changed, 7 insertions, 14 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result
index 341a6b7cd43..edac68a88d6 100644
--- a/mysql-test/r/ps.result
+++ b/mysql-test/r/ps.result
@@ -1857,10 +1857,9 @@ select Host, Db from mysql.host limit 0;
Host Db
show open tables from mysql;
Database Table In_use Name_locked
+mysql user 0 0
mysql general_log 0 0
-mysql slow_log 0 0
mysql host 0 0
-mysql user 0 0
call proc_1();
show open tables from mysql;
Database Table In_use Name_locked
@@ -1871,10 +1870,9 @@ select Host, Db from mysql.host limit 0;
Host Db
show open tables from mysql;
Database Table In_use Name_locked
+mysql user 0 0
mysql general_log 0 0
-mysql slow_log 0 0
mysql host 0 0
-mysql user 0 0
call proc_1();
show open tables from mysql;
Database Table In_use Name_locked
@@ -1885,10 +1883,9 @@ select Host, Db from mysql.host limit 0;
Host Db
show open tables from mysql;
Database Table In_use Name_locked
+mysql user 0 0
mysql general_log 0 0
-mysql slow_log 0 0
mysql host 0 0
-mysql user 0 0
call proc_1();
show open tables from mysql;
Database Table In_use Name_locked
@@ -1899,10 +1896,9 @@ select Host, Db from mysql.host limit 0;
Host Db
show open tables from mysql;
Database Table In_use Name_locked
+mysql user 0 0
mysql general_log 0 0
-mysql slow_log 0 0
mysql host 0 0
-mysql user 0 0
flush tables;
create function func_1() returns int begin flush tables; return 1; end|
ERROR 0A000: FLUSH is not allowed in stored function or trigger
@@ -1932,10 +1928,9 @@ select Host, Db from mysql.host limit 0;
Host Db
show open tables from mysql;
Database Table In_use Name_locked
+mysql user 0 0
mysql general_log 0 0
-mysql slow_log 0 0
mysql host 0 0
-mysql user 0 0
execute abc;
show open tables from mysql;
Database Table In_use Name_locked
@@ -1946,10 +1941,9 @@ select Host, Db from mysql.host limit 0;
Host Db
show open tables from mysql;
Database Table In_use Name_locked
+mysql user 0 0
mysql general_log 0 0
-mysql slow_log 0 0
mysql host 0 0
-mysql user 0 0
execute abc;
show open tables from mysql;
Database Table In_use Name_locked
@@ -1960,10 +1954,9 @@ select Host, Db from mysql.host limit 0;
Host Db
show open tables from mysql;
Database Table In_use Name_locked
+mysql user 0 0
mysql general_log 0 0
-mysql slow_log 0 0
mysql host 0 0
-mysql user 0 0
flush tables;
deallocate prepare abc;
create procedure proc_1() flush logs;