119
119
--echo End of 5.1 tests
122
--echo # Bug#12540545 61101: ASSERTION FAILURE IN THREAD 1256741184 IN
123
--echo # FILE /BUILDDIR/BUILD/BUILD/MYSQ
126
CREATE TABLE t1 (a CHAR(1), b CHAR(1), PRIMARY KEY (a,b)) ENGINE=InnoDB;
127
INSERT INTO t1 VALUES ('a', 'b'), ('c', 'd');
128
EXPLAIN SELECT COUNT(DISTINCT a) FROM t1 WHERE b = 'b';
129
SELECT COUNT(DISTINCT a) FROM t1 WHERE b = 'b';
132
CREATE TABLE t1 (a CHAR(1) NOT NULL, b CHAR(1) NOT NULL, UNIQUE KEY (a,b))
134
INSERT INTO t1 VALUES ('a', 'b'), ('c', 'd');
135
EXPLAIN SELECT COUNT(DISTINCT a) FROM t1 WHERE b = 'b';
136
SELECT COUNT(DISTINCT a) FROM t1 WHERE b = 'b';
139
--echo End of 5.5 tests