diff options
Diffstat (limited to 'mysql-test/r/mdl.result')
| -rw-r--r-- | mysql-test/r/mdl.result | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/r/mdl.result b/mysql-test/r/mdl.result index 1a7291d922b..d93bfd5c729 100644 --- a/mysql-test/r/mdl.result +++ b/mysql-test/r/mdl.result @@ -7,16 +7,16 @@ # CREATE TABLE t1(a INT) ENGINE=InnoDB; LOCK TABLES t1 WRITE CONCURRENT, t1 AS t2 READ; -SELECT * FROM information_schema.metadata_lock_info; -THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE TABLE_SCHEMA TABLE_NAME -9 MDL_INTENTION_EXCLUSIVE NULL Global read lock -9 MDL_SHARED_NO_READ_WRITE NULL Table metadata lock test t1 +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA, TABLE_NAME FROM information_schema.metadata_lock_info; +LOCK_MODE LOCK_TYPE TABLE_SCHEMA TABLE_NAME +MDL_INTENTION_EXCLUSIVE Global read lock +MDL_SHARED_NO_READ_WRITE Table metadata lock test t1 UNLOCK TABLES; LOCK TABLES t1 AS t2 READ, t1 WRITE CONCURRENT; -SELECT * FROM information_schema.metadata_lock_info; -THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE TABLE_SCHEMA TABLE_NAME -9 MDL_INTENTION_EXCLUSIVE NULL Global read lock -9 MDL_SHARED_WRITE NULL Table metadata lock test t1 -9 MDL_SHARED_READ_ONLY NULL Table metadata lock test t1 +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA, TABLE_NAME FROM information_schema.metadata_lock_info; +LOCK_MODE LOCK_TYPE TABLE_SCHEMA TABLE_NAME +MDL_INTENTION_EXCLUSIVE Global read lock +MDL_SHARED_WRITE Table metadata lock test t1 +MDL_SHARED_READ_ONLY Table metadata lock test t1 UNLOCK TABLES; DROP TABLE t1; |