1create table tt (id int primary key, x int) engine = tokudb; 2insert into tt values (1,0),(2,-pow(2,31)),(3,pow(2,31)-1); 3create table ti like tt; 4alter table ti engine=innodb; 5insert into ti select * from tt; 6set tokudb_enable_fast_update=1; 7set session sql_mode=(select replace(@@sql_mode,'STRICT_TRANS_TABLES','')); 8set session sql_mode=(select replace(@@sql_mode,'STRICT_ALL_TABLES','')); 9update tt set x=x+1 where id=1; 10update ti set x=x+1 where id=1; 11include/diff_tables.inc [test.tt, test.ti] 12update tt set x=x-2 where id=1; 13update ti set x=x-2 where id=1; 14include/diff_tables.inc [test.tt, test.ti] 15update tt set x=x+1 where id=1; 16update ti set x=x+1 where id=1; 17include/diff_tables.inc [test.tt, test.ti] 18update tt set x=x-1 where id=2; 19update ti set x=x-1 where id=2; 20Warnings: 21Warning 1264 Out of range value for column 'x' at row 1 22include/diff_tables.inc [test.tt, test.ti] 23update tt set x=x+1 where id=2; 24update ti set x=x+1 where id=2; 25include/diff_tables.inc [test.tt, test.ti] 26update tt set x=x+1 where id=3; 27update ti set x=x+1 where id=3; 28Warnings: 29Warning 1264 Out of range value for column 'x' at row 1 30include/diff_tables.inc [test.tt, test.ti] 31update tt set x=x-1 where id=3; 32update ti set x=x-1 where id=3; 33include/diff_tables.inc [test.tt, test.ti] 34insert into tt values (4,pow(2,31)-10); 35insert into ti values (4,pow(2,31)-10); 36update tt set x=x+20 where id=4; 37update ti set x=x+20 where id=4; 38Warnings: 39Warning 1264 Out of range value for column 'x' at row 1 40include/diff_tables.inc [test.tt, test.ti] 41insert into tt values (5,pow(2,31)-10); 42insert into ti values (5,pow(2,31)-10); 43update tt set x=x - -20 where id=5; 44update ti set x=x - -20 where id=5; 45Warnings: 46Warning 1264 Out of range value for column 'x' at row 1 47include/diff_tables.inc [test.tt, test.ti] 48insert into tt values (6,-pow(2,31)+10); 49insert into ti values (6,-pow(2,31)+10); 50update tt set x=x-20 where id=6; 51update ti set x=x-20 where id=6; 52Warnings: 53Warning 1264 Out of range value for column 'x' at row 1 54include/diff_tables.inc [test.tt, test.ti] 55insert into tt values (7,-pow(2,31)+10); 56insert into ti values (7,-pow(2,31)+10); 57update tt set x=x + -20 where id=7; 58update ti set x=x + -20 where id=7; 59Warnings: 60Warning 1264 Out of range value for column 'x' at row 1 61include/diff_tables.inc [test.tt, test.ti] 62drop table tt, ti; 63