Skip navigation links

MySQL Forums :: Partitioning :: ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes


Advanced Search

ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes
Posted by: chillyroll r ()
Date: April 17, 2009 06:07AM

Hi,

Below is my SHOW CREATE TABLE output:

CREATE TABLE `tbl_businesses_city` (
`business_id` int(20) NOT NULL AUTO_INCREMENT,
`business_name` varchar(255) CHARACTER SET latin1 NOT NULL,
`business_type_id` int(20) NOT NULL,
`business_user_id` bigint(20) NOT NULL,
`address1` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`address2` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`city_id` int(20) NOT NULL,
`state_code` varchar(2) CHARACTER SET latin1 DEFAULT NULL,
`zip_code` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
`business_phone` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
`business_secondary_phone` varchar(20) DEFAULT NULL,
`business_tertiary_phone` varchar(20) DEFAULT NULL,
`website` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`business_info` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`latitude` double DEFAULT '0',
`longitude` double DEFAULT '0',
`created_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`is_deleted` enum('Y','N') DEFAULT 'N',
`source_id` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`city` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`is_rated` char(1) DEFAULT 'N',
`source_key_id` varchar(50) NOT NULL,
`business_type_id_back` int(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`business_id`),
KEY `business_name` (`business_name`),
KEY `business_type_id` (`business_type_id`),
KEY `city_id` (`city_id`),
KEY `latitude` (`latitude`),
KEY `longitude` (`longitude`),
KEY `source_id` (`source_id`),
KEY `state_code` (`state_code`),
KEY `idx_zip_code` (`zip_code`),
FULLTEXT KEY `bus_name_type_fulltxt_idx` (`business_name`,`business_info`)
) ENGINE=MyISAM AUTO_INCREMENT=18020371 DEFAULT CHARSET=utf8 |

I am looking to partition this table on city_id but I am getting a below error when trying to create partitions.

mysql> alter table tbl_businesses_city partition by hash(city_id) partitions 4;
ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes

My table engine is MyISAM only. So not sure why is this popping up.

MySQL Version is 5.1.33-community.

Any idea?

Thanks

Options: ReplyQuote


Subject Views Written By Posted
ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes 10199 chillyroll r 04/17/2009 06:07AM
Re: ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes 5233 chillyroll r 04/17/2009 06:42AM


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.