Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
8.0.13-3, Not 5.7.x
Description
mysqltest: At line 115: Query 'UPDATE t1 SET id1=30, id2=31 WHERE id2=10' failed. ERROR 1105 (HY000): Using Gap Lock without full unique key in multi-table or multi-statement transactions is not allowed. You need to either rewrite queries to use all unique key columns in WHERE equal conditions, or rewrite to single-table, single-statement transaction. Query: UPDATE t1 SET id1=30, id2=31 WHERE id2=10 In included file /media/glorch/ssd/percona/PS/percona-server-install-8.0/mysql-test/var/tmp/2/unique_sec.sql: 115 included from /media/glorch/ssd/percona/PS/percona-server-install-8.0/mysql-test/suite/rocksdb/t/unique_sec.test: 12
and
mysqltest: At line 115: Query 'UPDATE t1 SET id1=30, id2=31 WHERE id2=10' failed. ERROR 1105 (HY000): Using Gap Lock without full unique key in multi-table or multi-statement transactions is not allowed. You need to either rewrite queries to use all unique key columns in WHERE equal conditions, or rewrite to single-table, single-statement transaction. Query: UPDATE t1 SET id1=30, id2=31 WHERE id2=10 In included file /media/glorch/ssd/percona/PS/percona-server-install-8.0/mysql-test/var/2/tmp/unique_sec_rev_cf.sql: 115 included from /media/glorch/ssd/percona/PS/percona-server-install-8.0/mysql-test/suite/rocksdb/t/unique_sec_rev_cf.test: 12