diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb_bug47777.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb_bug47777.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb_bug47777.result b/mysql-test/suite/innodb/r/innodb_bug47777.result new file mode 100644 index 00000000..6625c400 --- /dev/null +++ b/mysql-test/suite/innodb/r/innodb_bug47777.result @@ -0,0 +1,13 @@ +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('linestring(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('linestring(1 1)'); +count(*) +1 +drop table bug47777; |