|
1619.3.4
by Stewart Smith
add basic test for Handler_update status variable |
1 |
FLUSH STATUS; |
2 |
SHOW STATUS LIKE 'Handler_update'; |
|
3 |
CREATE TABLE t1 (a int primary key); |
|
4 |
INSERT INTO t1 VALUES (1); |
|
5 |
SHOW STATUS LIKE 'Handler_update'; |
|
6 |
UPDATE t1 SET a=2 WHERE a=1; |
|
7 |
SHOW STATUS LIKE 'Handler_update'; |
|
8 |
DROP TABLE t1; |
|
9 |
FLUSH STATUS; |
|
10 |
||
11 |
CREATE TABLE t1 (a int primary key, b varchar(100)); |
|
12 |
INSERT INTO t1 VALUES (1,"hello"), (2, "goodbye"); |
|
13 |
UPDATE t1 SET b="world" WHERE a=1; |
|
14 |
SHOW STATUS LIKE 'Handler_update'; |
|
15 |
UPDATE t1 SET a=a+10; |
|
16 |
SHOW STATUS LIKE 'Handler_update'; |
|
17 |
DROP TABLE t1; |