Debian Codegraph @

mysql-test/suite/innodb_gis/t/rtree_temporary.test

raw
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