MySQL Lists are EOL. Please join:

List:Internals« Previous MessageNext Message »
From:paul Date:March 22 2005 8:17pm
Subject:bk commit - mysqldoc tree (paul:1.2754)
View as plain text  
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

  1.2754 05/03/22 14:17:55 paul@stripped +1 -0
    Some silent column changes no longer occur.

    1.2588 05/03/22 14:17:17 paul@stripped +20 -1
    Some silent column changes no longer occur.

# 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:
# Root:	/src/extern/MySQL/bk/mysqldoc

--- 1.2587/Docs/manual.texi	2005-03-21 14:04:55 -06:00
+++ 1.2588/Docs/manual.texi	2005-03-22 14:17:17 -06:00
@@ -58789,9 +58789,16 @@
 @cindex silent column changes
 In some cases, MySQL silently changes column specifications from
-those given in a @code{CREATE TABLE} or @code{ALTER TABLE} statement:
+those given in a @code{CREATE TABLE} or @code{ALTER TABLE} statement.
+These might be changes to a data type, to attributes associated with a
+data type, or to an index specification.
+Possible data type changes are given in the following list.  These
+occur prior to MySQL 5.0.3.  (As of 5.0.3 an error occurs if a column
+cannot be created using the specified data type.)
 @itemize @bullet
 @code{VARCHAR} columns with a length less than four are changed to
@@ -58814,6 +58821,18 @@
 @code{VARCHAR(200000)} is converted to @code{MEDIUMTEXT}.
 Note that this conversion results in a change in behavior with regard to
 treatment of trailing spaces.
+For a specification of @code{DECIMAL(@var{M},@var{D})}, if @var{M} is not
+larger than @var{D}, it is adjusted upward. For example, @code{DECIMAL(10,10)}
+becomes @code{DECIMAL(11,10)}.
+@end itemize
+Other silent column specification changes include changes to attribute or
+index specifications:
+@itemize @bullet
 @code{TIMESTAMP} display sizes are discarded from MySQL 4.1 on, due
bk commit - mysqldoc tree (paul:1.2754)paul22 Mar