> At 19:16 +0300 9/29/03, Victoria Reznichenko wrote:
> >"G B U" <[EMAIL PROTECTED]> wrote:
> >>
> >> It seems to me that combination from the subject just doesn't work.
> >> Every time I try to incorporate spatial column into Innodb table
> >> Mysql dies. The simplest case, easy to repeat is bellow.
> >> When I'm trying to create table with just one spatial column I'm
> >> getting following error:
> >>
> >> mysql> create table t (p polygon not null, spatial index(p)) type=innodb;
> >> ERROR 2013: Lost connection to MySQL server during query
> >>
> >> In error log mysql writes:
> >>
> >> assertion "0" failed: file "ha_innodb.cc", line 1547
> >> 030929 16:52:24 mysqld restarted
> >>
> >> I have two identical systems and both demonstrate behaviour
> >> described above.
> >>
> >> About systems config.
> >> Mysql: Version: '4.1.0-alpha'
> >> OS: FreeBSD 4.8-RELEASE
> >>
> >> So could someone test this and confirm or disconfirm above-mentioned
> >> abnormal behaviour.
> >>
> >
> >Currently you can use spatial columns only in the MyISAM tables.
>
>
> Also, the crash described above is fixed in MySQL 4.1.1. GIS features
> still are available only in MyISAM (as Victoria notes), but attempting
> to use them with InnoDB won't cause loss of connection or server restart.
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)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
