svn commit - mysqldoc@docsrva: r10269 - in trunk: refman-5.1 refman-6.0

[jon]

Author: jstephens
Date: 2008-03-17 07:40:18 +0100 (Mon, 17 Mar 2008)
New Revision: 10269

Log:

Tablespace identifiers are case sensitive on Unix, but not on Windows.

(Thanks, Roland!)



Modified:
   trunk/refman-5.1/language-structure-core.xml
   trunk/refman-6.0/language-structure-core.xml


Modified: trunk/refman-5.1/language-structure-core.xml
===================================================================
--- trunk/refman-5.1/language-structure-core.xml	2008-03-16 11:29:15 UTC (rev 10268)
+++ trunk/refman-5.1/language-structure-core.xml	2008-03-17 06:40:18 UTC (rev 10269)
Changed blocks: 4, Lines Added: 16, Lines Deleted: 13; 3342 bytes

@@ -1242,13 +1242,14 @@
         In MySQL, databases correspond to directories within the data
         directory. Each table within a database corresponds to at least
         one file within the database directory (and possibly more,
-        depending on the storage engine). Consequently, the case
-        sensitivity of the underlying operating system plays a part in
-        the case sensitivity of database and table names. This means
-        database and table names are not case sensitive in Windows, and
-        case sensitive in most varieties of Unix. One notable exception
-        is Mac OS X, which is Unix-based but uses a default filesystem
-        type (HFS+) that is not case sensitive. However, Mac OS X also
+        depending on the storage engine). Tablespaces also correspond to
+        files. Consequently, the case sensitivity of the underlying
+        operating system plays a part in the case sensitivity of
+        database and table names. This means database, table, and
+        tablespace names are not case sensitive in Windows, but are case
+        sensitive in most varieties of Unix. One notable exception is
+        Mac OS X, which is Unix-based but uses a default filesystem type
+        (HFS+) that is not case sensitive. However, Mac OS X also
         supports UFS volumes, which are case sensitive just as on any
         Unix. See <xref linkend="extensions-to-ansi"/>. The
         <literal>lower_case_table_names</literal> system variable also

@@ -1271,9 +1272,9 @@
 
       <note>
         <para>
-          Although database and table names are not case sensitive on
-          some platforms, you should not refer to a given database or
-          table using different cases within the same statement. The
+          Although database, table, and tablespace names are not case
+          sensitive on some platforms, you should not refer to one of
+          these using different cases within the same statement. The
           following statement would not work because it refers to a
           table both as <literal>my_table</literal> and as
           <literal>MY_TABLE</literal>:

@@ -1290,8 +1291,8 @@
       </para>
 
       <para>
-        However, names of triggers, tablespaces, and logfile groups are
-        case sensitive. This differs from standard SQL.
+        However, names of triggers and logfile groups are case
+        sensitive. This differs from standard SQL.
       </para>
 
       <para>

@@ -1320,7 +1321,9 @@
         <literal>lower_case_table_names</literal> system variable, which
         you can set when starting <command>mysqld</command>.
         <literal>lower_case_table_names</literal> can take the values
-        shown in the following table. On Unix, the default value of
+        shown in the following table. This variable does
+        <emphasis>not</emphasis> affect case sensitivity of tablespace
+        identifiers. On Unix, the default value of
         <literal>lower_case_table_names</literal> is 0. On Windows the
         default value is 1. On Mac OS X, the default value is 2.
       </para>


Modified: trunk/refman-6.0/language-structure-core.xml
===================================================================
--- trunk/refman-6.0/language-structure-core.xml	2008-03-16 11:29:15 UTC (rev 10268)
+++ trunk/refman-6.0/language-structure-core.xml	2008-03-17 06:40:18 UTC (rev 10269)
Changed blocks: 4, Lines Added: 16, Lines Deleted: 13; 3342 bytes

@@ -1230,13 +1230,14 @@
         In MySQL, databases correspond to directories within the data
         directory. Each table within a database corresponds to at least
         one file within the database directory (and possibly more,
-        depending on the storage engine). Consequently, the case
-        sensitivity of the underlying operating system plays a part in
-        the case sensitivity of database and table names. This means
-        database and table names are not case sensitive in Windows, and
-        case sensitive in most varieties of Unix. One notable exception
-        is Mac OS X, which is Unix-based but uses a default filesystem
-        type (HFS+) that is not case sensitive. However, Mac OS X also
+        depending on the storage engine). Tablespaces also correspond to
+        files. Consequently, the case sensitivity of the underlying
+        operating system plays a part in the case sensitivity of
+        database and table names. This means database, table, and
+        tablespace names are not case sensitive in Windows, but are case
+        sensitive in most varieties of Unix. One notable exception is
+        Mac OS X, which is Unix-based but uses a default filesystem type
+        (HFS+) that is not case sensitive. However, Mac OS X also
         supports UFS volumes, which are case sensitive just as on any
         Unix. See <xref linkend="extensions-to-ansi"/>. The
         <literal>lower_case_table_names</literal> system variable also

@@ -1259,9 +1260,9 @@
 
       <note>
         <para>
-          Although database and table names are not case sensitive on
-          some platforms, you should not refer to a given database or
-          table using different cases within the same statement. The
+          Although database, table, and tablespace names are not case
+          sensitive on some platforms, you should not refer to one of
+          these using different cases within the same statement. The
           following statement would not work because it refers to a
           table both as <literal>my_table</literal> and as
           <literal>MY_TABLE</literal>:

@@ -1278,8 +1279,8 @@
       </para>
 
       <para>
-        However, names of triggers, tablespaces, and logfile groups are
-        case sensitive. This differs from standard SQL.
+        However, names of triggers and logfile groups are case
+        sensitive. This differs from standard SQL.
       </para>
 
       <para>

@@ -1308,7 +1309,9 @@
         <literal>lower_case_table_names</literal> system variable, which
         you can set when starting <command>mysqld</command>.
         <literal>lower_case_table_names</literal> can take the values
-        shown in the following table. On Unix, the default value of
+        shown in the following table. This variable does
+        <emphasis>not</emphasis> affect case sensitivity of tablespace
+        identifiers. On Unix, the default value of
         <literal>lower_case_table_names</literal> is 0. On Windows the
         default value is 1. On Mac OS X, the default value is 2.
       </para>