Debian Codegraph @

mysql-test/suite/innodb/t/innodb_bug47777.test

raw
1 --source include/have_innodb.inc
2 # This is the test for bug 47777. GEOMETRY
3 # data is treated as BLOB data in innodb.
4 # Consequently, its key value generation/storing
5 # should follow the process for the BLOB
6 # datatype as well.
7
8
9 create table bug47777(c2 linestring not null, primary key (c2(1))) engine=innodb;
10
11 insert into bug47777 values (geomfromtext('linestring(1 2,3 4,5 6,7 8,9 10)'));
12
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)');
15
16 # Update table bug47777 should be successful.
17 update bug47777 set c2=GeomFromText('linestring(1 1)');
18
19 # Verify the row get updated successfully. The original
20 # c2 value should be changed to GeomFromText('linestring(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('linestring(1 1)');
23
24 drop table bug47777;