Re: MySql Partitioning problem (bug?)

[Rick James]

You have discovered a reason why only RANGE partitioning is useful.

EXPLAIN is not at fault. It would take some smarts to understand that
WHERE test_id BETWEEN 1 AND 999
in only integers, and
(test_id DIV 1000)
would always generate "0" for those integers.

MySQL's partition pruning code is not up to that degree of intelligence.

And yet your Query 2 shows that it is even smart enough to do that, plus handle OR.

I suggest you post a bug (bugs.mysql.com), but rephrase it thus:
"If the pruning software can handle Query 2, why can't it handle Query 1?"