MySQL Features & Bugs - Revision history

Daytonlowell at 20:41, 14 July 2022

2022-07-14T20:41:24Z

← Older revision		Revision as of 15:41, 14 July 2022
Line 15:		Line 15:
	This is [https://bugs.mysql.com/bug.php?id=69233 a bug in at least MySQL versions 5.6.10 - 5.6.21] that affects Crystal reports.		This is [https://bugs.mysql.com/bug.php?id=69233 a bug in at least MySQL versions 5.6.10 - 5.6.21] that affects Crystal reports.
	<br>Reportedly, 5.5.31 is fine, and we know 5.6.22 and 5.7.6 have the bug fix (See Fogbugz {{case\|13362}}).		<br>Reportedly, 5.5.31 is fine, and we know 5.6.22 and 5.7.6 have the bug fix (See Fogbugz {{case\|13362}}).

			https://bugs.mysql.com/bug.php?id=97067

Daytonlowell: /* LEFT JOINs act like JOINs sometimes when using ODBC date format */

2020-11-18T14:52:27Z

LEFT JOINs act like JOINs sometimes when using ODBC date format

← Older revision		Revision as of 09:52, 18 November 2020
Line 13:		Line 13:
	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===		===LEFT JOINs act like JOINs sometimes when using ODBC date format===
	This is [https://bugs.mysql.com/bug.php?id=69233 a bug in at least MySQL versions 5.6.10 - 5.6.12] that affects Crystal reports.		This is [https://bugs.mysql.com/bug.php?id=69233 a bug in at least MySQL versions 5.6.10 - 5.6.21] that affects Crystal reports.
	<br>Reportedly, 5.5.31 is fine, and we know 5.6.~~20 has~~ the bug fix (See Fogbugz {{case\|13362}}).		<br>Reportedly, 5.5.31 is fine, and we know 5.6.22 and 5.7.6 have the bug fix (See Fogbugz {{case\|13362}}).

Daytonlowell at 19:58, 15 March 2019

2019-03-15T19:58:53Z

← Older revision		Revision as of 14:58, 15 March 2019
Line 14:		Line 14:
	===LEFT JOINs act like JOINs sometimes when using ODBC date format===		===LEFT JOINs act like JOINs sometimes when using ODBC date format===
	This is [https://bugs.mysql.com/bug.php?id=69233 a bug in at least MySQL versions 5.6.10 - 5.6.12] that affects Crystal reports.		This is [https://bugs.mysql.com/bug.php?id=69233 a bug in at least MySQL versions 5.6.10 - 5.6.12] that affects Crystal reports.
	<br>Reportedly, 5.5.31 is fine, and we know 5.6.20 has the bug fix (See Fogbugz case 13362).		<br>Reportedly, 5.5.31 is fine, and we know 5.6.20 has the bug fix (See Fogbugz {{case\|13362}}).

Daytonlowell: /* LEFT JOINs act like JOINs sometimes when using ODBC date format */

2019-03-15T19:57:46Z

LEFT JOINs act like JOINs sometimes when using ODBC date format

← Older revision		Revision as of 14:57, 15 March 2019
Line 13:		Line 13:
	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===		===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.		This is [https://bugs.mysql.com/bug.php?id=69233 a bug in at least MySQL versions 5.6.10 - 5.6.12] that affects Crystal reports.
	<br>~~5.6.10 and 5.6.12 are also affected.~~ Reportedly, 5.5.31 is fine, and we know 5.6.20 ~~is fine.~~		<br>Reportedly, 5.5.31 is fine, and we know 5.6.20 has the bug fix (See Fogbugz case 13362).
	~~<br>Updating to 5.6.20 solves~~ the ~~issue~~ (See Fogbugz case 13362).

Daytonlowell: Daytonlowell moved page MySQL Features to MySQL Features & Bugs

2019-01-23T18:27:41Z

Daytonlowell moved page MySQL Features to MySQL Features & Bugs

← Older revision	Revision as of 13:27, 23 January 2019
(No difference)

Jbonge at 18:06, 23 January 2019

2019-01-23T18:06:07Z

← Older revision		Revision as of 13:06, 23 January 2019
Line 13:		Line 13:
	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===		===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.		This is [https://bugs.mysql.com/bug.php?id=69233 a bug in MySQL version 5.6.11] that affects Crystal reports.
	Updating to 5.6.20 solves the issue (See Fogbugz case 13362).		<br>5.6.10 and 5.6.12 are also affected. Reportedly, 5.5.31 is fine, and we know 5.6.20 is fine.
			<br>Updating to 5.6.20 solves the issue (See Fogbugz case 13362).

Jbonge at 18:04, 23 January 2019

2019-01-23T18:04:57Z

← Older revision		Revision as of 13:04, 23 January 2019
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).

Daytonlowell at 20:52, 18 December 2018

2018-12-18T20:52:17Z

← Older revision		Revision as of 15:52, 18 December 2018
Line 1:		Line 1:
			==Features==
	* '''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~~:		* '''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]

			==Weird Bugs==
	<source lang="mysql">		<source lang="mysql">
	x INT DEFAULT NULL #works in all versions		x INT DEFAULT NULL #works in all versions
Line 7:		Line 11:
	</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)
	* '''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]

Daytonlowell at 20:00, 18 December 2018

2018-12-18T20:00:06Z

← Older revision		Revision as of 15:00, 18 December 2018
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]

Daytonlowell at 19:56, 18 December 2018

2018-12-18T19:56:41Z

← Older revision		Revision as of 14:56, 18 December 2018
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]
	* '''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]