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 = 18446744073709551615;
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;