mysqltest: Query with SQL_CALC_FOUND_ROWS, use_merge, and parallel(1) triggers error 4016 in workarea.mem_mgr_views on Windows

[chyujing]

Environment

• Operating System: Windows
• Test Framework: mysqltest

Description

The mysqltest case workarea.mem_mgr_views triggers an error 4016 when executing a join query that uses the combination of SQL_CALC_FOUND_ROWS, use_merge, and parallel(1) hints.

Steps to Reproduce

1. Log on to the test machine.
2. Navigate to the directory: /obdata/data/AndroidTest/ob_opensource_test/tools/deploy
3. Execute the test.

Impact

Test failure due to error 4016.