Debian Codegraph @

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

raw
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;