[tomato.git] / release / src / router / mysql / mysql-test / suite / innodb_plugin / r / innodb_bug47777.result
| blob | fbba47edcfc32ae701dda05f894f0f6fd491429b |
1 create table bug47777(c2 linestring not null, primary key (c2(1))) engine=innodb;
2 insert into bug47777 values (geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)'));
3 select count(*) from bug47777 where c2 =geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)');
4 count(*)
5 1
6 update bug47777 set c2=GeomFromText('POINT(1 1)');
7 select count(*) from bug47777 where c2 =geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)');
8 count(*)
9 0
10 select count(*) from bug47777 where c2 = GeomFromText('POINT(1 1)');
11 count(*)
12 1
13 drop table bug47777;