summaryrefslogtreecommitdiff
path: root/mysql-test/r/change_user.result
diff options
context:
space:
mode:
authordavi@moksha.com.br <>2007-10-16 12:29:22 -0300
committerdavi@moksha.com.br <>2007-10-16 12:29:22 -0300
commitc3447cef35286fc1064381497c1ff372b75b4c88 (patch)
tree2d2446c78221432deb6a2ba3a50f9236a3549280 /mysql-test/r/change_user.result
parent5cda50307fcbbac7aaeba13e110f9e0b669a9bd1 (diff)
downloadmariadb-git-c3447cef35286fc1064381497c1ff372b75b4c88.tar.gz
Bug#31608 missing mysqltest change_user command
The problem is that currently there is no way to test the behavior of the mysql_change_user() function using the mysqltest suite because there is no internal command for it. The solution is to introduce a change_user command that can be used to test aspects of the MySQL client function mysql_change_user().
Diffstat (limited to 'mysql-test/r/change_user.result')
-rw-r--r--mysql-test/r/change_user.result46
1 files changed, 46 insertions, 0 deletions
diff --git a/mysql-test/r/change_user.result b/mysql-test/r/change_user.result
new file mode 100644
index 00000000000..d0dfa855add
--- /dev/null
+++ b/mysql-test/r/change_user.result
@@ -0,0 +1,46 @@
+Bug#20023
+SELECT @@session.sql_big_selects;
+@@session.sql_big_selects
+1
+SELECT @@global.max_join_size;
+@@global.max_join_size
+-1
+change_user
+SELECT @@session.sql_big_selects;
+@@session.sql_big_selects
+1
+SELECT @@global.max_join_size;
+@@global.max_join_size
+-1
+SET @@global.max_join_size = 10000;
+SET @@session.max_join_size = default;
+change_user
+SELECT @@session.sql_big_selects;
+@@session.sql_big_selects
+0
+SET @@global.max_join_size = -1;
+SET @@session.max_join_size = default;
+change_user
+SELECT @@session.sql_big_selects;
+@@session.sql_big_selects
+1
+Bug#31418
+SELECT IS_FREE_LOCK('bug31418');
+IS_FREE_LOCK('bug31418')
+1
+SELECT IS_USED_LOCK('bug31418');
+IS_USED_LOCK('bug31418')
+NULL
+SELECT GET_LOCK('bug31418', 1);
+GET_LOCK('bug31418', 1)
+1
+SELECT IS_USED_LOCK('bug31418');
+IS_USED_LOCK('bug31418')
+1
+change_user
+SELECT IS_FREE_LOCK('bug31418');
+IS_FREE_LOCK('bug31418')
+1
+SELECT IS_USED_LOCK('bug31418');
+IS_USED_LOCK('bug31418')
+NULL