MySQL Bugs: #115977: FTS query exceeds result cache limit on MySQL 8.0.39

Bug #115977	FTS query exceeds result cache limit on MySQL 8.0.39
Submitted:	2 Sep 5:52	Modified:	2 Sep 13:09
Reporter:	SelvaKumar K	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	8.0.39	OS:	Ubuntu (Ubuntu 22.04.4 LTS)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any (Ubuntu 22.04.4 LTS)

Description:
Hi Team,

We have migrated customer from phpmyadmin environment to AWS Cloud . We have installed MySQL in EC2 instance with version of 8.0.39 . We have more data with text columns . 

Previously they are using MyISAM engine in php console , we suggested go with InnoDB . Here when we are searching with Full Text Index keep getting this issue on 8.0.39 

How to repeat:
Insert around 15k records with 30 characters length in text column . Then Search with below method , 

select id,sb_date_india_export from indiaexport where (MATCH(indian_exporter_name_india_export) AGAINST('"RAMRAM FLOWERS Export PRIVATE"'  IN BOOLEAN MODE)) limit 0,50

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.

Hi Team,

Am not asking help here , facing this issue past two weeks even tried all the possibilites same issue happening