MySQL Forums
Forum List  »  Merge Storage Engine

Is it true that MERGE tables don't support geometric data types?
Posted by: todd hodes
Date: February 08, 2005 07:08PM

in mysql Ver 14.3 Distrib 4.1.1-alpha, for pc-linux (i686)

given

create table geo1 (
`id` int(11) NOT NULL auto_increment,
`location` linestring NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

create table geo2 (
`id` int(11) NOT NULL auto_increment,
`location` linestring NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

then

create table geomerge (
`id` int(11) NOT NULL auto_increment,
`location` linestring NOT NULL default '',
KEY (`id`)
) ENGINE=MERGE DEFAULT CHARSET=utf8;

gives

ERROR 1178 (42000): The storage engine for the table doesn't support GEOMETRY

Is this true, that MERGE doesn't support geometric data types?
or is there a flaw in my MERGE command?

Options: ReplyQuote


Subject
Views
Written By
Posted
Is it true that MERGE tables don't support geometric data types?
6154
February 08, 2005 07:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.