summaryrefslogtreecommitdiff
path: root/mysql-test/t/insert.test
diff options
context:
space:
mode:
authorunknown <msvensson@neptunus.(none)>2006-02-01 11:36:32 +0100
committerunknown <msvensson@neptunus.(none)>2006-02-01 11:36:32 +0100
commitdb16cfc578e389cd63770aab9fe7bc1f520b2413 (patch)
treeec3c2deeb5bebb1761befdb1cdaaaff0271ee9a2 /mysql-test/t/insert.test
parentdb5fe0fc9772d9ab74d12d735cb67ca2fcb8721d (diff)
downloadmariadb-git-db16cfc578e389cd63770aab9fe7bc1f520b2413.tar.gz
Use common function 'append_field' to output the value of one field to the result.
Fix for extra zero in exponent of double values on windows. client/mysqltest.c: Write new function 'append_field' which takes care of appending one field to the dynamic string. Use function 'append_field' from both ps and normal execution Add hack to 'append_field' that removes the extra '0' in exponent for double values on Windows. mysql-test/r/type_float.result: One zero too much was removed( I think ) mysql-test/t/insert.test: Remove the "replace_result" for extra zero in exponent mysql-test/t/type_float.test: Remove the "replace_result" for extra zero in exponent mysql-test/t/variables.test: Remove the "replace_result" for extra zero in exponent
Diffstat (limited to 'mysql-test/t/insert.test')
-rw-r--r--mysql-test/t/insert.test9
1 files changed, 0 insertions, 9 deletions
diff --git a/mysql-test/t/insert.test b/mysql-test/t/insert.test
index 51d936f5b4f..ddde6cfa5d3 100644
--- a/mysql-test/t/insert.test
+++ b/mysql-test/t/insert.test
@@ -99,27 +99,22 @@ create table t1(number int auto_increment primary key, original_value varchar(50
set @value= "aa";
insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value);
---replace_result e-0 e- e+0 e+
--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);
---replace_result e-0 e- e+0 e+
--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);
---replace_result e-0 e- e+0 e+
--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);
---replace_result e-0 e- e+0 e+
--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);
---replace_result e-0 e- e+0 e+
--query_vertical select * from t1 where number =last_insert_id()
--error 1367
@@ -130,22 +125,18 @@ set @value= -1e+1111111111;
set @value= 1e+111;
insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value);
---replace_result e-0 e- e+0 e+
--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);
---replace_result e-0 e- e+0 e+
--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);
---replace_result e-0 e- e+0 e+
--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);
---replace_result e-0 e- e+0 e+
--query_vertical select * from t1 where number =last_insert_id()
drop table t1;