EVOLUTION-MANAGER

Edit File: locks-update-deadlock-1.test

source include/have_tokudb.inc; # test that update only take write locks # t1 scans all of the rows in a table and updates 1 of them # t1 grabs a write range lock on -infinity +infinity # t2 scans all of the rows in a table except the one updated by t1 # t2 should hang until t1 commits SET DEFAULT_STORAGE_ENGINE='tokudb'; --disable_warnings drop table if exists t; --enable_warnings connect(conn1,localhost,root); connection default; create table t (a int primary key, b int); insert into t values (1,0),(2,1),(3,0); begin; update t set b=b+1 where b>0; connection conn1; set transaction isolation level serializable; send select * from t where a!=2; connection default; commit; connection conn1; reap; connection default; disconnect conn1; drop table t;