diff options
author | vva@eagle.mysql.r18.ru <> | 2004-03-06 03:00:21 +0400 |
---|---|---|
committer | vva@eagle.mysql.r18.ru <> | 2004-03-06 03:00:21 +0400 |
commit | a8bbcc52a94e24740d50b2283bc645a6e2cf5180 (patch) | |
tree | 6f0b14624710df2135208a6cedc7fc3e19db1752 /mysql-test/t/insert.test | |
parent | b09799529384f67b3daf53d2252838eb6b6c88a1 (diff) | |
download | mariadb-git-a8bbcc52a94e24740d50b2283bc645a6e2cf5180.tar.gz |
- added commands --query_vertical and --query_horisontal to client/mysqltest.cc
- get my_strtod to return inf
- get Field_float::store(double) and Field_double::store(float) to set null for
nan value
(as extra serg's recomendations to fix for patch on
Bug #2082 'mysqldump converts "inf" to null')
Diffstat (limited to 'mysql-test/t/insert.test')
-rw-r--r-- | mysql-test/t/insert.test | 47 |
1 files changed, 13 insertions, 34 deletions
diff --git a/mysql-test/t/insert.test b/mysql-test/t/insert.test index b2fafe10192..b3d996c1475 100644 --- a/mysql-test/t/insert.test +++ b/mysql-test/t/insert.test @@ -90,7 +90,8 @@ drop database mysqltest; # # Test of wrong values for float data (bug #2082) -# +# + use test; create table t1( `number ` int auto_increment primary key, @@ -107,68 +108,46 @@ create table t1( set @value= "aa"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -vertical_results; -select * from t1 where `number `=last_insert_id(); -horisontal_results; +--query_vertical select * from t1 where `number `=last_insert_id() set @value= "1aa"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -vertical_results; -select * from t1 where `number `=last_insert_id(); -horisontal_results; +--query_vertical select * from t1 where `number `=last_insert_id() set @value= "aa1"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -vertical_results; -select * from t1 where `number `=last_insert_id(); -horisontal_results; +--query_vertical select * from t1 where `number `=last_insert_id() set @value= "1e+1111111111a"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -vertical_results; -select * from t1 where `number `=last_insert_id(); -horisontal_results; +--query_vertical select * from t1 where `number `=last_insert_id() set @value= "-1e+1111111111a"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -vertical_results; -select * from t1 where `number `=last_insert_id(); -horisontal_results; +--query_vertical select * from t1 where `number `=last_insert_id() set @value= 1e+1111111111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -vertical_results; -select * from t1 where `number `=last_insert_id(); -horisontal_results; +--query_vertical select * from t1 where `number `=last_insert_id() set @value= -1e+1111111111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -vertical_results; -select * from t1 where `number `=last_insert_id(); -horisontal_results; +--query_vertical select * from t1 where `number `=last_insert_id() set @value= 1e+111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -vertical_results; -select * from t1 where `number `=last_insert_id(); -horisontal_results; +--query_vertical select * from t1 where `number `=last_insert_id() set @value= -1e+111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -vertical_results; -select * from t1 where `number `=last_insert_id(); -horisontal_results; +--query_vertical select * from t1 where `number `=last_insert_id() set @value= 1; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -vertical_results; -select * from t1 where `number `=last_insert_id(); -horisontal_results; +--query_vertical select * from t1 where `number `=last_insert_id() set @value= -1; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -vertical_results; -select * from t1 where `number `=last_insert_id(); -horisontal_results; +--query_vertical select * from t1 where `number `=last_insert_id() drop table t1; |