diff options
Diffstat (limited to 'mysql-test/suite/innodb/t/innodb_bug47777.test')
| -rw-r--r-- | mysql-test/suite/innodb/t/innodb_bug47777.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/t/innodb_bug47777.test b/mysql-test/suite/innodb/t/innodb_bug47777.test new file mode 100644 index 00000000..575d84b9 --- /dev/null +++ b/mysql-test/suite/innodb/t/innodb_bug47777.test @@ -0,0 +1,24 @@ +--source include/have_innodb.inc +# This is the test for bug 47777. GEOMETRY +# data is treated as BLOB data in innodb. +# Consequently, its key value generation/storing +# should follow the process for the BLOB +# datatype as well. + + +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)')); + +# Verify correct row get inserted. +select count(*) from bug47777 where c2 =geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)'); + +# Update table bug47777 should be successful. +update bug47777 set c2=GeomFromText('linestring(1 1)'); + +# Verify the row get updated successfully. The original +# c2 value should be changed to GeomFromText('linestring(1 1)'). +select count(*) from bug47777 where c2 =geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)'); +select count(*) from bug47777 where c2 = GeomFromText('linestring(1 1)'); + +drop table bug47777; |