> 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.
It's a bug. The Windows version of 4.1.0 will allow this, but it shouldn't. You should change your table to MyISAM, because it probably will be disallowed in 4.1.1.
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)
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
