WL#3481: Partitioning: Add support for temporal data types
Affects: Server-7.1 — Status: Un-Assigned — Priority: Medium
MySQL will implement support for partitioning using temporal data types (DATE, TIME, TIMESTAMP and DATETIME), as well as support for partitioning using all functions that return a temporally-related value (e.g. QUARTER(), MONTH(), WEEK(), YEARWEEK()). Support for partitioning using temporal data types is implemented by support for general data types as is performed by WL#3352. So I suggest using this worklog for extending the support for partition functions with temporal content. These functions need to be strictly non-decreasing. Thus YEARWEEK will be ok, QUARTER, MONTH and WEEK will not, thus we should new functions YEARQUARTER and YEARMONTH and make those able to perform range based partition pruning. See also BUG#13436 Partitions: most data types don't work.
Copyright (c) 2000, 2017, Oracle Corporation and/or its affiliates. All rights reserved.