diff options
| author | unknown <holyfoot@deer.(none)> | 2006-07-04 12:56:53 +0500 |
|---|---|---|
| committer | unknown <holyfoot@deer.(none)> | 2006-07-04 12:56:53 +0500 |
| commit | 8e1162f830c3b7a19e8632ffc7e1a94a84e171c5 (patch) | |
| tree | 9f696d4b513142b433b7757c911ed0f39bc54678 /mysql-test/t/gis.test | |
| parent | 8703b22e167c706d5a8c77a1e24948b4db3fafb3 (diff) | |
| download | mariadb-git-8e1162f830c3b7a19e8632ffc7e1a94a84e171c5.tar.gz | |
bug #14807 (GeomFromText() should return MYSQL_TYPE_GEOMETRY)
we didn't have code creating GEOMETRY-type fields from Items (expression results)
So i added this code
mysql-test/r/gis.result:
test result fixed
mysql-test/t/gis.test:
testcase added
sql/item_geofunc.cc:
Item_geometry_func::tmp_table_field implemented
sql/item_geofunc.h:
tmp_table_field() and get_geometry_type() declared
Diffstat (limited to 'mysql-test/t/gis.test')
| -rw-r--r-- | mysql-test/t/gis.test | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index 4c6ff9b2fe7..7bba34be3ff 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -281,7 +281,7 @@ INSERT INTO t1 VALUES(GeomFromText('POINT(580848489 219587743)')); INSERT INTO t1 VALUES(GeomFromText('POINT(11247614 782797569)')); drop table t1; -create table t1 select POINT(1,3); +create table t1 select GeomFromWKB(POINT(1,3)); show create table t1; drop table t1; @@ -416,3 +416,9 @@ select * from t1; select asbinary(g) from t1; --disable_metadata drop table t1; + + +create table t1 select GeomFromText('point(1 1)'); +desc t1; +drop table t1; + |