Recommended Servers for MySQLThe world's most popular open source database
- 5.3 Key changes in MySQL 5.1 releases
- 5.3.1 Changes in MySQL 5.1.29 (11 October 2008)
- 5.3.2 Changes in MySQL 5.1.28 (28 August 2008)
- 5.3.3 Changes in MySQL 5.1.23 (29 January 2008)
- 5.3.4 Changes in MySQL 5.1.21 (16 August 2007)
- 5.3.5 Changes in MySQL 5.1.20 (25 June 2007)
- 5.3.6 Changes in MySQL 5.1.19 (25 May 2007)
- 5.3.7 Changes in MySQL 5.1.18 (08 May 2007)
- 5.3.8 Changes in MySQL 5.1.17 (04 April 2007)
- 5.3.9 Changes in MySQL 5.1.16 (26 February 2007)
- 5.3.10 Changes in MySQL 5.1.15 (25 January 2007)
- 5.3.11 Changes in MySQL 5.1.14 (05 December 2006)
- 5.3.12 Changes in MySQL 5.1.13 (Not released)
- 5.3.13 Changes in MySQL 5.1.12 (24 October 2006)
Functionality added or changed:
-
Incompatible Change:
INSERT DELAYEDis now downgraded to a normalINSERTif the statement uses functions that access tables or triggers, or that is called from a function or a trigger.This was done to resolve the following interrelated issues:
The server could abort or deadlock for
INSERT DELAYEDstatements for which another insert was performed implicitly (for example, via a stored function that inserted a row).A trigger using an
INSERT DELAYEDcaused the error INSERT DELAYED can't be used with table ... because it is locked with LOCK TABLES although the target table was not actually locked.INSERT DELAYEDinto a table with aBEFORE INSERTorAFTER INSERTtrigger gave an incorrectNEWpseudocolumn value and caused the server to deadlock or abort.
Bugs fixed:
Security Fix: UDFs are supposed to be loadable only from the plugin directory, but this restriction was not being enforced. (Bug#28341)
Security Fix: Use of a view could allow a user to gain update privileges for tables in other databases. (Bug#27878, CVE-2007-3782)