summaryrefslogtreecommitdiff
path: root/mysql-test/r/change_user.result
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2018-03-09 14:05:35 +0200
committerMonty <monty@mariadb.org>2018-03-29 13:59:44 +0300
commita7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch)
tree70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/r/change_user.result
parentab1941266c59a19703a74b5593cf3f508a5752d7 (diff)
downloadmariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/r/change_user.result')
-rw-r--r--mysql-test/r/change_user.result103
1 files changed, 0 insertions, 103 deletions
diff --git a/mysql-test/r/change_user.result b/mysql-test/r/change_user.result
deleted file mode 100644
index fa934fbf09a..00000000000
--- a/mysql-test/r/change_user.result
+++ /dev/null
@@ -1,103 +0,0 @@
-set global secure_auth=0;
-create user test_nopw;
-grant select on test.* to test_nopw;
-create user test_oldpw identified by password "09301740536db389";
-grant select on test.* to test_oldpw;
-create user test_newpw identified by "newpw";
-grant select on test.* to test_newpw;
-select concat('<', user(), '>'), concat('<', current_user(), '>'), database();
-concat('<', user(), '>') concat('<', current_user(), '>') database()
-<root@localhost> <root@localhost> test
-select concat('<', user(), '>'), concat('<', current_user(), '>'), database();
-concat('<', user(), '>') concat('<', current_user(), '>') database()
-<test_nopw@localhost> <test_nopw@%> NULL
-select concat('<', user(), '>'), concat('<', current_user(), '>'), database();
-concat('<', user(), '>') concat('<', current_user(), '>') database()
-<test_oldpw@localhost> <test_oldpw@%> NULL
-select concat('<', user(), '>'), concat('<', current_user(), '>'), database();
-concat('<', user(), '>') concat('<', current_user(), '>') database()
-<test_newpw@localhost> <test_newpw@%> NULL
-select concat('<', user(), '>'), concat('<', current_user(), '>'), database();
-concat('<', user(), '>') concat('<', current_user(), '>') database()
-<root@localhost> <root@localhost> NULL
-select concat('<', user(), '>'), concat('<', current_user(), '>'), database();
-concat('<', user(), '>') concat('<', current_user(), '>') database()
-<test_nopw@localhost> <test_nopw@%> test
-select concat('<', user(), '>'), concat('<', current_user(), '>'), database();
-concat('<', user(), '>') concat('<', current_user(), '>') database()
-<test_oldpw@localhost> <test_oldpw@%> test
-select concat('<', user(), '>'), concat('<', current_user(), '>'), database();
-concat('<', user(), '>') concat('<', current_user(), '>') database()
-<test_newpw@localhost> <test_newpw@%> test
-select concat('<', user(), '>'), concat('<', current_user(), '>'), database();
-concat('<', user(), '>') concat('<', current_user(), '>') database()
-<root@localhost> <root@localhost> test
-drop user test_nopw;
-drop user test_oldpw;
-drop user test_newpw;
-Bug#20023
-SELECT @@session.sql_big_selects;
-@@session.sql_big_selects
-1
-SELECT @@global.max_join_size;
-@@global.max_join_size
-HA_POS_ERROR
-change_user
-SELECT @@session.sql_big_selects;
-@@session.sql_big_selects
-1
-SELECT @@global.max_join_size;
-@@global.max_join_size
-HA_POS_ERROR
-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 = 18446744073709551615;
-SET @@session.max_join_size = default;
-change_user
-SELECT @@session.sql_big_selects;
-@@session.sql_big_selects
-1
-SELECT @@global.max_join_size;
-@@global.max_join_size
-18446744073709551615
-SELECT @@session.max_join_size;
-@@session.max_join_size
-18446744073709551615
-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') = CONNECTION_ID();
-IS_USED_LOCK('bug31418') = CONNECTION_ID()
-1
-change_user
-SELECT IS_FREE_LOCK('bug31418');
-IS_FREE_LOCK('bug31418')
-1
-SELECT IS_USED_LOCK('bug31418');
-IS_USED_LOCK('bug31418')
-NULL
-FLUSH STATUS;
-Value of com_select did not change
-set global secure_auth=default;
-set timestamp=unix_timestamp('2010-10-10 10:10:10');
-select now();
-now()
-2010-10-10 10:10:10
-select year(now()) > 2011;
-year(now()) > 2011
-0
-change_user
-select year(now()) > 2011;
-year(now()) > 2011
-1