Bug #31936 | Implicit DATETIME conversions work different on 5.0.24a vs. 5.0.45 | ||
---|---|---|---|
Submitted: | 30 Oct 2007 9:22 | Modified: | 15 Nov 2007 10:52 |
Reporter: | Tobias Asplund | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0, 5.1 BK | OS: | Linux |
Assigned to: | Alexey Botchkov | CPU Architecture: | Any |
Tags: | regression |
[30 Oct 2007 9:22]
Tobias Asplund
[30 Oct 2007 10:44]
Sveta Smirnova
Thank you for the report. Verified as described. Seems to be introduced by fix of bug #16546
[15 Nov 2007 10:52]
Alexey Botchkov
Expected behaviour. only this query should return nonempty result: SELECT * FROM t1 WHERE b = CAST(@b AS DATE); as it works.