bug: mtr testcase failed

[hustjieke]

Describe the problem

29 testcases in test suite, 2 testcase include subquery failed:

mysqltest: At line 4: query 'select 1 from (select * from tt) as A join tt where A.val > 1 XOR tt.val > 2' failed: 6: The query includes 
syntax that is not supported by the storage engine. Either restructure the query with supported syntax, or enable the MySQL 
core::Query Path in config file to execute the query with reduced performance.

Expected behavior

Completed: All 29 tests were successful.

How To Reproduce

After make install:

$ cd /stonedb56/install
$ mkdir log
$ cd mysql-test
$./mysql-test-run.pl --suite=stonedb --force --no-warnings

Environment

• CentOS 7.5
• gcc 7.3

Additional context

[hustjieke]

As stonedb did not support subquery like select 1 from (select * from tt) as A join tt where A.val > 1 XOR tt.val > 2,
we should set stonedb_ini_allowmysqlquerypath=1 in config file to make the sql execute success, otherwise, mtr will not execute success.