test_status_var_reader.result

#
# WL#15173: A component service to read status variable values
#
INSTALL COMPONENT "file://component_test_status_var_reader";
# FR5: test that no aggregation is triggered for session-altered variables
# Should return 0 rows
SELECT VARIABLE_NAME, VARIABLE_VALUE, test_get_status_var(VARIABLE_NAME, 0)
FROM performance_schema.global_status
WHERE VARIABLE_VALUE = test_get_status_var(VARIABLE_NAME, 0) AND
VARIABLE_NAME IN (
'Bytes_received',
'Bytes_sent');
# FR2, FR3, FR4.1 Test global status: should return 0 rows
SELECT VARIABLE_NAME, VARIABLE_VALUE, test_get_status_var(VARIABLE_NAME, 0)
FROM performance_schema.global_status
WHERE VARIABLE_VALUE <> test_get_status_var(VARIABLE_NAME, 0) AND
VARIABLE_NAME NOT IN (
'Bytes_received',
'Bytes_sent',
'Handler_commit',
'Handler_external_lock',
'Handler_write',
'Handler_read_key',
'Handler_read_next',
'Handler_read_rnd_next',
'Created_tmp_disk_tables',
'Created_tmp_tables',
'Handler_read_first',
'Com_stmt_reprepare');
# FR4 Test session status: should return 0 rows
SELECT VARIABLE_NAME, VARIABLE_VALUE, test_get_status_var(VARIABLE_NAME, 1)
FROM performance_schema.session_status
WHERE VARIABLE_VALUE <> test_get_status_var(VARIABLE_NAME, 1) AND
VARIABLE_NAME NOT IN (
'Bytes_received',
'Bytes_sent',
'Handler_commit',
'Handler_external_lock',
'Handler_write',
'Handler_read_key',
'Handler_read_next',
'Handler_read_rnd_next',
'Created_tmp_disk_tables',
'Created_tmp_tables',
'Handler_read_first',
'Com_stmt_reprepare');
UNINSTALL COMPONENT "file://component_test_status_var_reader";
# End of 8.0 tests