Bug #72222 | Strange interaction of SQL_MODE=ANSI and partition by TIMESTAMP | ||
---|---|---|---|
Submitted: | 3 Apr 2014 14:21 | Modified: | 3 Apr 2014 16:42 |
Reporter: | Hartmut Holzgraefe | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S3 (Non-critical) |
Version: | mysql-5.5.35; mysql-5.6.16 | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[3 Apr 2014 14:21]
Hartmut Holzgraefe
[3 Apr 2014 14:27]
Hartmut Holzgraefe
The problem seems to be in the ansi qotes in PARTITION BY RANGE ( UNIX_TIMESTAMP("t")) only, when removing these everything works fine
[3 Apr 2014 16:42]
MySQL Verification Team
Thank you for the bug report. Verified as described.