| 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('linestring(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('linestring(1 1)'); |
| 11 |
count(*) |
| 12 |
1 |
| 13 |
drop table bug47777; |