All Products
Search

This Product

    ApsaraDB RDS:The "ERROR 202 (HY000): Too many nested sub-expressions in a full-text search" error message is displayed when I use my ApsaraDB RDS for MySQL instance. What do I do?

    Document Center

    ApsaraDB RDS:The "ERROR 202 (HY000): Too many nested sub-expressions in a full-text search" error message is displayed when I use my ApsaraDB RDS for MySQL instance. What do I do?

    Last Updated:Mar 28, 2026

    Problem description

    When running SQL queries on an ApsaraDB RDS for MySQL instance, the following error is returned:

    ERROR 202 (HY000): Too many nested sub-expressions in a full-text search

    Cause

    MySQL 5.7.32 introduced a hard limit of 31 nested subqueries in a full-text search to fix a bug in that release. If your SQL statement exceeds this limit, ERROR 202 (HY000) is returned.

    Solution

    Rewrite the SQL statement so that the number of nested subqueries in the full-text search is no more than 31.