innodb_gis.rtree_split 'innodb' w1 [ fail ]
|
Test ended at 2017-10-29 20:03:20
|
|
CURRENT_TEST: innodb_gis.rtree_split
|
|
|
Server [mysqld.1 - pid: 7357, winpid: 7357, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
----------SERVER LOG END-------------
|
mysqltest failed but provided no output
|
The result from queries just before the failure was:
|
< snip >
|
select count(*) from t1 where MBRWithin(t1.c2, @g1);
|
count(*)
|
73728
|
set @g1 = ST_GeomFromText('Polygon((10 10,10 800,800 800,800 10,10 10))');
|
select count(*) from t1 where MBRWithin(t1.c2, @g1);
|
count(*)
|
0
|
drop index c2 on t1;
|
create spatial index idx2 on t1(c2);
|
show create table t1;
|
Table Create Table
|
t1 CREATE TABLE `t1` (
|
`c1` int(11) DEFAULT NULL,
|
`c2` geometry NOT NULL,
|
SPATIAL KEY `idx2` (`c2`)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1
|
set @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))');
|
select count(*) from t1 where MBRWithin(t1.c2, @g1);
|
count(*)
|
73728
|