EVOLUTION-MANAGER

Edit File: 1833.result

SET DEFAULT_STORAGE_ENGINE = 'tokudb'; DROP TABLE IF EXISTS foo; create table foo (a int, b int, primary key (a))engine=tokudb; insert into foo values (1,10),(2,2),(3,300),(4,40); select * from foo; a b 1 10 2 2 3 300 4 40 replace into foo values (5,50),(10,1000); select * from foo; a b 1 10 2 2 3 300 4 40 5 50 10 1000 replace into foo (a) values (1),(3); select * from foo; a b 1 NULL 2 2 3 NULL 4 40 5 50 10 1000 replace into foo values (1,1),(3,3),(6,60); select * from foo; a b 1 1 2 2 3 3 4 40 5 50 6 60 10 1000 alter table foo add index (b); select b from foo; b 1 2 3 40 50 60 1000 select * from foo; a b 1 1 2 2 3 3 4 40 5 50 6 60 10 1000 delete from foo where a > 4; replace into foo values (1,10),(2,2),(3,300),(4,40); select * from foo use index (primary); a b 1 10 2 2 3 300 4 40 replace into foo values (5,50),(10,1000); select * from foo use index (primary); a b 1 10 2 2 3 300 4 40 5 50 10 1000 replace into foo (a) values (1),(2),(3),(4); select * from foo use index (primary); a b 1 NULL 2 NULL 3 NULL 4 NULL 5 50 10 1000 DROP TABLE foo;