full text index: Parsing sql failed, near "ADD_COLUMNAR_REPLICA_ON_DEMAND;"

[shawn0915]

Error Report

Please answer the following questions before submitting your issue. Thanks!

1. 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;" 

2. 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;

[Oreoxmt]

@breezewish Could you please take a look at this issue? Thanks

[breezewish]

Thank you, currently this SQL can only be executed for Serverless clusters via SQL command line, instead of Cloud SQL Editor. I will track and improve this experience and will let you know when the fix is arrived.