/usr/lib/mysql-testsuite/t/percona_bug1192354.test 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 | ##############################################################################
# Bug 1192354: accessing information_schema.partitions causes plans to change
# MySQL bug: http://bugs.mysql.com/bug.php?id=69179
#
# This test creates partitioned table and quries it's statistics
# before and after querying information_schema.partitions
##############################################################################
--source include/have_innodb.inc
--source include/have_partition.inc
DROP TABLE IF EXISTS 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;
SELECT cardinality FROM information_schema.statistics WHERE table_name = 't1';
SELECT partition_name, table_rows FROM information_schema.partitions WHERE table_name = 't1';
SELECT cardinality FROM information_schema.statistics WHERE table_name = 't1';
ANALYZE TABLE t1;
SELECT cardinality FROM information_schema.statistics WHERE table_name = 't1';
DROP TABLE t1;
|