mysql-test/main/mdl_sync.result

74 # Check that SNW lock is compatible with it. To do this use ALTER TABLE
75 # which will fail during copying the table and thus obtaining SNW metadata
99 # Check that upgrade from SNW to X is blocked by presence of S lock.
143 # Check that SNW lock is compatible with it. To do this use ALTER TABLE
144 # which will fail during copying the table and thus obtaining SNW metadata
178 # Check that upgrade from SNW to X is blocked by presence of SH lock.
253 # Check that SNW lock is compatible with it. To do this use ALTER TABLE
254 # which will fail during copying the table and thus obtaining SNW metadata
302 # Check that upgrade from SNW to X is blocked by presence of SR lock.
348 # Check that SNW lock is not compatible with SW lock.
350 # the table to avoid upgrade of SNW -> X.
403 # There is no need to check that upgrade from SNW/SNRW to X is
404 # blocked by presence of SW lock because SNW/SNRW is incompatible
490 # Now we have ALTER TABLE with SU->SNW and RENAME TABLE with pending
500 # There is no need to check that upgrade from SNW/SNRW to X is
501 # blocked by presence of another SU lock because SNW/SNRW is
507 # 6) Acquire SNW lock on the table. We have to use DEBUG_SYNC for
508 #    this, to prevent SNW from being immediately upgraded to X.
526 # Check that SW lock is incompatible with SNW lock.
531 # Check that the above DELETE is blocked because of SNW lock.
549 # Check that SU lock is incompatible with SNW lock.
554 # Check that the above ALTER is blocked because of SNW lock.
566 # Note that we can't easily check SNW vs SNW locks since
567 # SNW is only used by ALTER TABLE after upgrading from SU
568 # and SU is also incompatible with SNW.
577 # Check that SNRW lock is incompatible with SNW lock.
582 # Check that the above LOCK TABLES is blocked because of SNW lock.
602 # Check that X lock is incompatible with SNW lock.
607 # Check that the above RENAME is blocked because of SNW lock.
620 # There is no need to check that upgrade from SNW/SNRW to X is
621 # blocked by presence of another SNW lock because SNW/SNRW is
622 # incompatible with SNW anyway.
685 # Note that we can't easily check SNW vs SNRW locks since
686 # SNW is only used by ALTER TABLE after upgrading from SU
725 # There is no need to check that upgrade from SNW/SNRW to X is
726 # blocked by presence of another SNRW lock because SNW/SNRW is
878 # Note that we can't easily check SNW vs X locks since
879 # SNW is only used by ALTER TABLE after upgrading from SU
948 # 1) Check compatibility for pending SNW lock.
950 # Acquire SW lock in order to create pending SNW lock later.
955 # Add pending SNW lock.
960 # Check that ALTER TABLE is waiting with pending SNW lock.
961 # Check that S, SH and SR locks are compatible with pending SNW
971 # Check that SW is incompatible with pending SNW
976 # Check that the above DELETE is blocked because of pending SNW lock.
987 # We can't do similar check for SNW, SNRW and X locks because
1073 # Check that SNW is compatible with pending SNRW
1205 # Check that SNW is incompatible with pending X
1264 #    context interact with active/pending SNW lock.
1274 # Create an active SNW lock on t2.
1275 # We have to use DEBUG_SYNC facility as otherwise SNW lock
1314 #    locked in SNW mode acquires yet another SR lock and then tries
1322 # Create an active SNW lock on t1.
1333 # Since the above ALTER TABLE is not upgrading SNW lock to X by waiting
1353 #     against which there is pending SNW lock acquires SR and SW
1360 # Create pending SNW lock on t1.
1365 # Wait until ALTER TABLE starts waiting for SNW lock.
1380 # 2) Now similar tests for active SNW lock which is being upgraded
1391 # Start transaction which will prevent SNW -> X upgrade from
1399 # Create SNW lock pending upgrade to X on t2.
1429 # Start transaction which will prevent SNW -> X upgrade from
1437 # Create SNW lock pending upgrade to X on t2.
1468 # Create SNW lock pending upgrade to X.
1964 # Ensure that ALTER waits once it has acquired SNW lock.
1970 # Wait till ALTER acquires SNW lock and stops.
1989 # Add a new request for SNW lock to waiting graph.
2001 # for SW lock; which is not granted because of pending SNW lock from
2003 # for SW and SNW locks have same weight ALTER was selected as a victim
2031 # SNW locks on t1 and t2, open table t1 and block on the debug
2047 # Such reopen should not cause releasing of SNW metadata locks
2585 # Start ALTER TABLE which will acquire SNW lock and
2601 # Unblock ALTER TABLE. Since it will try to upgrade SNW to X lock
2948 # We need EXECUTE 2 since ALTER TABLE does SU => SNW => X and we want