Difference between revisions of "MySQL Features & Bugs"
From ISoft Wiki
Jump to navigationJump to search
Daytonlowell (talk | contribs) |
Daytonlowell (talk | contribs) |
||
| Line 1: | Line 1: | ||
* '''Automatic Initialization and Updating for TIMESTAMP and DATETIME''': added in 5.6.5 [https://dev.mysql.com/doc/refman/5.6/en/timestamp-initialization.html Source] | * '''Automatic Initialization and Updating for TIMESTAMP and DATETIME''': added in 5.6.5 [https://dev.mysql.com/doc/refman/5.6/en/timestamp-initialization.html Source] | ||
** Additional Notes: | |||
<source lang="mysql"> | |||
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? | |||
</source> | |||
This seems like a bug, but it changed between devdb and cloud (so between 5.7.15 and 5.7.24) | |||
* '''Virtual/Generated Columns''': added in 5.7.9 [https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-9.html Source] | * '''Virtual/Generated Columns''': added in 5.7.9 [https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-9.html Source] | ||
* '''JSON Column Data Type''': added in 5.7.8 JSON Data Type: [https://dev.mysql.com/doc/refman/5.7/en/json.html Source] | * '''JSON Column Data Type''': added in 5.7.8 JSON Data Type: [https://dev.mysql.com/doc/refman/5.7/en/json.html Source] | ||
Revision as of 14:00, 18 December 2018
- Automatic Initialization and Updating for TIMESTAMP and DATETIME: added in 5.6.5 Source
- Additional Notes:
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)
