summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/r/insert_into_empty.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb/r/insert_into_empty.result')
-rw-r--r--mysql-test/suite/innodb/r/insert_into_empty.result22
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/insert_into_empty.result b/mysql-test/suite/innodb/r/insert_into_empty.result
index d17f24bd7d5..45f3dd7654c 100644
--- a/mysql-test/suite/innodb/r/insert_into_empty.result
+++ b/mysql-test/suite/innodb/r/insert_into_empty.result
@@ -229,6 +229,28 @@ commit;
SELECT * FROM t;
c
DROP TABLE t;
+#
+# MDEV-29545 InnoDB: Can't find record during replace stmt
+#
+CREATE TABLE t1(c1 INT PRIMARY KEY)ENGINE=InnoDB;
+BEGIN;
+INSERT INTO t1 VALUES(3331);
+connect con1,localhost,root,,,;
+BEGIN;
+SELECT c1 FROM t1;
+c1
+connection default;
+COMMIT;
+connection con1;
+REPLACE INTO t1 VALUES(1984), (1984);
+COMMIT;
+connection default;
+disconnect con1;
+SELECT * FROM t1;
+c1
+1984
+3331
+DROP TABLE t1;
# End of 10.6 tests
#
# MDEV-26947 UNIQUE column checks fail in InnoDB resulting