Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




D.1.2. Changes in release 5.1.7 (Not yet released)

Functionality added or changed:

  • Incompatible change: TYPE = engine_name is no longer accepted as a synonym for the ENGINE = engine_name table option. (TYPE has been deprecated since MySQL 4.0.)

  • Added the mysql_upgrade program that checks all tables for incompatibilities with the current version of MySQL Server and repairs them if necessary. This program should be run for each MySQL upgrade (rather than mysql_fix_privilege_tables). See Section 5.5.2, “mysql_upgrade — Check Tables for MySQL Upgrade”.

  • Added the FOR UPGRADE option for the CHECK TABLE statement. This option checks whether tables are incompatible with the current version of MySQL Server. Also added the --check-upgrade to mysqlcheck that invokes CHECK TABLE with the FOR UPGRADE Added the --fix-db-names and --fix-table-names options to mysqlcheck. option.

  • Added the RENAME DATABASE statement.

  • The SQL mode in effect at the time an event is created or altered is recorded and used during event execution. (Bug #16407)


  • Attempting to read pre-5.1.6 partitioned tables with a MySQL 5.1.7 (or later) server now generates a suitable warning message. (Bug #16695)

    For additional information about this issue, see Section D.1.3, “Changes in release 5.1.6 (01 February 2006)”.

  • NDB Cluster: Attempting to SELECT ... FROM INFORMATION_SCHEMA.FILES now raises a warning in the event that the cluster has crashed. (Bug #17087)

  • Removed the have_isam and have_raid system variables.

  • Status messages added to ndb_restore to allow users to know that data files for Disk Data are being created. (Bug #16873)

  • Added the IN NATURAL LANGUAGE MODE and IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION modifiers for full-text searches. See Section 12.7, “Full-Text Search Functions”.

  • Creator privileges are now checked for all events before execution. (Bug #17289)

  • CREATE/DROP/ALTER EVENT statements are not allowed in triggers. (Bug #16410)

Bugs fixed:

  • Creating NDB tables containing BLOB columns but no primary key caused unpredictable behavior. (Bug #17559)

  • Creating an event and using a whitespace character other than space following the DO keyword caused a server crash. (Bug #17453)

  • Previously, a stored function invocation was written to the binary log as DO func_name() if the invocation changes data and occurs within a non-logged statement, or if the function invokes a stored procedure that produces an error. These invocations now are logged as SELECT func_name() instead for better control over error code checking (slave servers could stop due to detecting a different error than occurred on the master). (Bug #14769)

  • CHECKSUM TABLE returned different values on MyISAM table depending on whether the QUICK or EXTENDED options were used. (Bug #8841)

  • Querying the INFORMATION_SCHEMA.partitions table on a non-max server caused a server crash. (Bug #16591)

  • MySQL server dropped client connection for certain SELECT statements against views defined that used MERGE algorithm. (Bug #16260)

  • A statement containing GROUP BY and HAVING clauses could return incorrect results when the HAVING clause contained logic that returned FALSE for every row. (Bug #14927)

  • Using GROUP BY on column used in WHERE clause could cause empty set to be returned. (Bug #16203)

  • DROP DATABASE did not drop events for the database. (Bug #16406)

  • Race conditions between event creation, dropping, and execution could result in a server crash or hang. (Bug #17373)

  • SET sql_mode = N, where N > 31, did not work properly. (Bug #13897)

  • Repeated invocation of my_init() and my_end() caused corruption of character set data and connection failure. (Bug #6536)

  • When used with the ExtractValue() function, an XPath expression having no leading “/” character would crash the server. (Bug #16234)

  • A SELECT from the last partition of a subpartitioned table having a UNIQUE KEY could crash the MySQL Server. (Bug #16907)

  • A SELECT on a subpartitioned table having a multiple-column PRIMARY or UNIQUE KEY, and whose partitioning function used only the first column of the key, could cause mysqld to crash. (Bug #16901)

  • Using REPLACE INTO on a partitioned table having a primary key would crash the server in the event of a duplicate key error. (Bug #16782)

  • DROP TABLE would sometimes fail on a table having subpartitions that used the default storage engine. (Bug #16775)

  • NDB Cluster: Sharing of table names containing special characters between multiple SQL nodes was not handled correctly when binary logging was enabled (a timeout error resulted). (Bug #17415)

  • NDB Cluster: Table definitions were not shared between multiple SQL nodes in a cluster without binary logging being enabled. (Bug #17414)

  • NDB Cluster: Cluster log file paths were truncated to 128 characters. They may now be as long as MAX_PATH (the maximum path length permitted by the operating system). (Bug #17411)

  • SHOW CREATE EVENT displayed no output. (Bug #16423)

  • Statements that contained Unicode characters were not logged to the log tables correctly. (Bug #16905)

  • On Windows platforms, some attempts to create partitioned tables from the command line would cause the mysql client to hang. (Bug #17082)

  • NDB Cluster: SHOW CREATE TABLE would fail when run against a table created in a different session. (Bug #17340)

  • NDB Cluster: Following multiple forced shutdowns and restarts of data nodes, DROP DATABASE could fail. (Bug #17325)

  • NDB Cluster: An UPDATE with an inner join failed to match any records if both tables in the join did not have a primary key. (Bug #17257)

  • NDB Cluster: A DELETE with a join in the WHERE clause failed to retrieve any records if both tables in the join did not have a primary key. (Bug #17249)

  • The NDB Cluster storage engine did not allow views to be updated. (Bug #17206)

  • NDB Cluster: Row-based replication of a cluster failed to take --binlog_ignore_db settings into account. (Bug #17188)

  • Trying to create a partitioned table with more than 32 attributes failed. (Bug #17179)

  • NDB Cluster: When attempting to import data into an NDB table using LOAD DATA INFILE, the server would hang in the event of a duplicate key error. (Bug #17154)

  • NDB Cluster: In some cases, LOAD DATA INFILE did not load all data into NDB tables. (Bug #17081)

  • NDB Cluster: Performing large numbers of data manipulation statements on cluster tables using Disk Data could lead to a server crash. ()

  • NDB Cluster: In some cases, a cluster using Disk Data tables could not be restarted following a normal shutdown. (Bug #16872)

  • NDB Cluster: The REDO log would become corrupted (and thus unreadable) in some circumstances, due to a failure in the query handler. (Bug #17295)

  • NDB Cluster: CREATE TABLE new_tbl LIKE old_tbl; failed when old_tbl used the NDB storage engine. (Bug #17005)

  • NDB Cluster: No error message was generated for setting NoOfFragmentLogFiles too low. (Bug #13966)

  • NDB Cluster: No error message was generated for setting MaxNoOfAttributes too low. (Bug #13965)

  • The SELECT privilege was required for triggers that performed no selects. (Bug #15196)

  • The UPDATE privilege was required for triggers that performed no updates. (Bug #15166)

  • CAST(... AS TIME) operations returned different results when using versus not using prepared-statement protocol. (Bug #15805)

  • Killing a long-running query containing a subquery could cause a server crash. (Bug #14851)

  • InnoDB could display an incorrect error message for a cascading update. (Bug #9680)

  • A RETURN statement within a trigger caused a server crash. RETURN now is disallowed within triggers. To exit immediately, use LEAVE. (Bug #16829)

  Published under the terms of the GNU General Public License Design by Interspire