Debian Codegraph @

mysql-test/suite/innodb_gis/r/rtree_temporary.result

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