Add query SYSTEM DROP TEXT INDEX CACHES

Why it matters

This feature provides a way to explicitly clear cached data related to text indexes, helping to free memory or refresh index state without needing to restart the server. It is useful for managing text index caches during maintenance or troubleshooting.

How to use it

Users can run the following SQL command to drop all cached entries for text indexes:

SYSTEM DROP TEXT INDEX CACHES

This command clears all text index caches currently held in memory.