Silent UNSIGNED - SIGNED conversion with STRICT mode
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Won't Fix
|
Medium
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
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=
Warnings:
Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_
Warning 3090 Changing sql mode 'NO_AUTO_
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;
tags: | added: upstream |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-1809