diff options
| author | unknown <magnus@neptunus.(none)> | 2004-05-25 12:25:22 +0200 |
|---|---|---|
| committer | unknown <magnus@neptunus.(none)> | 2004-05-25 12:25:22 +0200 |
| commit | 4cb7f4944d48d69e13138e196d3d5f55eb6a94df (patch) | |
| tree | 53c45c9394c46d7f605d226266e85ee4fd30776f /mysql-test/t/type_float.test | |
| parent | c94b1d606f15a2546f6cb05ea31797d306b09183 (diff) | |
| parent | f80e9e042ee33e1debdac1e46992470e495921c9 (diff) | |
| download | mariadb-git-4cb7f4944d48d69e13138e196d3d5f55eb6a94df.tar.gz | |
Merge msvensson@bk-internal.mysql.com:/home/bk/mysql-4.1
into neptunus.(none):/home/magnus/mysql-4.1
sql/handler.cc:
Auto merged
sql/sql_table.cc:
Auto merged
Diffstat (limited to 'mysql-test/t/type_float.test')
| -rw-r--r-- | mysql-test/t/type_float.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/type_float.test b/mysql-test/t/type_float.test index 7d3b90aabeb..d3ddecfc314 100644 --- a/mysql-test/t/type_float.test +++ b/mysql-test/t/type_float.test @@ -31,6 +31,14 @@ select a from t1 order by a; select min(a) from t1; drop table t1; +create table t1 (c1 double, c2 varchar(20)); +insert t1 values (121,"16"); +select c1 + c1 * (c2 / 100) as col from t1; +create table t2 select c1 + c1 * (c2 / 100) as col from t1; +select * from t2; +show create table t2; +drop table t1,t2; + # Bug #1022: When a table contains a 'float' field, # and one of the functions MAX, MIN, or AVG is used on that field, # the system crashes. |