On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
>
> Hmm... am I missing something?! IIRC there is nothing manual about Innodb
> not supporting spatial extensions. And on windows it seems that all is working
> fine. This is from my Win2000 box with the same Mysql version:
>
> mysql> create table t (p polygon not null, spatial index(p)) type=innodb;
> Query OK, 0 rows affected (0.00) sec
>
> mysql> insert into t (p) values (geomfromtext('polygon((1 1, 2 2, 1 2, 1 1))'));
> Query OK, 1 row affected (0.02) sec
>
> mysql> select astext(p) from t;
> +----------------------------+
> | astext(p) |
> +----------------------------+
> | POLYGON((1 1,2 2,1 2,1 1)) |
> +----------------------------+
> 1 row in set (0.00 sec)
Is it *really* an InnoDB table?
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 15 days, processed 553,853,916 queries (407/sec. avg)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
