summaryrefslogtreecommitdiff
path: root/mysql-test/t/insert.test
diff options
context:
space:
mode:
authormonty@mysql.com <>2004-03-18 00:09:13 +0200
committermonty@mysql.com <>2004-03-18 00:09:13 +0200
commitf34a642d6e492fa527e09593aa695e67d3867263 (patch)
tree93869dd2e083920baaab586bbd65e0b77b42fcfa /mysql-test/t/insert.test
parentf9ad65049088dc58591c954903a22e527e96ea5a (diff)
downloadmariadb-git-f34a642d6e492fa527e09593aa695e67d3867263.tar.gz
after merge fixes
Diffstat (limited to 'mysql-test/t/insert.test')
-rw-r--r--mysql-test/t/insert.test35
1 files changed, 12 insertions, 23 deletions
diff --git a/mysql-test/t/insert.test b/mysql-test/t/insert.test
index b3d996c1475..fd728c453aa 100644
--- a/mysql-test/t/insert.test
+++ b/mysql-test/t/insert.test
@@ -93,61 +93,50 @@ drop database mysqltest;
#
use test;
-create table t1(
- `number ` int auto_increment primary key,
- `original_value ` varchar(50),
- `f_double ` double,
- `f_float ` float,
- `f_double_7_2 ` double(7,2),
- `f_float_4_3 ` float (4,3),
- `f_double_u ` double unsigned,
- `f_float_u ` float unsigned,
- `f_double_15_1_u ` double(15,1) unsigned,
- `f_float_3_1_u ` float (3,1) unsigned
-);
+create table t1(number int auto_increment primary key, original_value varchar(50), f_double double, f_float float, f_double_7_2 double(7,2), f_float_4_3 float (4,3), f_double_u double unsigned, f_float_u float unsigned, f_double_15_1_u double(15,1) unsigned, f_float_3_1_u float (3,1) unsigned);
set @value= "aa";
insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value);
---query_vertical select * from t1 where `number `=last_insert_id()
+--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);
---query_vertical select * from t1 where `number `=last_insert_id()
+--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);
---query_vertical select * from t1 where `number `=last_insert_id()
+--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);
---query_vertical select * from t1 where `number `=last_insert_id()
+--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);
---query_vertical select * from t1 where `number `=last_insert_id()
+--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);
---query_vertical select * from t1 where `number `=last_insert_id()
+--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);
---query_vertical select * from t1 where `number `=last_insert_id()
+--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);
---query_vertical select * from t1 where `number `=last_insert_id()
+--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);
---query_vertical select * from t1 where `number `=last_insert_id()
+--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);
---query_vertical select * from t1 where `number `=last_insert_id()
+--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);
---query_vertical select * from t1 where `number `=last_insert_id()
+--query_vertical select * from t1 where number =last_insert_id()
drop table t1;