Below is the list of changes that have just been committed into a local
mysqldoc repository of paul. When paul does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html
ChangeSet
1.2717 05/03/12 12:17:06 paul@stripped +1 -0
Merge paul@stripped:/home/bk/mysqldoc
into frost.snake.net:/Volumes/frost2/MySQL/bk/mysqldoc
Docs/manual.texi
1.2549 05/03/12 12:17:04 paul@stripped +0 -0
Auto merged
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: paul
# Host: frost.snake.net
# Root: /Volumes/frost2/MySQL/bk/mysqldoc/RESYNC
--- 1.2548/Docs/manual.texi 2005-03-12 11:16:13 -06:00
+++ 1.2549/Docs/manual.texi 2005-03-12 12:17:04 -06:00
@@ -100567,6 +100567,29 @@
Functionality added or changed:
@itemize @bullet
@item
+@strong{Important note:} If you upgrade to @code{InnoDB}-4.1.1 or higher,
+you cannot downgrade to a version lower than 4.1.1
+any more! That is because earlier versions of @code{InnoDB} are not aware of
+multiple tablespaces.
+@item
+@strong{Warning: Incompatible change!}
+Renamed the C API @code{mysql_prepare_result()} function to
+@code{mysql_get_metadata()} because the old name was confusing.
+@item
+@strong{Warning: Incompatible change!}
+Client authentication now is based on 41-byte passwords in the @code{user}
+table, not 45-byte passwords as in 4.1.0. Any 45-byte passwords created for
+4.1.0 must be reset after running the @command{mysql_fix_privilege_tables}
+script.
+@item
+Added @code{secure_auth} global server system variable and @code{--secure-auth}
+server option that disallow authentication for accounts that have old
+(pre-4.1.1) passwords.
+@item
+Added @code{--secure-auth} option to @command{mysql} command-line client. If
+this option is set, the client refuses to send passwords in old (pre-4.1.1)
+format.
+@item
Table aliases are not case sensitive if @code{lower_case_table_names} is
non-zero.
@item
@@ -100588,8 +100611,8 @@
particular caches, and to preload indexes into caches.
@xref{CACHE INDEX, , @code{CACHE INDEX}}.
@xref{LOAD INDEX, , @code{LOAD INDEX}}.
-Structured system
-variables are introduced as a means of grouping related key cache parameters.
+Structured system variables are introduced as a means of grouping related
+key cache parameters.
@xref{Structured System Variables}.
@item
Added @code{preload_buffer_size} system variable.
@@ -100605,18 +100628,13 @@
reloaded in a particular order when the dump is reloaded. The existing
@code{FOREIGN_KEY_CHECKS} value is saved and restored.
@item
-@strong{Important note:} If you upgrade to @code{InnoDB}-4.1.1 or higher,
-you cannot downgrade to a version lower than 4.1.1
-any more! That is because earlier versions of @code{InnoDB} are not aware of
-multiple tablespaces.
-@item
-One can revoke all privileges from a user with
+You can revoke all privileges from a user with
@code{REVOKE ALL PRIVILEGES, GRANT FROM user_list}.
@item
Added @code{IGNORE} option for @code{DELETE} statement.
@item
-The MySQL source distribution now also includes the MySQL Internals
-Manual @file{internals.texi}.
+MySQL source distributions now also include the MySQL Internals Manual
+@file{internals.texi}.
@item
Added @code{mysql_set_server_option()} C API client function to allow multiple
statement handling in the server to be enabled or disabled.
@@ -100638,7 +100656,8 @@
@item
Removed unused @code{ft_max_word_len_for_sort} system variable.
@item
-Removed unused @code{ft_max_word_len_for_sort} variable from @command{myisamchk}.
+Removed unused @code{ft_max_word_len_for_sort} variable from
+@command{myisamchk}.
@item
Full-text search now supports multi-byte character sets and the Unicode
@code{utf8} character set. (The Unicode @code{ucs2} character set is not
@@ -100681,25 +100700,8 @@
an @code{AUTO_INCREMENT} column. With this mode enabled, zero is stored as
zero; only storing @code{NULL} generates a sequence number.
@item
-@strong{Warning: Incompatible change!}
-Client authentication now is based on 41-byte passwords in the
-@code{user} table, not 45-byte passwords as in 4.1.0.
-Any 45-byte passwords created for 4.1.0 must be reset after running the
-@command{mysql_fix_privilege_tables} script.
-@item
-Added @code{secure_auth} global server system variable and @code{--secure-auth}
-server option that disallow authentication for accounts that have old
-(pre-4.1.1) passwords.
-@item
-Added @code{--secure-auth} option to @command{mysql} command-line client. If this
-option is set, the client refuses to send passwords in old (pre-4.1.1) format.
-@item
-@strong{Warning: Incompatible change!}
-Renamed the C API @code{mysql_prepare_result()} function to
-@code{mysql_get_metadata()} as the old name was confusing.
-@item
-Added @code{DROP USER '@var{user_name}'@@'@var{host_name}'} statement to drop an account
-that has no privileges.
+Added @code{DROP USER '@var{user_name}'@@'@var{host_name}'} statement to
+drop an account that has no privileges.
@item
The interface to aggregate user-defined functions has changed a bit. You
must now declare a @code{xxx_clear()} function for each aggregate function
@@ -100734,9 +100736,9 @@
Added new @code{COMPRESS()}, @code{UNCOMPRESS()}, and
@code{UNCOMPRESSED_LENGTH()} functions.
@item
-When using @code{SET sql_mode='mode'} for a complex mode (like @code{ANSI}), we
-now update the @code{sql_mode} variable to include all the individual options
-implied by the complex mode.
+When using @code{SET sql_mode='mode'} for a complex mode (such as
+@code{ANSI}), we now update the @code{sql_mode} variable to include all the
+individual options implied by the complex mode.
@item
Added the OLAP (On-Line Analytical Processing) function @code{ROLLUP}, which
provides summary rows for each @code{GROUP BY} level.
@@ -100749,12 +100751,12 @@
@code{TIME} columns with hour values greater than 24 were returned incorrectly
to the client.
@item
-@code{ANALYZE TABLE}, @code{OPTIMIZE TABLE}, @code{REPAIR TABLE}, and @code{FLUSH} statements
-are now stored in the binary log and thus replicated to slaves.
-This logging does not occur if the optional @code{NO_WRITE_TO_BINLOG} keyword
-(or its alias @code{LOCAL}) is given. Exceptions are that
-@code{FLUSH LOGS}, @code{FLUSH MASTER}, @code{FLUSH SLAVE}, and
-@code{FLUSH TABLES WITH READ LOCK} are not logged in any case.
+@code{ANALYZE TABLE}, @code{OPTIMIZE TABLE}, @code{REPAIR TABLE}, and
+@code{FLUSH} statements are now stored in the binary log and thus replicated
+to slaves. This logging does not occur if the optional
+@code{NO_WRITE_TO_BINLOG} keyword (or its alias @code{LOCAL}) is given.
+Exceptions are that @code{FLUSH LOGS}, @code{FLUSH MASTER}, @code{FLUSH
+SLAVE}, and @code{FLUSH TABLES WITH READ LOCK} are not logged in any case.
For a syntax example, see @ref{FLUSH, , @code{FLUSH}}.
@item
New global system variable @code{relay_log_purge} to enable or disable automatic
@@ -100767,9 +100769,9 @@
that creates an empty table @code{table2} with a definition that is
exactly the same as @code{table1}, including any indexes.
@item
-@code{CREATE TABLE @var{tbl_name} (...) TYPE=@var{storage_engine}} now generates a
-warning if the named storage engine is not available. The table is still
-created as a @code{MyISAM} table, as before.
+@code{CREATE TABLE @var{tbl_name} (...) TYPE=@var{storage_engine}} now
+generates a warning if the named storage engine is not available. The table
+is still created as a @code{MyISAM} table, as before.
@item
Most subqueries are now much faster than before.
@item
| Thread |
|---|
| • bk commit - mysqldoc tree (paul:1.2717) | paul | 12 Mar |
