Debian Codegraph @

mysql-test/suite/innodb/t/innodb-stats-modified-counter.test

raw
1 -- source include/have_innodb.inc
2
3 #
4 # MDEV-8297: information_schema.innodb_sys_tablestats.modified_counter doesn't change on UPDATE
5 #
6
7 set global innodb_stats_auto_recalc=off;
8
9 CREATE TABLE t1 (i int) ENGINE=InnoDB;
10
11 SELECT NAME, STATS_INITIALIZED, NUM_ROWS, MODIFIED_COUNTER FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS WHERE NAME = 'test/t1';
12
13 INSERT INTO t1 VALUES (1);
14 INSERT INTO t1 VALUES (2);
15
16 SELECT NAME, STATS_INITIALIZED, NUM_ROWS, MODIFIED_COUNTER FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS WHERE NAME = 'test/t1';
17
18 DELETE FROM t1 WHERE i = 1;
19
20 SELECT NAME, STATS_INITIALIZED, NUM_ROWS, MODIFIED_COUNTER FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS WHERE NAME = 'test/t1';
21
22 UPDATE t1 SET i = 4 WHERE i = 2;
23
24 SELECT NAME, STATS_INITIALIZED, NUM_ROWS, MODIFIED_COUNTER FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS WHERE NAME = 'test/t1';
25
26 DROP TABLE t1;
27
28 set global innodb_stats_auto_recalc=default;