diff options
author | Georgi Kodinov <joro@sun.com> | 2009-06-16 12:59:57 +0300 |
---|---|---|
committer | Georgi Kodinov <joro@sun.com> | 2009-06-16 12:59:57 +0300 |
commit | 48d911e70834af190a0650e77584f644525af538 (patch) | |
tree | e0e1cef0bec1328e5521be2acecbc38cd8f4e908 /mysql-test/t/group_min_max.test | |
parent | 86c034621204d01852256a6985c06082e7f1ebec (diff) | |
download | mariadb-git-48d911e70834af190a0650e77584f644525af538.tar.gz |
Addendum to the fix for bug #44821: move partition dependent test
to a test file that guarantees the presence of partition code
Diffstat (limited to 'mysql-test/t/group_min_max.test')
-rw-r--r-- | mysql-test/t/group_min_max.test | 40 |
1 files changed, 0 insertions, 40 deletions
diff --git a/mysql-test/t/group_min_max.test b/mysql-test/t/group_min_max.test index 42a37294f1b..981be3efece 100644 --- a/mysql-test/t/group_min_max.test +++ b/mysql-test/t/group_min_max.test @@ -1018,43 +1018,3 @@ DROP TABLE t; --echo End of 5.0 tests -# -# Bug#44821: select distinct on partitioned table returns wrong results -# -CREATE TABLE t1 ( a INT, b INT, c INT, KEY bc(b, c) ) -PARTITION BY KEY (a, b) PARTITIONS 3 -; - -INSERT INTO t1 VALUES -(17, 1, -8), -(3, 1, -7), -(23, 1, -6), -(22, 1, -5), -(11, 1, -4), -(21, 1, -3), -(19, 1, -2), -(30, 1, -1), - -(20, 1, 1), -(16, 1, 2), -(18, 1, 3), -(9, 1, 4), -(15, 1, 5), -(28, 1, 6), -(29, 1, 7), -(25, 1, 8), -(10, 1, 9), -(13, 1, 10), -(27, 1, 11), -(24, 1, 12), -(12, 1, 13), -(26, 1, 14), -(14, 1, 15) -; - -SELECT b, c FROM t1 WHERE b = 1 GROUP BY b, c; - -EXPLAIN -SELECT b, c FROM t1 WHERE b = 1 GROUP BY b, c; - -DROP TABLE t1; |