← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-09-22 22:25:29 UTC
  • mto: (1791.1.1 drizzle)
  • mto: This revision was merged to the branch mainline in revision 1792.
  • Revision ID: brian@tangent.org-20100922222529-geo4wggmu5ntqa5k
Current boost work (more conversion).

Show diffs side-by-side

added added

removed removed

Lines of Context:
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;