diff options
| author | Gleb Shchepa <gleb.shchepa@oracle.com> | 2010-11-01 02:23:37 +0300 |
|---|---|---|
| committer | Gleb Shchepa <gleb.shchepa@oracle.com> | 2010-11-01 02:23:37 +0300 |
| commit | 89f9f6a40d3a820e6bbacb625aa375575e42aa85 (patch) | |
| tree | 59330b5cd7baa91abdfaefe4ea1c5482ff6dedc7 /mysql-test/t/func_time.test | |
| parent | d520df90fc68f2e9e41c74ea2c26f0028dbf79dc (diff) | |
| parent | 0389c6aac0bf32718e2166c97ef6dafb25e20e20 (diff) | |
| download | mariadb-git-89f9f6a40d3a820e6bbacb625aa375575e42aa85.tar.gz | |
manual merge 5.1-bugteam --> 5.5-bugteam (bug 52160)
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index 08c09adb093..0a2b473ca59 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -832,6 +832,16 @@ INSERT INTO t1 VALUES (0),(9.216e-096); SELECT 1 FROM t1 ORDER BY @x:=makedate(a,a); DROP TABLE t1; +--echo # +--echo # Bug #52160: crash and inconsistent results when grouping +--echo # by a function and column +--echo # + +CREATE TABLE t1(a CHAR(10) NOT NULL); +INSERT INTO t1 VALUES (''),(''); +SELECT COUNT(*) FROM t1 GROUP BY TIME_TO_SEC(a); +DROP TABLE t1; + --echo End of 5.1 tests --echo # |