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:Nov 24, 2023

    Problem description

    When I run SQL queries on my ApsaraDB RDS for MySQL instance, the following error message is displayed:

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

    Causes

    The maximum number of nested subqueries in a full-text search is set to 31 to fix a bug in MySQL 5.7.32. If the number of nested subqueries in a full-text search exceeds 31, this error is reported.

    Solutions

    Modify the SQL statement to reduce the number of nested subqueries in the full-text search to no more than 31.