(mysql.info) news-5-0-0

Info Catalog

(mysql.info) news-5-0-1

(mysql.info) news-5-0-x

 
 D.1.21 Changes in release 5.0.0 (22 Dec 2003: Alpha)
 ----------------------------------------------------
 
 Functionality added or changed:
 
    * The output of the `SHOW BINLOG EVENTS' statement has been
      modified. The `Orig_log_pos' column has been renamed to
      `End_log_pos' and now represents the offset of the last byte of
      the event, plus one.
 
    * *Important note:* If you upgrade to MySQL 4.1.1 or higher, it is
      difficult to downgrade back to 4.0 or 4.1.0! That is because, for
      earlier versions, `InnoDB' is not aware of multiple tablespaces.
 
    * Added support for `SUM(DISTINCT)', `MIN(DISTINCT)', and
      `MAX(DISTINCT)'.
 
    * The `KILL' statement now takes `CONNECTION' and `QUERY' modifiers.
      The first is the same as `KILL' with no modifier (it kills a given
      connection thread). The second kills only the statement currently
      being executed by the connection.
 
    * Added `TIMESTAMPADD()' and `TIMESTAMPDIFF()' functions.
 
    * Added `WEEK' and `QUARTER' values as `INTERVAL' arguments for the
      `DATE_ADD()' and `DATE_SUB()' functions.
 
    * New binary log format that enables replication of these session
      variables: `sql_mode', `SQL_AUTO_IS_NULL', `FOREIGN_KEY_CHECKS'
      (which was replicated since 4.0.14, but here it's done more
      efficiently and takes less space in the binary logs),
      `UNIQUE_CHECKS'. Other variables (like character sets,
      `SQL_SELECT_LIMIT', ...) will be replicated in upcoming 5.0.x
      releases.
 
    * Implemented Index Merge optimization for `OR' clauses. See 
      index-merge-optimization.
 
    * Basic support for stored procedures (SQL:2003 style). See 
      stored-procedures.
 
    * Added `SELECT INTO LIST_OF_VARS', which can be of mixed (that is,
      global and local) types. See  select-into-statement.
 
    * Easier replication upgrade (5.0.0 masters can read older binary
      logs and 5.0.0 slaves can read older relay logs). See 
      replication-compatibility, for more details). The format of the
      binary log and relay log is changed compared to that of MySQL 4.1
      and older.
 
 Bugs fixed:
 

Info Catalog

(mysql.info) news-5-0-1

(mysql.info) news-5-0-x