~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/innobase/mysql-test/innodb_bug47777.result

• browse files at revision 1841.1.7
• compare with another revision
• compare with revision 2165.1.3
• download diff
• download tarball
• view history from revision 1841.1.7

Show diffs side-by-side

added

removed

plugin/innobase/mysql-test/innodb_bug47777.result

 

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('POINT(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('POINT(1 1)');

 

11

count(*)

 

12

1

 

13

drop table bug47777;

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1