diff options
Diffstat (limited to 'mysql-test/suite/vcol/r/vcol_supported_sql_funcs_myisam.result')
| -rw-r--r-- | mysql-test/suite/vcol/r/vcol_supported_sql_funcs_myisam.result | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/mysql-test/suite/vcol/r/vcol_supported_sql_funcs_myisam.result b/mysql-test/suite/vcol/r/vcol_supported_sql_funcs_myisam.result index ce6bd7eed40..35e27ee3099 100644 --- a/mysql-test/suite/vcol/r/vcol_supported_sql_funcs_myisam.result +++ b/mysql-test/suite/vcol/r/vcol_supported_sql_funcs_myisam.result @@ -2251,7 +2251,7 @@ t1 CREATE TABLE `t1` ( insert into t1 values ('2003-02-05',default); insert into t1 values ('2003-02-32',default); Warnings: -Warning 1264 Out of range value for column 'a' at row 1 +Warning 1265 Data truncated for column 'a' at row 1 select * from t1; a b 2003-02-05 00:00:00 2003-02-28 00:00:00 @@ -2686,10 +2686,15 @@ t1 CREATE TABLE `t1` ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 insert into t1 values (1,default); insert into t1 values (-1,default); +Warnings: +Warning 1105 Cast to unsigned converted negative integer to it's positive complement select * from t1; a b 1 1 -1 18446744073709551615 +Warnings: +Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Warning 1105 Cast to unsigned converted negative integer to it's positive complement drop table t1; set sql_warnings = 0; # Convert() @@ -2703,10 +2708,15 @@ t1 CREATE TABLE `t1` ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 insert into t1 values (1,default); insert into t1 values (-1,default); +Warnings: +Warning 1105 Cast to unsigned converted negative integer to it's positive complement select * from t1; a b 1 1 -1 18446744073709551615 +Warnings: +Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Warning 1105 Cast to unsigned converted negative integer to it's positive complement drop table t1; set sql_warnings = 0; # |