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