forked from facebook/mysql-5.6
/
statements_row_inserted.inc
44 lines (35 loc) · 3.31 KB
/
statements_row_inserted.inc
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
# Executes sql command and validates the values of SUMS_ROWS_INSERTED from various
# statements table.
# The following variables should be set before invoking this inc file
# $sql
# $expected_sum_rows_inserted
#--let $rpl_debug = 1
# Start counters
--let $start_sum_rows_inserted_user = query_get_value(select sum(SUM_ROWS_INSERTED) as Value from performance_schema.events_statements_summary_by_user_by_event_name, Value, 1)
--let $start_sum_rows_inserted_host = query_get_value(select sum(SUM_ROWS_INSERTED) as Value from performance_schema.events_statements_summary_by_host_by_event_name, Value, 1)
--let $start_sum_rows_inserted_program = query_get_value(select sum(SUM_ROWS_INSERTED) as Value from performance_schema.events_statements_summary_by_program, Value, 1)
--let $start_sum_rows_inserted_event = query_get_value(select sum(SUM_ROWS_INSERTED) as Value from performance_schema.events_statements_summary_by_thread_by_event_name, Value, 1)
--let $start_sum_rows_inserted_global = query_get_value(select sum(SUM_ROWS_INSERTED) as Value from performance_schema.events_statements_summary_global_by_event_name, Value, 1)
--eval $sql
# Get counters
--let $end_sum_rows_inserted_user = query_get_value(select sum(SUM_ROWS_INSERTED) as Value from performance_schema.events_statements_summary_by_user_by_event_name, Value, 1)
--let $end_sum_rows_inserted_host = query_get_value(select sum(SUM_ROWS_INSERTED) as Value from performance_schema.events_statements_summary_by_host_by_event_name, Value, 1)
--let $end_sum_rows_inserted_program = query_get_value(select sum(SUM_ROWS_INSERTED) as Value from performance_schema.events_statements_summary_by_program, Value, 1)
--let $end_sum_rows_inserted_event = query_get_value(select sum(SUM_ROWS_INSERTED) as Value from performance_schema.events_statements_summary_by_thread_by_event_name, Value, 1)
--let $end_sum_rows_inserted_global = query_get_value(select sum(SUM_ROWS_INSERTED) as Value from performance_schema.events_statements_summary_global_by_event_name, Value, 1)
# Check sanity
--let $assert_text= SUM_ROWS_INSERTED on events_statements_summary_by_user_by_event_name should be increased by $expected_sum_rows_inserted.
--let $assert_cond= $end_sum_rows_inserted_user - $start_sum_rows_inserted_user = $expected_sum_rows_inserted
--source include/assert.inc
--let $assert_text= SUM_ROWS_INSERTED on events_statements_summary_by_host_by_event_name should be increased by $expected_sum_rows_inserted.
--let $assert_cond= $end_sum_rows_inserted_host - $start_sum_rows_inserted_host = $expected_sum_rows_inserted
--source include/assert.inc
--let $assert_text= SUM_ROWS_INSERTED on events_statements_summary_by_program should be increased by 0.
--let $assert_cond= $end_sum_rows_inserted_program - $start_sum_rows_inserted_program = 0
--source include/assert.inc
--let $assert_text= SUM_ROWS_INSERTED on events_statements_summary_by_thread_by_event_name should be increased by $expected_sum_rows_inserted.
--let $assert_cond= $end_sum_rows_inserted_event - $start_sum_rows_inserted_event = $expected_sum_rows_inserted
--source include/assert.inc
--let $assert_text= SUM_ROWS_INSERTED on events_statements_summary_global_by_event_name should be increased by $expected_sum_rows_inserted.
--let $assert_cond= $end_sum_rows_inserted_global - $start_sum_rows_inserted_global = $expected_sum_rows_inserted
--source include/assert.inc