pingcap / pingcap/tidb

match ... against report UnknownType: *ast.MatchAgainst

Open
#48,734 2 comments 0 reactions 0 assignees View on GitHub
sig/planner type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

create table t3 (
id int unsigned auto_increment not null primary key,
title VARCHAR(200),
body text,
fulltext (title,body)
);
nsert into t3 (title,body) values
('MySQL Tutorial','DBMS stands for DataBase ...'),
('How To Use MySQL Well','After you went through a ...'),
('Optimizing MySQL','In this tutorial we will show ...'),
('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
('MySQL vs. YourSQL','In the following database comparison ...'),
('MySQL Security','When configured properly, MySQL ...');

select * from t3 where match (title,body) against ('database');
### 2. What did you expect to see? (Required)
execute success.
### 3. What did you see instead (Required)
mysql> select * from t3 where match (title,body) against ('database');
ERROR 1105 (HY000): UnknownType: *ast.MatchAgainst
### 4. What is your TiDB version? (Required)

Release Version: v7.6.0-alpha-234-g3d176fcc2c
Edition: Community
Git Commit Hash: 3d176fcc2c46ce977b34fae87bc07b39ef77bf6d
Git Branch: master
UTC Build Time: 2023-11-21 02:53:06
GoVersion: go1.21.1
Race Enabled: false
Check Table Before Drop: false
Store: unistore

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.