Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.7(EOL), 10.8(EOL)
-
None
Description
10.5 ea40c75c |
$ perl ./mtr gcol.gcol_purge innodb.gap_locks --noreorder
|
|
gcol.gcol_purge 'innodb' [ pass ] 11825
|
innodb.gap_locks 'innodb' [ fail ]
|
Test ended at 2022-05-27 23:10:05
|
|
CURRENT_TEST: innodb.gap_locks
|
--- /mnt8t/bld/10.5-debug-nightly/mysql-test/suite/innodb/r/gap_locks.result 2021-09-14 19:07:00.000000000 +0300
|
+++ /mnt8t/bld/10.5-debug-nightly/mysql-test/suite/innodb/r/gap_locks.reject 2022-05-27 23:10:05.289693153 +0300
|
@@ -8,28 +8,28 @@
|
DELETE FROM t1 WHERE b='2' AND c=2;
|
SHOW ENGINE INNODB STATUS;
|
Type Name Status
|
-InnoDB 2 lock struct(s), 1 row lock(s)
|
+InnoDB 0 lock struct(s), 0 row lock(s)
|
ROLLBACK;
|
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
|
BEGIN;
|
DELETE FROM t1 WHERE b='2' AND c=2;
|
SHOW ENGINE INNODB STATUS;
|
Type Name Status
|
-InnoDB 2 lock struct(s), 1 row lock(s)
|
+InnoDB 0 lock struct(s), 0 row lock(s)
|
ROLLBACK;
|
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
|
BEGIN;
|
DELETE FROM t1 WHERE b='2' AND c=2;
|
SHOW ENGINE INNODB STATUS;
|
Type Name Status
|
-InnoDB 1 lock struct(s), 0 row lock(s)
|
+InnoDB 0 lock struct(s), 0 row lock(s)
|
ROLLBACK;
|
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
|
BEGIN;
|
DELETE FROM t1 WHERE b='2' AND c=2;
|
SHOW ENGINE INNODB STATUS;
|
Type Name Status
|
-InnoDB 1 lock struct(s), 0 row lock(s)
|
+InnoDB 0 lock struct(s), 0 row lock(s)
|
ROLLBACK;
|
SET GLOBAL INNODB_STATUS_OUTPUT_LOCKS = @save_locks;
|
DROP TABLE t1;
|
|
mysqltest: Result content mismatch
|
Attachments
Issue Links
- is duplicated by
-
MDEV-32859 gcol.gcol_purge causes innodb.gap_lock test failure
- Closed