← 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: 2011-01-06 05:17:09 UTC
  • Revision ID: brian@tangent.org-20110106051709-oa0se8ur02uc6i9o
Added native functions into the function table.

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;