6
6
# First we test tables with only an index.
9
#BUG#12662190 - COM_COMMIT IS NOT INCREMENTED FROM THE BINARY LOGS ON SLAVE, COM_BEGIN IS
10
#Testing command counters -BEFORE
11
#Storing the before counts of Slave
13
let $slave_com_commit_before= query_get_value(SHOW GLOBAL STATUS LIKE 'com_commit', Value, 1);
14
let $slave_com_insert_before= query_get_value(SHOW GLOBAL STATUS LIKE 'com_insert', Value, 1);
15
let $slave_com_delete_before= query_get_value(SHOW GLOBAL STATUS LIKE 'com_delete', Value, 1);
16
let $slave_com_update_before= query_get_value(SHOW GLOBAL STATUS LIKE 'com_update', Value, 1);
10
19
eval CREATE TABLE t1 (C1 CHAR(1), C2 CHAR(1), INDEX (C1)$extra_index_t1) ENGINE = $type ;
40
49
sync_slave_with_master;
41
50
SELECT * FROM t1 ORDER BY C1,C2;
52
#BUG#12662190 - COM_COMMIT IS NOT INCREMENTED FROM THE BINARY LOGS ON SLAVE, COM_BEGIN IS
53
#Testing command counters -AFTER
54
#Storing the after counts of Slave
56
let $slave_com_commit_after= query_get_value(SHOW GLOBAL STATUS LIKE 'com_commit', Value, 1);
57
let $slave_com_insert_after= query_get_value(SHOW GLOBAL STATUS LIKE 'com_insert', Value, 1);
58
let $slave_com_delete_after= query_get_value(SHOW GLOBAL STATUS LIKE 'com_delete', Value, 1);
59
let $slave_com_update_after= query_get_value(SHOW GLOBAL STATUS LIKE 'com_update', Value, 1);
62
--let $assert_text= Counter for COM_COMMIT is consistent with the number of actual commits
63
--let $assert_cond= $slave_com_commit_after - $slave_com_commit_before = 4
64
--source include/assert.inc
66
--let $assert_text= Counter for COM_INSERT is consistent with the number of actual inserts
67
--let $assert_cond= $slave_com_insert_after - $slave_com_insert_before = 2
68
--source include/assert.inc
70
--let $assert_text= Counter for COM_DELETE is consistent with the number of actual deletes
71
--let $assert_cond= $slave_com_delete_after - $slave_com_delete_before = 1
72
--source include/assert.inc
74
--let $assert_text= Counter for COM_UPDATE is consistent with the number of actual updates
75
--let $assert_cond= $slave_com_update_after - $slave_com_update_before = 1
76
--source include/assert.inc
43
78
# Testing update with a condition that does not match any rows, but
44
79
# which has a match for the index.