EVOLUTION-MANAGER

Edit File: i_s_tokudb_trx.test

skip Tokudb trx not in I_S in MariaDB;
# verify that information_schema.tokudb_trx gets populated with transactions

source include/have_tokudb.inc;
set default_storage_engine='tokudb';
set tokudb_prelock_empty=false;
disable_warnings;
drop table if exists t;
enable_warnings;

# should be empty
select trx_id,trx_mysql_thread_id from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id());

# should have my txn
set autocommit=0;
create table t (id int primary key);
insert into t values (1);
select count(trx_mysql_thread_id) from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id());

# should be empty
commit;
select trx_id,trx_mysql_thread_id from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id());

connect(conn_a,localhost,root,,);
set autocommit=0;
insert into t values (2);
select count(trx_mysql_thread_id) from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id());

connection default;
select count(trx_mysql_thread_id) from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id());
connection conn_a;
commit;
connection default;

# should be empty
select trx_id,trx_mysql_thread_id from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id());

disconnect conn_a;

drop table t;