MOON
Server: Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 PHP/5.4.10
System: Linux vps.presagepowered.net 2.6.18-398.el5 #1 SMP Tue Sep 16 20:51:48 EDT 2014 i686
User: mckernan (512)
PHP: 5.4.10
Disabled: NONE
Upload Files
File: //usr/share/mysql-test/t/not_embedded_server.test
#
# Here we collect tests that doesn't work with the embedded server
#

-- source include/not_embedded.inc

#
# Show full process list with prepare
# To not show other connections, this must be the first test and we must
# have a server restart before this one
#

prepare stmt1 from ' show full processlist ';
--replace_column 1 number 6 time 3 localhost
execute stmt1;
deallocate prepare stmt1;

# End of 4.1 tests

#
# Bug#31222: com_% global status counters behave randomly with
# mysql_change_user.
#

FLUSH STATUS;

--disable_result_log
--disable_query_log

let $i = 100;

while ($i)
{
  dec $i;

  SELECT 1;
}

--enable_query_log
--enable_result_log

let $before= query_get_value(SHOW GLOBAL STATUS LIKE 'com_select',Value,1);

--change_user

let $after= query_get_value(SHOW GLOBAL STATUS LIKE 'com_select',Value,1);

if (`select $after != $before`){
  SHOW GLOBAL STATUS LIKE 'com_select';
  die The value of com_select changed during change_user;
}
echo Value of com_select did not change;