List:Commits« Previous MessageNext Message »
From:jon Date:March 13 2008 7:29am
Subject:svn commit - mysqldoc@docsrva: r10217 - in trunk: refman-5.1 refman-6.0
View as plain text  
Author: jstephens
Date: 2008-03-13 07:29:29 +0100 (Thu, 13 Mar 2008)
New Revision: 10217

Log:

Names of tablespaces and logfile groups are case-sensitive

Fixes Docs Bug #27098



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


Modified: trunk/refman-5.1/language-structure-core.xml
===================================================================
--- trunk/refman-5.1/language-structure-core.xml	2008-03-13 05:54:21 UTC (rev 10216)
+++ trunk/refman-5.1/language-structure-core.xml	2008-03-13 06:29:29 UTC (rev 10217)
Changed blocks: 2, Lines Added: 14, Lines Deleted: 2; 1343 bytes

@@ -1065,6 +1065,14 @@
             <entry>64</entry>
           </row>
           <row>
+            <entry>Tablespace</entry>
+            <entry>64</entry>
+          </row>
+          <row>
+            <entry>Log File Group</entry>
+            <entry>64</entry>
+          </row>
+          <row>
             <entry>Alias</entry>
             <entry>255</entry>
           </row>

@@ -1278,11 +1286,15 @@
 
       <para>
         Column, index, stored routine, and event names are not case
-        sensitive on any platform, nor are column aliases. Trigger names
-        are case sensitive, which differs from standard SQL.
+        sensitive on any platform, nor are column aliases.
       </para>
 
       <para>
+        However, names of triggers, tablespaces, and logfile groups are
+        case sensitive. This differs from standard SQL.
+      </para>
+
+      <para>
         By default, table aliases are case sensitive on Unix, but not so
         on Windows or Mac OS X. The following statement would not work
         on Unix, because it refers to the alias both as


Modified: trunk/refman-6.0/language-structure-core.xml
===================================================================
--- trunk/refman-6.0/language-structure-core.xml	2008-03-13 05:54:21 UTC (rev 10216)
+++ trunk/refman-6.0/language-structure-core.xml	2008-03-13 06:29:29 UTC (rev 10217)
Changed blocks: 2, Lines Added: 14, Lines Deleted: 2; 1343 bytes

@@ -1053,6 +1053,14 @@
             <entry>64</entry>
           </row>
           <row>
+            <entry>Tablespace</entry>
+            <entry>64</entry>
+          </row>
+          <row>
+            <entry>Log File Group</entry>
+            <entry>64</entry>
+          </row>
+          <row>
             <entry>Alias</entry>
             <entry>255</entry>
           </row>

@@ -1266,11 +1274,15 @@
 
       <para>
         Column, index, stored routine, and event names are not case
-        sensitive on any platform, nor are column aliases. Trigger names
-        are case sensitive, which differs from standard SQL.
+        sensitive on any platform, nor are column aliases.
       </para>
 
       <para>
+        However, names of triggers, tablespaces, and logfile groups are
+        case sensitive. This differs from standard SQL.
+      </para>
+
+      <para>
         By default, table aliases are case sensitive on Unix, but not so
         on Windows or Mac OS X. The following statement would not work
         on Unix, because it refers to the alias both as


Modified: trunk/refman-6.0/sql-syntax.xml
===================================================================
--- trunk/refman-6.0/sql-syntax.xml	2008-03-13 05:54:21 UTC (rev 10216)
+++ trunk/refman-6.0/sql-syntax.xml	2008-03-13 06:29:29 UTC (rev 10217)
Changed blocks: 2, Lines Added: 4, Lines Deleted: 2; 1100 bytes

@@ -2605,7 +2605,8 @@
         <literal>UNDO</literal> file named
         '<replaceable>undo_file</replaceable>'. A <literal>CREATE
         LOGFILE GROUP</literal> statement has one and only one
-        <literal>ADD UNDOFILE</literal> clause.
+        <literal>ADD UNDOFILE</literal> clause. For rules covering the naming
of
+        log file groups, see <xref linkend="identifiers"/>.
       </para>
 
       <para>

@@ -5135,7 +5136,8 @@
         data file is created and added to the tablespace using this
         statement. Additional data files may be added to the tablespace
         by using the <literal>ALTER TABLESPACE</literal> statement (see
-        <xref linkend="alter-tablespace"/>).
+        <xref linkend="alter-tablespace"/>). For rules covering the naming of
+        tablespaces, see <xref linkend="identifiers"/>.
       </para>
 
       <para>
Thread
• svn commit - mysqldoc@docsrva: r10217 - in trunk: refman-5.1 refman-6.0jon13 Mar 2008