/usr/lib/mysql-testsuite/r/percona_bug1192354.result is in percona-server-test-5.6 5.6.22-rel71.0-0ubuntu4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 | DROP TABLE IF EXISTS t1;
Warnings:
Note 1051 Unknown table 'test.t1'
CREATE TABLE t1 (
c1 int,
c2 int,
PRIMARY KEY (c1, c2)
) ENGINE = InnoDB
PARTITION BY LIST (c1)
(PARTITION p0 VALUES IN (0) ENGINE = InnoDB,
PARTITION p1 VALUES IN (1) ENGINE = InnoDB);
INSERT INTO t1 VALUES (0, 0);
INSERT INTO t1 SELECT 0, c2+1 FROM t1;
INSERT INTO t1 SELECT 0, c2+2 FROM t1;
INSERT INTO t1 SELECT 0, c2+4 FROM t1;
INSERT INTO t1 SELECT 0, c2+8 FROM t1;
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
test.t1 analyze status OK
SELECT cardinality FROM information_schema.statistics WHERE table_name = 't1';
cardinality
2
17
SELECT partition_name, table_rows FROM information_schema.partitions WHERE table_name = 't1';
partition_name table_rows
p0 16
p1 0
SELECT cardinality FROM information_schema.statistics WHERE table_name = 't1';
cardinality
2
17
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
test.t1 analyze status OK
SELECT cardinality FROM information_schema.statistics WHERE table_name = 't1';
cardinality
2
17
DROP TABLE t1;
|