--disable_warnings
drop table if exists t1;
--enable_warnings

create table t1 (id int primary key not null auto_increment, bar  bigint);

create temporary table t2 ( id int auto_increment primary key, bar bigint
unsigned);

insert into t1 (bar) values (9223372036854775808);
insert into t2 (bar) values (9223372036854775808);

show warnings;

select * from t1, t2;

set @bigint1 = 9223372036854775808;

insert into t1 (bar) values (@bigint1);
insert into t2 (bar) values (@bigint1);

show warnings;

select * from t1, t2;

update t1 set bar = @bigint1 where id = 1;
update t2 set bar = @bigint1 where id = 1;

show warnings;

select * from t1, t2;