change_user.result 3.09 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
grant select on test.* to test_nopw;
grant select on test.* to test_oldpw identified by password "09301740536db389";
grant select on test.* to test_newpw identified by "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