注册

全文检索rebuild失败,错误-3205: 全文索引词库加载出错

DM_606334 2022/08/17 960 8 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:–03134283890-20220525-161267-10045 Pack7
【操作系统】:麒麟V10
【CPU】:X86
【问题描述】*:全文索引创建成功,但在rebuild提示词库出错。
实验如下:
create table ADDRESS
(
ADDRESSID INT IDENTITY(1,1) PRIMARY KEY,
ADDRESS1 VARCHAR(60) NOT NULL,
ADDRESS2 VARCHAR(60),
CITY VARCHAR(30) NOT NULL,
POSTALCODE VARCHAR(15) NOT NULL
) ;
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘洪山区369号金地太阳城56-1-202’,‘’,‘武汉市洪山区’,‘430073’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘洪山区369号金地太阳城57-2-302’,‘’,‘武汉市洪山区’,‘430073’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘青山区青翠苑1号’,‘’,‘武汉市青山区’,‘430080’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘武昌区武船新村115号’,‘’,‘武汉市武昌区’,‘430063’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘汉阳大道熊家湾15号’,‘’,‘武汉市汉阳区’,‘430050’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘洪山区保利花园50-1-304’,‘’,‘武汉市洪山区’,‘430073’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘洪山区保利花园51-1-702’,‘’,‘武汉市洪山区’,‘430073’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘洪山区关山春晓51-1-702’,‘’,‘武汉市洪山区’,‘430073’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘江汉区发展大道561号’,‘’,‘武汉市江汉区’,‘430023’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘江汉区发展大道555号’,‘’,‘武汉市江汉区’,‘430023’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘武昌区武船新村1号’,‘’,‘武汉市武昌区’,‘430063’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘江汉区发展大道423号’,‘’,‘武汉市江汉区’,‘430023’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘洪山区关山春晓55-1-202’,‘’,‘武汉市洪山区’,‘430073’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘洪山区关山春晓10-1-202’,‘’,‘武汉市洪山区’,‘430073’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘洪山区关山春晓11-1-202’,‘’,‘武汉市洪山区’,‘430073’);
INSERT INTO ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES(‘洪山区光谷软件园C1_501’,‘’,‘武汉市洪山区’,‘430073’);

CREATE CONTEXT INDEX cindex ON test.ADDRESS(ADDRESS1) LEXER DEFAULT_LEXER SYNC;
执行失败(语句1)
-3205: 全文索引词库加载出错

1条语句执行失败

回答 0
暂无回答
扫一扫
联系客服