diff options
| author | sergefp@mysql.com <> | 2005-08-07 21:32:26 +0000 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-08-07 21:32:26 +0000 |
| commit | 65566e449d6efb074c5a772f74f72eca108188e6 (patch) | |
| tree | 19c52ad26d2fdf1af81b89c06a0300c8fc241e1c /mysql-test/t/group_by.test | |
| parent | b76cea46e936376a33bdb5c8c001bac649585e29 (diff) | |
| parent | 0dba629a5ee2a4700d432e12622bcada42a4de8a (diff) | |
| download | mariadb-git-65566e449d6efb074c5a772f74f72eca108188e6.tar.gz | |
Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-5.0
into mysql.com:/home/psergey/mysql-5.0-bug11869-part3
Diffstat (limited to 'mysql-test/t/group_by.test')
| -rw-r--r-- | mysql-test/t/group_by.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index bfbdd098426..434c2662614 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -576,6 +576,16 @@ 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'); +# +# Bug #12266 GROUP BY expression on DATE column produces result with +# reduced length +# +create table t1 (f1 date); +insert into t1 values('2005-06-06'); +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; |