diff options
author | Sergei Golubchik <sergii@pisem.net> | 2014-01-26 21:49:11 +0100 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2014-01-26 21:49:11 +0100 |
commit | 3f2f9c36b16ad88d34a400f92cbb61e77a6ae63c (patch) | |
tree | 243c2d895f9f8ce92c9989cdd60d39014c688596 /mysql-test/t/group_by.test | |
parent | 0df3c2033bdf96272c426295e1f711e1299a62ac (diff) | |
download | mariadb-git-3f2f9c36b16ad88d34a400f92cbb61e77a6ae63c.tar.gz |
move innodb specific test from group_by.test to group_by_innodb.test
Diffstat (limited to 'mysql-test/t/group_by.test')
-rw-r--r-- | mysql-test/t/group_by.test | 25 |
1 files changed, 0 insertions, 25 deletions
diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index e4120f284de..c6d594edc1f 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -1,5 +1,3 @@ ---source include/have_innodb.inc - # Initialise --disable_warnings drop table if exists t1,t2,t3; @@ -1645,26 +1643,3 @@ FROM t1 JOIN t2 ON c = b GROUP BY b WITH ROLLUP; DROP TABLE t1,t2; ---echo # ---echo # Test of MDEV-4002 ---echo # - -CREATE TABLE t1 ( - pk INT NOT NULL PRIMARY KEY, - d1 DOUBLE, - d2 DOUBLE, - i INT NOT NULL DEFAULT '0', - KEY (i) -) ENGINE=InnoDB; - -INSERT INTO t1 VALUES (1,1.0,1.1,1),(2,2.0,2.2,2); - -PREPARE stmt FROM " -SELECT DISTINCT i, GROUP_CONCAT( d1, d2 ORDER BY d1, d2 ) -FROM t1 a1 NATURAL JOIN t1 a2 GROUP BY i WITH ROLLUP -"; - -EXECUTE stmt; -EXECUTE stmt; - -DROP TABLE t1; |