2003년 9월 10일

MySQL 4.0.15가 새로 나왔습니다. 다운 받으시려거든
http://www.mysql.com/downloads/ 나 미러 사이트에서 하시면 됩니다.

이번 판은 현 버전에 대한 bugfix release입니다.

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:

변경되거나 추가된 기능:

* `mysqldump' now correctly quotes all identifiers when communicating
   with the server. This assures that during the dump process,
   `mysqldump' will never send queries to the server that result in a
   syntax error.  This problem is *not* related to the `mysqldump'
   program's output, which was not changed. (Bug #1148)

* Change result set metadata information so that `MIN()' and `MAX()'
   report that they can return `NULL' (this is true because an empty
   set will return `NULL'). (Bug #324)

* Produce an error message on Windows if a second `mysqld' server is
   started on the same TCP/IP port as an already running `mysqld'
   server.

* The `mysqld' server variables `wait_timeout', `net_read_timeout'
   and `net_write_timeout' now work on Windows.

* Added option `--sql-mode=NO_DIR_IN_CREATE' to make it possible for
   slaves to ignore `INDEX DIRECTORY' and `DATA DIRECTORY' options
   given to `CREATE TABLE'.  When this is mode is on, `SHOW CREATE
   TABLE' will not show the given directories.

* `SHOW CREATE TABLE' now shows the `INDEX DIRECTORY' and `DATA
   DIRECTORY' options, if they were specified when the table was
   created.

* The `open_files_limit' server variable now shows the real open
   files limit.

* `MATCH ... AGAINST()' in natural language mode now treats words
   that are present in more than 2,000,000 rows as stopwords.

* The Mac OS X installation disk images now include an additional
   `MySQLStartupItem.pkg' package that enables the automatic startup
   of MySQL on system bootup.  *Note Mac OS X installation::.

* Most of the documentation included in the binary tarball
   distributions (`.tar.gz') has been moved into a subdirectory
   `docs'.  *Note Installation layouts::.

* The manual is now included as an additional `info' file in the
   binary distributions. (Bug #1019)

* Many binary distributions now include the embedded server library
   (`libmysqld') by default.  *Note Nutshell Embedded MySQL::.

* MySQL can now use range optimisation for `BETWEEN' with
   non-constant limits. (Bug #991)

* Replication error messages now include the default database, so
   that users can check which database the failing query was run for.

* Now the slave does not replicate `SET PASSWORD' if it is
   configured to exclude the `mysql' database from replication (using
   for example `replicate-wild-ignore-table=mysql.%'). This was
   already the case for `GRANT' and `REVOKE' since version 4.0.13
   (though there was Bug #980 in 4.0.13 & 4.0.14, which has been
   fixed in 4.0.15).

* Rewrote the information shown in the `State' column of `SHOW
   PROCESSLIST' for replication threads and for `MASTER_POS_WAIT()'
   and added the most common states for these threads to the
   documentation, *note Replication Implementation Details::.

* Added a test in replication to detect the case where the master
   died in the middle of writing a transaction to the binlog; such
   unfinished transactions now trigger an error message on the slave.

* A `GRANT' command that creates an anonymous user (that is, an
   account with an empty username) no longer requires `FLUSH
   PRIVILEGES' for the account to be recognized by the server.  (Bug
   #473)

* `CHANGE MASTER' now flushes `relay-log.info'. Previously this was
   deferred to the next run of `START SLAVE', so if `mysqld' was
   shutdown on the slave after `CHANGE MASTER' without having run
   `START SLAVE', the relay log's name and position were lost. At
   restart they were reloaded from `relay-log.info', thus reverting
   to their old (incorrect) values from before `CHANGE MASTER' and
   leading to error messages (as the old relay log did not exist any
   more) and the slave threads refusing to start. (Bug #858)

MySQL 4.0.15 is now available on the following additional platforms:

* HP-UX 11i for Itanium
* OpenBSD 3.4 x86

The binaries for Linux/s390 are currently missing - they will be made
available as soon as possible.