Why Does "PARTITION BY HASH MONTH(date_column) PARTITIONS 12" Put December Dates into Partition `p0` ?
(Doc ID 2958688.1)
Last updated on JULY 01, 2023
Applies to:
MySQL Server - Version 8.0 and laterInformation in this document applies to any platform.
Goal
The partition number is picked by doing a MODULUS operation on the MONTH. Hence for December, 12 MOD 12 is 0, so p0 is chosen.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |