Hi,
I am trying out the new GIS capabilities in MySQL 4.1.1-alpha (windows)
and I am trying to follow some of the examples from chapter 10 in the
manual.
Here is a snap shot of my run
--------------------------------------------------------------------
mysql> create table geom(g geometry);
Query OK, 0 rows affected (0.06 sec)
mysql> insert into geom values(GeomFromText('POINT(1,1)'));
Query OK, 1 row affected (0.00 sec)
mysql> select * from geom;
+------+
| g |
+------+
| NULL |
+------+
1 row in set (0.00 sec)
mysql> select AsText(g) from geom;
+-----------+
| AsText(g) |
+-----------+
| NULL |
+-----------+
1 row in set (0.00 sec)
mysql>
---------------------------------------------------------------------
Notice that the select statement at the end gives me NULL for the value
of g.
I was expecting the following:
mysql> select AsText(g) from geom;
+-----------+
| AsText(g) |
+-----------+
| Point(1 1)|
+-----------+
1 row in set (0.00 sec)
Does anyone know what I am missing?
Thanks,
Matt
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
