diff options
| author | iggy@rolltop.ignatz42.dyndns.org <> | 2006-09-28 14:30:20 -0400 |
|---|---|---|
| committer | iggy@rolltop.ignatz42.dyndns.org <> | 2006-09-28 14:30:20 -0400 |
| commit | f063bee3b264cd6e1f61f190196f1a01780fe410 (patch) | |
| tree | 00d8223a8610a3b2bcfad70184770c407e986575 /mysql-test/t/analyse.test | |
| parent | 397f0df9ad2df62698d4c1824c965c4b884b990c (diff) | |
| download | mariadb-git-f063bee3b264cd6e1f61f190196f1a01780fe410.tar.gz | |
Bug#20305: PROCEDURE ANALYSE() returns wrong M for FLOAT(M, D) and DOUBLE(M, D)
Diffstat (limited to 'mysql-test/t/analyse.test')
| -rw-r--r-- | mysql-test/t/analyse.test | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/mysql-test/t/analyse.test b/mysql-test/t/analyse.test index dfca8f575a4..88fe8dc55e7 100644 --- a/mysql-test/t/analyse.test +++ b/mysql-test/t/analyse.test @@ -82,4 +82,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 |