Apéndice C. Historial de cambios de MySQL

MySQL 5.0

previous page next page

Apéndice C. Historial de cambios de MySQL

Tabla de contenidos

C.1. Cambios en la entrega 5.0.x (Desarrollo)
C.1.1. Cambios en la entrega 5.0.11 (todavía no liberada)
C.1.2. Cambios en la entrega 5.0.10 (todavía no liberada)
C.1.3. Cambios en la entrega 5.0.9 (15 julio 2005)
C.1.4. Cambios en la entrega 5.0.8 (not released)
C.1.5. Cambios en la entrega 5.0.7 (10 June 2005)
C.1.6. Cambios en la entrega 5.0.6 (26 May 2005)
C.1.7. Cambios en la entrega 5.0.5 (not released)
C.1.8. Cambios en la entrega 5.0.4 (16 Apr 2005)
C.1.9. Cambios en la entrega 5.0.3 (23 Mar 2005: Beta)
C.1.10. Cambios en la entrega 5.0.2 (01 Dec 2004)
C.1.11. Cambios en la entrega 5.0.1 (27 Jul 2004)
C.1.12. Cambios en la entrega 5.0.0 (22 Dec 2003: Alpha)
C.2. Cambios en MyODBC
C.2.1. Cambios en MyODBC 3.51.12
C.2.2. Cambios en MyODBC 3.51.11

This appendix lists the changes in the MySQL source code for version 5.1.0 and later releases. For information about changes in previous versions of the MySQL database software, see the Manual de referencia de MySQL 4.1, which provides coverage of the 3.22, 3.23, 4.0, and 4.1 series of releases.

We are working actively on MySQL 5.0 and 5.1, and provide only critical bugfixes for MySQL 4.1, 4.0, and MySQL 3.23. We update this section as we add new features, so that everybody can follow the development.

Note that we tend to update the manual at the same time we make changes to MySQL. If you find a recent version of MySQL listed here that you can't find on our download page (http://dev.mysql.com/downloads/), it means that the version has not yet been released.

The date mentioned with a release version is the date of the last BitKeeper ChangeSet on which the release was based, not the date when the packages were made available. The binaries are usually made available a few days after the date of the tagged ChangeSet, because building and testing all packages takes some time.

C.1. Cambios en la entrega 5.0.x (Desarrollo)

The following changelog shows what has been done in the 5.0 tree:

  • Basic support for read-only server side cursors.

  • Basic support for (updatable) views. See, for example, Sección 21.2, “Sintaxis de ”.

  • Basic support for stored procedures (SQL:2003 style). See Capítulo 19, Procedimientos almacenados y funciones.

  • Initial support for rudimentary triggers.

  • Added , which can be of mixed (that is, global and local) types. See Sección 19.2.9.3, “La sentencia ”.

  • Removed the update log. It is fully replaced by the binary log. If the MySQL server is started with , it is translated to (or ignored if the server is explicitly started with ), and a warning message is written to the error log. Setting silently sets instead (or do nothing if the server is explicitly started with ).

  • Support for the storage engine has been removed. If you have tables, you should convert them before upgrading. See Sección 2.10.1, “Aumentar la versión de 4.1 a 5.0”.

  • Support for options in tables has been removed. If you have tables that use these options, you should convert them before upgrading. See Sección 2.10.1, “Aumentar la versión de 4.1 a 5.0”.

  • User variable names are now case insensitive: If you do then now returns . Case sensitivity of a variable's value depends on the collation of the value.

  • Strict mode, which in essence means that you get an error instead of a warning when inserting an incorrect value into a column. See Sección 5.3.2, “El modo SQL del servidor”.

  • and columns remember end space. A or column can contain up to 65,535 characters or bytes, respectively.

  • () tables can have columns.

  • When using a constant string or a function that generate a string result in , MySQL creates the result field based on the max_length of the string/expression:

    max_length Column type
    = 0
    < 512
    >= 512

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

C.1.1. Cambios en la entrega 5.0.11 (todavía no liberada)

