Details
-
Type:
Bug
-
Status:
Resolved
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: CMT8.4.1
-
Fix Version/s: CMT8.4.1.201203
-
Component/s: CUBRID Migration Toolkit
-
Labels:None
-
Environment:
CentOS 6, JDK 1.6.0_29
Description
I have MySQL database with the following two tables
CREATE TABLE `jm_finder_tokens` (
`term` varchar(75) NOT NULL,
`stem` varchar(75) NOT NULL,
`common` tinyint(1) unsigned NOT NULL DEFAULT '0',
`phrase` tinyint(1) unsigned NOT NULL DEFAULT '0',
`weight` float unsigned NOT NULL DEFAULT '1',
`context` tinyint(1) unsigned NOT NULL DEFAULT '2',
KEY `idx_word` (`term`),
KEY `idx_context` (`context`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8
CREATE TABLE `jm_finder_tokens_aggregate` (
`term_id` int(10) unsigned NOT NULL,
`map_suffix` char(1) NOT NULL,
`term` varchar(75) NOT NULL,
`stem` varchar(75) NOT NULL,
`common` tinyint(1) unsigned NOT NULL DEFAULT '0',
`phrase` tinyint(1) unsigned NOT NULL DEFAULT '0',
`term_weight` float unsigned NOT NULL,
`context` tinyint(1) unsigned NOT NULL DEFAULT '2',
`context_weight` float unsigned NOT NULL,
`total_weight` float unsigned NOT NULL,
KEY `token` (`term`),
KEY `keyword_id` (`term_id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8
When I try to use CMT to migrate those two tables, I get the following errors:
Index "idx_word" in table "jm_finder_tokens": Full text index is not supported in CUBRID.
Index "token" in table "jm_finder_tokens_aggregate": Full text index is not supported in CUBRID.
Details:
mysql> desc jm_finder_tokens;
-----------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
-----------------------------------------------+
| term | varchar(75) | NO | MUL | NULL | |
| stem | varchar(75) | NO | NULL | ||
| common | tinyint(1) unsigned | NO | 0 | ||
| phrase | tinyint(1) unsigned | NO | 0 | ||
| weight | float unsigned | NO | 1 | ||
| context | tinyint(1) unsigned | NO | MUL | 2 |
-----------------------------------------------+
mysql> desc jm_finder_tokens_aggregate;
------------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
------------------------------------------------------+
| term_id | int(10) unsigned | NO | MUL | NULL | |
| map_suffix | char(1) | NO | NULL | ||
| term | varchar(75) | NO | MUL | NULL | |
| stem | varchar(75) | NO | NULL | ||
| common | tinyint(1) unsigned | NO | 0 | ||
| phrase | tinyint(1) unsigned | NO | 0 | ||
| term_weight | float unsigned | NO | NULL | ||
| context | tinyint(1) unsigned | NO | 2 | ||
| context_weight | float unsigned | NO | NULL | ||
| total_weight | float unsigned | NO | NULL |
------------------------------------------------------+
10 rows in set (0.00 sec)
There are no full text indexes on those tables. So I guess it's a bug?