bk commit - mysqldoc tree (paul:1.2893)

[paul]

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.2893 05/04/25 13:22:25 paul@stripped +1 -0
  manual.texi:
    Correct some inconsistencies in different lower_case_table_names
    descriptions.  Say that you should set the variable to 1
    if you use InnoDB tables.

  Docs/manual.texi
    1.2734 05/04/25 13:21:44 paul@stripped +15 -5
    Correct some inconsistencies in different lower_case_table_names
    descriptions.  Say that you should set the variable to 1
    if you use InnoDB tables.

# 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:	kite-hub.kitebird.com
# Root:	/src/extern/MySQL/bk/mysqldoc

--- 1.2733/Docs/manual.texi	2005-04-25 11:28:33 -05:00
+++ 1.2734/Docs/manual.texi	2005-04-25 13:21:44 -05:00
@@ -21201,12 +21201,14 @@
 From 4.1.1, it also applies to table aliases.
 @xref{Name case sensitivity}.
 
+If you are using @code{InnoDB} tables, you should set this variable to 1
+on all platforms to force names to be converted to lowercase.
+
 You should @emph{not} set this variable to 0 if you are running
-MySQL on a system that does not have case-sensitive filenames (such as
-Windows or Mac OS X).  New in 4.0.18:  If this variable is not set at
-startup and the
-filesystem on which the data directory is located does not have
-case-sensitive filenames, MySQL automatically sets
+MySQL on a system that does not have case-sensitive filenames (such
+as Windows or Mac OS X).  New in 4.0.18:  If this variable is not set
+at startup and the filesystem on which the data directory is located
+does not have case-sensitive filenames, MySQL automatically sets
 @code{lower_case_table_names} to 2.
 
 @item max_allowed_packet
@@ -42258,6 +42260,9 @@
 
 @end multitable
 
+On Windows, the default value of @code{lower_case_table_names} is 1.
+On Mac OS X, the default is 1 before MySQL 4.0.18 and 2 as of 4.0.18.
+
 If you are using MySQL on only one platform, you don't normally have to
 change the @code{lower_case_table_names} variable. However, you may
 encounter difficulties if you want to transfer tables between platforms
@@ -42280,6 +42285,11 @@
 to your database and table names with the correct lettercase on Windows. If
 you transfer your queries to Unix, where lettercase is significant, they do
 not work if the lettercase is incorrect.
+
+Exception: If you are using @code{InnoDB} tables, you should set
+@code{lower_case_table_names} to 1 on all platforms to force names to be
+converted to lowercase.
+
 @end itemize
 
 Note that before setting @code{lower_case_table_names} to 1 on Unix, you must