Note that the result is correct if I do "SET join_cache_level=0".
EXPLAIN shows that table t4 is "with LooseScan's range", and it uses join buffering.
Note that the result is correct if I do "SET join_cache_ level=0" .
EXPLAIN shows that table t4 is "with LooseScan's range", and it uses join buffering.