diff --git a/mysql-test/suite/perfschema/r/idx_compare_replication_applier_status.result b/mysql-test/suite/perfschema/r/idx_compare_replication_applier_status.result index f0d3fcee91b..69b72bae893 100644 --- a/mysql-test/suite/perfschema/r/idx_compare_replication_applier_status.result +++ b/mysql-test/suite/perfschema/r/idx_compare_replication_applier_status.result @@ -7,11 +7,15 @@ include/stop_slave.inc SET @old_slave_parallel_workers= @@global.slave_parallel_workers; SET GLOBAL slave_parallel_workers= 4; include/start_slave.inc +SELECT COUNT_TRANSACTIONS_RETRIES INTO @old_count_transactions_retries FROM +performance_schema.replication_applier_status; ## Create index_test() procedure DROP PROCEDURE IF EXISTS index_test; -select * from performance_schema.replication_applier_status; -CHANNEL_NAME SERVICE_STATE REMAINING_DELAY COUNT_TRANSACTIONS_RETRIES +select CHANNEL_NAME, SERVICE_STATE, REMAINING_DELAY, +COUNT_TRANSACTIONS_RETRIES - @old_count_transactions_retries as should_be_zero FROM +performance_schema.replication_applier_status; +CHANNEL_NAME SERVICE_STATE REMAINING_DELAY should_be_zero ON NULL 0 set @pfs_columns = "*"; TABLE: "replication_applier_status" diff --git a/mysql-test/suite/perfschema/t/idx_compare_replication_applier_status.test b/mysql-test/suite/perfschema/t/idx_compare_replication_applier_status.test index 0a77c9a55ce..f429f4f549c 100644 --- a/mysql-test/suite/perfschema/t/idx_compare_replication_applier_status.test +++ b/mysql-test/suite/perfschema/t/idx_compare_replication_applier_status.test @@ -13,10 +13,15 @@ SET GLOBAL slave_parallel_workers= 4; --source include/start_slave.inc --connection slave + +SELECT COUNT_TRANSACTIONS_RETRIES INTO @old_count_transactions_retries FROM +performance_schema.replication_applier_status; --source ../include/idx_compare_setup_index_test.inc # Debug -select * from performance_schema.replication_applier_status; +select CHANNEL_NAME, SERVICE_STATE, REMAINING_DELAY, +COUNT_TRANSACTIONS_RETRIES - @old_count_transactions_retries as should_be_zero FROM +performance_schema.replication_applier_status; set @pfs_columns = "*"; let $table = "replication_applier_status";