diff options
| author | unknown <serg@serg.mylan> | 2004-05-11 12:20:04 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-05-11 12:20:04 +0200 |
| commit | 699cbc02cc3eac51524a56fc106d013633f336f6 (patch) | |
| tree | f3d3a9763d4a4fb400d44095fac3daf7e4824698 /mysql-test/t | |
| parent | 5b00724963bfd1b8c7072df3130819a8afbf2f85 (diff) | |
| parent | 76bc67711723bfa0eeda33798c706d9e333bbb30 (diff) | |
| download | mariadb-git-699cbc02cc3eac51524a56fc106d013633f336f6.tar.gz | |
Merge bk-internal:/home/bk/mysql-4.0/
into serg.mylan:/usr/home/serg/Abk/mysql-4.0
Diffstat (limited to 'mysql-test/t')
| -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 23941ad2913..65d594387b9 100644 --- a/mysql-test/t/type_float.test +++ b/mysql-test/t/type_float.test @@ -28,6 +28,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; + # # FLOAT/DOUBLE/DECIMAL handling # |