← 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/r/gis-rtree.result

  • 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/r/gis-rtree.result
1549
1549
HANDLER t1 CLOSE;
1550
1550
DROP TABLE t1;
1551
1551
End of 5.0 tests.
 
1552
#
 
1553
# Bug #57323/11764487: myisam corruption with insert ignore 
 
1554
# and invalid spatial data
 
1555
#
 
1556
CREATE TABLE t1(a LINESTRING NOT NULL, b GEOMETRY NOT NULL,
 
1557
SPATIAL KEY(a), SPATIAL KEY(b)) ENGINE=MyISAM;
 
1558
INSERT INTO t1 VALUES(GEOMFROMTEXT("point (0 0)"), GEOMFROMTEXT("point (1 1)"));
 
1559
INSERT IGNORE INTO t1 SET a=GEOMFROMTEXT("point (-6 0)"), b=GEOMFROMTEXT("error");
 
1560
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field
 
1561
INSERT IGNORE INTO t1 SET a=GEOMFROMTEXT("point (-6 0)"), b=NULL;
 
1562
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field
 
1563
SELECT ASTEXT(a), ASTEXT(b) FROM t1;
 
1564
ASTEXT(a)       ASTEXT(b)
 
1565
POINT(0 0)      POINT(1 1)
 
1566
DROP TABLE t1;
 
1567
CREATE TABLE t1(a INT NOT NULL, b GEOMETRY NOT NULL,
 
1568
KEY(a), SPATIAL KEY(b)) ENGINE=MyISAM;
 
1569
INSERT INTO t1 VALUES(0, GEOMFROMTEXT("point (1 1)"));
 
1570
INSERT IGNORE INTO t1 SET a=0, b=GEOMFROMTEXT("error");
 
1571
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field
 
1572
INSERT IGNORE INTO t1 SET a=1, b=NULL;
 
1573
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field
 
1574
SELECT a, ASTEXT(b) FROM t1;
 
1575
a       ASTEXT(b)
 
1576
0       POINT(1 1)
 
1577
DROP TABLE t1;
 
1578
End of 5.1 tests