diff options
| author | hf@deer.(none) <> | 2005-02-21 19:20:05 +0400 |
|---|---|---|
| committer | hf@deer.(none) <> | 2005-02-21 19:20:05 +0400 |
| commit | 803ed1a11615fe9a74afc45f8f45b426b59fbb40 (patch) | |
| tree | 84d3fc85af1db9c809044e40b5ef8eb312c32f5d /mysql-test/r/analyse.result | |
| parent | 1666f99b1427728c1b0484906102d5c941bcc5d3 (diff) | |
| download | mariadb-git-803ed1a11615fe9a74afc45f8f45b426b59fbb40.tar.gz | |
Tests modified to coved decimal-related code
Diffstat (limited to 'mysql-test/r/analyse.result')
| -rw-r--r-- | mysql-test/r/analyse.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/analyse.result b/mysql-test/r/analyse.result index 83f70a69622..a56902e8ae7 100644 --- a/mysql-test/r/analyse.result +++ b/mysql-test/r/analyse.result @@ -102,3 +102,10 @@ select * from t1 procedure analyse(); Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype test.t1.v " \\ 1 19 0 0 3.7619 NULL ENUM('"','""','"c','\'\0\\"','\'','\'\'','\'b','a\0\0\0b','a\0','a""""b','a\'\'\'\'b','abc','abc\'def\\hij"klm\0opq','a\\\\\\\\b','b\'','c"','d\\','The\ZEnd','\\','\\d','\\\\') NOT NULL drop table t1; +create table t1 (df decimal(5,1)); +insert into t1 values(1.1); +insert into t1 values(2.2); +select * from t1 procedure analyse(); +Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype +test.t1.df 1.1 2.2 8 8 0 0 1.650000000 0.302500000 ENUM('1.1','2.2') NOT NULL +drop table t1; |