MySQL :: MySQL 5.0 Reference Manual :: C.1 Changes in Release 5.0.x (Production)

MySQL 5.0 Reference Manual :: C MySQL Change History :: C.1 Changes in Release 5.0.x (Production)

C.1.1 Changes in MySQL 5.0.90 (15 January 2010) »

Section Navigation [Toggle]

C.1. Changes in Release 5.0.x (Production)

C.1.1. Changes in MySQL 5.0.90 (15 January 2010)
C.1.2. Changes in MySQL 5.0.89 (02 December 2009)
C.1.3. Changes in MySQL 5.0.88 (04 November 2009)
C.1.4. Release Notes for MySQL Enterprise 5.0.87sp1 [QSP] (03 February 2010)
C.1.5. Changes in MySQL 5.0.87 (15 October 2009)
C.1.6. Changes in MySQL 5.0.86 (09 September 2009)
C.1.7. Changes in MySQL 5.0.85 (11 August 2009)
C.1.8. Release Notes for MySQL Enterprise 5.0.84sp1 [QSP] (30 September 2009)
C.1.9. Changes in MySQL 5.0.84 (07 July 2009)
C.1.10. Changes in MySQL 5.0.83 (29 May 2009)
C.1.11. Release Notes for MySQL Enterprise 5.0.82sp1 [QSP] (21 July 2009)
C.1.12. Changes in MySQL 5.0.82 (20 May 2009)
C.1.13. Release Notes for MySQL Community Server 5.0.81 (01 May 2009)
C.1.14. Release Notes for MySQL Enterprise 5.0.80 [MRU] (01 May 2009)
C.1.15. Release Notes for MySQL Enterprise 5.0.79 [MRU] (09 March 2009)
C.1.16. Release Notes for MySQL Enterprise 5.0.78 [MRU] (06 February 2009)
C.1.17. Release Notes for MySQL Community Server 5.0.77 (28 January 2009)
C.1.18. Release Notes for MySQL Enterprise 5.0.76 [MRU] (05 January 2009)
C.1.19. Release Notes for MySQL Community Server 5.0.75 (17 December 2008)
C.1.20. Release Notes for MySQL Enterprise 5.0.74sp1 [QSP] (30 April 2009)
C.1.21. Release Notes for MySQL Enterprise 5.0.74 [MRU] (03 December 2008)
C.1.22. Release Notes for MySQL Enterprise 5.0.72sp1 [QSP] (13 January 2009)
C.1.23. Release Notes for MySQL Enterprise 5.0.72 [MRU] (24 October 2008)
C.1.24. Release Notes for MySQL Enterprise 5.0.70 [MRU] (27 September 2008)
C.1.25. Release Notes for MySQL Enterprise 5.0.68 [MRU] (13 August 2008)
C.1.26. Release Notes for MySQL Community Server 5.0.67 (04 August 2008)
C.1.27. Release Notes for MySQL Enterprise 5.0.66sp1 [QSP] (23 October 2008)
C.1.28. Release Notes for MySQL Enterprise 5.0.66a [MRU] (16 July 2008)
C.1.29. Release Notes for MySQL Enterprise 5.0.66 [MRU] (09 July 2008)
C.1.30. Release Notes for MySQL Enterprise 5.0.64 [MRU] (10 June 2008)
C.1.31. Release Notes for MySQL Enterprise 5.0.62 [MRU] (12 May 2008)
C.1.32. Release Notes for MySQL Enterprise 5.0.60sp1 [QSP] (27 June 2008)
C.1.33. Release Notes for MySQL Enterprise 5.0.60 [MRU] (28 April 2008)
C.1.34. Release Notes for MySQL Enterprise 5.0.58 [MRU] (05 March 2008)
C.1.35. Release Notes for MySQL Enterprise 5.0.56sp1 [QSP] (30 March 2008)
C.1.36. Release Notes for MySQL Enterprise 5.0.56 [MRU] (06 February 2008)
C.1.37. Release Notes for MySQL Enterprise 5.0.54a [MRU] (11 January 2008)
C.1.38. Release Notes for MySQL Enterprise 5.0.54 [MRU] (14 December 2007)
C.1.39. Release Notes for MySQL Enterprise 5.0.52 [MRU] (30 November 2007)
C.1.40. Release Notes for MySQL Community Server 5.0.51b (24 April 2008)
C.1.41. Release Notes for MySQL Community Server 5.0.51a (11 January 2008)
C.1.42. Release Notes for MySQL Community Server 5.0.51 (15 November 2007)
C.1.43. Release Notes for MySQL Enterprise 5.0.50sp1a [QSP] (11 January 2008)
C.1.44. Release Notes for MySQL Enterprise 5.0.50sp1 [QSP] (12 December 2007)
C.1.45. Release Notes for MySQL Enterprise 5.0.50 [MRU] (19 October 2007)
C.1.46. Release Notes for MySQL Enterprise 5.0.48 [MRU] (27 August 2007)
C.1.47. Release Notes for MySQL Enterprise 5.0.46 [MRU] (13 July 2007)
C.1.48. Release Notes for MySQL Community Server 5.0.45 (04 July 2007)
C.1.49. Release Notes for MySQL Enterprise 5.0.44sp1 [QSP] (01 August 2007)
C.1.50. Release Notes for MySQL Enterprise 5.0.44 [MRU] (21 June 2007)
C.1.51. Release Notes for MySQL Enterprise 5.0.42 [MRU] (23 May 2007)
C.1.52. Release Notes for MySQL Community Server 5.0.41 (01 May 2007)
C.1.53. Release Notes for MySQL Enterprise 5.0.40 [MRU] (17 April 2007)
C.1.54. Release Notes for MySQL Enterprise 5.0.38 [MRU] (20 March 2007)
C.1.55. Release Notes for MySQL Community Server 5.0.37 (27 February 2007)
C.1.56. Release Notes for MySQL Enterprise 5.0.36sp1 [QSP] (12 April 2007)
C.1.57. Release Notes for MySQL Enterprise 5.0.36 [MRU] (20 February 2007)
C.1.58. Release Notes for MySQL Enterprise 5.0.34 [MRU] (17 January 2007)
C.1.59. Release Notes for MySQL Community Server 5.0.33 (09 January 2007)
C.1.60. Release Notes for MySQL Enterprise 5.0.32 [MRU] (20 December 2006)
C.1.61. Release Notes for MySQL Enterprise 5.0.30sp1 [QSP] (19 January 2007)
C.1.62. Release Notes for MySQL Enterprise 5.0.30 [MRU] (14 November 2006)
C.1.63. Release Notes for MySQL Enterprise 5.0.28 (24 October 2006)
C.1.64. Release Notes for MySQL Community Server 5.0.27 (21 October 2006)
C.1.65. Changes in MySQL 5.0.26 (03 October 2006)
C.1.66. Changes in MySQL 5.0.25 (15 September 2006)
C.1.67. Changes in MySQL 5.0.24a (25 August 2006)
C.1.68. Changes in MySQL 5.0.24 (27 July 2006)
C.1.69. Changes in MySQL 5.0.23 (Not released)
C.1.70. Changes in MySQL 5.0.22 (24 May 2006)
C.1.71. Changes in MySQL 5.0.21 (02 May 2006)
C.1.72. Changes in MySQL 5.0.20a (18 April 2006)
C.1.73. Changes in MySQL 5.0.20 (31 March 2006)
C.1.74. Changes in MySQL 5.0.19 (04 March 2006)
C.1.75. Changes in MySQL 5.0.18 (21 December 2005)
C.1.76. Changes in MySQL 5.0.17 (14 December 2005)
C.1.77. Changes in MySQL 5.0.16 (10 November 2005)
C.1.78. Changes in MySQL 5.0.15 (19 October 2005 Production)
C.1.79. Changes in MySQL 5.0.14 (Not released)
C.1.80. Changes in MySQL 5.0.13 (22 September 2005 Release Candidate)
C.1.81. Changes in MySQL 5.0.12 (02 September 2005)
C.1.82. Changes in MySQL 5.0.11 (06 August 2005)
C.1.83. Changes in MySQL 5.0.10 (27 July 2005)
C.1.84. Changes in MySQL 5.0.9 (15 July 2005)
C.1.85. Changes in MySQL 5.0.8 (Not released)
C.1.86. Changes in MySQL 5.0.7 (10 June 2005)
C.1.87. Changes in MySQL 5.0.6 (26 May 2005)
C.1.88. Changes in MySQL 5.0.5 (Not released)
C.1.89. Changes in MySQL 5.0.4 (16 April 2005)
C.1.90. Changes in MySQL 5.0.3 (23 March 2005 Beta)
C.1.91. Changes in MySQL 5.0.2 (01 December 2004)
C.1.92. Changes in MySQL 5.0.1 (27 July 2004)
C.1.93. Changes in MySQL 5.0.0 (22 December 2003 Alpha)

