diff options
| author | unknown <hf@deer.(none)> | 2004-09-22 22:36:53 +0500 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2004-09-22 22:36:53 +0500 |
| commit | 126ea49d08dda845740c2f9c93531b69bc707873 (patch) | |
| tree | aa41988964c204abc8e7cd531addfd35f09a1f7d /mysql-test | |
| parent | 871c5c0175cc579f355202464f9f858b473a9357 (diff) | |
| download | mariadb-git-126ea49d08dda845740c2f9c93531b69bc707873.tar.gz | |
Additional fix for bug #5136 (Geometry object is corrupted when queried)
CREATE TABLE t1 SELECT POINT(1,2); fixed
mysql-test/r/gis.result:
Appropriate test result
mysql-test/t/gis.test:
test case
sql/item_geofunc.cc:
Item_geometry_func::fix_lengths_and_dec implementation
several fix_length_and_dec's not needed now
sql/item_geofunc.h:
Item_geometry_func class presented
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/gis.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/gis.test | 4 |
2 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result index 9f5dd286cf9..fd71cad36a6 100644 --- a/mysql-test/r/gis.result +++ b/mysql-test/r/gis.result @@ -485,3 +485,10 @@ MBRContains(GeomFromText('Polygon((0 0, 0 7, 7 7, 7 0, 0 0))'), a); AsText(a) POINT(1 1) drop table t1; +create table t1 select POINT(1,3); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `POINT(1,3)` longblob NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table t1; diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index e35b9996a44..30da019be3e 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -190,3 +190,7 @@ select AsText(a) from t1 where and MBRContains(GeomFromText('Polygon((0 0, 0 7, 7 7, 7 0, 0 0))'), a); drop table t1; + +create table t1 select POINT(1,3); +show create table t1; +drop table t1; |