I'm running TiDB with TiFlash and trying to get queries like SELECT a FROM t WHERE t.a 1 OR t.a IN…

I'm running TiDB with TiFlash and trying to get queries like SELECT a FROM t WHERE t.a 1 OR t.a IN…: a task in MiMo-V2.6-RL-oss: Agentic RL Environments (MiMo RL release). Problem Statement I'm running TiDB with TiFlash and trying to get queries like SELECT a FROM t WHERE t.a 1 OR t.a IN (SELECT a…

The task

Problem Statement I'm running TiDB with TiFlash and trying to get queries like SELECT a FROM t WHERE t.a > 1 OR t.a IN (SELECT a FROM t) (and the NOT IN variant) to run in MPP mode, but EXPLAIN keeps showing a root-level join and I get a warning saying MPP is blocked because…

Part of XiaomiMiMo/MiMo-V2.6-RL-oss.