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