Difference between revisions of "MySQL Features & Bugs"
From ISoft Wiki
Jump to navigationJump to search
Daytonlowell (talk | contribs) |
|||
| Line 5: | Line 5: | ||
==Weird Bugs== | ==Weird Bugs== | ||
===DEFAULT NULL=== | |||
<source lang="mysql"> | <source lang="mysql"> | ||
x INT DEFAULT NULL #works in all versions | x INT DEFAULT NULL #works in all versions | ||
| Line 11: | Line 12: | ||
</source> | </source> | ||
This seems like a bug, but it changed between devdb and cloud (so between 5.7.15 and 5.7.24) | 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 [https://bugs.mysql.com/bug.php?id=69233 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). | |||
Revision as of 12:04, 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).
