"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. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
