Silent UNSIGNED - SIGNED conversion with STRICT mode

[Sveta Smirnova]

Description:
With STRICT mode if stored routine called with unsigned int argument and tries to use it update signed column in a table update succeeds and no warning issued.

How to repeat:
set sql_mode='strict_all_tables';

Warnings:
Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.

create table t1(f1 int) engine=innodb;

delimiter |
create procedure p1(v1 int unsigned)
begin
insert into t1 values(v1);
end
|
delimiter ;

call p1(2280017636);

select * from t1;
f1
-2014949660

drop procedure p1;
drop table t1;

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1809