Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug47777.result

raw
1 create table bug47777(c2 linestring not null) engine=innodb;
2 insert into bug47777 values (ST_geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)'));
3 select count(*) from bug47777 where c2 =ST_geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)');
4 count(*)
5 1
6 update bug47777 set c2=ST_GeomFromText('POINT(1 1)');
7 ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field
8 select count(*) from bug47777 where c2 =ST_geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)');
9 count(*)
10 1
11 select count(*) from bug47777 where c2 = ST_GeomFromText('POINT(1 1)');
12 count(*)
13 0
14 drop table bug47777;