diff options
author | Michael Widenius <monty@mariadb.org> | 2018-03-09 14:05:35 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2018-03-29 13:59:44 +0300 |
commit | a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch) | |
tree | 70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/r/change_user.result | |
parent | ab1941266c59a19703a74b5593cf3f508a5752d7 (diff) | |
download | mariadb-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.result | 103 |
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 |