Bug #43669 | Falcon returns diff. no of digits than other engines with MIN() for YEAR values | ||
---|---|---|---|
Submitted: | 16 Mar 2009 9:16 | Modified: | 19 Nov 2013 18:19 |
Reporter: | Nidhi Shrotriya | Email Updates: | |
Status: | Unsupported | Impact on me: | |
Category: | MySQL Server: Data Types | Severity: | S3 (Non-critical) |
Version: | 6.0.11 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | data types |
[16 Mar 2009 9:16]
Nidhi Shrotriya
[16 Mar 2009 9:17]
Nidhi Shrotriya
Test Case
Attachment: insert_year_bug_falcon_43669.test (application/octet-stream, text), 2.36 KiB.
[16 Mar 2009 10:27]
Sveta Smirnova
Thank you for the report. Verified as described. Workaround: use one of format functions.
[28 Apr 2009 15:12]
Lars-Erik Bjørk
This seems to be very much related to bug#43668. If we remove the index from the table, the result will be the same for MyISAM as for Falcon. It seems that the output format depends on the access method used. I will look more closely into this tomorrow.
[29 Apr 2009 8:13]
Lars-Erik Bjørk
When no index is present, both MyISAM and InnoDB has the same output format as Falcon. Falcon has the same output format both when an index is present and not, as the index is not used by the server. I am tempted to say that this is not a Falcon bug, but probably a server bug, if a bug at all.
[19 Nov 2013 14:34]
Manyi Lu
Posted by developer: Falcon is no longer a supported engine.