diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/t/fast_update_uint_bounds.test')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/t/fast_update_uint_bounds.test | 42 |
1 files changed, 17 insertions, 25 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/fast_update_uint_bounds.test b/storage/tokudb/mysql-test/tokudb/t/fast_update_uint_bounds.test index f4f43d60e31..a35658cba18 100644 --- a/storage/tokudb/mysql-test/tokudb/t/fast_update_uint_bounds.test +++ b/storage/tokudb/mysql-test/tokudb/t/fast_update_uint_bounds.test @@ -1,62 +1,54 @@ source include/have_tokudb.inc; source include/have_innodb.inc; -set default_storage_engine='tokudb'; - -disable_warnings; -drop table if exists t; -enable_warnings; - -create table tt (id int primary key, x int unsigned); +create table tt (id int primary key, x int unsigned) engine = tokudb; insert into tt values (1,0),(2,pow(2,32)-1); create table ti like tt; alter table ti engine=innodb; insert into ti select * from tt; -set tokudb_disable_slow_update=1; +set tokudb_enable_fast_update=1; +source ../include/setup_fast_update_upsert.inc; -update noar tt set x=x+1 where id=1; -update noar ti set x=x+1 where id=1; +update tt set x=x+1 where id=1; +update ti set x=x+1 where id=1; let $diff_tables = test.tt, test.ti; source include/diff_tables.inc; -update noar tt set x=x-2 where id=1; -update noar ti set x=if(x<2,0,x-2) where id=1; +update tt set x=x-2 where id=1; +update ti set x=if(x<2,0,x-2) where id=1; let $diff_tables = test.tt, test.ti; source include/diff_tables.inc; -update noar tt set x=x+1 where id=1; -update noar ti set x=x+1 where id=1; +update tt set x=x+1 where id=1; +update ti set x=x+1 where id=1; let $diff_tables = test.tt, test.ti; source include/diff_tables.inc; -update noar tt set x=x-1 where id=2; -update noar ti set x=x-1 where id=2; +update tt set x=x-1 where id=2; +update ti set x=x-1 where id=2; let $diff_tables = test.tt, test.ti; source include/diff_tables.inc; -update noar tt set x=x+1 where id=2; -update noar ti set x=x+1 where id=2; +update tt set x=x+1 where id=2; +update ti set x=x+1 where id=2; let $diff_tables = test.tt, test.ti; source include/diff_tables.inc; # test clip at maximum insert into tt values (4,pow(2,32)-10); insert into ti values (4,pow(2,32)-10); -update noar tt set x=x+20 where id=4; -update noar ti set x=x+20 where id=4; +update tt set x=x+20 where id=4; +update ti set x=x+20 where id=4; let $diff_tables = test.tt, test.ti; source include/diff_tables.inc; # test clip at minimum insert into tt values (5,10); insert into ti values (5,10); -update noar tt set x=x-20 where id=5; -update noar ti set x=if(x<20,0,x-20) where id=5; +update tt set x=x-20 where id=5; +update ti set x=if(x<20,0,x-20) where id=5; let $diff_tables = test.tt, test.ti; source include/diff_tables.inc; drop table tt, ti; - - - |