diff options
| author | unknown <iggy@rolltop.ignatz42.dyndns.org> | 2006-09-28 14:32:30 -0400 |
|---|---|---|
| committer | unknown <iggy@rolltop.ignatz42.dyndns.org> | 2006-09-28 14:32:30 -0400 |
| commit | e99cf7edb9649fe847e8f1b7ac694febda844968 (patch) | |
| tree | adefb048b1160cf1a8a8e448cb8291f9ab9d8330 /mysql-test/t/analyse.test | |
| parent | 131d94f58c07629ec37c0af32c6657dea8bc5e4e (diff) | |
| parent | 314e10592ceac7def3ea4863d5a1f8b23464bf30 (diff) | |
| download | mariadb-git-e99cf7edb9649fe847e8f1b7ac694febda844968.tar.gz | |
Merge rolltop.ignatz42.dyndns.org:/mnt/storeage/bug20305/my41-bug20305
into rolltop.ignatz42.dyndns.org:/mnt/storeage/bug20305/my50-bug20305
mysql-test/r/analyse.result:
Auto merged
sql/sql_analyse.cc:
Auto merged
mysql-test/t/analyse.test:
manual merge
Diffstat (limited to 'mysql-test/t/analyse.test')
| -rw-r--r-- | mysql-test/t/analyse.test | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/mysql-test/t/analyse.test b/mysql-test/t/analyse.test index a248c671c18..efcf5f6421c 100644 --- a/mysql-test/t/analyse.test +++ b/mysql-test/t/analyse.test @@ -90,5 +90,16 @@ create table t2 (country_id int primary key, country char(20) not null); insert into t2 values (1, 'USA'),(2,'India'), (3,'Finland'); select product, sum(profit),avg(profit) from t1 group by product with rollup procedure analyse(); drop table t1,t2; -# End of 4.1 tests +# +# Bug #20305 PROCEDURE ANALYSE() returns wrong M for FLOAT(M, D) and DOUBLE(M, D) +# + +create table t1 (f1 double(10,5), f2 char(10), f3 double(10,5)); +insert into t1 values (5.999, "5.9999", 5.99999), (9.555, "9.5555", 9.55555); +select f1 from t1 procedure analyse(1, 1); +select f2 from t1 procedure analyse(1, 1); +select f3 from t1 procedure analyse(1, 1); +drop table t1; + +--echo End of 4.1 tests |