MySQL 3.23.57 has been released

[Greg Weir]

 Hi,


 MySQL 3.23.57, a new version of the popular Open Source Database,
 has been released. It is now available in source and binary form for a
 number of platforms from our download pages at
 http://www.mysql.com/downloads/ and mirror sites.


 Note that not all mirror sites may be up to date at this point in time -
 if you can't find this version on some mirror, please try again later or
 choose another download site.


 This is a bugfix release for the former production version.


 Please refer to our bug database at http://bugs.mysql.com/ for more
 details about the individual bugs fixed in this version.


  News from the ChangeLog:

   * Fixed problem in alarm handling that could cause problems when
     getting a packet that is too large.

   * Fixed problem when installing MySQL as a service on Windows when one
     gave 2 arguments (option file group name and service name) to mysqld.

   * Fixed kill pid-of-mysqld to work on Mac OS X.

   * SHOW TABLE STATUS displayed incorrect Row_format value for tables
     that have been compressed with myisampack. (Bug #427)

   * SHOW VARIABLES LIKE 'innodb_data_file_path' displayed only the name
     of the first datafile (bug #468).

   * Fixed security problem where mysqld didn't allow one to UPDATE rows
     in a table even if one had a global UPDATE privilege and a database
     SELECT privilege.

   * Fixed a security problem with SELECT and wildcarded select list, when
     user only had partial column SELECT privileges on the table.

   * Fixed unlikely problem in optimising WHERE clause with a constant
     expression such as in WHERE 1 AND (a=1 AND b=1).

   * Fixed problem on IA64 with timestamps that caused mysqlbinlog to
     fail.

   * The default option for innodb_flush_log_at_trx_commit was changed
     from 0 to 1 to make InnoDB tables ACID by default. See section 7.5.3
     InnoDB Startup Options.

   * Fixed problem with too many allocated alarms on slave when connecting
     to master many times (normally not a very critical error).

   * Fixed a bug in replication of temporary tables. (Bug #183)

   * Fixed 64 bit bug that affected at least AMD hammer systems.

   * Fixed a bug when doing LOAD DATA INFILE IGNORE: When reading the
     binary log, mysqlbinlog and the replication code read REPLACE instead
     of IGNORE. This could make the slave's table become different from
     the master's table. (Bug #218)

   * Fixed a bug in MyISAM when a row is inserted into a table with a
     large number of NULL columns. Bug was caused by incorrect calculation of
     the record length, as the space required for storage of NULL bits was
     not added to the total record length.

   * The binary log was not locked during TRUNCATE table_name or DELETE
     FROM table_name statements, which could cause an INSERT to table_name to
     be written to the log before the TRUNCATE or DELETE statements.

   * Fixed rare bug in UPDATE of InnoDB tables where one row could be
     updated multiple times.

   * Produce an error for empty table and column names.

   * Changed PROCEDURE ANALYSE() to report DATE instead of NEWDATE.

   * Changed PROCEDURE ANALYSE(#) to restrict the number of values in an
     ENUM column to # also for string values.

   * mysqldump no longer silently deletes the binary logs when invoked
     with the --master-data or --first-slave option; while this behaviour
     was convenient for some users, others may suffer from it. Now one has
     to explicitly ask for binary logs to be deleted by using the new
     --delete-master-logs option.

   * Fixed a bug in mysqldump when it was invoked with the --master-data
     option: The CHANGE MASTER TO statements that were appended to the SQL
     dump had incorrect coordinates. (Bug #159)


 Regards,

      - Greg

--
Greg Weir, Production Engineer
MySQL AB, www.mysql.com

Are you MySQL certified?  www.mysql.com/certification