summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb_gis/t/rtree_temporary.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb_gis/t/rtree_temporary.test')
-rw-r--r--mysql-test/suite/innodb_gis/t/rtree_temporary.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb_gis/t/rtree_temporary.test b/mysql-test/suite/innodb_gis/t/rtree_temporary.test
index 5c4df251970..e541d7c2698 100644
--- a/mysql-test/suite/innodb_gis/t/rtree_temporary.test
+++ b/mysql-test/suite/innodb_gis/t/rtree_temporary.test
@@ -16,3 +16,16 @@ CREATE TEMPORARY TABLE t1 (c POINT NOT NULL,SPATIAL (c)) ENGINE=InnoDB;
INSERT INTO t1 SELECT POINT(0,0) FROM seq_1_to_366;
INSERT INTO t1 VALUES (POINT(1e-270,1e-130));
DROP TABLE t1;
+
+--echo #
+--echo # MDEV-29507 InnoDB: Failing assertion: table->n_rec_locks == 0
+--echo #
+
+connect con1,localhost,root,,;
+CREATE TEMPORARY TABLE t (c POINT NOT NULL,SPATIAL (c)) ENGINE=InnoDB;
+INSERT INTO t SELECT POINTFROMTEXT ('POINT(0 0)') FROM seq_1_to_500;
+XA BEGIN 'a';
+DELETE FROM t ORDER BY c;
+disconnect con1;
+
+--echo # End of 10.3 tests