Fulltext index disabled after insert...select..
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
Subject
Views
Written By
Posted
Fulltext index disabled after insert...select..
5515
July 24, 2006 01:49AM
2457
July 26, 2006 12:10AM
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.