From 26d0c4b1b4b78971e95b78117e2401c658ef1aa0 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 16 Mar 2004 14:59:22 +0400 Subject: Fix for #233 (final part) mysql-test/r/gis.result: test result added mysql-test/t/gis.test: test case added sql/field.h: now set_field_to_null can return -1 sql/field_conv.cc: now set_field_to_null* can return -1 --- mysql-test/t/gis.test | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'mysql-test/t') diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index 35f2cff8f9a..541cff731b8 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -160,3 +160,11 @@ SELECT SRID(GeomFromText('LineString(1 1,2 2)',101)); explain extended SELECT SRID(GeomFromText('LineString(1 1,2 2)',101)); #select issimple(MultiPoint(Point(3, 6), Point(4, 10))), issimple(Point(3, 6)),issimple(PolygonFromText('POLYGON((10 10,20 10,20 20,10 20,10 10))')),issimple(GeometryFromText('POINT(1 4)')), issimple(AsWKB(GeometryFromText('POINT(1 4)'))); explain extended select issimple(MultiPoint(Point(3, 6), Point(4, 10))), issimple(Point(3, 6)); + +create table t1 (a geometry not null); +insert into t1 values (GeomFromText('Point(1 2)')); +-- error 1105 +insert into t1 values ('Garbage'); +alter table t1 add spatial index(a); + +drop table t1; -- cgit v1.2.1