Difference between revisions of "MySQL Features & Bugs"
From ISoft Wiki
Jump to navigationJump to search
Daytonlowell (talk | contribs) m (Daytonlowell moved page MySQL Features to MySQL Features & Bugs) |
|
(No difference)
| |
Revision as of 12:27, 23 January 2019
Features
- Automatic Initialization and Updating for TIMESTAMP and DATETIME: added in 5.6.5 Source
- Virtual/Generated Columns: added in 5.7.9 Source
- JSON Column Data Type: added in 5.7.8 JSON Data Type: Source
Weird Bugs
DEFAULT NULL
x INT DEFAULT NULL #works in all versions
x TIMESTAMP DEFAULT NULL #works in some versions, and not in others
x TIMESTAMP NULL DEFAULT NULL #seems to work in all?
This seems like a bug, but it changed between devdb and cloud (so between 5.7.15 and 5.7.24)
LEFT JOINs act like JOINs sometimes when using ODBC date format
This is a bug in MySQL version 5.6.11 that affects Crystal reports.
5.6.10 and 5.6.12 are also affected. Reportedly, 5.5.31 is fine, and we know 5.6.20 is fine.
Updating to 5.6.20 solves the issue (See Fogbugz case 13362).
