这被证明是新查询优化中的一个错误，但我能够通过禁用服务器上的一些优化找到解决方法.

This proved to be a bug in the new query optimizations, but I was able to find a workaround by disabling some of the optimizations on the server.

这是我使用的命令:

Set global optimizer_switch='derived_merge=off,subquery_to_derived=off,prefer_ordering_index=off,semijoin=off';

希望在他们修复错误之前它会有所帮助.

Hope it helps until they fix the bug.