full text index: Parsing sql failed, near "ADD_COLUMNAR_REPLICA_ON_DEMAND;"
Open
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 617
- Forks
- 724
- Avg merge
- 2d 10h
- Merged PRs (30d)
- 223
Description
Error Report
Please answer the following questions before submitting your issue. Thanks!
- What is the URL/path of the document related to this issue?
https://docs.pingcap.com/tidbcloud/vector-search-full-text-search-sql/
create table t_text (id int, ct text);
alter table t_text add fulltext index(ct) WITH PARSER MULTILINGUAL ADD_COLUMNAR_REPLICA_ON_DEMAND;
report error:
Parsing sql failed, Please check if sql syntax is correct, line 1 column 97 near "ADD_COLUMNAR_REPLICA_ON_DEMAND;"
- How would you like to improve it?
but this work:
ALTER TABLE t_text
SET TIFLASH REPLICA 2;
alter table t_text add fulltext index(ct) WITH PARSER MULTILINGUAL;
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Open the linked full-text search SQL documentation page and compare its CREATE TABLE and ALTER TABLE examples with the reported parser error. Check the documented syntax and the working two-step example, then update the page so the example uses supported SQL and verify that the revised statement parses successfully.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, documentation
- Issue type
- Documentation
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100