--disable_warnings drop database if exists bug26020; create database bug26020; --enable_warnings use bug26020; set @var := 0; create table t1(a bigint not null auto_increment primary key, b bigint, c bigint); insert into t1 (b,c) values (10,0), (30,0), (10, 0); select if(b=@var, 999, b) , @var := b from t1 order by b; --disable_warnings drop database bug26020; --enable_warnings