mysqltest case subquery.rqg_subquery_semijoin_mismatch fails with error 4016 on Windows

[chyujing]

Description

During mysqltest execution on Windows, the test case subquery.rqg_subquery_semijoin_mismatch fails. The specific query pattern involves DISTINCT, LEFT JOIN, and an IN subquery containing ORDER BY and a self-join on table D. This query execution results in error code 4016.

Steps to Reproduce

1. On the test machine, navigate to the directory: /obdata/data/AndroidTest/ob_opensource_test/tools/deploy.
2. Execute the relevant mysqltest, which triggers the subquery.rqg_subquery_semijoin_mismatch case.

Environment

• Operating System: Windows
• Test Case: subquery.rqg_subquery_semijoin_mismatch
• Error Code: 4016