diff options
author | unknown <Sinisa@sinisa.nasamreza.org> | 2004-12-10 00:17:43 +0200 |
---|---|---|
committer | unknown <Sinisa@sinisa.nasamreza.org> | 2004-12-10 00:17:43 +0200 |
commit | 41a61e84d724e48f6d1e026e7f79469b55ac230c (patch) | |
tree | b27451f2c18a2828b5fcfbb778dd531035f336d9 /mysql-test/t/func_str.test | |
parent | ac96a2bbcb26cdb20f9ae14d0053773c1fa4a27e (diff) | |
download | mariadb-git-41a61e84d724e48f6d1e026e7f79469b55ac230c.tar.gz |
A fix for a crashing bug #7101, which occures when the
expression involving LEFT() function is used in GROUP BY
field.
mysql-test/r/func_str.result:
A result for bug #7101 test case
mysql-test/t/func_str.test:
Test case for bug #7101
Diffstat (limited to 'mysql-test/t/func_str.test')
-rw-r--r-- | mysql-test/t/func_str.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index d5a3e80c417..2934a9733a7 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -421,3 +421,11 @@ drop table t1; # select left(1234, 3) + 0; + +# +# Bug #7101: bug with LEFT() when used as a field in GROUP BY aggregation +# +create table t1 (a int not null primary key, b varchar(40), c datetime); +insert into t1 (a,b,c) values (1,'Tom',now()),(2,'ball games',now()), (3,'Basil',now()), (4,'Dean',now()),(5,'Ellis',now()), (6,'Serg',now()), (7,'Sergei',now()),(8,'Georg',now()),(9,'Salle',now()),(10,'Sinisa',now()); +select count(*) as total, left(c,10) as reg from t1 group by reg order by reg desc limit 0,12; +drop table t1; |