SHOW OPEN TABLES 가 되는군요... 어서빨리 안정버전이 나오길... ^^;;

-------------------------------------------------------------------

Hi,

MySQL 5.0.12-beta, 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 eighth published Beta release in the 5.0 series.
All attention will continue to be focused on fixing bugs and stabilizing
5.0 for later production release.

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.

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


Changes in release 5.0.12:

Functionality added or changed:
* Recursive triggers are detected and disallowed. (Bug #11896
(http://bugs.mysql.com/11896),Bug#12644(http://bugs.mysql.com/12644))
* Natural joins and joins with USING, including outer join variants, now
are processed according to the SQL:2003 standard. (Bug #4789
(http://bugs.mysql.com/4789), Bug #6136 (http://bugs.mysql.com/6136),
Bug #6276 (http://bugs.mysql.com/6276), Bug #6495
(http://bugs.mysql.com/6495), Bug #6558 (http://bugs.mysql.com/6558),
Bug #9978 (http://bugs.mysql.com/9978), Bug #10646
(http://bugs.mysql.com/10646),Bug#10972(http://bugs.mysql.com/10972),
Bug #11710 (http://bugs.mysql.com/11710))
* SHOW OPEN TABLES now supports FROM and LIKE clauses. (Bug #12183
(http://bugs.mysql.com/12183))
* SHOW TABLE STATUS FROM INFORMATION_SCHEMA now sorts output by table
name the same as it does forother databases. (Bug #12315
(http://bugs.mysql.com/12315))
* SHOW ENGINE INNODB STATUS now can display longer query strings. (Bug
#7819 (http://bugs.mysql.com/7819))
* Added the SLEEP() function, which pauses for the number of seconds
given by its argument. (Bug #6760 (http://bugs.mysql.com/6760))
* Trying to drop the default keycache by setting
@@global.key_buffer_size
to zero now returns a warning that the default keycache cannot be
dropped. (Bug #10473 (http://bugs.mysql.com/10473))
* The stability of cursors when used with InnoDB tables was greatly
improved. (Bug #11832 (http://bugs.mysql.com/11832), Bug #12243
(http://bugs.mysql.com/12243),Bug#11309(http://bugs.mysql.com/11309))
* It is no longer possible to issue FLUSH commands from within stored
functions or triggers. See Section I.1, "Restrictions on Stored
Routines and Triggers" for details.
(Bug #12280 (http://bugs.mysql.com/12280),
Bug #12307 (http://bugs.mysql.com/12307))
* INFORMATION_SCHEMA objects are now reported as a SYSTEM VIEW table
type. (Bug #11711 (http://bugs.mysql.com/11711))

Bugs fixed:
* An optimizer estimate of zero rows for a non-empty InnoDB table used
in a left or right join could cause incomplete rollback for the table.
(Bug #12779 (http://bugs.mysql.com/12779))
* Interleaved execution of stored procedures and functions could be
written to the binary log incorrectly, causing replication slaves to
get out of sync. (Bug #12335 (http://bugs.mysql.com/12335))
* A query of the form SHOW TABLE STATUS FROM db_name WHERE name IN
(select_query) would crash the server. (Bug #12636
(http://bugs.mysql.com/12636))
* Users created using an IP address or other alias rather than a
hostname listed in /etc/hosts could not set their own passwords.
(Bug #12302 (http://bugs.mysql.com/12302))
* Using DESCRIBE on a view after renaming a column in one of the view's
base tables caused the server to crash. (Bug #12533
(http://bugs.mysql.com/12533))
* DELETE or UPDATE for an indexed MyISAM table could fail. This was due
to a change in end-space comparison behavior from 4.0 to 4.1. (Bug
#12565 (http://bugs.mysql.com/12565))
* Joins on VARCHAR columns of different lengths could produce incorrect
results. (Bug #11398 (http://bugs.mysql.com/11398))
* A “Duplicate column name” error no longer occurs when selecting from a
view defined as SELECT * from a join that uses a USING clause on
tables that have a common column name. (Bug #6558
(http://bugs.mysql.com/6558))
* Invocations of the SLEEP() function incorrectly could get optimized
away for statements in which it occurs. Statements containing SLEEP()
incorrectly could be stored in the query cache. (Bug #12689
(http://bugs.mysql.com/12689))
* NDB Cluster: An ALTER TABLE command caused loss of data stored prior
to the issuing of the command.(Bug #12118
(http://bugs.mysql.com/12118))
* Query cache is switched off if a thread (connection) has tables
locked. This prevents invalid results where the locking thread inserts
values between a second thread connecting and selecting from the
table. (Bug #12385 (http://bugs.mysql.com/12385))
* NOW(), CURRENT_TIME and values generated by timestamp columns are now
constant for the duration of a stored function or trigger. This
prevents the breaking of statements-based replication. (Bug #12480
(http://bugs.mysql.com/12480),Bug#12481(http://bugs.mysql.com/12481))
* Some statements executed on a master server caused the SQL thread on a
slave to run out of memory. (Bug #12532 (http://bugs.mysql.com/12532))
* A SELECT DISTINCT query with a constant value for one of the columns
would return only a single row. (Bug #12625
(http://bugs.mysql.com/12625))
* NDB Cluster: Cluster failed to take character set data into account
when recomputing hashes (and thus could not locate records for
updating or deletion) following a configuration change and node
restart. (Bug #12220 (http://bugs.mysql.com/12220))
* NDB Cluster: Wrong error message displayed when cluster management
server closed port while mysqld was connecting. (Bug #10950
(http://bugs.mysql.com/10950))
* A view was allowed to depend on a function that referred to a
temporary table. (Bug #10970 (http://bugs.mysql.com/10970))
* Prepared statement parameters could cause errors in the binary log if
the character set was cp932. (Bug #11338
(http://bugs.mysql.com/11338))
* The CREATE_OPTIONS column of INFORMATION_SCHEMA.TABLES showed
incorrect options for tables in INFORMATION_SCHEMA. (Bug #12397
(http://bugs.mysql.com/12397))
* MEMORY tables using B-Tree index on 64-bit platforms could produce
false table is full errors. (Bug #12460 (http://bugs.mysql.com/12460))
* Issuing FLUSH INSTANCES followed by STOP INSTANCE caused instance
manager to crash. (Bug #10957 (http://bugs.mysql.com/10957))
* Duplicate instructions in stored procedures resulted in incorrect
execution when the optimizer optimized the duplicate code away. (Bug
#12168 (http://bugs.mysql.com/12168))
* SHOW TABLES FROM returned wrong error message if the schema specified
did not exist. (Bug #12591 (http://bugs.mysql.com/12591))
* ROW() function returned incorrect result when comparison involved NULL
values. (Bug #12509 (http://bugs.mysql.com/12509))
* Views with multiple UNION and UNION ALL produced incorrect results.
(Bug #10624 (http://bugs.mysql.com/10624))
* Stored procedures with particularly long loops could crash server due
to memory leak. (Bug #12297 (http://bugs.mysql.com/12297), Bug #11247
(http://bugs.mysql.com/11247))
* Trigger and stored procedure execution could break replication. (Bug
#12482 (http://bugs.mysql.com/12482))
* A server crash could result from an update of a view defined as a
join, even though the update only updated a single table. (Bug #12569
(http://bugs.mysql.com/12569))
* On Windows when the --innodb_buffer_pool_awe_mem_mb option has been
given, the server detects whether AWE support is available and has
been compiled into the server, and displays an appropriate error
message if not. (Bug #6581 (http://bugs.mysql.com/6581))
* The NUMERIC_SCALE column of the INFORMATION_SCHEMA.COLUMNS table
should be returned as 0 for integer columns. It was being returned as
NULL. (Bug #12301 (http://bugs.mysql.com/12301))
* The COLUMN_DEFAULT column of the INFORMATION_SCHEMA.COLUMNS table
should be returned as NULL if a column has no default value. An empty
string was being returned if the column was defined as NOT NULL. (Bug
#12518 (http://bugs.mysql.com/12518))
* Slave I/O threads were considered to be in the running state when
launched (rather than after successfully connecting to the master
server), resulting in incorrect SHOW SLAVE STATUS output. (Bug #10780
(http://bugs.mysql.com/10780))
* Column names in subqueries must be unique, but were not being checked
for uniqueness. (Bug #11796 (http://bugs.mysql.com/11796))
* On Windows, the server could crash during shutdown if both replication
threads and normal client connection threads were active. (Bug #11796
(http://bugs.mysql.com/11796))
* Some subqueries of the form SELECT ... WHERE ROW(...) IN (subquery)
were being handled incorrectly. (Bug #11867
(http://bugs.mysql.com/11867))
* Selecting from a view after INSERT statements for the view's
underlying table yielded different results than subsequent selects.
(Bug #12382 (http://bugs.mysql.com/12382))
* The mysql_info() C API function could return incorrect data when
executed as part of a multi-statement that included a mix of
statements that do and do not return information. (Bug #11688
(http://bugs.mysql.com/11688))
* When restoring INFORMATION_SCHEMA as the default database after
failing to execute a stored procedure in an inaccessible database, the
server returned a spurious ERROR 42000: Unknown database
'information_schema' message. (Bug #12318
(http://bugs.mysql.com/12318))
* InnoDB: Limit recursion depth to 200 in deadlock detection to avoid
running out of stack space. (Bug #12588 (http://bugs.mysql.com/12588))
* Renamed the rest() macro in my_list.h to list_rest() to avoid name
clashes with user code. (Bug #12327 (http://bugs.mysql.com/12327))
* DATE_ADD() and DATE_SUB() were converting invalid dates to NULL in
TRADITIONAL SQL mode rather than rejecting them with an error. (Bug
#10627 (http://bugs.mysql.com/10627))
* A trigger that included a SELECT statement could cause a server crash.
(Bug #11587 (http://bugs.mysql.com/11587))
* An incorrect conversion from double to ulonglong caused indexes not to
be used for BDB tables on HP-UX. (Bug #10802
(http://bugs.mysql.com/10802))
* myisampack failed to delete .TMD temporary files when run with -T
option. (Bug #12235 (http://bugs.mysql.com/12235))
* Added portability check for Intel compiler to address a problem
compiling InnoDB code. (Bug #11510 (http://bugs.mysql.com/11510))
* XA allowed two active transactions to be started with the same XID.
(Bug #12162 (http://bugs.mysql.com/12162))
* Concatenating USER()/DATEBASE() with a column produces invalid
results. (Bug #12351 (http://bugs.mysql.com/12351))
* Creating a view that included the TIMESTAMPDIFF() function resulted in
invalid view. (Bug #12298 (http://bugs.mysql.com/12298))
* Comparison of InnoDB multi-part primary keys that include VARCHAR
columns can result in incorrect results. (Bug #12340
(http://bugs.mysql.com/12340))
* For PKG installs on Mac OS X, the preinstallation and postinstallation
scripts were being run only for new installations and not for upgrade
installations, resulting in an incomplete installation process. (Bug
#11380 (http://bugs.mysql.com/11380))
* Using cursors and nested queries for the same table, corrupted results
were returned for the outer query. (Bug #11909
(http://bugs.mysql.com/11909))
* User variables were not automatically cast for comparisons, causing
queries to fail if the column and connection character sets differed.
Now when mixing strings with different character sets but the same
coercibility, allow conversion if one character set is a superset of
the other. (Bug #10892 (http://bugs.mysql.com/10892))
* Selecting from a view defined as a join over many tables could result
in a server crash due to miscalculation of the number of conditions in
the WHERE clause. (Bug #12470 (http://bugs.mysql.com/12470))
* Pathame values for options such as ---basedir or --datadir didn't work
on Japanese Windows machines for directory names containing multibyte
characters having a second byte of 0x5C (‘\’). (Bug #5439
(http://bugs.mysql.com/5439))
* A race condition between server threads could cause a crash if one
thread deleted a stored routine while another thread was executing a
stored routine. (Bug #12228 (http://bugs.mysql.com/12228))
* Mishanding of comparison for rows containg NULL values against rows
produced by an IN subquery could cause a server crash. (Bug #12392
(http://bugs.mysql.com/12392))
* Inserting NULL into a GEOMETRY column for a table that has a trigger
could result in a server crash if the table was subsequently dropped.
(Bug #12281 (http://bugs.mysql.com/12281))
* A failure to obtain a lock for an IN SHARE MODE query could result in
a server crash. (Bug #12082 (http://bugs.mysql.com/12082))
* SELECT ... INTO var_name within a trigger could cause a server crash.
(Bug #11973 (http://bugs.mysql.com/11973))
* INSERT ... SELECT ... ON DUPLICATE KEY UPDATE could fail with an
erroneous “Column 'col_name' specified twice” error. (Bug #10109
(http://bugs.mysql.com/10109))
* SHOW TABLE STATUS sometimes reported a Row_format value of Dynamic for
MEMORY tables, though such tables always have a format of Fixed. (Bug
#3094 (http://bugs.mysql.com/3094))
* A query using a LEFT JOIN, an IN subquery on the outer table, and an
ORDER BY clause, caused the server to crash when cursors were enabled.
(Bug #11901 (http://bugs.mysql.com/11901))
* Using a stored procedure that referenced tables in the
INFORMATION_SCHEMA database would return an empty result set. (Bug
#10055 (http://bugs.mysql.com/10055), Bug #12278
(http://bugs.mysql.com/12278))
* Columns defined as TINYINT(1) redefined as TINYINT(4) when
incorporated into a VIEW. (Bug #11335 (http://bugs.mysql.com/11335))
* ISO-8601 formatted dates were not being parsed correctly. (Bug #7308
(http://bugs.mysql.com/7308))
* FLUSH TABLES WITH READ LOCK combined with LOCK TABLE .. WRITE caused
deadlock. (Bug #9459 (http://bugs.mysql.com/9459))
* NULL column definitions read incorrectly for inner tables of nested
outer joins. (Bug #12154 (http://bugs.mysql.com/12154))
* GROUP_CONCAT ignores the DISTINCT modifier when used in a query
joining multiple tables where one of the tables has a single row. (Bug
#12095 (http://bugs.mysql.com/12095))
* UNION query with FULLTEXT could cause server crash. (Bug #11869
(http://bugs.mysql.com/11869))

Bye,
Joerg

--
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com