From 7835ff508331e46f9983912c2d1ddffde42c2685 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 3 Apr 2003 15:13:14 +0500 Subject: AsWKB() function has been added. --- mysql-test/r/gis.result | 5 ++++- mysql-test/t/gis.test | 4 +++- 2 files changed, 7 insertions(+), 2 deletions(-) (limited to 'mysql-test') diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result index 12a1428d514..a5a280b974f 100644 --- a/mysql-test/r/gis.result +++ b/mysql-test/r/gis.result @@ -43,7 +43,7 @@ INSERT INTO pt VALUES (101, PointFromText('POINT(10 10)')), (102, PointFromText('POINT(20 10)')), (103, PointFromText('POINT(20 20)')), -(104, PointFromText('POINT(10 20)')); +(104, PointFromWKB(AsWKB(PointFromText('POINT(10 20)')))); INSERT INTO ls VALUES (105, LineFromText('LINESTRING(0 0,0 10,10 0)')), (106, LineStringFromText('LINESTRING(10 10,20 10,20 20,10 20,10 10)')), @@ -388,3 +388,6 @@ gc geometrycollection binary YES NULL gm geometry binary YES NULL fid int(11) binary 0 DROP TABLE g1; +SELECT AsText(GeometryFromWKB(AsWKB(GeometryFromText('POINT(1 4)')))); +AsText(GeometryFromWKB(AsWKB(GeometryFromText('POINT(1 4)')))) +POINT(1 4) diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index f1fe8b33cc5..b7c41135123 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -29,7 +29,7 @@ INSERT INTO pt VALUES (101, PointFromText('POINT(10 10)')), (102, PointFromText('POINT(20 10)')), (103, PointFromText('POINT(20 20)')), -(104, PointFromText('POINT(10 20)')); +(104, PointFromWKB(AsWKB(PointFromText('POINT(10 20)')))); INSERT INTO ls VALUES (105, LineFromText('LINESTRING(0 0,0 10,10 0)')), @@ -140,3 +140,5 @@ SHOW FIELDS FROM g1; ALTER TABLE g1 ADD fid INT NOT NULL; SHOW FIELDS FROM g1; DROP TABLE g1; + +SELECT AsText(GeometryFromWKB(AsWKB(GeometryFromText('POINT(1 4)')))); -- cgit v1.2.1