Text 1809, 577 rader
Skriven 2007-05-04 22:58:33 av madodel
Ärende: [VOICENWS] SW: MySQL Community Server 5.0.37 has been released for O
============================================================================
22:58:41 
<madodel@ptdprolog.net>, uid 50002) with qmail-scanner-2.01 
(authenticated:madodel@[24.238.92.194])
OS/2 & eCS
++ From the VOICE OS/2-eCS News Service   http://www.os2voice.org ++

From: Paul Smedley <paulDESPAM@DESPAMsmedley.info>

Hi All,

I've finally got around to uploading an OS/2 and eCS port of MySQL 5.0.37 
to my site at http://smedley.info/os2ports

Please see the readme.os2 file contained in the zip for details on how to 
provide feedback and support this project.

Cheers,

Paul.

-------- Original Message --------
Subject: MySQL Community Server 5.0.37 has been released
Date: Mon, 12 Mar 2007 14:23:57 +0100
From: Mads Martin Joergensen <mmjDESPAM@DESPAMmysql.com>
To: announceDESPAM@DESPAMlists.mysql.com

Dear MySQL users,

MySQL Community Server 5.0.37, a new version of the popular Open Source
Database Management System, has been released. The release is now
available in source and binary form 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,
so if you can't find this version on some mirror, please try again later
or choose another download site.

This is our second full (source and binary) release of the MySQL
Community Server since we made the split between the Community and
Enterprise Version.  It includes all bug fixes applied to up to and
including the MySQL 5.0.36 Enterprise Server.

This release also resolves a crashing bug that could be exploited as a
potential local Denial of Service attack,

    http://bugs.mysql.com/bug.php?id=24630

We would like to thank Stefan Streichsbier from SEC Consult, who also
informed us about this bug via our security@mysql.com mail address - he
will send out a separate advisory about his findings.

In addition to these bug fixes we'd like to thank Jeremy Cole for the
contribution of two new features, the SHOW PROFILE statement which
provides access to various profiling information useful to analyze
performance bottlenecks. This information is also visible in the
corresponding INFORMATION_SCHEMA.PROFILING table.

Unfortunately the SHOW PROFILE implementation as of 5.0.37 still has a
small gotcha, that we will resolve for the next release: the MySQL
command line client hangs if you issue the SHOW PROFILE command without
having enabled the @@profiling session variable before:

    http://bugs.mysql.com/bug.php?id=26938

So when you evaluate this new feature, make sure to enable it by issuing
"SET @@profiling = 1;" before.

Jeremy also contributed a patch to display the
"Uptime_since_flush_status" status variable, which indicates the number
of seconds since the most recent FLUSH STATUS statement.

We welcome and appreciate your feedback, bug reports, bug fixes,
patches etc.:

    http://forge.mysql.com/wiki/Contributing

The following section lists the changes from version to version in the
MySQL source code as compared to the last released version of MySQL
Community Server, the MySQL Community Server 5.0.33 source only release.
It can also be viewed online at

    http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs-5-0-37.html

