← 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: Monty Taylor
  • Date: 2008-10-16 06:32:59 UTC
  • mfrom: (518 drizzle)
  • mto: (511.1.5 codestyle)
  • mto: This revision was merged to the branch mainline in revision 521.
  • Revision ID: monty@inaugust.com-20081016063259-fwbqogq7lnezct0l
Merged with trunk.

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;