Re: Query to a partitioned table using all partitions

[Rick James]

I suspect it is "not a bug" because any range of days would be complex to work with in BY RANGE(DAY(...)) -- it might wrap the list of partitions, it might include all partitions if, for example, you say
WHERE date BETWEEN NOW() - INTERVAL 44 DAY AND NOW()

BY RANGE(TO_DAYS(...)), instead always produces a simple range of partitions.

You could counter-argue that that was being lazy; maybe you would be right. Since there are dozens (hundreds?) of different cases that it fails to handle as a human might desire, I suspect it was a deliberate simplification.