create table bug47777(c2 linestring not null, primary key (c2(1))) engine=innodb; insert into bug47777 values (geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)')); select count(*) from bug47777 where c2 =geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)'); count(*) 1 update bug47777 set c2=GeomFromText('POINT(1 1)'); select count(*) from bug47777 where c2 =geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)'); count(*) 0 select count(*) from bug47777 where c2 = GeomFromText('POINT(1 1)'); count(*) 1 drop table bug47777;