"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.
-- 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]
