> 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
See:
http://www.mysql.com/doc/en/Creating_spatial_columns.html
I'll add a note to the beginning of the chapter as well to make this more obvious.
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)
My guess is that the table type may not really be InnoDB. What does SHOW CREATE TABLE t or SHOW TABLE STATUS LIKE 't' say?
-- 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]