2
# Bug#20023 mysql_change_user() resets the value of SQL_BIG_SELECTS
6
SELECT @@session.sql_big_selects;
7
# The exact value depends on the server build flags
8
--replace_result 18446744073709551615 HA_POS_ERROR 4294967295 HA_POS_ERROR
9
SELECT @@global.max_join_size;
12
SELECT @@session.sql_big_selects;
13
# The exact value depends on the server build flags
14
--replace_result 18446744073709551615 HA_POS_ERROR 4294967295 HA_POS_ERROR
15
SELECT @@global.max_join_size;
16
SET @@global.max_join_size = 10000;
17
SET @@session.max_join_size = default;
20
SELECT @@session.sql_big_selects;
21
# On some machines the following will result into a warning
23
SET @@global.max_join_size = -1;
25
SET @@session.max_join_size = default;
28
SELECT @@session.sql_big_selects;
31
# Bug#31418 User locks misfunctioning after mysql_change_user()
35
SELECT IS_FREE_LOCK('bug31418');
36
SELECT IS_USED_LOCK('bug31418');
37
SELECT GET_LOCK('bug31418', 1);
38
SELECT IS_USED_LOCK('bug31418') = CONNECTION_ID();
41
SELECT IS_FREE_LOCK('bug31418');
42
SELECT IS_USED_LOCK('bug31418');
45
# Bug#31222: com_% global status counters behave randomly with
66
let $before= query_get_value(SHOW GLOBAL STATUS LIKE 'com_select',Value,1);
70
let $after= query_get_value(SHOW GLOBAL STATUS LIKE 'com_select',Value,1);
72
if (`select $after != $before`){
73
SHOW GLOBAL STATUS LIKE 'com_select';
74
die The value of com_select changed during change_user;
76
echo Value of com_select did not change;