diff options
Diffstat (limited to 'mysql-test/r/insert.result')
| -rw-r--r-- | mysql-test/r/insert.result | 421 |
1 files changed, 205 insertions, 216 deletions
diff --git a/mysql-test/r/insert.result b/mysql-test/r/insert.result index 9c066d67af1..782a71e83d1 100644 --- a/mysql-test/r/insert.result +++ b/mysql-test/r/insert.result @@ -87,252 +87,241 @@ create table t1 (c int); insert into mysqltest.t1 set mysqltest.t1.c = '1'; 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); Warnings: -Warning 1265 Data truncated for column 'f_double ' at row 1 -Warning 1265 Data truncated for column 'f_float ' at row 1 -Warning 1265 Data truncated for column 'f_double_7_2 ' at row 1 -Warning 1265 Data truncated for column 'f_float_4_3 ' at row 1 -Warning 1265 Data truncated for column 'f_double_u ' at row 1 -Warning 1265 Data truncated for column 'f_float_u ' at row 1 -Warning 1265 Data truncated for column 'f_double_15_1_u ' at row 1 -Warning 1265 Data truncated for column 'f_float_3_1_u ' at row 1 -select * from t1 where `number `=last_insert_id(); -number 1 -original_value aa -f_double 0 -f_float 0 -f_double_7_2 0.00 -f_float_4_3 0.000 -f_double_u 0 -f_float_u 0 -f_double_15_1_u 0.0 -f_float_3_1_u 0.0 +Warning 1265 Data truncated for column 'f_double' at row 1 +Warning 1265 Data truncated for column 'f_float' at row 1 +Warning 1265 Data truncated for column 'f_double_7_2' at row 1 +Warning 1265 Data truncated for column 'f_float_4_3' at row 1 +Warning 1265 Data truncated for column 'f_double_u' at row 1 +Warning 1265 Data truncated for column 'f_float_u' at row 1 +Warning 1265 Data truncated for column 'f_double_15_1_u' at row 1 +Warning 1265 Data truncated for column 'f_float_3_1_u' at row 1 +select * from t1 where number =last_insert_id(); +number 1 +original_value aa +f_double 0 +f_float 0 +f_double_7_2 0.00 +f_float_4_3 0.000 +f_double_u 0 +f_float_u 0 +f_double_15_1_u 0.0 +f_float_3_1_u 0.0 set @value= "1aa"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); Warnings: -Warning 1265 Data truncated for column 'f_double ' at row 1 -Warning 1265 Data truncated for column 'f_float ' at row 1 -Warning 1265 Data truncated for column 'f_double_7_2 ' at row 1 -Warning 1265 Data truncated for column 'f_float_4_3 ' at row 1 -Warning 1265 Data truncated for column 'f_double_u ' at row 1 -Warning 1265 Data truncated for column 'f_float_u ' at row 1 -Warning 1265 Data truncated for column 'f_double_15_1_u ' at row 1 -Warning 1265 Data truncated for column 'f_float_3_1_u ' at row 1 -select * from t1 where `number `=last_insert_id(); -number 2 -original_value 1aa -f_double 1 -f_float 1 -f_double_7_2 1.00 -f_float_4_3 1.000 -f_double_u 1 -f_float_u 1 -f_double_15_1_u 1.0 -f_float_3_1_u 1.0 +Warning 1265 Data truncated for column 'f_double' at row 1 +Warning 1265 Data truncated for column 'f_float' at row 1 +Warning 1265 Data truncated for column 'f_double_7_2' at row 1 +Warning 1265 Data truncated for column 'f_float_4_3' at row 1 +Warning 1265 Data truncated for column 'f_double_u' at row 1 +Warning 1265 Data truncated for column 'f_float_u' at row 1 +Warning 1265 Data truncated for column 'f_double_15_1_u' at row 1 +Warning 1265 Data truncated for column 'f_float_3_1_u' at row 1 +select * from t1 where number =last_insert_id(); +number 2 +original_value 1aa +f_double 1 +f_float 1 +f_double_7_2 1.00 +f_float_4_3 1.000 +f_double_u 1 +f_float_u 1 +f_double_15_1_u 1.0 +f_float_3_1_u 1.0 set @value= "aa1"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); Warnings: -Warning 1265 Data truncated for column 'f_double ' at row 1 -Warning 1265 Data truncated for column 'f_float ' at row 1 -Warning 1265 Data truncated for column 'f_double_7_2 ' at row 1 -Warning 1265 Data truncated for column 'f_float_4_3 ' at row 1 -Warning 1265 Data truncated for column 'f_double_u ' at row 1 -Warning 1265 Data truncated for column 'f_float_u ' at row 1 -Warning 1265 Data truncated for column 'f_double_15_1_u ' at row 1 -Warning 1265 Data truncated for column 'f_float_3_1_u ' at row 1 -select * from t1 where `number `=last_insert_id(); -number 3 -original_value aa1 -f_double 0 -f_float 0 -f_double_7_2 0.00 -f_float_4_3 0.000 -f_double_u 0 -f_float_u 0 -f_double_15_1_u 0.0 -f_float_3_1_u 0.0 +Warning 1265 Data truncated for column 'f_double' at row 1 +Warning 1265 Data truncated for column 'f_float' at row 1 +Warning 1265 Data truncated for column 'f_double_7_2' at row 1 +Warning 1265 Data truncated for column 'f_float_4_3' at row 1 +Warning 1265 Data truncated for column 'f_double_u' at row 1 +Warning 1265 Data truncated for column 'f_float_u' at row 1 +Warning 1265 Data truncated for column 'f_double_15_1_u' at row 1 +Warning 1265 Data truncated for column 'f_float_3_1_u' at row 1 +select * from t1 where number =last_insert_id(); +number 3 +original_value aa1 +f_double 0 +f_float 0 +f_double_7_2 0.00 +f_float_4_3 0.000 +f_double_u 0 +f_float_u 0 +f_double_15_1_u 0.0 +f_float_3_1_u 0.0 set @value= "1e+1111111111a"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); Warnings: -Warning 1265 Data truncated for column 'f_double ' at row 1 -Warning 1265 Data truncated for column 'f_float ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float ' at row 1 -Warning 1265 Data truncated for column 'f_double_7_2 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_7_2 ' at row 1 -Warning 1265 Data truncated for column 'f_float_4_3 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_4_3 ' at row 1 -Warning 1265 Data truncated for column 'f_double_u ' at row 1 -Warning 1265 Data truncated for column 'f_float_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_u ' at row 1 -Warning 1265 Data truncated for column 'f_double_15_1_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_15_1_u ' at row 1 -Warning 1265 Data truncated for column 'f_float_3_1_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_3_1_u ' at row 1 -select * from t1 where `number `=last_insert_id(); -number 4 -original_value 1e+1111111111a -f_double 1.79769313486232e+308 -f_float 3.40282e+38 -f_double_7_2 99999.99 -f_float_4_3 9.999 -f_double_u 1.79769313486232e+308 -f_float_u 3.40282e+38 -f_double_15_1_u 99999999999999.9 -f_float_3_1_u 99.9 +Warning 1265 Data truncated for column 'f_double' at row 1 +Warning 1265 Data truncated for column 'f_float' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float' at row 1 +Warning 1265 Data truncated for column 'f_double_7_2' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_7_2' at row 1 +Warning 1265 Data truncated for column 'f_float_4_3' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_4_3' at row 1 +Warning 1265 Data truncated for column 'f_double_u' at row 1 +Warning 1265 Data truncated for column 'f_float_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_u' at row 1 +Warning 1265 Data truncated for column 'f_double_15_1_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_15_1_u' at row 1 +Warning 1265 Data truncated for column 'f_float_3_1_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_3_1_u' at row 1 +select * from t1 where number =last_insert_id(); +number 4 +original_value 1e+1111111111a +f_double 1.79769313486232e+308 +f_float 3.40282e+38 +f_double_7_2 99999.99 +f_float_4_3 9.999 +f_double_u 1.79769313486232e+308 +f_float_u 3.40282e+38 +f_double_15_1_u 99999999999999.9 +f_float_3_1_u 99.9 set @value= "-1e+1111111111a"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); Warnings: -Warning 1265 Data truncated for column 'f_double ' at row 1 -Warning 1265 Data truncated for column 'f_float ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float ' at row 1 -Warning 1265 Data truncated for column 'f_double_7_2 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_7_2 ' at row 1 -Warning 1265 Data truncated for column 'f_float_4_3 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_4_3 ' at row 1 -Warning 1265 Data truncated for column 'f_double_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_u ' at row 1 -Warning 1265 Data truncated for column 'f_float_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_u ' at row 1 -Warning 1265 Data truncated for column 'f_double_15_1_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_15_1_u ' at row 1 -Warning 1265 Data truncated for column 'f_float_3_1_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_3_1_u ' at row 1 -select * from t1 where `number `=last_insert_id(); -number 5 -original_value -1e+1111111111a -f_double -1.79769313486232e+308 -f_float -3.40282e+38 -f_double_7_2 -99999.99 -f_float_4_3 -9.999 -f_double_u 0 -f_float_u 0 -f_double_15_1_u 0.0 -f_float_3_1_u 0.0 +Warning 1265 Data truncated for column 'f_double' at row 1 +Warning 1265 Data truncated for column 'f_float' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float' at row 1 +Warning 1265 Data truncated for column 'f_double_7_2' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_7_2' at row 1 +Warning 1265 Data truncated for column 'f_float_4_3' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_4_3' at row 1 +Warning 1265 Data truncated for column 'f_double_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_u' at row 1 +Warning 1265 Data truncated for column 'f_float_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_u' at row 1 +Warning 1265 Data truncated for column 'f_double_15_1_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_15_1_u' at row 1 +Warning 1265 Data truncated for column 'f_float_3_1_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_3_1_u' at row 1 +select * from t1 where number =last_insert_id(); +number 5 +original_value -1e+1111111111a +f_double -1.79769313486232e+308 +f_float -3.40282e+38 +f_double_7_2 -99999.99 +f_float_4_3 -9.999 +f_double_u 0 +f_float_u 0 +f_double_15_1_u 0.0 +f_float_3_1_u 0.0 set @value= 1e+1111111111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); Warnings: -Warning 1264 Data truncated, out of range for column 'f_float ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_7_2 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_4_3 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_15_1_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_3_1_u ' at row 1 -select * from t1 where `number `=last_insert_id(); -number 6 -original_value 1.7976931348623e+308 -f_double 1.79769313486232e+308 -f_float 3.40282e+38 -f_double_7_2 99999.99 -f_float_4_3 9.999 -f_double_u 1.79769313486232e+308 -f_float_u 3.40282e+38 -f_double_15_1_u 99999999999999.9 -f_float_3_1_u 99.9 +Warning 1264 Data truncated, out of range for column 'f_float' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_7_2' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_4_3' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_15_1_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_3_1_u' at row 1 +select * from t1 where number =last_insert_id(); +number 6 +original_value 1.7976931348623e+308 +f_double 1.79769313486232e+308 +f_float 3.40282e+38 +f_double_7_2 99999.99 +f_float_4_3 9.999 +f_double_u 1.79769313486232e+308 +f_float_u 3.40282e+38 +f_double_15_1_u 99999999999999.9 +f_float_3_1_u 99.9 set @value= -1e+1111111111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); Warnings: -Warning 1264 Data truncated, out of range for column 'f_float ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_7_2 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_4_3 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_15_1_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_3_1_u ' at row 1 -select * from t1 where `number `=last_insert_id(); -number 7 -original_value -1.7976931348623e+308 -f_double -1.79769313486232e+308 -f_float -3.40282e+38 -f_double_7_2 -99999.99 -f_float_4_3 -9.999 -f_double_u 0 -f_float_u 0 -f_double_15_1_u 0.0 -f_float_3_1_u 0.0 +Warning 1264 Data truncated, out of range for column 'f_float' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_7_2' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_4_3' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_15_1_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_3_1_u' at row 1 +select * from t1 where number =last_insert_id(); +number 7 +original_value -1.7976931348623e+308 +f_double -1.79769313486232e+308 +f_float -3.40282e+38 +f_double_7_2 -99999.99 +f_float_4_3 -9.999 +f_double_u 0 +f_float_u 0 +f_double_15_1_u 0.0 +f_float_3_1_u 0.0 set @value= 1e+111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); Warnings: -Warning 1264 Data truncated, out of range for column 'f_float ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_7_2 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_4_3 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_15_1_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_3_1_u ' at row 1 -select * from t1 where `number `=last_insert_id(); -number 8 -original_value 1e+111 -f_double 1e+111 -f_float 3.40282e+38 -f_double_7_2 99999.99 -f_float_4_3 9.999 -f_double_u 1e+111 -f_float_u 3.40282e+38 -f_double_15_1_u 99999999999999.9 -f_float_3_1_u 99.9 +Warning 1264 Data truncated, out of range for column 'f_float' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_7_2' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_4_3' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_15_1_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_3_1_u' at row 1 +select * from t1 where number =last_insert_id(); +number 8 +original_value 1e+111 +f_double 1e+111 +f_float 3.40282e+38 +f_double_7_2 99999.99 +f_float_4_3 9.999 +f_double_u 1e+111 +f_float_u 3.40282e+38 +f_double_15_1_u 99999999999999.9 +f_float_3_1_u 99.9 set @value= -1e+111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); Warnings: -Warning 1264 Data truncated, out of range for column 'f_float ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_7_2 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_4_3 ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_15_1_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_3_1_u ' at row 1 -select * from t1 where `number `=last_insert_id(); -number 9 -original_value -1e+111 -f_double -1e+111 -f_float -3.40282e+38 -f_double_7_2 -99999.99 -f_float_4_3 -9.999 -f_double_u 0 -f_float_u 0 -f_double_15_1_u 0.0 -f_float_3_1_u 0.0 +Warning 1264 Data truncated, out of range for column 'f_float' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_7_2' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_4_3' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_15_1_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_3_1_u' at row 1 +select * from t1 where number =last_insert_id(); +number 9 +original_value -1e+111 +f_double -1e+111 +f_float -3.40282e+38 +f_double_7_2 -99999.99 +f_float_4_3 -9.999 +f_double_u 0 +f_float_u 0 +f_double_15_1_u 0.0 +f_float_3_1_u 0.0 set @value= 1; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); -select * from t1 where `number `=last_insert_id(); -number 10 -original_value 1 -f_double 1 -f_float 1 -f_double_7_2 1.00 -f_float_4_3 1.000 -f_double_u 1 -f_float_u 1 -f_double_15_1_u 1.0 -f_float_3_1_u 1.0 +select * from t1 where number =last_insert_id(); +number 10 +original_value 1 +f_double 1 +f_float 1 +f_double_7_2 1.00 +f_float_4_3 1.000 +f_double_u 1 +f_float_u 1 +f_double_15_1_u 1.0 +f_float_3_1_u 1.0 set @value= -1; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); Warnings: -Warning 1264 Data truncated, out of range for column 'f_double_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_double_15_1_u ' at row 1 -Warning 1264 Data truncated, out of range for column 'f_float_3_1_u ' at row 1 -select * from t1 where `number `=last_insert_id(); -number 11 -original_value -1 -f_double -1 -f_float -1 -f_double_7_2 -1.00 -f_float_4_3 -1.000 -f_double_u 0 -f_float_u 0 -f_double_15_1_u 0.0 -f_float_3_1_u 0.0 +Warning 1264 Data truncated, out of range for column 'f_double_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_double_15_1_u' at row 1 +Warning 1264 Data truncated, out of range for column 'f_float_3_1_u' at row 1 +select * from t1 where number =last_insert_id(); +number 11 +original_value -1 +f_double -1 +f_float -1 +f_double_7_2 -1.00 +f_float_4_3 -1.000 +f_double_u 0 +f_float_u 0 +f_double_15_1_u 0.0 +f_float_3_1_u 0.0 drop table t1; |