summaryrefslogtreecommitdiff
path: root/mysql-test/main/stat_tables_partition.test
blob: 1316e5cca11c8e021630d7812c02011ca8c2e729 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
--source include/have_partition.inc

--echo #
--echo # Bug mdev-3866: valgrind complain from ANALYZE on a table with BIT field
--echo # 

SET use_stat_tables = 'preferably';

CREATE TABLE t1 (pk int PRIMARY KEY, a bit(1), INDEX idx(a)
) ENGINE=MyISAM PARTITION BY KEY(pk) PARTITIONS 2;
INSERT INTO t1 VALUES (1,1),(2,0),(3,0),(4,1);

ANALYZE TABLE t1;

SET use_stat_tables = DEFAULT;

DROP TABLE t1;