Debian Codegraph @

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

raw
1 SET default_storage_engine=innodb;
2 --source include/gis_generic.inc
3 --source include/gis_keys.inc
4
5 #
6 # Bug #15680 (SPATIAL key in innodb)
7 #
8 #--error ER_TABLE_CANT_HANDLE_SPKEYS
9 create table t1 (g geometry not null SRID 0, spatial gk(g)) engine=innodb;
10
11 DROP TABLE t1;
12
13 # Test read uncommitted
14 create table t1 (c1 int, c2 geometry not null SRID 0, spatial index (c2))engine=innodb;
15
16 connect (a,localhost,root,,);
17 connection a;
18
19 start transaction;
20 insert into t1 values(1, Point(1,1));
21
22
23 connect (con1,localhost,root,,);
24 connection con1;
25 set @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
26 set transaction isolation level read uncommitted;
27 select count(*) from t1 where ST_Within(t1.c2, @g1);
28 disconnect con1;
29
30 --source include/wait_until_disconnected.inc
31
32 connection a;
33 commit;
34 disconnect a;
35 --source include/wait_until_disconnected.inc
36
37 connection default;
38 drop table t1;
39