[前][次][番号順一覧][スレッド一覧]

mysql:12193

From: zen kishimoto <zen kishimoto <zen@xxxxxxxxxx>>
Date: Tue, 27 Sep 2005 07:28:53 -0700
Subject: [mysql 12193] Re: MySQL 5.0.13-rc

RC = Release Candidate
だそうです。

岸本



とみたまさひろ wrote:

>とみたです。
>
>MySQL 5.0.13-rc が出たようです。
>
>前は -beta の次は -gamma だったんだけど、-rc になったのかな…?
>
>日本語に関係しそうなのは、
>
>   * A new command line argument was added to mysqld to ignore client
>     character set information sent during handshake, and use server side
>     settings instead, to reproduce 4.0 behaviour
>     (Bug #9948 (http://bugs.mysql.com/9948)):
>      mysqld --skip-character-set-client-handshake
>
>   * UNION [DISTINCT] was not removing all duplicates for multi-byte
>     character values. (Bug #12891 (http://bugs.mysql.com/12891))
>
>くらい?
>
>
>Subject: MySQL 5.0.13-rc has been released
>Date: Mon, 26 Sep 2005 21:51:33 +0200 (CEST)
>
>Hi,
>
>MySQL 5.0.13, a new version of the popular Open Source Database Management
>System, has been released. The Community Edition is now available in source
>and binary form for a number of platforms from our download pages at
>http://dev.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 the first published release candidate (previously known as "gamma
>release") in the 5.0 series. All attention will continue to be focused on
>fixing bugs and stabilizing 5.0 for the upcoming production release.
>We would like to encourage you to give this release a try! Your feedback
>is very important to us.
>
>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:
>
>Functionality added or changed
>
>   * Better detection of connection timeout for replication servers on
>     Windows allows elimination of extraneous Lost connection errors in the
>     error log. (Bug #5588 (http://bugs.mysql.com/5588))
>   * The counters for the Key_read_requests, Key_reads, Key_write_requests,
>     and Key_writes status variables were changed from unsigned long to
>     unsigned longlong to accommodate larger variables without rollover.
>     (Bug #12920 (http://bugs.mysql.com/12920))
>   * The restriction on the use of PREPARE, EXECUTE, and DEALLOCATE PREPARE
>     within stored procedures was lifted. The restriction still applies to
>     stored functions and triggers.
>     (Bug #10975 (http://bugs.mysql.com/10975),
>     Bug #7115 (http://bugs.mysql.com/7115),
>     Bug #10605 (http://bugs.mysql.com/10605))
>   * A new command line argument was added to mysqld to ignore client
>     character set information sent during handshake, and use server side
>     settings instead, to reproduce 4.0 behaviour
>     (Bug #9948 (http://bugs.mysql.com/9948)):
>      mysqld --skip-character-set-client-handshake
>   * OPTIMIZE TABLE and HANDLER now are prohibited in stored procedures and
>     functions and in triggers. (Bug #12953 (http://bugs.mysql.com/12953),
>     Bug #12995 (http://bugs.mysql.com/12995))
>   * InnoDB: The TRUNCATE TABLE statement for InnoDB tables always resets the
>     counter for an AUTO_INCREMENT column now, regardless of whether there is
>     a foreign key constraint on the table. (Beginning with 5.0.3, TRUNCATE
>     TABLE reset the counter, but only if there was no such constraint.)
>     (Bug #11946 (http://bugs.mysql.com/11946))
>   * The LEAST() and GREATEST() functions used to return NULL only if all
>     arguments were NULL. Now they return NULL if any argument is NULL, the
>     same as Oracle. (Bug #12791 (http://bugs.mysql.com/12791))
>   * Two new collations have been added for Esperanto: utf8_esperanto_ci and
>     ucs2_esperanto_ci.
>   * Reorder network startup to come after all other initialization,
>     particularly storage engine startup which can take a long time. This
>     also prevents MySQL from being run on a privileged port (any port under
>     1024) unless run as the root user.
>     (Bug #11707 (http://bugs.mysql.com/11707))
>   * The Windows binary packages are now compiled with the Microsoft Visual
>     Studio 2003 compiler instead of Microsoft Visual C++ 6.0
>   * The binaries compiled with the Intel icc compiler are now built using
>     icc 9.0 instead of icc 8.1. You will have to install new versions of the
>     Intel icc runtime libraries, which are available from here:
>     (http://dev.mysql.com/downloads/os-linux.html)
>
>Bugs fixed
>
>   * Within a stored procedure, fetching a large number of rows in a loop
>     using a cursor could result in a server crash or an out of memory error.
>     Also, values inserted within a stored procedure using a cursor were
>     interpreted as latin1 even if character set variables had been set to a
>     different character set. (Bug #6513 (http://bugs.mysql.com/6513),
>     Bug #9819 (http://bugs.mysql.com/9819))
>   * For a server compiled with yaSSL, clients that used MySQL Connector/J
>     were not able to establish SSH connections.
>     (Bug #13029 (http://bugs.mysql.com/13029))
>   * When used in view definitions, DAYNAME(expr), DAYOFWEEK(expr),
>     WEEKDAY(expr) were incorrectly treated as though the expression was
>     TO_DAYS(expr) or TO_DAYS(TO_DAYS(expr)).
>     (Bug #13000 (http://bugs.mysql.com/13000))
>   * Incorrect implicit nesting of joins caused the parser to fail on queries
>     of the form SELECT ... FROM t1 JOIN t2 JOIN t3 ON t1.t1col = t3.t3col
>     with an Unknown column 't1.t1col' in 'on clause' error.
>     (Bug #12943 (http://bugs.mysql.com/12943))
>   * NDB: A cluster shutdown following the crash of a data node would fail to
>     terminate the remaining node processes, even though ndb_mgm showed the
>     shutdown request as having been completed. (Bug #10938
>     (http://bugs.mysql.com/10938), Bug #9996 (http://bugs.mysql.com/9996),
>     Bug #11623 (http://bugs.mysql.com/11623))
>   * A column that can be NULL was not handled properly for WITH ROLLUP in a
>     subquery or view. (Bug #12885 (http://bugs.mysql.com/12885))
>   * Within a transaction, the following statements now cause an implicit
>     commit: CREATE FUNCTION, DROP FUNCTION, DROP PROCEDURE, ALTER FUNCTION,
>     ALTER PROCEDURE, CREATE PROCEDURE. This corrects a problem where these
>     statements followed by ROLLBACK might not be replicated properly.
>     (Bug #12870 (http://bugs.mysql.com/12870))
>   * Simultaneous execution of DML statements and CREATE TRIGGER or DROP
>     TRIGGER statements on the same table could cause server crashes or
>     errors. (Bug #12704 (http://bugs.mysql.com/12704))
>   * If a stored function invoked from a SELECT failed with an error, it
>     could cause the client connection to be dropped. Now such errors
>     generate warnings instead so as not to interrupt the SELECT.
>     (Bug #12379 (http://bugs.mysql.com/12379))
>   * A concurrency problem for CREATE ... SELECT could cause a server crash.
>     (Bug #12845 (http://bugs.mysql.com/12845))
>   * The server incorrectly generated an Unknown table error message when for
>     attempts to drop tables in the INFORMATION_SCHEMA database. Now it
>     issues an Access denied message.
>     (Bug #9846 (http://bugs.mysql.com/9846))
>   * The server allowed privileges to be granted explicitly for the
>     INFORMATION_SCHEMA database. Such privileges are always implicit and
>     should not be grantable. (Bug #10734 (http://bugs.mysql.com/10734))
>   * The server allowed TEMPORARY tables and stored procedures to be created
>     in the INFORMATION_SCHEMA database.
>     (Bug #9683 (http://bugs.mysql.com/9683), Bug #10708 (http://bugs.mysql.com/10708))
>   * The server failed to disallow SET AUTOCOMMIT in stored functions and
>     triggers. It is allowed to change the value of AUTOCOMMIT in stored
>     procedures, but a runtime error might occur if the procedure is invoked
>     from a stored function or trigger.
>     (Bug #12712 (http://bugs.mysql.com/12712))
>   * Using an INOUT parameter with a DECIMAL data type in a stored procedure
>     caused a server crash. (Bug #12979 (http://bugs.mysql.com/12979))
>   * Performing an IS NULL check on the MIN() or MAX() of an indexed columns
>     produced incorrect results. (Bug #12695 (http://bugs.mysql.com/12695))
>   * The mysql.server script contained incorrect path for the libexec
>     directory. (Bug #12550 (http://bugs.mysql.com/12550))
>   * The NDB START BACKUP command could be interrupted by a SHOW command.
>     (Bug #13054 (http://bugs.mysql.com/13054))
>   * The LIKE ... ESCAPE syntax produced invalid results when escape
>     character was larger than one byte.
>     (Bug #12611 (http://bugs.mysql.com/12611))
>   * A client connection thread cleanup problem caused the server to crash
>     when closing the connection if the binary log was enabled.
>     (Bug #12517 (http://bugs.mysql.com/12517))
>   * Using AS to rename a column selected from a view in a subquery made it
>     not possible to refer to that column in the outer query.
>     (Bug #12993 (http://bugs.mysql.com/12993))
>   * The character_set_system system variable could not be selected with
>     SELECT @@character_set_system.
>     (Bug #11775 (http://bugs.mysql.com/11775))
>   * A view-creation statement of the form CREATE VIEW name AS SELECT ...
>     FROM tbl_name AS name failed with a Not unique table/alias: 'name'
>     error. (Bug #6808 (http://bugs.mysql.com/6808))
>   * UNION [DISTINCT] was not removing all duplicates for multi-byte
>     character values. (Bug #12891 (http://bugs.mysql.com/12891))
>   * Multiplying a DECIMAL value within a loop in a stored routine could
>     incorrectly result in a value of NULL.
>     (Bug #12938 (http://bugs.mysql.com/12938))
>   * mysql and mysqldump were ignoring the --defaults-extra-file option. (Bug
>     #12917 (http://bugs.mysql.com/12917))
>   * Columns named in the USING() clause of JOIN ... USING() were incorrectly
>     resolved in case-sensitive fashion.
>     (Bug #13067 (http://bugs.mysql.com/13067))
>   * Local variables in stored routines were not always initialized
>     correctly. (Bug #13133 (http://bugs.mysql.com/13133))
>   * SHOW FIELDS FROM schemaname.viewname caused error 1046 when no default
>     schema was set. (Bug #12905 (http://bugs.mysql.com/12905))
>   * The value of character_set_results could be set to NULL, but returned
>     the string "NULL" when retrieved.
>     (Bug #12363 (http://bugs.mysql.com/12363))
>   * InnoDB: Limit recursion depth to 200 in deadlock detection to avoid
>     running out of stack space. (Bug #12588 (http://bugs.mysql.com/12588))
>   * GROUP_CONCAT() ignored an empty string if it was the first value to
>     occur in the result. (Bug #12863 (http://bugs.mysql.com/12863))
>   * Outer join elimination was erroneously applied for some queries that
>     used a NOT BETWEEN condition, an IN(value_list) condition, or an IF()
>     condition. (Bug #12101 (http://bugs.mysql.com/12101), Bug #12102
>     (http://bugs.mysql.com/12102))
>   * SHOW FIELDS truncated the TYPE column to 40 characters.
>     (Bug #7142 (http://bugs.mysql.com/7142))
>   * Use of PREPARE and EXECUTE with a statement that selected from a view in
>     a subquery could cause a server crash.
>     (Bug #12651 (http://bugs.mysql.com/12651))
>   * On HP-UX 11.x (PA-RISC), the -L option caused mysqlimport to crash. (Bug
>     #12958 (http://bugs.mysql.com/12958))
>   * If the binary log is enabled, execution of a stored procedure that
>     modifies table data and uses user variables could cause a server crash
>     or incorrect information to be written to the binary log.
>     (Bug #12637 (http://bugs.mysql.com/12637))
>   * Queries with subqueries, where the inner subquery uses the range or
>     index_merge access method, could return incorrect results.
>     (Bug #12720 (http://bugs.mysql.com/12720))
>   * After changing the character set with SET CHARACTER SET, the result of
>     the GROUP_CONCAT() function was not converted to the proper character
>     set. (Bug #12829 (http://bugs.mysql.com/12829))
>   * A bug introduced in MySQL 5.0.12 caused SHOW TABLE STATUS to display an
>     Auto_increment value of 0 for InnoDB tables.
>     (Bug #12973 (http://bugs.mysql.com/12973))
>   * Foreign keys were not properly enforced in TEMPORARY tables. Foreign
>     keys now are disallowed in TEMPORARY tables.
>     (Bug #12084 (http://bugs.mysql.com/12084))
>   * Replication of LOAD DATA INFILE failed between systems that use
>     different pathname syntax (such as delimiter characters).
>     (Bug #11815 (http://bugs.mysql.com/11815))
>   * Within a stored procedure, a server crash was caused by assigning to a
>     VARCHAR INOUT parameter the value of an expression that included the
>     variable itself. (For example, SET c = c.)
>     (Bug #12849 (http://bugs.mysql.com/12849))
>   * SELECT ... JOIN ... ON ... JOIN ... USING caused a server crash.
>     (Bug #12977 (http://bugs.mysql.com/12977))
>   * Using GROUP BY when selecting from a view in some cases could cause
>     incorrect results to be returned.
>     (Bug #12922 (http://bugs.mysql.com/12922))
>   * A lock wait timeout caused InnoDB to roll back the entire current
>     transaction. Now it rolls back only the most recent SQL statement.
>     (Bug #12308 (http://bugs.mysql.com/12308))
>   * myisampack did not properly pack BLOB values larger than 2^24 bytes.
>     (Bug #4214 (http://bugs.mysql.com/4214))
>   * Incorrect results could be returned from a view processed using a
>     temporary table. (Bug #12941 (http://bugs.mysql.com/12941))
>   * The server crashed when one thread resized the query cache while another
>     thread was using it. (Bug #12848 (http://bugs.mysql.com/12848))
>   * mysqld_multi now quotes arguments on command lines that it constructs to
>     avoid problems with arguments that contain shell metacharacters.
>     (Bug #11280 (http://bugs.mysql.com/11280))
>   * InnoDB: A consistent read could return inconsistent results due to a bug
>     introduced in MySQL 5.0.5. (Bug #12947 (http://bugs.mysql.com/12947))
>   * Deadlock occurred when several account management statements were run
>     (particularly between FLUSH PRIVILEGES/SET PASSWORD and GRANT/REVOKE
>     statements). (Bug #12423 (http://bugs.mysql.com/12423))
>   * The Windows installer made a change to one of the mysql.proc table
>     files, causing stored routine functionality to be compromised. The
>     Windows installer now never overwrites files in the MySQL data
>     directory. During an upgrade from one version to another, a file in the
>     data directory will not be overwritten even if it has not been modified
>     since it was put there by an older installer.
>     If you have already lost access to stored routines because of this
>     problem, you can get them back using the following procedure:
>        + Stop the server.
>        + In the mysql\data directory under your MySQL installation
>          directory, and replace the proc.frm file with corresponding file
>          from the version of MySQL that you were using before you upgraded.
>        + Start the server
>        + Start the mysql command-line client (use the root account or
>          another account that has full database privileges) and execute the
>          mysql_fix_privilege_tables.sql script that upgrades the grant
>          tables to the current structure. Instructions for doing this are
>          given in Section 2.10.8, "Upgrading the Grant Tables."
>     After this, all stored routine functionality should work.
>     (Bug #12820 (http://bugs.mysql.com/12820))
>   * On Windows, the server was preventing tables from being created if the
>     table name was a prefix of a forbidden name. For example, nul is a
>     forbidden name because it's the same as a Windows device name, but a
>     table with the name of n or nu was being forbidden as well.
>     (Bug #12325 (http://bugs.mysql.com/12325))
>   * InnoDB was too permissive with LOCK TABLE ... READ LOCAL and alowed new
>     inserts into the table. Now READ LOCAL is equivalent to READ for InnoDB.
>     This will cause slightly more locking in mysqldump, but makes InnoDB
>     table dumps consistent with MyISAM table dumps.
>     (Bug #12410 (http://bugs.mysql.com/12410))
>   * Use of the mysql client HELP command from within a stored routine caused
>     a “packets out of order” error and a lost connection. Now HELP is
>     detected and disallowed within stored routines.
>     (Bug #12490 (http://bugs.mysql.com/12490))
>   * Use of yaSSL for a secure client connection caused LOAD DATA LOCAL
>     INFILE to fail. (Bug #11286 (http://bugs.mysql.com/11286))
>   * SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION no longer qualify the
>     routine name with the database name, for consistency with the behavior
>     of SHOW CREATE TABLE. (Bug #10362 (http://bugs.mysql.com/10362))
>   * A UNION of long utf8 VARCHAR columns was sometimes returned as a column
>     with a LONGTEXT data type rather than VARCHAR. This could prevent such
>     queries from working at all if selected into a MEMORY table because the
>     MEMORY storage engine does not support the TEXT data types.
>     (Bug #12537 (http://bugs.mysql.com/12537))
>   * If a client has opened an InnoDB table for which the .ibd file is
>     missing, InnoDB would not honor a DROP TABLE statement for the table.
>     (Bug #12852 (http://bugs.mysql.com/12852))
>   * ALTER TABLE ... DISCARD TABLESPACE for non-InnoDB table caused the
>     client to lose the connection. (The server was not returning the error
>     properly.) (Bug #12207 (http://bugs.mysql.com/12207))
>   * DO IFNULL(NULL, NULL) and SELECT CAST(IFNULL(NULL, NULL) AS DECIMAL)
>     caused a server crash. (Bug #12841 (http://bugs.mysql.com/12841))
>   * When using a cursor, a SELECT statement that uses a GROUP BY clause
>     could return incorrect results. (Bug #11904 (http://bugs.mysql.com/11904))
>   * The SYSDATE() function now returns the time at which it was invoked. In
>     particular, within a stored routine or trigger, SYSDATE() returns the
>     time at which it executes, not the time at which the stored routine or
>     triggering statement began to execute.
>     (Bug #12480 (http://bugs.mysql.com/12480))
>   * CREATE VIEW inside a stored procedure caused a server crash if the table
>     underlying the view had been deleted.
>     (Bug #12468 (http://bugs.mysql.com/12468))
>   * A memory leak resulting from repeated SELECT ... INTO statements inside
>     a stored procedure could cause the server to crash.
>     (Bug #11333 (http://bugs.mysql.com/11333))
>
>Bye,
>	LenZ
>- -- 
> Lenz Grimmer <lenz@xxxxxxxxxx>
> Senior Production Engineer
> MySQL GmbH, http://www.mysql.de/
> Hamburg, Germany
> Are you MySQL certified?  http://www.mysql.com/certification/
>
>  
>

-- 
Zen Kishimoto                      www.ipdevices.com
IP Devices, Inc.                   zen@xxxxxxxxxx
2175 De La Cruz Blvd., Suite 10    (408) 567-9391
Santa Clara, CA 95050              (801) 720-8847 (FAX)



[前][次][番号順一覧][スレッド一覧]

     12192 2005-09-27 23:19 [とみたまさひろ <tomm] MySQL 5.0.13-rc                         
->   12193 2005-09-27 23:28 ┗[zen kishimoto <zen@x]