--echo #
--echo # Test for bug bug91541 ("Flush status" statement adds twice to global values)
--echo #

--source include/have_perfschema.inc

SET @saved_show_compatibility_56 = @@global.show_compatibility_56;
SET GLOBAL show_compatibility_56 = OFF;

--echo #
--echo # default connection
--echo #
--let $initial_global_value = query_get_value(SHOW GLOBAL STATUS LIKE 'Slow_queries', Value, 1)
--let $default_session_value = query_get_value(SHOW SESSION STATUS LIKE 'Slow_queries', Value, 1)
--let $assert_cond = $default_session_value = 0
--let $assert_text = Default session value must be zero
--source include/assert.inc

--source include/count_sessions.inc

--echo #
--echo # first connection
--echo #
--connect (con1,localhost,root,,)
--let $current_global_value = query_get_value(SHOW GLOBAL STATUS LIKE 'Slow_queries', Value, 1)
--let $first_session_value = query_get_value(SHOW SESSION STATUS LIKE 'Slow_queries', Value, 1)
--let $assert_cond = $current_global_value - $initial_global_value = 0
--let $assert_text = Global value requested from the first session must not change
--source include/assert.inc
--let $assert_cond = $first_session_value = 0
--let $assert_text = First session value must be zero
--source include/assert.inc

SET long_query_time = 2;
SELECT SLEEP(3);
SET long_query_time = @@global.long_query_time;

--let $current_global_value = query_get_value(SHOW GLOBAL STATUS LIKE 'Slow_queries', Value, 1)
--let $first_session_value = query_get_value(SHOW SESSION STATUS LIKE 'Slow_queries', Value, 1)
--let $assert_cond = $current_global_value - $initial_global_value = 1
--let $assert_text = Global value requested from the first session after SLEEP() must inccrease by 1
--source include/assert.inc
--let $assert_cond = $first_session_value = 1
--let $assert_text = First session value must increase by 1
--source include/assert.inc

--connection default
--disconnect con1
--source include/wait_until_count_sessions.inc

--echo #
--echo # default connection
--echo #
--connection default
--let $current_global_value = query_get_value(SHOW GLOBAL STATUS LIKE 'Slow_queries', Value, 1)
--let $default_session_value = query_get_value(SHOW SESSION STATUS LIKE 'Slow_queries', Value, 1)
--let $assert_cond = $current_global_value - $initial_global_value = 1
--let $assert_text = Global value requested from the default session after DISCONNECT must remain the same
--source include/assert.inc
--let $assert_cond = $default_session_value = 0
--let $assert_text = Default session value must remain zero
--source include/assert.inc

FLUSH STATUS;

--let $current_global_value = query_get_value(SHOW GLOBAL STATUS LIKE 'Slow_queries', Value, 1)
--let $default_session_value = query_get_value(SHOW SESSION STATUS LIKE 'Slow_queries', Value, 1)
--let $assert_cond = $current_global_value - $initial_global_value = 1
--let $assert_text = Global value requested from the default session after FLUSH must remain the same
--source include/assert.inc
--let $assert_cond = $default_session_value = 0
--let $assert_text = Default session value must remain zero
--source include/assert.inc

SET GLOBAL show_compatibility_56 = @saved_show_compatibility_56;