Bug #4036 | multiple SELECT DATE_FORMAT, incorrect results | ||
---|---|---|---|
Submitted: | 7 Jun 2004 12:41 | Modified: | 8 Jun 2004 10:04 |
Reporter: | Carl Franks | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 4.0.18-max-debug | OS: | Windows (Windows XP) |
Assigned to: | Sergei Glukhov | CPU Architecture: | Any |
[7 Jun 2004 12:41]
Carl Franks
[7 Jun 2004 12:55]
Carl Franks
Update: Have confirmed the same results using the latest binary, 4.0.20a-debug on Windows XP.
[7 Jun 2004 17:34]
Sergei Glukhov
bk commit into 3.23 tree (1.1441)
[8 Jun 2004 10:04]
Sergei Glukhov
The right bug comment should be 'DATE_FORMAT(time_column,...) - incorrect result'. The issue was that function DATE_FORMAT handled time column as date. fixed in 3.23 source tree.