CREATE INDEX Document Code Error

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: CREATE INDEX 文档代码错误

| username: OnTheRoad

Documentation Error: Please provide feedback using the template below

The compatibility section states “Does not support FULLTEXT, HASH, and SPATIAL indexes.” However, in the syntax diagram of the CREATE INDEX code, branches for SPATIAL and FULLTEXT syntax are included.

2
| username: ShawnYan | Original post link

I think this should be fine. It doesn’t support fulltext, but it supports this syntax:

(root@127.1) [test] 08:56:57> create fulltext index idx on t1 (name);
ERROR 8200 (HY000): FULLTEXT and SPATIAL index is not supported
(root@127.1) [test] 08:57:27> create fulltext2 index idx on t1 (name);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 16 near "fulltext2 index idx on t1 (name)"
3
| username: OnTheRoad | Original post link

It supports this syntax, but does not support this type of index. So does the support for this syntax have no significance? Isn’t this contradictory?

4
| username: ShawnYan | Original post link

I can only say that it is a feature that needs improvement, but the syntax parser is supported, it just can’t be executed yet.

Related issues:

5
| username: OnTheRoad | Original post link

The documentation should match the product version. This makes it easier for users to refer to. At least, I’ve never seen Oracle 12c using Oracle 19c documentation. :grin:

6
| username: Billmay表妹 | Original post link

I will provide some feedback~

7
| username: Billmay表妹 | Original post link

The specific PR can be seen at:

Documentation update sql: update sql-statement-create-index.md by qiancai · Pull Request #11376 · pingcap/docs-cn · GitHub

8
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.