1 # This is the test for bug 47777. GEOMETRY
2 # data is treated as BLOB data in innodb.
3 # Consequently, its key value generation/storing
4 # should follow the process for the BLOB
7 --source include/have_innodb.inc
9 create table bug47777(c2 linestring not null, primary key (c2(1))) engine=innodb;
11 insert into bug47777 values (geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)'));
13 # Verify correct row get inserted.
14 select count(*) from bug47777 where c2 =geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)');
16 # Update table bug47777 should be successful.
17 update bug47777 set c2=GeomFromText('POINT(1 1)');
19 # Verify the row get updated successfully. The original
20 # c2 value should be changed to GeomFromText('POINT(1 1)').
21 select count(*) from bug47777 where c2 =geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)');
22 select count(*) from bug47777 where c2 = GeomFromText('POINT(1 1)');