full text query macth not work

[foolishlittlefox]

_ = db.Use(sharding.Register(sharding.Config{
		ShardingKey:         "ymd",
		NumberOfShards:      100,
		PrimaryKeyGenerator: sharding.PKCustom,
		ShardingAlgorithm: func(columnValue any) (suffix string, err error) {
			parentId := cast.ToInt(columnValue)
			suffix = fmt.Sprintf("_%v", parentId)
			return
		},
		PrimaryKeyGeneratorFn: func(tableIdx int64) int64 {
			return 0
		},
		// This case for show up give notifications, audit_logs table use same sharding rule.
	}, ChatMsg{}))

qb.Where(fmt.Sprintf("(MATCH(body) AGAINST('%s'))", req.Key))

can not fond table

[huacnlee]

All query must include the sharding key.

You have used ymd column as the sharding key, but there is not include in there where conditions.

[foolishlittlefox]

This is the complete sql statement

SELECT * FROM t_chat_msg WHERE ymd = 202311 AND to = '1025359' AND (MATCH(body) AGAINST('在' IN BOOLEAN MODE)) LIMIT 20

I found that it should be caused by the sqlparser package not being able to correctly parse SQL statements.

[foolishlittlefox]

It should be that this statement was not parsed successfully.
expr, err := sqlparser.NewParser(strings.NewReader(query)).ParseStatement()

[huacnlee]

@hyperphoton 这个应该是 SQLParser 解析不了