← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/t/gis-rtree.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/gis-rtree.test
928
928
 
929
929
 
930
930
--echo End of 5.0 tests.
 
931
 
 
932
 
 
933
--echo #
 
934
--echo # Bug #57323/11764487: myisam corruption with insert ignore 
 
935
--echo # and invalid spatial data
 
936
--echo #
 
937
 
 
938
CREATE TABLE t1(a LINESTRING NOT NULL, b GEOMETRY NOT NULL,
 
939
  SPATIAL KEY(a), SPATIAL KEY(b)) ENGINE=MyISAM;
 
940
INSERT INTO t1 VALUES(GEOMFROMTEXT("point (0 0)"), GEOMFROMTEXT("point (1 1)"));
 
941
--error ER_CANT_CREATE_GEOMETRY_OBJECT
 
942
INSERT IGNORE INTO t1 SET a=GEOMFROMTEXT("point (-6 0)"), b=GEOMFROMTEXT("error");
 
943
--error ER_CANT_CREATE_GEOMETRY_OBJECT
 
944
INSERT IGNORE INTO t1 SET a=GEOMFROMTEXT("point (-6 0)"), b=NULL;
 
945
SELECT ASTEXT(a), ASTEXT(b) FROM t1;
 
946
DROP TABLE t1;
 
947
 
 
948
CREATE TABLE t1(a INT NOT NULL, b GEOMETRY NOT NULL,
 
949
  KEY(a), SPATIAL KEY(b)) ENGINE=MyISAM;
 
950
INSERT INTO t1 VALUES(0, GEOMFROMTEXT("point (1 1)"));
 
951
--error ER_CANT_CREATE_GEOMETRY_OBJECT
 
952
INSERT IGNORE INTO t1 SET a=0, b=GEOMFROMTEXT("error");
 
953
--error ER_CANT_CREATE_GEOMETRY_OBJECT
 
954
INSERT IGNORE INTO t1 SET a=1, b=NULL;
 
955
SELECT a, ASTEXT(b) FROM t1;
 
956
DROP TABLE t1;
 
957
 
 
958
--echo End of 5.1 tests