MySQL Forums
Forum List  »  Full-Text Search

Fulltext index disabled after insert...select..
Posted by: Martin Feng
Date: July 24, 2006 01:49AM

The SQL code is like this:

CREATE TABLE TBL_TMPFULLTEXTCOLUMNS
(
COL_TEXTID INT UNSIGNED NOT NULL,
COL_TEXT MEDIUMTEXT NOT NULL,
COL_TITLE VARCHAR(256) NOT NULL,
PRIMARY KEY (COL_TEXTID),
FULLTEXT IDX_TITLE_TEXT (COL_TITLE, COL_TEXT)
) ENGINE = MyISAM,
DELAY_KEY_WRITE = 1;

INSERT IGNORE TBL_TMPFULLTEXTCOLUMNS (COL_TEXTID, COL_TEXT, COL_TITLE)
SELECT t.COL_TEXTID, t.COL_TEXT, t.COL_TITLE
FROM ...;

Then 'show index from TBL_TMPFULLTEXTCOLUMNS' shows that IDX_TITLE_TEXT is disabled. I need to run 'alter table enable keys' to enable the full text index.

Is this a bug or designed behavior?


------------------------------
My environment:

MySQL 5.0.22, installed from MySQL-server-standard-5.0.22-0.rhel4.i386.rpm and MySQL-Max-5.0.22-0.i386.rpm,
OS: CentOS 4.3
DB: CHARACTER SET utf8 COLLATE utf8_general_ci

Options: ReplyQuote


Subject
Views
Written By
Posted
Fulltext index disabled after insert...select..
5515
July 24, 2006 01:49AM


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.