Functionality added or changed:

  • mysqldump now dumps triggers for each dumped table. This can be suppressed with the option. (Bug #10431)

  • Added new error message to indicate that, while the stack is not completly full, more stack space is required. (Bug #11213)

  • : Improved handling of the configuration variables , , , and should result in noticeably faster startup times for MySQL Cluster. (Bug #12149)

  • Added support of where clause for queries with . (Bug #11745)

Bugs fixed:

  • Multiple queries in a stored procedure causes error and client hang. (Bug #6897)

  • Added checks to prevent error when allocating memory when there was insufficient memory available. (Bug #7003)

  • Character data truncated when GBK characters and are present. (Bug #11987)

  • Comparisons like fail when using . (Bug #11754)

  • Corrected inaccurate error message when inserting out of range data under SQL mode. (Bug #11546)

  • When used in a query against a view, the function returned only a single row. (Bug #11412)

  • Calling the C API function after all rows of a result set were exhausted would return an error instead of . (Bug #11037)

  • Information about a trigger was not displayed in the output of when the selected database was , prior to the trigger's first invocation. (Bug #12127)

  • Issuing successive would cause the client to hang. (Bug #11934)

  • In stored procedures, a cursor that fetched an empty string into a variable would set the variable to instead. (Bug #8692)

  • A trigger dependent on a feature of one setting would cause an error when invoked after the was changed. (Bug #5891)

  • A delayed insert that would duplicate an existing record crashed the server instead. (Bug #12226)

  • when gave rise to an invalid error message. (Bug #11964)

  • On AMD64, attempting to repair a table with a full-text index would crash the server. (Bug #11684)

  • The MySQL Cluster backup log was invalid where the number of Cluster nodes was not equal to a power of 2. (Bug #11675)

  • sometimes returned a result with a different collation that that of its arguments. (Bug #10201)

  • The and functions returned the wrong length to . (Bug #11311)

  • A column would be mis-identified as in table descriptions. (Bug #11227)

  • Incorrect error message displayed if user attempted to create a table in a non-existing database using . syntax. (Bug #10407)

  • : Do not flush after each write, not even before setting up the doublewrite buffer. Flushing can be extremely slow on some systems. (Bug #12125)

  • : True : Return columns in the format expected by MySQL. (Bug #12186)

C.1.2. Cambios en la entrega 5.0.10 (todavía no liberada)

Functionality added or changed:

  • Security improvement: Applied a patch that addresses a data vulnerability that could result in a buffer overflow and code execution. (CAN-2005-2096) (Bug #11844)

  • The viewing of triggers and trigger metadata has been enhanced as follows:

  • Triggers can now reference tables by name. See Sección 20.1, “Sintaxis de ” for more information.

  • The output of now displays the option. (Bug #11999)

  • On Windows, the search path used by MySQL applications for now includes (that is, the application's parent directory, and hence, the installation directory). (Bug #10419)

  • Added C API function for obtaining information about the default character set of the current connection.

  • The bundled version of the library was upgraded to version 5.0.

  • It is no longer necessary to issue an explicit for any tables accessed by a trigger prior to executing any statements that might invoke the trigger. (Bug #9581, Bug #8406)

  • : A new option is available for use with the ndb_mgmd client. When called with this option, ndb_mgmd prints all configuration data to , then exits.

  • The namespace for triggers has changed. Previously, trigger names had to be unique per table. Now they must be unique within the schema (database). An implication of this change is that syntax now uses a schema name instead of a table name (schema name is optional and, if omitted, the current schema will be used).

    Note: When upgrading from a previous version of MySQL 5 to MySQL 5.0.10 or newer, you must drop all triggers before upgrading and re-create them after or will not work after the upgrade. (Bug #5892)

Bugs fixed:

  • : Attempting to create or drop tables during a backup would cause the cluster to shut down. (Bug #11942)

  • When attempting to drop a table with a broken unique index, failed to drop the table and erroneously report that the table was unknown. (Bug #11355)

  • gave unexpected results when only static value present between the . (Bug #11885)

  • Fixed compile error when using GCC4 on AMD64. (Bug #12040)

  • ignored the option in the section of the Cluster configuration file. (Bug #12028)

  • didn't work for users with limited access. (Bug #11577)

  • MySQL server would crash is a fetch was performed after a when cursors were involved. (Bug #10760)

  • The temporary tables created by an on a cluster table were visible to all MySQL servers. (Bug #12055)

  • was leaking file descriptors. (Bug #11898)

  • IP addresses not shown in command on second ndb_mgmd (or on ndb_mgmd restart). (Bug #11596)

  • Functions that evaluate to constants (such as and were being evaluated in the definition of a rather than included verbatim. (Bug #4663)

  • Execution of failed to increment the status variable. (Bug #11685)

  • For execution of a stored procedure that refers to a view, changes to the view definition were not seen. The procedure continued to see the old contents of the view. (Bug #6120)

  • For prepared statements, the SQL parser did not disallow ‘’ parameter markers immediately adjacent to other tokens, which could result in malformed statements in the binary log. (For example, could become .) (Bug #11299)

  • When two threads compete for the same table, a deadlock could occur if one thread has also a lock on another table through and the thread is attempting to remove the table in some manner and the other thread want locks on both tables. (Bug #10600)

  • Aliasing the column names in a did not work when executing a query on the . (Bug #11399)

  • Performing an on a from a produced unexpected results when and underlying table had the same column name on different columns. Bug #11709)

  • The C API function did not clear error information. (Bug #11183)

  • When used within a subquery, returned an empty string. (Bug #10269)

  • Multiple-table queries using would fail with an error. (Bug #9979)

  • returned incorrect length information for and and columns. (Bug #9735)

  • was failing the test suite on Windows due to being incorrectly cast to . (Bug #11567)

  • : Server left core files following shutdown if data nodes had failed. (Bug #11516)

  • Creating a trigger in one database that references a table in another database was being allowed without generating errors. (Bug #8751)

  • Duplicate trigger names were allowed within a single schema. (Bug #6182)

  • Server did not accept some fully-qualified trigger names. (Bug #8758)

  • The SQL mode accepted invalid dates if the date value provided was the result of an implicit type conversion. (Bug #5906)

  • The MySQL server had issues with certain combinations of basedir and datadir. (Bug #7249)

  • had some inaccurate values for some data types. (Bug #11057)

  • LIKE pattern matching using prefix index didn't return correct result. (Bug #11650)

  • For several character sets, MySQL incorrectly converted the character code for the division sign to the character set. (Bug #11717)

  • When invoked within a view, returned incorrect values. (Bug #11760)

  • displayed a file size of 0 for all log files but the current one if the files were not located in the data directory. (Bug #12004)

  • Server-side prepared statements failed for columns with a character set of . (Bug #9442)

  • References to system variables in an SQL statement prepared with were evaluated during to their values at prepare time, not to their values at execution time. (Bug #9359)

  • For server shutdown on Windows, error messages of the form user: '' were being written to the error log. Now connections are closed more gracefully without generating error messages. (Bug #7403)

  • Increased the version number of the shared library from 14 to 15 because it is binary incompatible with the MySQL 4.1 client library. (Bug #11893)

  • A recent optimizer change caused and to not properly identify the rows to be deleted. (Bug #11853)

  • Within a stored procedure that selects from a table, invoking another procedure that requires a write lock for the table caused that procedure to fail with a message that the table was read-locked. (Bug #9565)

  • Within a stored procedure, selecting from a table through a view caused subsequent updates to the table to fail with a message that the table was read-locked. (Bug #9597)

  • For a stored procedure defined with characteristic, incorrectly reported the use invoking the procedure, not the user who defined it. (Bug #7291)

  • Creating a table with a or column with the clause caused a server crash if the table's character set was . (Bug #11819)

  • With strict SQL mode enabled, reported spurious “Invalid default value” messages for columns that had no clause. (Bug #9881)

  • In SQL prepared statements, comparisons could fail for values not equally space-padded. For example, returns 1, but incorrectly returned 0. (Bug #9379)

  • Labels in stored routines did not work if the character set was not . (Bug #7088)

  • Invoking the function could cause a server crash if the server was started without the option. (Bug #11643)

  • The server crashed upon execution of a statement that used a stored function indirectly (via a view) if the function was not yet in the connection-specific stored routine cache and the statement would update a status variable. This fix allows the use of stored routines under without explicitly locking the table. However, you cannot use in statements that will combine locking of it with modifications for other tables. (Bug #11554)

  • The server crashed when dropping a trigger that invoked a stored procedure, if the procedure was not yet in the connection-specific stored routine cache. (Bug #11889)

  • Selecting the result of an aggregate function for an or column within a subquery could result in a server crash. (Bug #11821)

  • Incorrect column values could be retrieved from views defined using statements of the form . (Bug #11771)

  • The table was not being created properly with the proper character set and collation, causing server crashes for stored procedure operations if the server was using a multi-byte character set. To take advantage of the bug fix, mysql_fix_privileges_tables should be run to correct the structure of the table. (Bug #11365)

  • Execution of a prepared statement that invoked a non-existent or dropped stored routine would crash the server. (Bug #11834)

  • Executing a statement that invoked a trigger would cause problems unless a was first issued for any tables accessed by the trigger. Note: The exact nature of the problem depended upon the MySQL 5.0 release being used: prior to 5.0.3, this resulted in a crash; from 5.0.3 to 5.0.7, MySQL would issue a warning; in 5.0.9, the server would issue an error. (Bug #8406)

    The same issue caused to fail following if triggers were involved. (Bug #9581)

  • In a shared Windows environment, MySQL could not find its configuration file unless the file was in the directory. (Bug #5354)

C.1.3. Cambios en la entrega 5.0.9 (15 julio 2005)

Functionality added or changed:

  • An attempt to create a column with a display width (for example, ) now results in a warning. Display widths have not been supported for since MySQL 4.1. (Bug #10466)

  • : When creating or extending an InnoDB data file, at most one megabyte at a time is allocated for initializing the file. Previously, InnoDB allocated and initialized 1 or 8 megabytes of memory, even if only a few 16-kilobyte pages were to be written. This improves the performance of in mode.

  • : Various optimizations. Removed unreachable debug code from non-debug builds. Added hints for the branch predictor in gcc. Made assertions occupy less space.

  • : Make by default. Bypass the concurrency checking if the setting is greater than or equal to 20.

  • : Make killable. (Bug #9730)

  • Recursion in stored routines is now disabled because it was crashing the server. We plan to modify stored routines to allow this to operate safely in a future release. (Bug #11394)

  • The handling of columns has been improved, and should now be much more reliable in a number of cases. (Bug #10617, Bug #11091, Bug #11572)

Bugs fixed:

  • did not take the into account when quoting identifiers. (Bug #6903)

  • The script did not handle symbolic linking properly. (Bug #10986)

  • Incorrect results when using on a . (Bug #11639)

  • Instances of the function in view definitions were converted to . This is incorrect because is the same as , not . (Bug #10651)

  • mysqldump failed when reloading a view if the view was defined in terms of a different view that had not yet been reloaded. mysqldump now creates a dummy table to handle this case. (Bug #10927)

  • mysqldump could crash for illegal or nonexistent table names. (Bug #9358)

  • The option for mysqldump was being ignored if table names were given after the database name. (Bug #9558)

  • The option for mysqldump resulted in no error if the binary log was not enabled. Now an error occurs unless the option is given. (Bug #11678)

  • and require SSL support to be enabled, but were not checking for it. Checking for incorrect arguments or resource exhaustion was also improved for these functions. (Bug #10589)

  • When used in joins, failed to truncate to zero any string values that could not be converted to numbers. (Bug #10124)

  • did not format column values correctly. (Bug #9657)

  • There was a compression algorithm issue with for very large datasets (where the total size of of all records in a single column was on the order of 3 GB or more) on 64-bit platforms. (A fix for other platforms was made in MySQL 5.0.6.) (Bug #8321)

  • Temporary tables were created in the data directory instead of . (Bug #11440)

  • MySQL would not compile correctly on QNX due to missing function. (Bug #11544)

  • A would work correctly with a table only when there was an index on . (Bug #11484)

  • The server would lose table-level and privileges following a or server restart. (Bug #9795)

  • In strict mode, an into a view that did not include a value for a column but that did include a test on the same column would succeed, This happened even though the should have been prevented due to the failure to supply a value for the column. (Bug #6443)

  • Running a on multiple views crashed the server. (Bug #11337)

  • When a table had a primary key containing a column, creation of another index failed with the error , even when the new index did not contain a column. (Bug #11657)

  • NDB Cluster: When trying to open a table that could not be discovered or unpacked, cluster would return error codes which the MySQL server falsely interpreted as operating system errors. (Bug #103651)

  • Manually inserting a row with into and performing a would cause the server to crash. (Bug #11330)

  • A cursor using a query with a filter on a or column would cause the server to crash server after the data was fetched. (Bug #11172)

  • Closing a cursor that was already closed would cause MySQL to hang. (Bug #9814)

  • Using on a column set caused incorrect results when used in a . (Bug #11469)

  • Signed would not accept as a value. (Bug #11215)

  • Views did not use indexes on all appropriate queries. (Bug #10031)

  • For tables, it was possible for for updates to be performed using outdated key statistics when the updates involved only very small changes in a very few rows. This resulted in the random failures of queries such as where the same query with no clause would succeed. (Bug #10178)

  • Optimizer performed range check when comparing unsigned integers to negative constants, could cause errors. (Bug #11185)

  • Wrong comparison method used in when relaxed date syntax used (i.e. ). (Bug #11325)

  • The and functions would cause errors when used with a . (Bug #7024)

  • Clients would hang following some errors with stored procedures. (Bug #9503)

  • Combining cursors and subselects could cause server crash or memory leaks. (Bug #10736)

  • If a prepared statement cursor is opened but not completely fetched, attempting to open a cursor for a second prepared statement will fail. (Bug #10794)

C.1.4. Cambios en la entrega 5.0.8 (not released)

Note: Starting with version 5.0.8, changes for MySQL Cluster can be found in the combined Change History.

Functionality added or changed:

  • tables now support indexes of up to 500 bytes. See Sección 14.3, “El motor de almacenamiento ()”. (Bug #10566)

  • New - Prevents automatic substitution of storage engine when the requested storage engine is disabled or not compiled in. (Bug #6877)

  • The statements , , , and cause an implicit commit. (Bug #6883)

  • Expanded on information provided in general log and slow query log for prepared statements. (Bug #8367, Bug #9334)

  • Where a query uses a grouping column from the query's clause, MySQL now issues a warning. This is because the SQL standard states that any grouping column must unambiguously reference a column of the table resulting from the query's clause, and allowing columns from the clause to be used as grouping columns is a MySQL extension to the standard.

    By way of example, consider the following table: 

    CREATE TABLE users (
  userid INT NOT NULL PRIMARY KEY,
  username VARCHAR(25),
  usergroupid INT NOT NULL
);

    MySQL allows you to use the alias in this query: 

    SELECT usergroupid AS id, COUNT(userid) AS number_of_users
FROM users
GROUP BY id;

    However, the SQL standard requires that the column name be used, as shown here: 

    SELECT usergroupid AS id, COUNT(userid) AS number_of_users
FROM users
GROUP BY usergroupid;

    Queries such as the first of the two shown above will continue to be supported in MySQL; however, beginning with MySQL 5.0.8, using a column alias in this fashion will generate a warning. Note that in the event of a collision between column names and/or aliases used in joins, MySQL attempts to resolve the conflict by giving preference to columns arising from tables named in the query's clause. (Bug #11211)

  • The granting or revocation of privileges on a stored routine is no longer performed when running the server with even after the statement has been executed. (Bug #9993)

  • Added support for syntax for bit literal. (Bug #10650)

Bugs fixed:

  • Security fix: On Windows systems, a user with any of the following privileges

    on could crash by issuing a or command. In addition, any of the commands , , , or would report success even though the database was not in fact changed. Note: Although this bug was thought to be fixed previously, it was later discovered to be present in the MySQL 5.0.7-beta release for Windows. (Bug #9148, CAN-2005-0799

  • A . LIKE ... statement would crash the server when no database was selected. (Bug #11028)

  • queries or queries without or could return inconsistent results for indexed columns. (Bug #11044)

  • The command in MySQL Instance Manager displayed option values incorrectly for options for which no value had been given. (Bug #11200)

  • An outer join with an empty derived table (a result from a subquery) returned no result. (Bug #11284)

  • An outer join with an condition that evaluated to false could return an incorrect result. (Bug #11285)

  • would sometimes fail to remove the pid file for the old process after a crash. As a result, the server would fail to start due to a false error. (Bug #11122)

  • function could produce incorrect results if first argument is . (Bug #11142)

  • Setting caused an erroneous error message. (Bug #10732)

  • Converting a column having an index to a different type (such as ) gave rise to an incorrect error message. (Bug #10543)

    Note that this bugfix induces a slight change in the behaviour of indexes: If an index is defined to be the same length as a field (or is left to default to that field's length), and the length of the field is later changed, then the index will adopt the new length of the field. Previously, the size of the index did not change for some field types (such as ) when the field type was changed.

  • column of table of was empty. (Bug #11055)

  • A value could not be included in a . (Bug #11387)

  • Server crashed when using on the result of a operation on a value. (Bug #11385)

  • Possible values in columns could crash the server when a was used in a query. (Bug #11295)

  • Fixed 64 bit compiler warning for packet length in replication. (Bug #11064)

  • Multiple range accesses in a subquery cause server crash. (Bug #11487)

  • An issue with index merging could cause suboptimal index merge plans to be chosen when searching by indexes created on columns. The same issue caused the InnoDB storage engine to issue the warning . (Bug #8441)

  • The script was not parsing the output of correctly when called with the option. (Bug #7967)

  • returned incorrect results when called from a stored procedure, where had a primary key. (Bug #10136)

  • When used in defining a view, the function failed with calculated values, for example, when passed the value returned by . (Bug #7521)

  • returned multiple rows (it should return a single row). (Bug #8614)

  • produced incorrect result when using . (Bug #11298)

  • Fixed hang/crash with Boolean full-text search where a query contained more query terms that one-third of the query length (it could be achieved with truncation operator: 'a*b*c*d*'). (Bug #7858)

  • Fixed column name generation in creation to ensure there are no duplicate column names. (Bug #7448)

  • An clause sometimes had no effect on the ordering of a result when selecting specific columns (as opposed to using ) from a view. (Bug #7422)

  • Some data definition statements ( where the table was not a temporary table, , , and ) were not being written to the binary log after a . This also caused problems with replication. (Bug #6883)

  • Calling a stored procedure that made use of an query caused a server crash. (Bug #11060)

  • Selecting from a view defined using caused an error; attempting to execute a query after defining such a view crashed the server. (Bug #7015)

  • The mysql client would output a prompt twice following input of very long strings, because it incorrectly assumed that a call to the _cgets() function would clear the input buffer. (Bug #10840)

  • A three byte buffer overflow in the client functions caused improper exiting of the client when reading a command from the user. (Bug #10841)

  • Fixed a problem where a stored procedure caused a server crash if the query cache was enabled. (Bug #9715)

  • returned an “unknown database” error. (Bug #9434)

  • Corrected a problem with returning an incorrect result on 64-bit systems. (Bug #11235)

  • Fixed a problem resolving table names with when the table name lettercase differed in the and clauses. (Bug #9500)

  • Fixed server crash due to some internal functions not taking into account that for multi-byte character sets, columns could exceed 255 bytes and columns could exceed 65,535 bytes. (Bug #11167)

  • Fixed locking problems for multiple-statement statements performed within a stored routine, such as incorrectly locking a to-be-modified table with a read lock rather than a write lock. (Bug #11158)

  • Fixed a portability problem testing for support that caused compilation problems when using OpenSSL/yaSSL on HP-UX and Mac OS X. (Bug #10675, Bug #11150)

  • The hostname cache was not working. (Bug #10931)

  • On Windows, did not interpret wildcard characters properly if they were given in the table name argument. (Bug #10947)

  • Using to prepare a statement that invoked a stored routine that deallocated the prepared statement caused a server crash. This is prevented by disabling dynamic SQL within stored routines. (Bug #10975)

  • Default hostname for MySQL server was always . (Bug #11174)

  • Using to prepare a statement that invoked a stored routine that executed the prepared statement caused a error the second time the routine was invoked. This is prevented by disabling dynamic SQL within stored routines. (Bug #7115)

  • Using prepared statements within a stored routine (, , ) could cause the client connection to be dropped after the routine returned. This is prevented by disabling dynamic SQL within stored routines. (Bug #10605)

  • When using a cursor with a prepared statement, the first execution returned the correct result but was not cleaned up properly, causing subsequent executions to return incorrect results. (Bug #10729)

  • MySQL Cluster: Connections between data nodes and management nodes were not being closed following shutdown of . (Bug #11132)

  • MySQL Cluster: processes would not reconnect to cluster following restart of . (Bug #11221)

  • MySQL Cluster: Fixed problem whereby data nodes would fail to restart on 64-bit Solaris (Bug #9025)

  • MySQL Cluster: Calling crashed the cluster when running on Red Hat Enterprise 4/64-bit/Opteron. (Bug #10058)

  • MySQL Cluster: Insert records were incorrectly applied by , thus making restoration from backup inconsistent if the binlog contained inserts. (Bug #11166)

  • MySQL Cluster: Cluster would time out and crash after first query on 64-bit Solaris 9. (Bug #8918)

  • MySQL Cluster: client command displayed incorrect output after master data node failure. (Bug #11050)

  • MySQL Cluster: A delete performed as part of a transaction caused an erroneous result. (Bug #11133)

  • MySQL Cluster: Not allowing sufficient parallelism in cluster configuration (e.g. too small) caused to fail without providing any error messages. (Bug #10294)

  • MySQL Cluster: When using dynamically allocated ports on Linux, cluster would hang on initial startup. (Bug #10893)

  • MySQL Cluster: Setting TransactionInactiveTimeout= 0 did not result in an infinite timeout. (Bug #11290)

  • : Enforce maximum of UTF-8 data in . (Bug #10409)

  • : Pad UTF-8 variable-length columns with . Pad UCS2 columns with . (Bug #10511)

C.1.5. Cambios en la entrega 5.0.7 (10 June 2005)

Functionality added or changed:

  • Added C API function for setting the default character set of the current connection. This allows clients to affect the character set used by . (Bug #8317)

  • The behaviour of the system variable has been changed. The default value is now 0 (rather than -1) and it now has session-level scope (rather than being global). See Sección 5.3.4, “Variables de estado del servidor” for additional information.

  • All characters occuring on the same line following the keyword will be set as delimiter. For example, will set as the delimiter. This behavior is now consistent between MySQL 5.1 and MySQL 5.0. (Bug #9879)

  • The , , and columns of output can now be . This is required for using on queries that use no tables (i.e. ). (Bug #9899)

  • Placeholders now can be used for in prepared statements. (Bug #7306)

  • now displays a column that indicates the size of each file.

  • The option for mysqldump has been disabled to avoid causing problems with storage engines that do not support . (Bug #7815)

  • Improved the optimizer to be able to use indexes for expressions of the form NOT IN (, , ...) and NOT BETWEEN AND .. (Bug #10561)

  • Removed and from the Windows “No Installer” distribution (they had already been removed from the “With Installer” distribution before). Removed those programs from the source distribution.

  • Removed from the source distribution and from the “No Installer” Windows distribution (it had already been removed from the “With Installer” distribution before).

  • : In stored procedures and functions, no longer takes full explicit table locks for every involved table. Only `intention' locks are taken, similar to those in the execution of an ordinary SQL statement. This greatly reduces the number of deadlocks.

Bugs fixed:

  • Security update: A user with limited privileges could obtain information about the privileges of other users by querying objects in the database for which that user did not have the requisite privileges. (Bug #10964)

  • Triggers with dropped functions caused crashes. (Bug #5893)

  • Failure of a trigger did not prevent the triggering statement from performing its operation on the row for which the trigger error occurred. Now the triggering statement fails as described in Sección 20.3, “Utilización de disparadores”. (Bug #10902)

  • Issuing a write lock for a table from one client prevented other clients from accessing the table's metadata. For example, if one client issued a . WRITE, then a second client attempting to execute a ; would hang. (Bug #9998)

  • The failed to return when supplied with an invalid argument. See Sección 12.5, “Funciones de fecha y hora”. (Bug #10568)

  • The functions , , and performed incorrect conversions of their arguments. (Bug #9939)

  • The function returned incorrect results with some format specifiers. See Sección 12.5, “Funciones de fecha y hora”. (Bug #10590)

  • Dropping stored routines when the MySQL server had been started with generated extraneous warnings. (Bug #9993)

  • A problem with the file caused compilation of MySQL to fail on single-processor Linux systems running 2.6 kernels. (Bug #10364)

  • The ucs2_turkish_ci collation failed with upper('i'). UPPER/LOWER now can return a string with different length. (Bug #8610)

  • OPTIMIZE of InnoDB table does not return 'Table is full' if out of tablespace. (Bug #8135)

  • GROUP BY queries with ROLLUP returned wrong results for expressions containing group by columns. (Bug #7894)

  • Fixed bug in function where value list contains . (Bug #10944)

  • Corrected a problem where an incorrect column type was returned in the result set metadata when using a prepared statement to select from a view. (Bug #11111)

  • Fixed bug in the MySQL Instance manager that caused the version to always be when was issued. (Bug #10229)

  • Using to sort the results of an that contained a expression returned incorrect results due to integer overflow. (Bug #9669)

  • Fixed a server crash resulting from accessing tables within stored functions. This is handled by prohibiting statements that do an explicit or explicit commit or rollback within stored functions or triggers. (Bug #10015)

  • Fixed a server crash resulting from the second invocation of a stored procedure that selected from a view defined as a join that used in the join conditions. (Bug #6866)

  • Using for a table that had a trigger caused a crash when executing a statement that activated the trigger, and also a crash later with for the database containing the table. (Bug #5894)

  • Fixed a server crash resulting from an attempt to allocate too much memory when and were used. (Bug #11088)

  • Fixed a portability problem for compiling on Windows with Visual Studio 6. (Bug #11153)

  • The incorrect sequence of statements READ NEXT without a preceding READ = () for an table resulted in a server crash rather than an error. (Bug #5373)

  • On Windows, with set to 2, using to alter a or table that had a mixed-case name also improperly changed the name to lowercase. (Bug #9660)

  • The server timed out SSL connections too quickly on Windows. (Bug #8572)

  • Executing for a table while other threads where selecting from the table caused a deadlock. (Bug #10602)

  • Fixed a server crash resulting from that selected from a table being altered by . (Bug #10224)

  • The storage engine properly handled outer joins, but not inner joins. (Bug #10848)

  • Consistently report table names in uppercase in output. (Bug #10059)

  • Fixed a failure of to sum values properly. (Bug #10982)

  • Triggers were not being activated for multiple-table or statements. (Bug #5860)

  • triggers were not being activated for statements. (Bug #6812)

  • triggers were not being activated for implicit inserts (). (Bug #8755)

  • If a stored function contained a statement, the function crashed when invoked. now is disallowed within stored functions. (Bug #8409)

  • Multiple-row could fail on a duplicate-key error when having one key and one unique key. (Bug #11080)

  • Fixed a server crash resulting from invalid string pointer when inserting into the table. (Bug #10181)

  • Multiple-table did always delete on the fly from the first table that was to be deleted from. In some cases, when using many tables and it was necessary to access the same row twice in the first table, we could miss some rows-to-be-deleted from other tables. This is now fixed.

  • The function could hang if you were executing many statements in a call and one of those statements raised an error. (Bug #9992)

  • The combination of , , and sometimes triggered a memory deallocation bug on Windows resulting in a server crash. (Bug #9593)

  • : Do very fast shutdown only if , but wait for threads to exit and release allocated memory if . Starting with MySQL/InnoDB 5.0.5, InnoDB would do brutal shutdown also when . (Bug #9673)

  • : Fixed in a stored procedure call if was set in . (Bug #10746)

  • : Fixed a duplicate key error that occurred with in a table with an column. (Bug #11005)

  • Fixed that MySQL would pass a wrong key length to storage engines in . This could cause warnings in the log. (Bug #11039)

  • Fixed a server crash for or when the clause contained a correlated subquery that referred to a column of the table being modified. (Bug #6384)

  • Fixed a problem causing an incorrect result for columns that include an aggregate function as part of an expression when is added to . (Bug #7914)

  • Fixed a problem with returning an incorrect result from a view that selected a expression from the result of an outer join. (Bug #9938)

  • MySQL was adding a clause to columns that included no explicit and were defined as . (This is supposed to happen only for columns that are .) (Bug #6267)

  • Corrected inappropriate error messages that were displayed when attempting to set the read-only and system variables. (Bug #10339)

C.1.6. Cambios en la entrega 5.0.6 (26 May 2005)

Functionality added or changed:

  • Incompatible change: and tables created with columns in MySQL 5.0.3 to 5.0.5 will appear corrupt after an upgrade to MySQL 5.0.6. Dump such tables with mysqldump before upgrading, and then reload them after upgrading. (The same incompatibility will occur for these tables created in MySQL 5.0.6 after a downgrade to MySQL 5.0.3 to 5.0.5.) (Bug #10465, Bug #10625)

  • Added the system variable, which indicates the number of digits of precision by which to increase the result of division operations performed with the operator.

  • Added the system variable, which applies when binary logging is enabled. It controls whether stored routine creators can be trusted not to create stored routines that will cause unsafe events to be written to the binary log.

  • Added the server option for setting the system variable from the command line.

  • Implemented the option for the C API function. This sets how many rows to fetch at a time when using cursors with prepared statements.

  • The and statements now support an clause to be used for disambiguating whether the grant object is a table, a stored function, or a stored procedure. Use of this clause requires that you upgrade your grant tables. See Sección 2.10.2, “Aumentar la versión de las tablas de privilegios”. (Bug #10246)

  • Added , , and columns to the table of . (Bug #9587)

  • Added a option to mysql to cause warnings to be shown after each statement if there are any. This option applies to interactive and batch mode. In interactive mode, and may be used to enable and disable warning display. (Bug #8684)

  • Removed a limitation that prevented use of FIFOs as logging targets (such as for the general query log). This modification does not apply to the binary log and the relay log. (Bug #8271)

  • Added a option to my_print_defaults.

  • When the server cannot read a table because it cannot read the file, print a message that the table was created with a different version of MySQL. (This can happen if you create tables that use new features and then downgrade to an older version of MySQL.) (Bug #10435)

  • now shows the , and system variables. (Bug #7800)

  • Removed unused system variable .

  • Changed default value of from 4 to 6. This allows us to avoid errors for most cases.

  • The variable now takes 3 values. Setting this to 2 changes MyISAM to do concurrent inserts to end of table if table is in use by another thread.

  • New prompt for mysql. This prompt indicates that a comment was begun on an earlier line and the closing sequence has not yet been seen. (Bug #9186)

  • If strict SQL mode is enabled, and columns with a length greater than 65,535 no longer are silently converted to or columns. Instead, an error occurs. (Bug #8295, Bug #8296)

  • The table now has a column. (Bug #8998)

  • : When the maximum length of output would be exceeded, truncate the beginning of the list of active transactions, instead of truncating the end of the output. (Bug #5436)

  • : If option is set and the isolation level of the transaction is not set to serializable then uses a consistent read for select in clauses like and that do not specify or . Thus no locks are set to rows read from selected table.

  • Updated version of to 2.9. (Bug #2596)

  • Removed and from the Windows “With Installer” distribution.

Bugs fixed:

  • An error in the implementation of the compression algorithm caused to fail with very large sets of data (total size of all the records in a single column needed to be >= 3 GB in order to trigger this issue). (Bug #8321)

  • Statements that create and use stored routines were not being written to the binary log, which affects replication and data recovery options. (Bug #2610) Stored routine-related statements now are logged, subject to the issues and limitations discussed in Sección 19.3, “Registro binario de procedimientos almacenados y disparadores”

  • Disabled binary logging within stored routines to avoid writing spurious extra statements to the binary log. For example, if a routine executes an statement, then for , the statement appears in the binary log, but not the statement. (Bug #9100)

  • Statements that create and drop triggers were not being written to the binary log, which affects replication and data recovery options. (Bug #10417) Trigger-related statements now are logged, subject to the issues and limitations discussed in Sección 19.3, “Registro binario de procedimientos almacenados y disparadores”

  • The and C API functions now close any cursor that is open for the statement, which prevents a server crash. (Bug #9478)

  • The C API function now returns an error for option values that are defined in but not yet implemented, such as . (Bug #9643)

  • tables could fail on Windows due to incorrect interpretation of pathname separator characters for filenames in the file. (Bug #10687)

  • Fixed a server crash for with tables, which do not have unique indexes. (Bug #10400)

  • Fix to do better rounding for double values (for example, returns , not ). (Bug #9060)

  • Disallow use of or for user variables or local variables in stored routines. (Bug #9286)

  • Fixed a server crash when using on an indexed column in an table. (Bug #9798)

  • In strict SQL mode, some assignments to numeric columns that should have been rejected were not (such as the result of an arithmetic expression or an explicit operation). (Bug #6961)

  • created a column, which is too small to hold the 36-character result from . (Bug #9535)

  • Fixed a server crash in the storage engine. (Bug #10175)

  • Fixed a server crash resulting from repeated calls to when the argument evaluated to . (Bug #10599)

  • For a user-defined function invoked from within a prepared statement, the UDF's initialization routine was invoked for each execution of the statement, but the deinitialization routine was not. (It was invoked only when the statement was closed.) Similarly, when invoking a UDF from within a trigger, the initialization routine was invoked but the deinitialization routine was not. For UDFs that have an expensive deinit function (such as , this bugfix will have negative performance consequences. (Bug #9913)

  • Portability fix for Cygwin: Don't use in source files. (Bug #10241)

  • Fix to work when is set on a case-sensitive filesystem and the source table name is not given in lowercase. (Bug #9761)

  • Fixed a server crash resulting from a statement where the arguments were a view name followed by a table name. (Bug #9897)

  • Within a stored procedure, attempting to update a view defined as an inner join failed with a ' was locked with a READ lock and can't be updated error. (Bug #9481)

  • Fixed a problem with tables being inaccessible depending on lettercase used to refer to them. (Bug #10018)

  • my_print_defaults was ignoring the option or crashing when the option was given. (Bug #9136, Bug #9851)

  • The table was missing columns of views for which the user has access. (Bug #9838)

  • Fixed a mysqldump crash that occurred with the option when dumping tables with a large number of long column names. (Bug #10286)

  • Corrected a problem where values where not assigned properly to or columns if certain other columns preceded them in the table definition. (Bug #10179)

  • For tables, avoid writing absolute pathnames in the file for the names of the constituent tables so that if the data directory is moved, tables will not break. For mysqld, write just the table name if it is in the same database as the table, and a path relative to the data directory otherwise. For the embedded servers, absolute pathnames may still be used. (Bug #5964)

  • Corrected a problem resolving outer column references in correlated subqueries when using the prepared statements. (Bug #10041)

  • Corrected the error message for exceeding the limit to say instead of . (Bug #9947)

  • Fixed incorrect memory block allocation for the query cache in the embedded server. (Bug #9549)

  • Corrected an inability to select from a view within a stored procedure. (Bug #9758)

  • Fixed a server crash resulting from use of with . (Bug #9799)

  • Fixed a server crash resulting from use of with . (Bug #9800)

  • Fixed a server crash resulting from use of a or column with or and . (Bug #9820)

  • Fixed a server crash resulting from use of with a prepared statement that uses a cursor. (Bug #9520)

  • Fixed server crash resulting from multiple calls to a stored procedure that assigned the result of a subquery to a variable or compared it to a value with . (Bug #5963)

  • Selecting from a single-table view defined on multiple-table views caused a server crash. (Bug #8528)

  • If the file named by a option does not exist or is otherwise inaccessible, an error now occurs. (Bug #5056)

  • and were not being respected on Windows. (Bug #9721)

  • from tables failed if the statement has a clause and an aggregate function in the select list. (Bug #9404)

  • Corrected some failures of prepared statements for SQL ( plus ) to return all rows for some statements. (Bug #9096, Bug #9777)

  • Remove extra slashes in value (for example, convert to , because they caused various errors. (Bug #8497)

  • Added , , and privileges to the privilege table. (They had been added to in MySQL 5.0.3 but not to the table.) (Bug #8166)

  • Fixed configure to properly recognize whether NTPL is available on Linux. (Bug #2173)

  • Incomplete results were returned from for tables for non- users. (Bug #10261)

  • Fixed a portability problem in compiling with VC++ on Windows. (Bug #10245)

  • returned rather than . (Bug #10404)

  • for an (unsigned 4-byte integer) column could return negative values if the column contained values larger than 2^31. (Bug #9298)

  • got confused and could not find the view if there was a temporary table with the same name as the view. (Bug #8921)

  • Fixed a deadlock resulting from use of while an statement is in progress. (Bug #7823)

  • The optimizer was choosing suboptimal execution plans for certain outer joins where the right table of a left join (or left table of a right join) had both and conditions. (Bug #10162)

  • for an table failed if the file was not present. (Bug #9911)

  • Invoking a stored function that executed a statement resulted in a server crash. (Bug #8408)

  • Fixed problems with static variables and do not link with to allow building on FreeBSD 5.3. (Bug #9714)

  • Fixed some awk script portability problems in cmd-line-utils/libedit/makelist.sh. (Bug #9954)

  • Fixed a problem with mishandling of key parts in hash indexes on columns, resulting in incorrect query results. (Bug #9489, Bug #10176)

  • : Fixed a critical bug in InnoDB : it could assign the same value for several rows. (Bug #10359) : All InnoDB bug fixes from 4.1.12 and earlier versions, and also the fixes to bugs #10335 and #10607 listed in the 4.1.13 change notes.

C.1.7. Cambios en la entrega 5.0.5 (not released)

No public release of MySQL 5.0.5 was made. The changes described in this section are available in MySQL 5.0.6.

Functionality added or changed:

  • Added support for the data type to the , , and storage engines.

  • no longer displays the deprecated system variable. (Bug #9738)

  • The behavior controlled by the option now can be changed at runtime by setting the value of the global system variable. It now accepts values 0, 1 and 2 (except on Netware where 2 is disabled). If set to 2, then when the MySQL server shuts down, will just flush its logs and shut down brutally (and quickly) as if a MySQL crash had occurred; no committed transaction will be lost, but a crash recovery will be done at next startup.

Bugs fixed:

  • Security fix: If mysqld was started with , it would run using the privileges of the account it was invoked from, even if that was . (Bug #9833)

  • Corrected a failure to resolve a column reference correctly for a that compared a join column to an subquery. (Bug #9338)

  • Fixed a problem where, after an internal temporary table in memory became too large and had to be converted to an on-disk table, the error indicator was not cleared and the query failed with error 1023 (). (Bug #9703)

  • Multiple-table updates could produce spurious data-truncation warnings if they used a join across columns that are indexed using a column prefix. (Bug #9103)

  • Fixed a string-length comparison problem that caused mysql to fail loading dump files containing certain ''-sequences. (Bug #9756)

  • Fixed a failure to resolve a column reference properly when an outer join involving a view contained a subquery and the column was used in the subquery and the outer query. (Bug #6106, Bug #6107)

  • Use of a subquery that used in the clause of the main query sometimes resulted in a error. (Bug #9681)

  • Fixed a memory leak that occurred when selecting from a view that contained a subquery. (Bug #10107)

  • Fixed an optimizer bug in computing the union of two ranges for the operator. (Bug #9348)

  • Fixed a segmentation fault in mysqlcheck that occurred when the last table checked in mode returned an error (such as the table being a table). (Bug #9492)

  • now sets the result type of the variable to /. (Bug #6598)

  • Incorrect results were returned for queries of the form ), where the subquery selected rows based on an condition. (Bug #9516)

  • Executing and then calling a stored procedure caused an error and resulting in the server thinking that no stored procedures exist. (Bug #9566)

  • Selecting from a view containing a subquery caused the server to hang. (Bug #8490)

  • Within a stored procedure, attempting to execute a multiple-table failed with a ' was locked with a READ lock and can't be updated error. (Bug #9486)

  • Starting mysqld with the and (or caused a server crash. (Bug #9815)

  • Queries containing incorrectly were registered in the query cache. (Bug #9796)

  • Setting the system variable to succeeded, but retrieving the variable resulted in a value of (the old name for the storage engine) rather than . (Bug #10039)

  • mysqlshow displayed an incorrect row count for tables. (Bug #9391)

  • The server died with signal 11 if a non-existent location was specified for the location of the binary log. Now the server exits after printing an appropriate error messsage. (Bug #9542)

  • Fixed a problem in the client/server protocol where the server closed the connection before sending the final error message. The problem could show up as a when attempting to connect to access a non-existent database. (Bug #6387, Bug #9455)

  • Fixed a -related crash in mysql when the user pressed Control-R. (Bug #9568)

  • For stored functions that should return a value, corrected a failure of the value to be in format. (Bug #8861)

  • Fixed a server crash resulting from invocation of a stored function that returned a value having an or data type. (Bug #9775)

  • Fixed a server crash resulting from invocation of a stored function that returned a value having a data type. (Bug #9102)

  • Fixed a server crash resulting from invocation of a stored function that returned a value having a data type. (Bug #7648)

  • with a negative time first argument and postive time second argument produced incorrect results. (Bug #8068)

  • Fixed a problem with for tables being written twice to the binary log. (Bug #9149)

  • : Prevent from changing the storage engine if there are foreign key constraints on the table. (Bug #5574, Bug #5670)

  • : Fixed a bug where next-key locking doesn't allow the insert which does not produce a phantom. (Bug #9354) If the range is of type , lock only the RECORD, if the record with the column value exists in a CLUSTERED index. This allows inserts before a range.

  • : When , and will ignore any type incompatibilities between referencing and referenced columns. Thus, it will be possible to convert the character sets of columns that participate in a foreign key. Be sure to convert all tables before modifying any data! (Bug #9802)

  • Provide more informative error messages in clustered setting when a query is issued against a table that has been modified by another server. (Bug #6762)

C.1.8. Cambios en la entrega 5.0.4 (16 Apr 2005)

Functionality added or changed:

  • Added table option when creating table in mysql_create_system_tables script to make sure the table is created as a table even if the default storage engine has been changed. (Bug #9496)

  • for an table no longer prints a value because the value has no meaning. (Bug #8941)

  • Invalid values for now generate errors. (Bug #5902)

  • Added option to mysqlshow, to display a column indicating the table type, as in . (Bug #5036)

  • The way the time zone information is stored into the binary log was changed, so that it's now possible to have a replication master and slave running with different global time zones. A drawback is that replication from 5.0.4 masters to pre-5.0.4 slaves is impossible.

  • Added compilation option to configure. (Previously it was necessary to pass to the compiler manually in order to enable large table support.) See Sección 2.8.2, “Opciones típicas de configure” for details.

  • New configuration directives and implemented for including option files and searching directories for option files. See Sección 4.3.2, “Usar ficheros de opciones” for usage.

Bugs fixed:

  • The use of together with erroneously resulted in some outer joins being converted to inner joins by the optimizer. (Bug #9017)

  • Fixed an optimizer problem where extraneous comparisons between values in indexed columns were being done for operators such as that are never true for . (Bug #8877)

  • Fixed the client/server protocol for prepared statements so that reconnection works properly when the connection is killed while reconnect is enabled. (Bug #8866)

  • A server installed as a Windows service and started with could not be stopped. (Bug #9665)

  • Fixed a server crash resulting from multiple executions of a prepared statement involving a join of an table with another table. (Bug #9383)

  • Fixed and collations to not consider '' equal to ''. If you upgrade to this version from an earlier version, you should rebuild the indexes of affected tables. (Bug #9269)

  • mysqldump dumped core when invoked with and options and a non-existent table name. (Bug #9175)

  • Allow extra HKSCS and cp950 characters ( extension characters) to be accepted in columns. (Bug #9357)

  • mysql.server no longer uses non-portable alias command or LSB functions. (Bug #9852)

  • Fixed a server crash resulting from on a decimal expression. (Bug #9210)

  • In prepared statements, subqueries containing parameters were erroneously treated as tables during preparation, resulting in a server crash. (Bug #8807)

  • InnoDB: and columns were treated incorrectly as character strings. This bug did not manifest itself with collations if there were less than about 100 elements in an , but it caused malfunction with . Old tables will continue to work. In new tables, and will be internally stored as unsigned integers. (Bug #9526)

  • InnoDB: Avoid test suite failures caused by a locking conflict between two server instances at server shutdown/startup. This conflict on advisory locks appears to be the result of a bug in the operating system; these locks should be released when the files are closed, but somehow that does not always happen immediately in Linux. (Bug #9381)

  • InnoDB: True : InnoDB stored the 'position' of a row wrong in a column prefix primary key index; this could cause MySQL to complain in an update of the primary key, and also some or queries. (Bug #9314)

  • InnoDB: Fix bug in MySQL/InnoDB 5.0.3: SQL statements were not rolled back on error. (Bug #8650)

  • Fixed a error when two prepared statements for single-row result sets were open simultaneously. (Bug #8880)

  • Fixed a server crash after a call to for single-row result set. (Bug #9159)

  • Fixed server crashes for or when selecting from multiple-table view. (Bug #8703, Bug #9398)

  • SQL mode should prevent inserts where a column with no default value is omitted or set to a value of . Fixed cases where this restriction was not enforced. (Bug #5986)

  • Fixed a server crash when creating a for a table, if the table contained a column. (Bug #9571)

  • Warning message from did not always indicate correct number of lines. (Bug #8681)

  • The commit count cache for was not properly invalidated when deleting a record using a cursor. (Bug #8585)

  • Fixed option-parsing code for the embedded server to understand , , and suffixes for the and options. (Bug #9472)

  • Selecting a column failed if the binary client/server protocol was used. (Bug #9608)

  • Fixed a permissions problem whereby information in could be exposed to a user with insufficient privileges. (Bug #7214)

  • An error now occurs if you try to insert an invalid value via a stored procedure in mode. (Bug #5907)

  • Link with on Fedora Core 3 to get language support functions. (Bug #6554)

  • The value of the and columns of the table must be for numeric columns, but were not. (Bug #9344)

  • did not drop triggers that were defined for the table. did not drop triggers in the database. (Bug #5859, Bug #6559)

  • and now require the and privileges, not and . ( is a row-level privilege, not a table-level privilege.) (Bug #9260)

  • Some user variables were not being handled with “implicit” coercibility. (Bug #9425)

  • Setting the system variable to 0 resulted in a setting of 1. (Bug #9072)

  • Fixed a collation coercibility problem that caused a union between binary and non-binary columns to fail. (Bug #6519)

  • Fixed a bug in division of floating point numbers. It could cause nine zeroes () to be inserted in the middle of the quotient. (Bug #9501)

  • tables had an implicit upper limit for the number of rows. As a result, not all data could be returned for some queries. (Bug #9317)

  • Fixed a problem with the command in mysql that resulted in mysql crashing. (Bug #8499)

  • now produces warnings when casting incorrect and values. This also applies to implicit to casts. (Bug #5912)

  • now fails in mode if the alteration generates warnings.

  • Using or in SQL mode now produces a warning. (Bug #6145)

  • Inserting a zero date in a , or column during mode now produces an error. (Bug #5933)

  • Inserting a zero date into a column in mode now produces an error.

  • now produces errors in strict mode (and warnings otherwise) when given an illegal argument. (Bug #5902)

  • Fixed a problem with that sometimes caused incorrect sorting of data. (Bug #9309)

  • Fixed server crash resulting from queries that combined , , and . (Bug #8615)

  • Incorrect results were returned from queries that combined , , and . (Bug #8616)

  • Too many rows were returned from queries that combined and if was given. (Bug #8617)

  • If on replication master a is interrupted in the middle (integrity constraint violation, killed connection...), the slave used to skip this entirely, thus missing some changes if this command permanently inserted/updated some table records before being interrupted. This is now fixed. (Bug #3247)

C.1.9. Cambios en la entrega 5.0.3 (23 Mar 2005: Beta)

Note: This Beta release, as any other pre-production release, should not be installed on “production” level systems or systems with critical data. It is good practice to back up your data before installing any new version of software. Although MySQL has done its best to ensure a high level of quality, protect your data by making a backup as you would for any software beta release.

Functionality added or changed:

  • New privilege was added.

  • Security improvement: The server creates , , , , , and table files only if a file with the same name does not already exist. Thanks to Stefano Di Paola for finding and informing us about this issue. (CAN-2005-0711)

  • Security improvement: User-defined functions should have at least one symbol defined in addition to the symbol that corresponds to the main function. These auxiliary symbols correspond to the , , , , and functions. mysqld by default no longer loads UDFs unless they have at least one auxiliary symbol defined in addition to the main symbol. The option controls whether UDFs that have only an symbol can be loaded. By default, the option is off. also checks UDF filenames when it reads them from the table and rejects those that contain directory pathname separator characters. (It already checked names as given in statements.) See Sección 27.2.3.1, “Secuencias de llamada UDF para funciones simples”, Sección 27.2.3.2, “Secuencias de llamada UDF para funciones agregadas”, and Sección 27.2.3.6, “Precauciones de seguridad en funciones definidas por usuarios”. Thanks to Stefano Di Paola for finding and informing us about this issue. (CAN-2005-0709, CAN-2005-0710)

  • in the compile-time datadir (usually in the binary tarball distributions) is not being read anymore. The value of the environment variable is used instead of the hard-coded path.

  • Support for the storage engine has been removed. If you have tables, you should convert them before upgrading. See Sección 2.10.1, “Aumentar la versión de 4.1 a 5.0”.

  • Support for options in tables has been removed. If you have tables that use these options, you should convert them before upgrading. See Sección 2.10.1, “Aumentar la versión de 4.1 a 5.0”.

  • Added support for .

  • no longer is included in the composite SQL mode. (Bug #8510)

  • mysqld_safe will create the directory where the UNIX socket file is to be located if the directory does not exist. This applies only to the last component of the directory pathname. (Bug #8513)

  • The coercibility for the return value of functions such as or now is “system constant” rather than “implicit.” This makes these functions more coercible than column values so that comparisons of the two do not result in errors. was modified to accommodate this new coercibility value. See Sección 12.9.3, “Funciones de información”.

  • User variable coercibility has been changed from “coercible” to “implicit.” That is, user variables have the same coercibility as column values.

  • Boolean full-text phrase searching now requires only that matches contain exactly the same words as the phrase and in the same order. Non-word characters no longer need match exactly.

  • returns a warning for non-existing tables. The checksum value remains as before. (Bug #8256)

  • The server now includes a timestamp in the message that is written to the error log at startup. (Bug #8444)

  • Added session variable to cause -level warnings not to be recorded. (Bug #6662)

  • Allowed the service-installation command for Windows servers to specify a single option other than following the service name. This is for compatibility with MySQL 4.1. (Bug #7856)

  • InnoDB: Upgrading from 4.1: The sorting order for end-space in columns for InnoDB tables has changed. Starting from 5.0.3, InnoDB compares columns as space-padded at the end. If you have a non-unique index on a column, you should run on it, and run if the check reports errors. If you have a on a column, you should rebuild the table with .

  • : Commit after every 10,000 copied rows when executing , , or . This makes it much faster to recover from an aborted operation.

  • Added and as standard SQL aliases for the and functions that compute population variance and standard deviation. Added new and functions to compute sample variance and standard deviation. (Bug #3190)

  • Fixed a problem with out-of-order packets being sent ( after or ) following a statement. (Bug #6804)

  • Retrieving from a view defined as a that mixed and resulted in a different result than retrieving from the original . (Bug #6565)

  • Fixed a problem with non-optimal query execution plans being chosen on IRIX. (Bug #8578)

  • in column definitions now is a distinct data type; it no longer is treated as a synonym for .

  • Bit-field values can be written using ' notation. is a binary value written using 0s and 1s.

  • From the Windows distribution, predefined accounts without passwords for remote users ("root@%", "@%") were removed (other distributions never had them).

  • Added and as synonyms for the and C API functions. and are symbols, but the names more clearly indicate that they should be called when beginning and ending use of a MySQL C API library no matter whether the application uses or . (Bug #6149)

  • now displays rather than blank in the output column if the corresponding table column cannot be .

  • Changed XML format for mysql from ></> to "></field> to allow for proper encoding of column names that are not legal as element names. (Bug #7811)

  • Added and options for mysqld.

  • Added option for mysqld.

  • Added system variable.

  • , , , and so forth display information about the database. Also, several statements now accept a clause specifying which output rows to display. See Capítulo 22, La base de datos de información .

  • Added the and privileges, and made the privilege operational.

  • InnoDB: Corrected a bug in the crash recovery of tables that caused corruption. (Bug #7973) There may still be bugs in the crash recovery, especially in tables.

  • When the storage engine detects corruption of a table, a message describing the problem now is written to the error log.

  • InnoDB: When MySQL/InnoDB is compiled on Mac OS X 10.2 or earlier, detect the operating system version at run time and use the file flush method on Mac OS X versions 10.3 and later. In Mac OS X, does not flush the write cache in the disk drive, but the special does; however, the flush request is ignored by some external devices. Failure to flush the buffers may cause severe database corruption at power outages.

  • InnoDB: Implemented fast . The old approach (deleting rows one by one) may be used if the table is being referenced by foreign keys. (Bug #7150)

  • Added (SJIS for Windows Japanese) and (UJIS for Windows Japanese) character sets.

  • Added several status variables. See Sección 5.3.4, “Variables de estado del servidor”.

  • Added the storage engine. See Sección 14.6, “El motor de almacenamiento ”.

  • now uses rather than to specify an index type. (Bug #7233)

  • InnoDB now supports a fast . One visible change from this is that auto-increment values for this table are reset on .

  • Added an member to the data structure that is used in the C API for prepared statements. This member is used for reporting data truncation errors. Truncation reporting is enabled via the new option for the C API function.

  • API change: the flag in the structure is now set to 0 by . Only those client programs which didn't explicitly set this flag to 0 or 1 after experience a change. Having automatic reconnection enabled by default was considered too dangerous (after reconnection, table locks, temporary tables, user and session variables are lost).

  • is now killable while it's waiting for running statements to finish.

  • () can have fields.

  • columns now remember end space. A column can now contain up to 65535 bytes. For more details, see Sección C.1, “Cambios en la entrega 5.0.x (Desarrollo)”. If the table handler doesn't support the new type, then it's converted to a column. Currently this happens for tables.

  • InnoDB: Introduced a compact record format that does not store the number of columns or the lengths of fixed-size columns. The old format can be requested by specifying . The new format () is the default. The new format typically saves 20 % of disk space and memory.

  • InnoDB: Setting the initial value for an table using now works, and resets the current value.

  • is (which means “unknown”) if the slave SQL thread is not running, or if the slave I/O thread is not running or not connected to master. It is zero if the SQL thread has caught up to the I/O thread. It no longer grows indefinitely if the master is idle.

  • The MySQL server aborts immediately instead of simply issuing a warning if it is started with the option but cannot initialize the binary log at startup (that is, an error occurs when writing to the binary log file or binary log index file).

  • The binary log file and binary log index file now are handled the same way as tables when there is a “disk full” or “quota exceeded” error. See Sección A.4.3, “Cómo se comporta MySQL ante un disco lleno”.

  • The MySQL server now aborts when started with option and without , and when started with and without .

  • If the MySQL server is started without an argument to and without , thus not providing a name for the binary log index file, a warning is issued because MySQL falls back to using the hostname for that name, and this is prone to replication issues if the server's hostname's gets changed later. See Sección A.8.4, “Cuestiones abiertas en MySQL”.

  • Added account-specific limit, which allows you to specify the maximum number of concurrent connections for the account. Also, all limited resources now are counted per account (instead of being counted per user + host pair as it was before). Use the option to get the old behavior.

  • InnoDB: A shared record lock () is now taken for a matching record in the foreign key check because inserts can be allowed into gaps.

  • InnoDB: Relaxed locking in , single table and single table clauses when is used and isolation level of the transaction is not serializable. uses consistent read in these cases for a selected table.

  • Added a new global system variable : if the replication slave SQL thread fails to execute a transaction because of an deadlock or exceeded InnoDB's or NDBCluster's or , it automatically retries times before stopping with an error. The default is 10. (Bug #8325)

  • When a client releases a user-level lock, will not be written to the binary log anymore (this makes the binary log smaller); as a counterpart, the slave does not actually take the lock when it executes . This is mainly an optimization and should not affect existing setups. (Bug #7998)

  • The way the character set information is stored into the binary log was changed, so that it's now possible to have a replication master and slave running with different global character sets. A drawback is that replication from 5.0.3 masters to pre-5.0.3 slaves is impossible.

  • The statement was extended to support user variables in the target column list, and an optional clause. Now one can perform some transformations on data after they have been read and before they are inserted into the table. For example: 

    LOAD DATA INFILE 'file.txt'
  INTO TABLE t1
  (column1, @var1)
  SET column2 = @var1/100;

    Also, replication of was changed, so you can't replicate such statements from a 5.0.3 master to pre-5.0.3 slaves.

Bugs fixed:

  • If a table on Windows had or table options, mysqldump dumped the directory pathnames with single-backslash pathname separators. This would cause syntax errors when importing the dump file. mysqldump now changes '' to '' in the pathnames on Windows. (Bug #6660)

  • now fixes that the privilege tables can be used in MySQL 4.1. This allows one to easily downgrade to 4.1 or run MySQL 5.0 and 4.1 with the same privilege files for testing purposes.

  • Fixed bug creating user with GRANT fails with password but works without, (Bug #7905)

  • mysqldump misinterpreted '' and '' characters in the names of tables to be dumped as wildcard characters. (Bug #9123)

  • The definition of the enumeration-valued column of the table was missing some of the current allowable SQL modes, so stored routines would not necessarily execute with the SQL mode in effect at the time of routine definition. (Bug #8902)

  • did not invalidate query results in the query cache that were generated from the table. (Bug #8480)

  • In strict or traditional SQL mode, too-long string values assigned to string columns (, , , , , or ) were correctly truncated, but the server returned an SQLSTATE value of (should be ). (Bug #6999, Bug #9029)

  • Stored functions that used cursors could return incorrect results. (Bug #8386)

  • ,) could fail to return for invalid values in , if was declared as . (Bug #8669)

  • Ordering by unsigned expression (more complex than a column reference) was treating the value as signed, producing incorrectly sorted results. (Bug #7425)

  • was treating unsigned columns as signed. (Bug #7425)

  • Fixed a problem with boolean full-text searches on columns where a double quote in the search string caused a server crash. (Bug #8351)

  • For a query with both and clauses and a clause with a subquery, was returned for any column selected by the subquery. (Bug #8218)

  • Fixed a bug in , which did not work within stored procedures. A workaround has been made so that within stored procedures, is executed like . This was necessary because is implicitly locking tables. (Bug #8850)

  • Fixed an optimizer bug that caused incorrectly ordered result from a query that used a index to retrieve rows and there was another index that was usable for . For such a query, showed join type, but regular (not ) index in the column. (Bug #6635)

  • If named an index column multiple times in the select list, the server tried to access different key fields for each instance of the column, which could result in a crash. (Bug #8532)

  • For a stored function that refers to a given table, invoking the function while selecting from the same table resulted in a server crash. (Bug #8405)

  • Comparison of a column containing to a subquery that produced values resulted in a server crash. (Bug #8397)

  • The option for myisamchk was changed to . The value needed for specifying how to sort indexes is a collation name, not a character set name. (Bug #8349)

  • Hostname matching didn't work if a netmask was specified for table-specific privileges. (Bug #3309)

  • Corruption of table indexes could occur with if the table had already been opened. For example, this was possible if the table had been opened implicitly by selecting from a table that mapped to the table. The server now issues an error message for under these conditions. (Bug #8306)

  • Setting the connection collation to a value different from the server collation followed by a statement that included a quoted default value resulted in a server crash. (Bug #8235)

  • Fixed handling of table-name matching in mysqlhotcopy to accommodate 2.9003 and up (which implement identifier quoting). (Bug #8136)

  • Selecting from a view defined as a join caused a server crash if the query cache was enabled. (Bug #8054)

  • Results in the query cache generated from a view were not properly invalidated after or on that view. (Bug #8050)

  • returned an incorrect value after a statement that selected constants and included and clauses. (Bug #7945)

  • Selecting from an table combined with a subselect on an table caused an error with the message is corrupted. (Bug #8164)

  • Fixed a problem with equality propagation optimization for prepared statements and stored procedures that caused a server crash upon re-execution of the prepared statement or stored procedure. (Bug #8115, Bug #8849)

  • between an empty base table and a view on an empty base table caused a server crash. (Bug #7433)

  • Use of in the select list when selecting from a view caused a server crash. (Bug #7116)

  • Use of a view in a correlated subquery that contains but no caused a server crash. (Bug #6894)

  • Handling by of references to stored functions within views was incorrect and could result in a server crash. (Bug #6814)

  • mysqldump now avoids writing to the dump output if the server is older than version 4.1 and would not understand that statement. (Bug #7997)

  • Fixed problems when selecting from a view that had an or subquery. Selecting columns by name caused a server crash. With , a crash did not occur, but columns in outer query were not resolved properly. (Bug #6394)

  • DDL statements for views were not being written to the binary log (and thus not subject to replication). (Bug #4838)

  • The function was not ignoring arguments, contrary to the documentation. (Bug #6317)

  • Creating a table using a name containing a character that is illegal in resulted in the character being stripped from the name and no error. The character now is considered an error. (Bug #8041)

  • Fixed a problem with the Cyrillic letters I and SHORT I being treated the same by the collation. (Bug #8385)

  • Some columns that contained catalog identifiers were of type . These were changed to , where is the appropriate maximum identifier length. (Bug #7215)

  • Some columns that contained timestamp values were of type . These were changed to . (Bug #7217)

  • An expression that tested a case-insensitive character column against string constants that differed in lettercase could fail because the constants were treated as having a binary collation. (For example, could fail.) (Bug #7098, Bug #8690)

  • The output of the () command in mysql had the values for the server and client character sets reversed. (Bug #7571)

  • If the slave was running with options which excluded one temporary table and included another, and the two tables were used in a single statement, as the ones the master automatically writes to its binary log upon client's disconnection when client has not explicitly dropped these, the slave could forget to delete the included replicated temporary table. Only the slave needs to be upgraded. (Bug #8055)

  • When setting integer system variables to a negative value with , the value was treated as a positive value modulo 2^32. (Bug #6958)

  • Corrected a problem with references to where statements such as would succeed but statements such as would fail. (Bug #8023)

  • Fixed a server crash caused by ... WHERE ... ORDER BY . when the column was qualified with the table name. (Bug #8392)

  • Fixed a bug in in natural language mode that could cause a server crash if the index was not used in a join ( did not show join mode) and the search query matched no rows in the table (Bug #8522).

  • : Honor the startup option when creating temporary files. Previously, temporary files were always created in the temporary directory of the operating system. On Netware, will continue to ignore . (Bug #5822)

  • Platform and architecture information in version information produced for option on Windows was always . More accurately determine platform as or for 32-bit or 64-bit Windows, and architecture as for x86, for Itanium, and for Alpha. (Bug #4445)

  • If multiple semicolon-separated statements were received in a single packet, they were written to the binary log as a single event rather than as separate per-statement events. For a server serving as a replication master, this caused replication to fail when the event was sent to slave servers. (Bug #8436)

  • Fixed statement to actually load index in memory. (Bug #8452)

  • Fixed a failure of multiple-table updates to replicate properly on slave servers when options had been specified. (Bug #7011)

  • Fixed failure of Windows when the source or destination table was located in a symlinked database directory. (Bug #6607)

  • With set to 1, mysqldump on Windows could write the same table name in different lettercase for different SQL statements. Fixed so that consistent lettercase is used. (Bug #5185)

  • mysqld_safe now understands the option. Previously, it ignored the option and attempted to start the server anyway. (Bug #7931)

  • Fixed problem in SQL mode for strings that contained both the string quoting character and backslash. (Bug #6368)

  • Fixed some portability issues with overflow in floating point values.

  • Prepared statements now gives warnings on prepare.

  • Fixed bug in prepared statements with .

  • Fixed bug in prepared statements with .

  • Fixed a bug in function returning unsigned number (third argument is positive, and return value does not fit in 32 bits). (Bug #7751)

  • Fixed a failure of the operator to return correct result if all values in the list were constants and some of them were using substring functions, for example, , , or . (Bug #7716)

  • Fixed a crash in function when its second or third argument was from a table (see Sección 7.2.1, “Sintaxis de (Obtener información acerca de un )”). (Bug #7705)

  • Fixed a problem with calculation of number of columns in row comparison against subquery. (Bug #8020)

  • Fixed erroneous output resulting from combined with a subquery and . (Bug #7946)

  • Fixed server crash in comparing a nested row expression (for example ) with a subquery. (Bug #8022)

  • Fixed server crash resulting from certain correlated subqueries with forward references (references to an alias defined later in the outer query). (Bug #8025)

  • Fixed server crash resulting from re-execution of prepared statements containing subqueries. (Bug #8125)

  • Fixed a bug where improperly would accept an index on a column that would reject. (Bug #7884)

  • now reports rather than for a table (unless the SQL mode is enabled). (Bug #6659)

  • Fixed a bug where the use of with caused a server crash. (Bug #7769)

  • Fixed a bug where comparing the result of a subquery to a non-existent column caused a server crash on Windows. (Bug #7885)

  • Fixed a bug in a combination of and operators of full-text search. Using more than one truncated negative search term, was causing empty result set.

  • InnoDB: Corrected the handling of trailing spaces in the character set. (Bug #7350, Bug #8771)

  • InnoDB: Use native function on Netware. All InnoDB temporary files are created under . Previously, InnoDB temporary files were never deleted on Netware.

  • Fixed a bug in handling, that resulted in error when the table was still smaller than the limit. (Bug #7791).

  • Fixed a symlink vulnerability in the mysqlaccess script. Reported by Javier Fernandez-Sanguino Pena and Debian Security Audit Team. (CAN-2005-0004)

  • Fixed a bug that caused server crash if some error occured during filling of temporary table created for derived table or view handling. (Bug #7413)

  • Fixed a bug which caused server crash if query containing function with constant arguments was prepared. (Bug #6849)

  • Prevent adding query to the binary log when the insertion of new records partially failed. (Bug #6682)

  • Fixed a bug which caused a crash when only the slave I/O thread was stopped and started. (Bug #6148)

  • Giving mysqld a caused it to crash.

  • Changed semantics of statements so that replication of is possible when using and . (Bug #6391)

  • A sequence of (or ), , transactional update, , could hang the connection forever and possibly the MySQL server itself. This happened for example when running the script several times. (Bug #6732)

  • mysqlbinlog did not print statements in front of statements inserting into temporary tables, thus causing potential problems when rolling forward these statements after restoring a backup. (Bug #6671)

  • InnoDB: Fixed a bug no error message for ALTER with InnoDB and AUTO_INCREMENT (Bug #7061). now supports query to set auto increment value for a table.

  • Made the MySQL server accept executing even if the connection has an open transaction or locked tables; refusing it made mysqldump --single-transaction sometimes fail to print a complete statement for some dumped databases. (Bug #7358)

  • Fixed that, when encountering a “disk full” or “quota exceeded” write error, sometimes didn't sleep and retry the write, thus resulting in a corrupted table. (Bug #7714)

  • Fixed that was not honored if using only transactions. (Bug #7236)

  • Fixed that a slave could crash after replicating many , , or statements from the master. (Bug #6461, Bug #7658)

  • mysqlbinlog forgot to add backquotes around the collation of user variables (causing later parsing problems as is a reserved word). (Bug #7793)

  • Ensured that mysqldump --single-transaction sets its transaction isolation level to before proceeding (otherwise if the MySQL server was configured to run with a default isolation level lower than it could give an inconsistent dump). (Bug #7850)

  • Fixed that when using the function (or any function adding spaces to the right) in a query that had to be resolved by using a temporary table, all resulting strings had rightmost spaces removed (i.e. did not work) (Bug #4048)

  • Fixed that a 5.0.3 slave can connect to a master < 3.23.50 without hanging (the reason for the hang is a bug in these quite old masters -- hangs them -- which was fixed in MySQL 3.23.50). (Bug #7965)

  • InnoDB: Fixed a deadlock without any locking, simple select and update (Bug #7975). now takes an exclusive lock when is checking duplicate keys.

  • Fixed a bug where MySQL was allowing concurrent updates (inserts, deletes) to a table if binary logging is enabled. Changed to ensure that all updates are executed in a serialized fashion, because they are executed serialized when binlog is replayed. (Bug #7879)

  • Fixed a rare race condition which could lead to hanging. (Bug #8682)

  • Fixed a bug that caused the slave to stop on statements that produced an error on the master. (Bug #8412)

C.1.10. Cambios en la entrega 5.0.2 (01 Dec 2004)

Functionality added or changed:

  • Warning: Incompatible change! The precedence of operator has changed so that expressions such as are parsed correctly as rather than as . The pre-5.0 higher-precedence behavior can be obtained by enabling the new SQL mode.

  • now shows the thread specific status variables and shows the status variables for the whole server.

  • Added support for the “information database” that provides database metadata. See Capítulo 22, La base de datos de información .

  • A clause in a statement now can refer to columns in the clause, as required by standard SQL.

  • Added the and statements.

  • Modify so that it drops the account, including all its privileges. Formerly, it removed the account record only for an account that had had all privileges revoked.

  • Added syntax, where is , , or .

  • Added several status variables. See Sección 5.3.4, “Variables de estado del servidor”.

  • Implemented the clause for .

  • now works for views.

  • The and keywords are now accepted as synonyms for and .

  • Added initial support for rudimentary triggers (the and statements).

  • Added basic support for read-only server side cursors.

  • mysqldump --single-transaction --master-data is now able to take an online (non-blocking) dump of InnoDB and report the corresponding binary log coordinates, which makes a backup suitable for point-in-time recovery, roll-forward or replication slave creation. See Sección 8.7, “El programa de copia de seguridad de base de datos mysqldump”.

  • Added , , , options to mysqlbinlog (makes point-in-time recovery easier).

  • Made the MySQL server not react to signals and on Mac OS X 10.3. This is needed because under this OS, the MySQL server receives lots of these signals (reported as Bug #2030).

  • New and startup options. These allow you to set up a server to generate auto-increment values that don't conflict with another server.

  • MySQL now by default checks dates and in strict mode allows only fully correct dates. If you want MySQL to behave as before, you should enable the new SQL mode.

  • Added , , , , , and SQL modes. The mode is shorthand for all the preceding modes. When using mode , MySQL generates an error if you try to insert a wrong value in a column. It does not adjust the value to the closest possible legal value.

  • MySQL now remembers which columns were declared to have default values. In / mode, you now get an error if you do an without specifying all columns that don't have a default value. A side effect of this is that when you do for a new table, you no longer see a value for a column for which you didn't specify a default value.

  • The compilation flag was removed because you can get the same behavior by setting the system variable to .

  • Added SQL mode to prevent from automatically creating new users if it would otherwise do so, unless a password also is specified.

  • We now detect too-large floating point numbers during statement parsing and generate an error messages for them.

  • Renamed the system variable to . This variable now can have only two values:

    • or : Don't issue an error message (warning only) if a VIEW without presence of a key in the underlying table is used in queries with a clause for updating. (This is the default value.)

    • or : Prohibit update of a VIEW, which does not contain a key in the underlying table and the query uses a clause (usually get from GUI tools).

  • Reverted output format of to old pre-5.0.1 format that did not include a table type column. To get the additional column that lists the table type, use now.

  • The mysql_fix_privilege_tables script now initializes the global and privileges in the table to the value of the privilege in that table.

  • If the server finds that the table has not been upgraded to include the view-related privilege columns, it treats each account as having view privileges that are the same as its privilege.

  • InnoDB: If you specify the option in , InnoDB in an or a only locks the rows that it updates or deletes. This greatly reduces the probability of deadlocks.

  • A connection doing a rollback now displays "Rolling back" in the column of .

  • mysqlbinlog now prints an informative commented line (thread id, timestamp, server id, etc) before each , like it does for other queries; unless is used.

  • Two new server system variables were introduced. and can be set locally or globally, and are intended for use in controlling the behaviour of columns in master-to-master replication. Note that these variables are not intended to take the place of sequences. See Sección 5.3.3, “Variables de sistema del servidor”.

Bugs fixed:

  • Fixed that mysqlbinlog --read-from-remote-server sometimes couldn't accept two binary logfiles on the command line. (Bug #4507)

  • Fixed that mysqlbinlog --position --read-from-remote-server had incorrect lines. (Bug #4506)

  • Fixed that caused replication slave to stop. (Bug #4971)

  • Fixed that failed to disable . (Bug #5038)

  • Fixed that option had no effect if client read it from a configuration file using . (Bug #5073)

  • Fixed that did not work on some platforms (Mac OS X). (Bug #5064)

  • Fixed that mysql-test-run failed on the test if running test from the installed (the target of 'make install') directory. (Bug #5050)

  • Fixed that mysql-test-run failed on the test when run as Unix user 'root'. (Bug #4678)

  • Fixed an unlikely deadlock which could happen when using . (Bug #4810)

  • Fixed a crash when one connection got ed while it was doing . (Bug #4827)

  • Made block if server is running with binary logging; this ensures that the binary log position can be trusted when doing a full backup of tables and the binary log. (Bug #4953)

  • Fixed that the counter of an column was not reset by is the table was a temporary one. (Bug #5033)

  • Fixed slave SQL thread so that the statements it replicates don't advance its position (so that if it gets interrupted before the actual update query, it later redoes the ). (Bug #5705)

  • Fixed that if the slave SQL thread found a syntax error in a query (which should be rare, as the master parsed it successfully), it stops. (Bug #5711)

  • Fixed that if a write to a MyISAM table fails because of a full disk or an exceeded disk quota, it prints a message to the error log every 10 minutes, and waits until disk becomes free. (Bug #3248)

  • Fixed problem introduced in 4.0.21 where a connection starting a transaction, doing updates, then , then , would cause replication slaves to stop (complaining about error 1223). Bug surfaced when using the InnoDB script. (Bug #5949)

  • , , and are now replicated without any error code in the binary log. (Bug #5551)

  • If a connection had an open transaction but had done no updates to transactional tables (for example if had just done a then executed a non-transactional update, that update automatically committed the transaction (thus releasing InnoDB's row-level locks etc). (Bug #5714)

  • If a connection was interrupted by a network error and did a rollback, the network error code got stored into the and binary log events; that caused superfluous slave stops. (Bug #6522)

  • Fixed a bug which prevented mysqlbinlog from being able to read from , for example, when piping the output from zcat to mysqlbinlog. (Bug #7853)

C.1.11. Cambios en la entrega 5.0.1 (27 Jul 2004)

Note: This build passes our test suite and fixes a lot of reported bugs found in the previous 5.0.0 release. However, please be aware that this is not a “standard MySQL build” in the sense that there are still some open critical bugs in our bugs database at http://bugs.mysql.com/ that affect this release as well. We are actively fixing these and will make a new release where these are fixed as soon as possible. However, this binary should be a good candidate for testing new MySQL 5.0 features for future products.

Functionality added or changed:

  • Warning: Incompatible change! C API change: now requires a second argument. This is a source-level incompatibility that affects how you compile client programs; it does not affect the ability of compiled clients to communicate with older servers. See Sección 24.3.3.56, “”.

  • When installing a MySQL server as a Windows service, the installation command can include a option following the service name to cause the server to run using the Windows account that has limited privileges. This is in addition to the option that also can be given following the service name.

  • Added support for read-only and updatable views based on a single table or other updatable views. View use requires that you upgrade your grant tables to add the view-related privileges. See Sección 2.10.2, “Aumentar la versión de las tablas de privilegios”.

  • Implemented a new “greedy search” optimizer that can significantly reduce the time spent on query optimization for some many-table joins. (You are affected if not only some particular is slow, but even using for it takes a noticeable amount of time.) Two new system variables, and , can be used to fine-tune optimizer behavior.

  • A stored procedure is no longer “global.” That is, it now belongs to a specific database:

    • When a database is dropped, all routines belonging to that database are also dropped.

    • Procedure names may be qualified, for example,

    • When executed from another database, an implicit is in effect.

    • Explicit statements no longer are allowed in a stored procedure.

    See Capítulo 19, Procedimientos almacenados y funciones.

  • Fixed output field name and values according to standard. Field name changed from to , values are , and . (Bug #4603)

  • Added the system variable.

  • Added the server option.

  • Added status variable that reports optimizer cost for last compiled query.

  • Added the option to mysqlbinlog, for use in conjunction with .

  • Added the server option, which adds consistency guarantees between the content of tables and the binary log. See Sección 5.10.3, “El registro binario (Binary Log)”.

  • for tables is now mapped to instead of . This rebuilds the table, which updates index statistics and frees space in the clustered index.

  • is now a settable global variable (not only a startup option).

  • For replication of () tables: Made the master automatically write a statement to its binary log when a table is opened for the first time since master's startup. This is for the case where the slave has replicated a non-empty table, then the master is shut down and restarted: the table is now empty on master; the empties it on slave too. Note that even with this fix, between the master's restart and the first use of the table on master, the slave still has out-of-date data in the table. But if you use the option to populate the table on the master at startup, it ensures that the failing time interval is zero. (Bug #2477)

  • When a session having open temporary tables terminates, the statement automatically written to the binary log is now instead of , for more robustness.

  • The MySQL server now returns an error if is issued by a user without the privilege (in previous versions it just silently ignored the statement in this case).

  • Changed that when the MySQL server has binary logging disabled (that is, no option was used), then no transaction binary log cache is allocated for connections. This should save bytes of memory (32KB by default) for every connection.

  • Added the global variable and startup option, which makes the MySQL server synchronize its binary log to disk () after every Nth write to the binary log.

  • Changed the slave SQL thread to print less useless error messages (no more message duplication; no more messages when an error is skipped because of ).

  • , , single-table , and single-table now are written to the binary log even if they changed nothing on the master (for example, even if a matched no rows). The old behavior sometimes caused bad surprises in replication setups.

  • Replication and mysqlbinlog now have better support for the case that the session character set and collation variables are changed within a given session. See Sección 6.7, “Características de la replicación y problemas conocidos”.

  • Killing a statement does not result in the table being marked as “corrupted” any more; the table remains as if had not even started. See Sección 13.5.5.3, “Sintaxis de ”.

Bugs fixed:

  • Strange results with index (x, y) ... AND y>= ORDER BY ; (Bug #3155)

  • Subquery and order by (Bug #3118)

  • caused the client to hang if the database did not exist. (Bug #2333)

  • (which is a deprecated syntax, should be used instead) could crash the slave. (Bug #2516)

  • Multiple-table statements were never replicated by the slave if there were any options. (Bug #2527)

  • The MySQL server did not report any error if a statement (submitted through or ) was terminated by garbage characters. This can happen if you pass a wrong parameter to these functions. The result was that the garbage characters were written into the binary log. (Bug #2703)

  • Replication: If a client connects to a slave server and issues an administrative statement for a table (for example, or ), this could sometimes stop the slave SQL thread. This does not lead to any corruption, but you must use to get replication going again. (Bug #1858)

  • Made clearer the error message that one gets when an update is refused because of the option. (Bug #2757)

  • Fixed that rules apply to when the table pattern is , as is the case for and . (Bug #3000)

  • Fixed that when a event is found by the slave SQL thread in the middle of a transaction, the value of in remains correct. (Bug #3017)

  • Corrected the master's binary log position that reports when it is doing a crash recovery on a slave server. (Bug #3015)

  • Changed the column in to never show a value of -1. (Bug #2826)

  • Changed that when a statement is automatically written to the binary log when a session ends, the statement is recorded with an error code of value zero (this ensures that killing a on the master does not result in a superfluous error on the slave). (Bug #3063)

  • Changed that when a thread handling (also known as a thread) is killed, its statements are recorded with an error code of value zero (killing such a thread does not endanger replication, so we thus avoid a superfluous error on the slave). (Bug #3081)

  • Fixed deadlock when two commands were run at the same time. (Bug #2921)

  • Fixed that a statement never triggers a superfluous error on the slave, if it must be excluded given the options. The bug was that if the statement had been killed on the master, the slave would stop. (Bug #2983)

  • The option of mysqlbinlog now requires an argument.

  • Fixed a segmentation fault when running after . (Bug #2922)

  • mysqlbinlog --read-from-remote-server read all binary logs following the one that was requested. It now stops at the end of the requested file, the same as it does when reading a local binary log. There is an option to get the old behavior. (Bug #3204)

  • Fixed mysqlbinlog --read-from-remote-server to print the exact positions of events in the "at #" lines. (Bug #3214)

  • Fixed a rare error condition that caused the slave SQL thread spuriously to print the message and stop when it was not necessary to do so. (Bug #3401)

  • Fixed mysqlbinlog not to forget to print a statement under rare circumstances where the binary log contained a statement. (Bug #3415)

  • Fixed a memory corruption when replicating a when the master had version 3.23. (Bug #3422)

  • Multiple-table statements were always replicated by the slave if there were some options and no options. (Bug #3461)

  • Fixed a crash of the MySQL slave server when it was built with and replicating itself. (Bug #3568)

  • Fixed that in some replication error messages, a very long query caused the rest of the message to be invisible (truncated), by putting the query last in the message. (Bug #3357)

  • If was not set using startup options but with , the replication slave still complained that it was not set. (Bug #3829)

  • mysql_fix_privilege_tables didn't correctly handle the argument of its option. (Bug #4240)

  • Fixed potential memory overrun in (which required a compromised DNS server and certain operating systems). (Bug #4017, CAN-2004-0836)

  • During the installation process of the server RPM on Linux, mysqld was run as the system user, and if you had it created binary log files owned by in this directory, which remained owned by after the installation. This is now fixed by starting mysqld as the system user instead. (Bug #4038)

  • Made honor the value of . (Bug #4066)

  • The slave SQL thread refused to replicate if it examined more than 4 billion rows. (Bug #3871)

  • mysqlbinlog didn't escape the string content of user variables, and did not deal well when these variables were in non-ASCII character sets; this is now fixed by always printing the string content of user variables in hexadecimal. The character set and collation of the string is now also printed. (Bug #3875)

  • Fixed incorrect destruction of expression that led to a server crash on complex / expressions if query was ignored (either by a replication server because of rules, or by any MySQL server because of a syntax error). (Bug #3969, Bug #4494)

  • If failed while loading the data, the temporary table was not dropped. (Bug #4551)

  • Fixed that when a multiple-table failed to drop a table on the master server, the error code was not written to the binary log. (Bug #4553)

  • When the slave SQL thread was replicating a statement, it didn't show the statement in the output of . (Bug #4326)

C.1.12. Cambios en la entrega 5.0.0 (22 Dec 2003: Alpha)

Functionality added or changed:

  • Important note: If you upgrade to MySQL 4.1.1 or higher, it is difficult to downgrade back to 4.0 or 4.1.0! That is because, for earlier versions, is not aware of multiple tablespaces.

  • Added support for , , and .

  • The statement now takes and modifiers. The first is the same as with no modifier (it kills a given connection thread). The second kills only the statement currently being executed by the connection.

  • Added and functions.

  • Added and values as arguments for the and functions.

  • New binary log format that enables replication of these session variables: , , (which was replicated since 4.0.14, but here it's done more efficiently and takes less space in the binary logs), . Other variables (like character sets, , ...) will be replicated in upcoming 5.0.x releases.

  • Implemented Index Merge optimization for clauses. See Sección 7.2.6, “Index Merge Optimization”.

  • Basic support for stored procedures (SQL:2003 style). See Capítulo 19, Procedimientos almacenados y funciones.

  • Added , which can be of mixed (that is, global and local) types. See Sección 19.2.9.3, “La sentencia ”.

  • Easier replication upgrade (5.0.0 masters can read older binary logs and 5.0.0 slaves can read older relay logs). See Sección 6.5, “Compatibilidad entre versiones de MySQL con respecto a la replicación” for more details). The format of the binary log and relay log is changed compared to that of MySQL 4.1 and older.

Bugs fixed:

previous page start next page