diff options
| author | unknown <evgen@moonbone.local> | 2005-08-05 01:03:21 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-08-05 01:03:21 +0400 |
| commit | 75c06af27784e6fa6ba23f4cd6803bc7574f8253 (patch) | |
| tree | 7abd6c7793d4154ac791d3aa3df15b104f52ee7a /mysql-test | |
| parent | 1beb95e3e43c7ae56a75e9206fa2b904480d0604 (diff) | |
| parent | b2dc376afe3a3f37ab11bfa292c1bf041fd89db1 (diff) | |
| download | mariadb-git-75c06af27784e6fa6ba23f4cd6803bc7574f8253.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-4.1
into moonbone.local:/work/mysql-4.1-bug-12266
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/group_by.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/group_by.test | 10 |
2 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 295663fe1d3..8287a042d60 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -757,3 +757,10 @@ SELECT n+1 AS n FROM t1 GROUP BY n; n 2 DROP TABLE t1; +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; +date(left(f1+0,8)) +2005-06-06 +drop table t1; diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index c07d309005e..815da66c717 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -590,4 +590,14 @@ INSERT INTO t1 VALUES (1); SELECT n+1 AS n FROM t1 GROUP BY n; DROP TABLE t1; +# +# 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; + # End of 4.1 tests |