Toad reports an error for Full-Text Search JSON index (available since 12.2)

Hi

Toad 14.1.120.923

Noticed that Toad reports an error for the following statement. But actually this is valid syntax and execution succeeds.

Basically this syntax is valid from 12.2 onwards for json full text search indexes.

-- 12.1 syntax
CREATE INDEX TOIMINGUD_JSON_SISU ON TOIMINGUD (JSON_SISU) INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('LEXER MYLEX SECTION GROUP CTXSYS.JSON_SECTION_GROUP SYNC (ON COMMIT)');

-- 12.2 syntax
CREATE SEARCH INDEX TOIMINGUD_JSON_SISU ON TOIMINGUD (JSON_SISU) FOR JSON;

Regards
Raul

Thanks. I see it's still flagged as invalid syntax in Toad 15.1

1 Like