--source include/have_metadata_lock_info.inc

create table t1 (a int);

insert into t1 values (1);

--echo #

--echo # With autocommit=1, no locks exist after the select

set session autocommit=1;

select * from t1;

select * from INFORMATION_SCHEMA.METADATA_LOCK_INFO;

--echo #

--echo # With autocommit=0, the lock exists

set session autocommit=0;

select * from t1;

select * from INFORMATION_SCHEMA.METADATA_LOCK_INFO;

show variables like 'in_transaction';

COMMIT;

select * from INFORMATION_SCHEMA.METADATA_LOCK_INFO;

create table t1 (a int);

insert into t1 values (1);

#

# With autocommit=1, no locks exist after the select

set session autocommit=1;

select * from t1;

a

1

select * from INFORMATION_SCHEMA.METADATA_LOCK_INFO;

THREAD_ID	LOCK_MODE	LOCK_DURATION	LOCK_TYPE	TABLE_SCHEMA	TABLE_NAME

#

# With autocommit=0, the lock exists

set session autocommit=0;

select * from t1;

a

1

select * from INFORMATION_SCHEMA.METADATA_LOCK_INFO;

THREAD_ID	LOCK_MODE	LOCK_DURATION	LOCK_TYPE	TABLE_SCHEMA	TABLE_NAME

4	MDL_SHARED_READ	NULL	Table metadata lock	test	t1

show variables like 'in_transaction';

Variable_name	Value

in_transaction	0

COMMIT;

select * from INFORMATION_SCHEMA.METADATA_LOCK_INFO;

THREAD_ID	LOCK_MODE	LOCK_DURATION	LOCK_TYPE	TABLE_SCHEMA	TABLE_NAME