# ml_err29.test
# Strange behaviour around truncation and warnings

--disable_warnings
drop table if exists t1 ;
--enable_warnings

create table t1
( c1  tinyint, c20 char(2), c21 char(100), primary key(c1)) ;


# "positive" examples, where the value exceeds the length of c20 char(2)
# We get a warning, that the value was truncated.
insert into t1 ( c1, c20, c21 ) values ( 50, '500', '500' ) ;
insert into t1 ( c1, c20, c21 ) values ( 51, 500, 500 ) ;
insert into t1 ( c1, c20, c21 ) values ( 52, -5.0E+2, -5.0E+2 ) ;
set @arg00= 500.0 ;
insert into t1 ( c1, c20, c21 ) values ( 53, @arg00, @arg00 ) ;

# Here I'm missing the warnings .
insert into t1 ( c1, c20, c21 ) values ( 54, 500.0, 500.0 ) ;
insert into t1 ( c1, c20, c21 ) values ( 55, +5.0E+2, +5.0E+2 ) ;
insert into t1 ( c1, c20, c21 ) values ( 56, +5000E+2, +5000E+2 ) ;

select * from t1;