| 1 |
--source include/have_innodb.inc |
| 2 |
--source include/have_sequence.inc |
| 3 |
|
| 4 |
--echo # |
| 5 |
--echo # MDEV-27417 Spatial index tries to update |
| 6 |
--echo # change buffer bookkeeping page |
| 7 |
--echo # |
| 8 |
CREATE TEMPORARY TABLE t1 (c POINT NOT NULL, SPATIAL(c)) ENGINE=InnoDB; |
| 9 |
INSERT INTO t1 SELECT PointFromText('POINT(0 0)') FROM seq_1_to_366; |
| 10 |
DROP TABLE t1; |
| 11 |
|
| 12 |
--echo # |
| 13 |
--echo # MDEV-28478 Assertion mtr->get_log_mode() == MTR_LOG_NO_REDO |
| 14 |
--echo # |
| 15 |
CREATE TEMPORARY TABLE t1 (c POINT NOT NULL,SPATIAL (c)) ENGINE=InnoDB; |
| 16 |
INSERT INTO t1 SELECT POINT(0,0) FROM seq_1_to_366; |
| 17 |
INSERT INTO t1 VALUES (POINT(1e-270,1e-130)); |
| 18 |
DROP TABLE t1; |
| 19 |
|
| 20 |
--echo # |
| 21 |
--echo # MDEV-29507 InnoDB: Failing assertion: table->n_rec_locks == 0 |
| 22 |
--echo # |
| 23 |
|
| 24 |
connect con1,localhost,root,,; |
| 25 |
CREATE TEMPORARY TABLE t (c POINT NOT NULL,SPATIAL (c)) ENGINE=InnoDB; |
| 26 |
INSERT INTO t SELECT POINTFROMTEXT ('POINT(0 0)') FROM seq_1_to_500; |
| 27 |
XA BEGIN 'a'; |
| 28 |
DELETE FROM t ORDER BY c; |
| 29 |
disconnect con1; |
| 30 |
|
| 31 |
--echo # End of 10.3 tests |