555
555
--echo End of 5.0 tests
558
# Bug #34928: Confusion by having Primary Key and Index
560
CREATE TABLE t1(a INT, b INT, c INT, d INT, e INT,
561
PRIMARY KEY(a,b,c,d,e),
565
INSERT INTO t1(a, b, c) VALUES (1, 1, 1),
572
EXPLAIN SELECT DISTINCT a, b, d, c FROM t1;
574
SELECT DISTINCT a, b, d, c FROM t1;
578
--echo End of 5.1 tests