> 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?
Yes it is really InnoDB table and I'm really confused now.
mysql> show table status like 't';
+------+--------+------------+------+----------------+-------------+------------
-----+--------------+-----------+----------------+-------------+-------------+--
----------+-------------------+----------------+----------------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_le
ngth | Index_length | Data_free | Auto_increment | Create_time | Update_time | C
heck_time | Charset | Create_options | Comment |
+------+--------+------------+------+----------------+-------------+------------
-----+--------------+-----------+----------------+-------------+-------------+--
----------+-------------------+----------------+----------------------+
| t | InnoDB | Dynamic | 1 | 16384 | 16384 |
NULL | 16384 | 0 | NULL | NULL | NULL | N
ULL | latin1_swedish_ci | | InnoDB free: 4096 kB |
+------+--------+------------+------+----------------+-------------+------------
-----+--------------+-----------+----------------+-------------+-------------+--
----------+-------------------+----------------+----------------------+
1 row in set (0.01 sec)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
