diff options
| author | sergefp@mysql.com <> | 2005-08-07 22:10:05 +0000 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-08-07 22:10:05 +0000 |
| commit | e554e61734f11b794c648c4f7f0f50b6dc1272eb (patch) | |
| tree | 91545d35ac475ea136b7810330730df6338ebdbd /mysql-test/t/group_by.test | |
| parent | 65566e449d6efb074c5a772f74f72eca108188e6 (diff) | |
| download | mariadb-git-e554e61734f11b794c648c4f7f0f50b6dc1272eb.tar.gz | |
Post-merge fixes
Diffstat (limited to 'mysql-test/t/group_by.test')
| -rw-r--r-- | mysql-test/t/group_by.test | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index 434c2662614..8300b502518 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -575,6 +575,11 @@ CREATE TABLE t1 (id varchar(20) NOT NULL); INSERT INTO t1 VALUES ('trans1'), ('trans2'); CREATE TABLE t2 (id varchar(20) NOT NULL, err_comment blob NOT NULL); INSERT INTO t2 VALUES ('trans1', 'a problem'); +SELECT COUNT(DISTINCT(t1.id)), LEFT(err_comment, 256) AS comment + FROM t1 LEFT JOIN t2 ON t1.id=t2.id GROUP BY comment; + +DROP TABLE t1, t2; + # # Bug #12266 GROUP BY expression on DATE column produces result with @@ -586,11 +591,6 @@ insert into t1 values('2005-06-06'); select date(left(f1+0,8)) from t1 group by 1; drop table t1; -SELECT COUNT(DISTINCT(t1.id)), LEFT(err_comment, 256) AS comment - FROM t1 LEFT JOIN t2 ON t1.id=t2.id GROUP BY comment; - -DROP TABLE t1, t2; - # # Test for bug #11414: crash on Windows for a simple GROUP BY query # |