End of Product Lifecycle. Active development and support for MySQL Database Server version 5.0 has ended. However, there is still extended support available. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. According to the MySQL Lifecycle Policy (see http://www.mysql.com/about/legal/lifecycle/#policy), only Security and Severity Level 1 issues will still be fixed for MySQL 5.0. Please consider upgrading to a recent version.

An overview of which features were added in MySQL 5.0 can be found here: Section 1.5, “What Is New in MySQL 5.0”. The list following summarizes what has been done in the 5.0 tree.

For a full list of changes, please refer to the changelog sections for each individual 5.0 release.

For discussion of upgrade issues that you many encounter for upgrades to MySQL 5.0 from MySQL 4.1, see Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”.

VARCHAR and VARBINARY columns retain trailing spaces. A VARCHAR() or VARBINARY column can contain up to 65,535 characters or bytes, respectively.
Strict SQL mode, which causes an error instead of a warning when inserting an incorrect value into a column. See Section 5.1.7, “Server SQL Modes”.
A new fixed-point math library supports precision math, resulting in more accurate results when working with the DECIMAL and NUMERIC data types. For details, see Section 11.13, “Precision Math”.
Basic support for views. See Section 18.4, “Using Views”.
Basic support for stored procedures and functions (SQL:2003 style). See Section 18.2, “Using Stored Routines (Procedures and Functions)”.
Basic support for triggers. See Section 18.3, “Using Triggers”.
Basic support for read-only server side cursors. For information about using cursors within stored routines, see Section 12.7.5, “Cursors”. For information about using cursors from within the C API, see Section 20.8.7.3, “mysql_stmt_attr_set()”.
Support for SELECT INTO list_of_vars, where the variables can be a mix of global and local types. See Section 12.7.3.3, “SELECT ... INTO Statement”.
MEMORY (HEAP) tables can have VARCHAR columns.
When using a constant string or a function that generates a string result in CREATE ... SELECT, MySQL creates the result column based on the maximum length of the string or expression:

Maximum Length Data type

= 0 CHAR(0)

< 512 VARCHAR(max_length)

>= 512 TEXT
Removed the update log. It is fully replaced by the binary log. If the MySQL server is started with --log-update, it is translated to --log-bin (or ignored if the server is explicitly started with --log-bin), and a warning message is written to the error log. Setting sql_log_update silently sets sql_log_bin instead (or do nothing if the server is explicitly started with --log-bin).
Removed support for the ISAM storage engine. If you have ISAM tables, you should convert them before upgrading. See Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”.
Removed support for RAID options in MyISAM tables. If you have tables that use these options, you should convert them before upgrading. See Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”.

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents

Maximum Length	Data type
= 0	`CHAR(0)`
< 512	`VARCHAR(max_length)`
>= 512	`TEXT`