Bug #82071 Incorret Update
Submitted: 30 Jun 2016 18:11 Modified: 30 Jun 2016 20:16
Reporter: An Chen Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.7 OS:Windows
Assigned to: CPU Architecture:Any

[30 Jun 2016 18:11] An Chen
Description:
update tablename1 set MOVIEID='00000000000000000000000000092020' and programid='99999999000000010000000000091353' where VideoId='L574';

for this update sql, it will not update the col MOVIEID and col programid correctly, in fact the value of col programid will not changed , and the value of col MOVIEID will be 0 or 1 .

How to repeat:
 CREATE TABLE tablename1 (

    MOVIEID varchar(128),

    programid varchar(128),

    VideoId VARCHAR(1024)

); 

insert into tablename1(MOVIEID,programid,VideoId )values('0000000','11111','L574');

update tablename1 set MOVIEID='00000000000000000000000000092020' and programid='99999999000000010000000000091353' where VideoId='L574';
[30 Jun 2016 20:16] MySQL Verification Team
Thank you for the bug report. Duplicate of http://bugs.mysql.com/bug.php?id=26405, http://bugs.mysql.com/bug.php?id=19398.