Functionality added or changed:
  * Added the SHOW PROFILES and SHOW PROFILE statements to display
    statement profile data, and the accompanying
    INFORMATION_SCHEMA.PROFILING table. Profiling is controlled
    via the profiling and profiling_history_size session
    variables. see Section 13.5.4.22, "SHOW PROFILES and SHOW
    PROFILE Syntax," and Section 20.17, "The INFORMATION_SCHEMA
    PROFILING Table." (From Jeremy Cole)
    (Bug#24795: http://bugs.mysql.com/24795)
  * Added the Uptime_since_flush_status status variable, which
    indicates the number of seconds since the most recent FLUSH
    STATUS statement. (From Jeremy Cole)
    (Bug#24822: http://bugs.mysql.com/24822)
  * Incompatible change: Previously, the DATE_FORMAT() function
    returned a binary string. Now it returns a string with a
    character set and collation given by character_set_connection
    and collation_connection so that it can return month and
    weekday names containing non-ASCII characters.
    (Bug#22646: http://bugs.mysql.com/22646)
  * NDB Cluster: The LockPagesInMainMemory configuration parameter
    has changed its type and possible values. For more
    information, see [1]LockPagesInMainMemory.
    (Bug#25686: http://bugs.mysql.com/25686)
    Important: The values true and false are no longer accepted
    for this parameter. If you were using this parameter and had
    it set to false in a previous release, you must change it to
    0. If you had this parameter set to true, you should instead
    use 1 to obtain the same behavior as previously, or 2 to take
    advantage of new functionality introduced with this release
    described in the section cited above.
  * Important: When using MERGE tables the definition of the MERGE
    table and the MyISAM tables are checked each time the tables
    are opened for access (including any SELECT or INSERT
    statement. Each table is compared for column order, types,
    sizes and associated. If there is a difference in any one of
    the tables then the statement will fail.
  * The localhost anonymous user account created during MySQL
    installation on Windows now has no global privileges. Formerly
    this account had all global privileges. For operations that
    require global privileges, the root account can be used
    instead. (Bug#24496: http://bugs.mysql.com/24496)
  * The bundled yaSSL library was upgraded to version 1.5.8.
  * The --skip-thread-priority option now is enabled by default
    for binary Mac OS X distributions. Use of thread priorities
    degrades performance on Mac OS X.
    (Bug#18526: http://bugs.mysql.com/18526)
  * Added the --disable-grant-options option to configure. If
    configure is run with this option, the --bootstrap,
    --skip-grant-tables, and --init-file options for mysqld are
    disabled and cannot be used. For Windows, the configure.js
    script recognizes the DISABLE_GRANT_OPTIONS flag, which has
    the same effect.

Bugs fixed:
  * Incompatible change: For ENUM columns that had enumeration
    values containing commas, the commas were mapped to 0xff
    internally. However, this rendered the commas
    indistinguishable from true 0xff characters in the values.
    This no longer occurs. However, the fix requires that you dump
    and reload any tables that have ENUM columns containing true
    0xff in their values: Dump the tables using mysqldump with the
    current server before upgrading from a version of MySQL 5.0
    older than 5.0.36 to version 5.0.36 or newer.
    (Bug#24660: http://bugs.mysql.com/24660)
  * If the duplicate key value was present in the table, INSERT
    ... ON DUPLICATE KEY UPDATE reported a row count indicating
    that a record was updated, even when no record actually
    changed due to the old and new values being the same. Now it
    reports a row count of zero.
    (Bug#19978: http://bugs.mysql.com/19978)
  * Some UPDATE statements were slower than in previous versions
    when the search key could not be converted to a valid value
    for the type of the search column.
    (Bug#24035: http://bugs.mysql.com/24035)
  * The WITH CHECK OPTION clause for views was ignored for updates
    of multiple-table views when the updates could not be
    performed on fly and the rows to update had to be put into
    temporary tables first.
    (Bug#25931: http://bugs.mysql.com/25931)
  * Using ORDER BY or GROUP BY could yield different results when
    selecting from a view and selecting from the underlying table.
    (Bug#26209: http://bugs.mysql.com/26209)
  * LAST_INSERT_ID() was not reset to 0 if INSERT ... SELECT
    inserted no rows. (Bug#23170: http://bugs.mysql.com/23170)
  * Storing values specified as hexadecimal values 64 or more bits
    long into BIT(64), BIGINT, or BIGINT UNSIGNED columns did not
    raise any warning or error if the value was out of range.
    (Bug#22533: http://bugs.mysql.com/22533)
  * Inserting DEFAULT into a column with no default value could
    result in garbage in the column. Now the same result occurs as
    when inserting NULL into a NOT NULL column.
    (Bug#20691: http://bugs.mysql.com/20691)
  * The presence of ORDER BY in a view definition prevented the
    MERGE algorithm from being used to resolve the view even if
    nothing else in the definition required the TEMPTABLE
    algorithm. (Bug#12122: http://bugs.mysql.com/12122)
  * ISNULL(DATE(NULL)) and ISNULL(CAST(NULL AS DATE)) erroneously
    returned false. (Bug#23938: http://bugs.mysql.com/23938)
  * If a slave server closed its relay log (for example, due to an
    error during log rotation), the I/O thread did not recognize
    this and still tried to write to the log, causing a server
    crash. (Bug#10798: http://bugs.mysql.com/10798)
  * Using an INFORMATION_SCHEMA table with ORDER BY in a subquery
    could cause a server crash.
    (Bug#24630: http://bugs.mysql.com/24630,
    Bug#26556: http://bugs.mysql.com/26556)
  * Collation for LEFT JOIN comparisons could be evaluated
    incorrectly, leading to improper query results.
    (Bug#26017: http://bugs.mysql.com/26017)
  * For the IF() and COALESCE() function and CASE expressions,
    large unsigned integer values could be mishandled and result
    in warnings. (Bug#22026: http://bugs.mysql.com/22026)
  * The number of setsockopt() calls performed for reads and
    writes to the network socket was reduced to decrease system
    call overhead. (Bug#22943: http://bugs.mysql.com/22943)
  * A WHERE clause that used BETWEEN for DATETIME values could be
    treated differently for a SELECT and a view defined as that
    SELECT. (Bug#26124: http://bugs.mysql.com/26124)
  * ORDER BY on DOUBLE values could change the set of rows
    returned by a query. (Bug#19690: http://bugs.mysql.com/19690)
  * The code for generating USE statements for binary logging of
    CREATE PROCEDURE statements resulted in confusing output from
    mysqlbinlog for DROP PROCEDURE statements.
    (Bug#22043: http://bugs.mysql.com/22043)
  * LOAD DATA INFILE did not work with pipes.
    (Bug#25807: http://bugs.mysql.com/25807)
  * DISTINCT queries that were executed using a loose scan for an
    InnoDB table that had been emptied caused a server crash.
    (Bug#26159: http://bugs.mysql.com/26159)
  * The InnoDB parser sometimes did not account for null bytes,
    causing spurious failure of some queries.
    (Bug#25596: http://bugs.mysql.com/25596)
  * Type conversion errors during formation of index search
    conditions were not correctly checked, leading to incorrect
    query results. (Bug#22344: http://bugs.mysql.com/22344)
  * Within a stored routine, accessing a declared routine variable
    with PROCEDURE ANALYSE() caused a server crash.
    (Bug#23782: http://bugs.mysql.com/23782)
  * Use of already freed memory caused SSL connections to hang
    forever. (Bug#19209: http://bugs.mysql.com/19209)
  * mysql.server stop timed out too quickly (35 seconds) waiting
    for the server to exit. Now it waits up to 15 minutes, to
    ensure that the server exits.
    (Bug#25341: http://bugs.mysql.com/25341)
  * A yaSSL program named test was installed, causing conflicts
    with the test system utility. It is no longer installed.
    (Bug#25417: http://bugs.mysql.com/25417)
  * perror crashed on some platforms due to failure to handle a
    NULL pointer. (Bug#25344: http://bugs.mysql.com/25344)
  * mysql_stmt_fetch() did an invalid memory deallocation when
    used with the embedded server.
    (Bug#25492: http://bugs.mysql.com/25492)
  * mysql_kill() caused a server crash when used on an SSL
    connection. (Bug#25203: http://bugs.mysql.com/25203)
  * The readline library wrote to uninitialized memory, causing
    mysql to crash. (Bug#19474: http://bugs.mysql.com/19474)
  * yaSSL was sensitive to the presence of whitespace at the ends
    of lines in PEM-encoded certificates, causing a server crash.
    (Bug#25189: http://bugs.mysql.com/25189)
  * mysqld_multi and mysqlaccess looked for option files in /etc
    even if the --sysconfdir option for configure had been given
    to specify a different directory.
    (Bug#24780: http://bugs.mysql.com/24780)
  * The SEC_TO_TIME() and QUARTER() functions sometimes did not
    handle NULL values correctly.
    (Bug#25643: http://bugs.mysql.com/25643)
  * With ONLY_FULL_GROUP_BY enables, the server was too strict:
    Some expressions involving only aggregate values were rejected
    as non-aggregate (for example, MAX(a) - MIN(a)).
    (Bug#23417: http://bugs.mysql.com/23417)
  * The arguments of the ENCODE() and the DECODE() functions were
    not printed correctly, causing problems in the output of
    EXPLAIN EXTENDED and in view definitions.
    (Bug#23409: http://bugs.mysql.com/23409)
  * An error in the name resolution of nested JOIN ... USING
    constructs was corrected.
    (Bug#25575: http://bugs.mysql.com/25575)
  * A return value of -1 from user-defined handlers was not
    handled well and could result in conflicts with server code.
    (Bug#24987: http://bugs.mysql.com/24987)
  * The server might fail to use an appropriate index for DELETE
    when ORDER BY, LIMIT, and a non-restricting WHERE are present.
    (Bug#17711: http://bugs.mysql.com/17711)
  * Use of ON DUPLICATE KEY UPDATE defeated the usual restriction
    against inserting into a join-based view unless only one of
    the underlying tables is used.
    (Bug#25123: http://bugs.mysql.com/25123)
  * Some queries against INFORMATION_SCHEMA that used subqueries
    failed. (Bug#23299: http://bugs.mysql.com/23299).
  * SHOW COLUMNS reported some NOT NULL columns as NULL.
    (Bug#22377: http://bugs.mysql.com/22377)
  * View definitions that used the ! operator were treated as
    containing the NOT operator, which has a different precedence
    and can produce different results.
    (Bug#25580: http://bugs.mysql.com/25580).
  * For a UNIQUE index containing many NULL values, the optimizer
    would prefer the index for col IS NULL conditions over other
    more selective indexes.
    (Bug#25407: http://bugs.mysql.com/25407).
  * GROUP BY and DISTINCT did not group NULL values for columns
    that have a UNIQUE index.
    (Bug#25551: http://bugs.mysql.com/25551).
  * ALTER TABLE ... ENABLE KEYS acquired a global lock, preventing
    concurrent execution of other statements that use tables.
    (Bug#25044: http://bugs.mysql.com/25044).
  * For an InnoDB table with any ON DELETE trigger, TRUNCATE TABLE
    mapped to DELETE and activated triggers. Now a fast truncation
    occurs and triggers are not activated.
    (Bug#23556: http://bugs.mysql.com/23556).
  * For ALTER TABLE, using ORDER BY expression could cause a
    server crash. Now the ORDER BY clause allows only column names
    to be specified as sort criteria (which was the only
    documented syntax, anyway).
    (Bug#24562: http://bugs.mysql.com/24562)
  * readline detection did not work correctly on NetBSD.
    (Bug#23293: http://bugs.mysql.com/23293)
  * The --with-readline option for configure does not work for
    commercial source packages, but no error message was printed
    to that effect. Now a message is printed.
    (Bug#25530: http://bugs.mysql.com/25530)
  * If an ORDER BY or GROUP BY list included a constant expression
    being optimized away and, at the same time, containing
    single-row subselects that return more that one row, no error
    was reported. If a query requires sorting by expressions
    containing single-row subselects that return more than one
    row, execution of the query may cause a server crash.
    (Bug#24653: http://bugs.mysql.com/24653)
  * Attempts to access a MyISAM table with a corrupt column
    definition caused a server crash.
    (Bug#24401: http://bugs.mysql.com/24401)
  * To enable installation of MySQL RPMs on Linux systems running
    RHEL 4 (which includes SE-Linux) additional information was
    provided to specify some actions that are allowed to the MySQL
    binaries. (Bug#12676: http://bugs.mysql.com/12676)
  * When SET PASSWORD was written to the binary log double quotes
    were included in the statement. If the slave was running in
    with the sql_mode set to ANSI_QUOTES the event would fail and
    halt the replication process.
    (Bug#24158: http://bugs.mysql.com/24158)
  * Accessing a fixed record format table with a crashed key
    definition results in server/myisamchk segmentation fault.
    (Bug#24855: http://bugs.mysql.com/24855)
  * When opening a corrupted .frm file during a query, the server
    crashes. (Bug#24358: http://bugs.mysql.com/24358)
  * If there was insufficient memory to store or update a blob
    record in a MyISAM table then the table will marked as
    crashed. (Bug#23196: http://bugs.mysql.com/23196)
  * When updating a table that used a JOIN of the table itself
    (for example, when building trees) and the table was modified
    on one side of the expression, the table would either be
    reported as crashed or the wrong rows in the table would be
    updated. (Bug#21310: http://bugs.mysql.com/21310)
  * Queries that evaluate NULL IN (SELECT ... UNION SELECT ...)
    could produce an incorrect result (FALSE instead of NULL).
    (Bug#24085: http://bugs.mysql.com/24085)
  * When reading from the standard input on Windows, mysqlbinlog
    opened the input in text mode rather than binary mode and
    consequently misinterpreted some characters such as Control-Z.
    (Bug#23735: http://bugs.mysql.com/23735)
  * Within stored routines or prepared statements, inconsistent
    results occurred with multiple use of INSERT ... SELECT ... ON
    DUPLICATE KEY UPDATE when the ON DUPLICATE KEY UPDATE clause
    erroneously tried to assign a value to a column mentioned only
    in its SELECT part. (Bug#24491: http://bugs.mysql.com/24491)
  * Expressions of the form (a, b) IN (SELECT a, MIN(b) FROM t
    GROUP BY a) could produce incorrect results when column a of
    table t contained NULL values while column b did not.
    (Bug#24420: http://bugs.mysql.com/24420)
  * Expressions of the form (a, b) IN (SELECT c, d ...) could
    produce incorrect results if a, b, or both were NULL.
    (Bug#24127: http://bugs.mysql.com/24127)
  * No warning was issued for use of the DATA DIRECTORY or INDEX
    DIRECTORY table options on a platform that does not support
    them. (Bug#17498: http://bugs.mysql.com/17498)
  * When a prepared statement failed during the prepare operation,
    the error code was not cleared when it was reused, even if the
    subsequent use was successful.
    (Bug#15518: http://bugs.mysql.com/15518)
  * mysql_upgrade failed when called with a basedir pathname
    containing spaces. (Bug#22801: http://bugs.mysql.com/22801)
  * Hebrew-to-Unicode conversion failed for some characters.
    Definitions for the following Hebrew characters (as specified
    by the ISO/IEC 8859-8:1999) were added: LEFT-TO-RIGHT MARK
    (LRM), RIGHT-TO-LEFT MARK (RLM)
    (Bug#24037: http://bugs.mysql.com/24037)
  * An AFTER UPDATE trigger on an InnoDB table with a composite
    primary key caused the server to crash.
    (Bug#25398: http://bugs.mysql.com/25398)
  * A query that contained an EXIST subquery with a UNION over
    correlated and uncorrelated SELECT queries could cause the
    server to crash. (Bug#25219: http://bugs.mysql.com/25219)
  * A query with ORDER BY and GROUP BY clauses where the ORDER BY
    clause had more elements than the GROUP BY clause caused a
    memory overrun leading to a crash of the server.
    (Bug#25172: http://bugs.mysql.com/25172)
  * If there was insufficient memory available to mysqld, this
    could sometimes cause the server to hang during startup.
    (Bug#24751: http://bugs.mysql.com/24751)
  * If a prepared statement accessed a view, access to the tables
    listed in the query after that view was checked in the
    security context of the view.
    (Bug#24404: http://bugs.mysql.com/24404)
  * A query using WHERE unsigned_column NOT IN ('negative_value')
    could cause the server to crash.
    (Bug#24261: http://bugs.mysql.com/24261)
  * A FETCH statement using a cursor on a table which was not in
    the table cache could sometimes cause the server to crash.
    (Bug#24117: http://bugs.mysql.com/24117)
  * SSL connections could hang at connection shutdown.
    (Bug#24148: http://bugs.mysql.com/24148)
  * The STDDEV() function returned a positive value for data sets
    consisting of a single value.
    (Bug#22555: http://bugs.mysql.com/22555)
  * mysqltest incorrectly tried to retrieve result sets for some
    queries where no result set was available.
    (Bug#19410: http://bugs.mysql.com/19410)
  * mysqltest crashed with a stack overflow.
    (Bug#24498: http://bugs.mysql.com/24498)
  * Passing a NULL value to a user-defined function from within a
    stored procedure crashes the server.
    (Bug#25382: http://bugs.mysql.com/25382)
  * The row count for MyISAM tables was not updated properly,
    causing SHOW TABLE STATUS to report incorrect values.
    (Bug#23526: http://bugs.mysql.com/23526)
  * The BUILD/check-cpu script did not recognize Celeron
    processors. (Bug#20061: http://bugs.mysql.com/20061)
  * On Windows, the SLEEP() function could sleep too long,
    especially after a change to the system clock.
    (Bug#14094: http://bugs.mysql.com/14094,
    Bug#17635: http://bugs.mysql.com/17635,
    Bug#24686: http://bugs.mysql.com/24686)
  * A stored routine containing semicolon in its body could not be
    reloaded from a dump of a binary log.
    (Bug#20396: http://bugs.mysql.com/20396)
  * For SET, SELECT, and DO statements that invoked a stored
    function from a database other than the default database, the
    function invocation could fail to be replicated.
    (Bug#19725: http://bugs.mysql.com/19725)
  * SET lc_time_names = value allowed only exact literal values,
    not expression values.
    (Bug#22647: http://bugs.mysql.com/22647)
  * Changes to the lc_time_names system variable were not
    replicated. (Bug#22645: http://bugs.mysql.com/22645)
  * SELECT ... FOR UPDATE, SELECT ... LOCK IN SHARE MODE, DELETE,
    and UPDATE statements executed using a full table scan were
    not releasing locks on rows that did not satisfy the WHERE
    condition. (Bug#20390: http://bugs.mysql.com/20390)
  * A stored procedure, executed from a connection using a binary
    character set, and which wrote multibyte data, would write
    incorrectly escaped entries to the binary log. This caused
    syntax errors, and caused replication to fail.
    (Bug#23619: http://bugs.mysql.com/23619,
    Bug#24492: http://bugs.mysql.com/24492)
  * mysqldump --order-by-primary failed if the primary key name
    was an identifier that required quoting.
    (Bug#13926: http://bugs.mysql.com/13926)
  * Re-execution of CREATE DATABASE, CREATE TABLE, and ALTER TABLE
    statements in stored routines or as prepared statements caused
    incorrect results or crashes.
    (Bug#22060: http://bugs.mysql.com/22060)
  * The internal functions for table preparation, creation, and
    alteration were not re-execution friendly, causing problems in
    code that: repeatedly altered a table; repeatedly created and
    dropped a table; opened and closed a cursor on a table,
    altered the table, and then reopened the cursor.
    (Bug#4968: http://bugs.mysql.com/4968,
    Bug#6895: http://bugs.mysql.com/6895,
    Bug#19182: http://bugs.mysql.com/19182,
    Bug#19733: http://bugs.mysql.com/19733)
  * A workaround was implemented to avoid a race condition in the
    NPTL pthread_exit() implementation.
    (Bug#24507: http://bugs.mysql.com/24507)
  * NDB Cluster (Cluster APIs): libndbclient.so was not versioned.
    (Bug#13522: http://bugs.mysql.com/13522)
  * NDB Cluster: The ndb_size.tmpl file (necessary for using the
    ndb_size.pl script) was missing from binary distributions.
    (Bug#24191: http://bugs.mysql.com/24191)
  * NDB Cluster: A query with an IN clause against an NDB table
    employing explicit user-defined partitioning did not always
    return all matching rows.
    (Bug#25821: http://bugs.mysql.com/25821)
  * NDB Cluster: An UPDATE using an IN clause on an NDB table on
    which there was a trigger caused mysqld to crash.
    (Bug#25522: http://bugs.mysql.com/25522)
  * NDB Cluster (Cluster APIs): Deletion of an
    Ndb_cluster_connection object took a very long time.
    (Bug#25487: http://bugs.mysql.com/25487)
  * NDB Cluster: It was not possible to create an NDB table with a
    key on two VARCHAR columns where both columns had a storage
    length in excess of 256.
    (Bug#25746: http://bugs.mysql.com/25746)
  * NDB Cluster: In some circumstances, shutting down the cluster
    could cause connected mysqld processes to crash.
    (Bug#25668: http://bugs.mysql.com/25668)
  * NDB Cluster: Memory allocations for TEXT columns were
    calculated incorrectly, resulting in space being wasted and
    other issues. (Bug#25562: http://bugs.mysql.com/25562)
  * NDB Cluster: The failure of a master node during a node
    restart could lead to a resource leak, causing later node
    failures. (Bug#25554: http://bugs.mysql.com/25554)
  * NDB Cluster: The management server did not handle logging of
    node shutdown events correctly in certain cases.
    (Bug#22013: http://bugs.mysql.com/22013)
  * NDB Cluster: A node shutdown occurred if the master failed
    during a commit. (Bug#25364: http://bugs.mysql.com/25364)
  * NDB Cluster: Creating a non-unique index with the USING HASH
    clause silently created an ordered index instead of issuing a
    warning. (Bug#24820: http://bugs.mysql.com/24820)
  * NDB Cluster: SELECT statements with a BLOB or TEXT column in
    the selected column list and a WHERE condition including a
    primary key lookup on a VARCHAR primary key produced empty
    result sets. (Bug#19956: http://bugs.mysql.com/19956)
  * Optimizations that are legal only for subqueries without
    tables and WHERE conditions were applied for any subquery
    without tables. (Bug#24670: http://bugs.mysql.com/24670)
  * The server was built even when configure was run with the
    --without-server option.
    (Bug#23973: http://bugs.mysql.com/23973)
  * mysqld_error.h was not installed when only the client
    libraries were built. (Bug#21265: http://bugs.mysql.com/21265)
  * Using a view in combination with a USING clause caused column
    aliases to be ignored.
    (Bug#25106: http://bugs.mysql.com/25106)
  * A view was not handled correctly if the SELECT part contained
    `\Z'. (Bug#24293: http://bugs.mysql.com/24293)
  * Inserting a row into a table without specifying a value for a
    BINARY(N) NOT NULL column caused the column to be set to
    spaces, not zeroes. (Bug#14171: http://bugs.mysql.com/14171)
  * An assertion failed incorrectly for prepared statements that
    contained a single-row non-correlated subquery that was used
    as an argument of the IS NULL predicate.
    (Bug#25027: http://bugs.mysql.com/25027)
  * A table created with the ROW_FORMAT = FIXED table option loses
    the option if an index is added or dropped with CREATE INDEX
    or DROP INDEX. (Bug#23404: http://bugs.mysql.com/23404)
  * Dropping a user-defined function sometimes did not remove the
    UDF entry from the mysql.proc table.
    (Bug#15439: http://bugs.mysql.com/15439)
  * Changing the value of MI_KEY_BLOCK_LENGTH in myisam.h and
    recompiling MySQL resulted in a myisamchk that saw existing
    MyISAM tables as corrupt.
    (Bug#22119: http://bugs.mysql.com/22119)
  * Instance Manager could crash during shutdown.
    (Bug#19044: http://bugs.mysql.com/19044)
  * A deadlock could occur, with the server hanging on Closing
    tables, with a sufficient number of concurrent INSERT DELAYED,
    FLUSH TABLES, and ALTER TABLE operations.
    (Bug#23312: http://bugs.mysql.com/23312)
  * A user-defined variable could be assigned an incorrect value
    if a temporary table was employed in obtaining the result of
    the query used to determine its value.
    (Bug#16861: http://bugs.mysql.com/16861)
  * The optimizer removes expressions from GROUP BY and DISTINCT
    clauses if they happen to participate in expression = constant
    predicates of the WHERE clause, the idea being that, if the
    expression is equal to a constant, then it cannot take on
    multiple values. However, for predicates where the expression
    and the constant item are of different result types (for
    example, when a string column is compared to 0), this is not
    valid, and can lead to invalid results in such cases. The
    optimizer now performs an additional check of the result types
    of the expression and the constant; if their types differ,
    then the expression is not removed from the GROUP BY list.
    (Bug#15881: http://bugs.mysql.com/15881)
  * Referencing an ambiguous column alias in an expression in the
    ORDER BY clause of a query caused the server to crash.
    (Bug#25427: http://bugs.mysql.com/25427)
  * Some CASE statements inside stored routines could lead to
    excessive resource usage or a crash of the server.
    (Bug#24854: http://bugs.mysql.com/24854,
    Bug#19194: http://bugs.mysql.com/19194)
  * Some joins in which one of the joined tables was a view could
    return erroneous results or crash the server.
    (Bug#24345: http://bugs.mysql.com/24345)
  * OPTIMIZE TABLE tried to sort R-tree indexes such as spatial
    indexes, although this is not possible (see Section 13.5.2.5,
    "OPTIMIZE TABLE Syntax").
    (Bug#23578: http://bugs.mysql.com/23578)
  * User-defined variables could consume excess memory, leading to
    a crash caused by the exhaustion of resources available to the
    MEMORY storage engine, due to the fact that this engine is
    used by MySQL for variable storage and intermediate results of
    GROUP BY queries. Where SET had been used, such a condition
    could instead give rise to the misleading error message You
    may only use constant expressions with SET, rather than Out of
    memory (Needed NNNNNN bytes).
    (Bug#23443: http://bugs.mysql.com/23443)
  * InnoDB: During a restart of the MySQL Server that followed the

---
 * Origin: Waldo's Place USA Internet Gateway (1:3634/1000)