Bug #28928 | UNIX_TIMESTAMP() should be considered unary monotonic by partition pruning | ||
---|---|---|---|
Submitted: | 6 Jun 2007 14:03 | Modified: | 13 Jun 2011 13:21 |
Reporter: | Sergey Petrunya | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S3 (Non-critical) |
Version: | OS: | Any | |
Assigned to: | Mattias Jonsson | CPU Architecture: | Any |
[6 Jun 2007 14:03]
Sergey Petrunya
[22 Nov 2007 11:21]
Mattias Jonsson
In a future release there will be a function to_sec() for this use. UNIX_TIMESTAMP() is not unary monotonic, since it is only 32-bit and partitioning functions should be 64-bit. For large date it returns 0.
[4 Feb 2010 6:42]
Sveta Smirnova
Bug #50899 was marked as duplicate of this one.
[3 Feb 2011 16:41]
Laurent Bigonville
Hi, Now that UNIX_TIMESTAMP() is needed to partition by TIMESTAMP column, I guess that this bug must be reopened Cheers
[4 Feb 2011 13:07]
Mattias Jonsson
I'm resetting this to verified. There should be possible to support range pruning for UNIX_TIMESTAMP().
[4 Feb 2011 14:09]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/130417 3576 Mattias Jonsson 2011-02-04 Bug#28928: UNIX_TIMESTAMP() should be considered unary monotonic by partition pruning Preliminary patch to support range pruning for UNIX_TIMESTAMP. TODO: Fix the tests, add better tests.
[2 Mar 2011 4:56]
Lei Zou
Does any MySQL release contain the fix for bug 28928? Please advice. We need this patch badly. Thanks.
[16 Mar 2011 11:10]
Mattias Jonsson
The patch is not pushed to any production tree yet. I just recommitted the patch with more tests.
[29 Apr 2011 9:56]
Mattias Jonsson
Closed bug#60440 as a duplicate of this.
[7 Jun 2011 16:30]
Jean-Francois Dionne
Hi, any update on that? I'm pretty sure I'm not the only one waiting for the patch...
[13 Jun 2011 13:21]
Jon Stephens
Documented as follows in the 5.5.15 and 5.6.13 changelogs. The UNIX_TIMESTAMP() function was not treated an a monotonic function for purposes of partition pruning. Also updated info regarding functions in Partitioning Limitations. Closed.