svn commit - mysqldoc@docsrva: r8539 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0 refman-common

[paul]

Author: paul
Date: 2007-11-05 20:45:11 +0100 (Mon, 05 Nov 2007)
New Revision: 8539

Log:
 r32360@polar:  paul | 2007-11-05 13:44:28 -0600
 Revise cursor description.
 (Bug#31597)
 read-only -> read only when not used as adjective.


Modified:
   trunk/refman-4.1/client-utility-programs.xml
   trunk/refman-4.1/errors-problems.xml
   trunk/refman-4.1/news-4.0.xml
   trunk/refman-4.1/storage-engines.xml
   trunk/refman-5.0/client-utility-programs.xml
   trunk/refman-5.0/errors-problems.xml
   trunk/refman-5.0/restrictions.xml
   trunk/refman-5.0/se-myisam.xml
   trunk/refman-5.0/stored-procedures.xml
   trunk/refman-5.0/triggers.xml
   trunk/refman-5.1/client-utility-programs.xml
   trunk/refman-5.1/errors-problems-core.xml
   trunk/refman-5.1/extending-mysql.xml
   trunk/refman-5.1/restrictions.xml
   trunk/refman-5.1/se-myisam.xml
   trunk/refman-5.1/storage-engines.xml
   trunk/refman-5.1/stored-procedures.xml
   trunk/refman-5.1/triggers.xml
   trunk/refman-6.0/client-utility-programs.xml
   trunk/refman-6.0/errors-problems.xml
   trunk/refman-6.0/extending-mysql.xml
   trunk/refman-6.0/restrictions.xml
   trunk/refman-6.0/se-myisam.xml
   trunk/refman-6.0/storage-engines.xml
   trunk/refman-6.0/stored-procedures.xml
   trunk/refman-6.0/triggers.xml
   trunk/refman-common/news-innodb.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:32355
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:26562
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:21581
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:32360
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:26562
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:21581


Modified: trunk/refman-4.1/client-utility-programs.xml
===================================================================
--- trunk/refman-4.1/client-utility-programs.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-4.1/client-utility-programs.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 670 bytes

@@ -3104,7 +3104,7 @@
 
           <listitem>
             <para>
-              After packing a table, it becomes read-only. This is
+              After packing a table, it becomes read only. This is
               generally intended (such as when accessing packed tables
               on a CD). Allowing writes to a packed table is on our TODO
               list, but with low priority.


Modified: trunk/refman-4.1/errors-problems.xml
===================================================================
--- trunk/refman-4.1/errors-problems.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-4.1/errors-problems.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 663 bytes

@@ -1909,7 +1909,7 @@
 
               <listitem>
                 <para>
-                  If your large table is read-only, you can use
+                  If your large table is read only, you can use
                   <command>myisampack</command> to compress it.
                   <command>myisampack</command> usually compresses a
                   table by at least 50%, so you can have, in effect,


Modified: trunk/refman-4.1/news-4.0.xml
===================================================================
--- trunk/refman-4.1/news-4.0.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-4.1/news-4.0.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 601 bytes

@@ -4969,7 +4969,7 @@
         <para>
           <literal>ALTER TABLE ... UNION=(...)</literal> for
           <literal>MERGE</literal> table is now allowed even if some
-          underlying <literal>MyISAM</literal> tables are read-only.
+          underlying <literal>MyISAM</literal> tables are read only.
           (Bug #702)
         </para>
       </listitem>


Modified: trunk/refman-4.1/storage-engines.xml
===================================================================
--- trunk/refman-4.1/storage-engines.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-4.1/storage-engines.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 650 bytes

@@ -1344,7 +1344,7 @@
 
         <note>
           <para>
-            While a compressed table is read-only, and you cannot
+            While a compressed table is read only, and you cannot
             therefore update or add rows in the table, DDL (Data
             Definition Language) operations are still valid. For
             example, you may still use <literal>DROP</literal> to drop


Modified: trunk/refman-5.0/client-utility-programs.xml
===================================================================
--- trunk/refman-5.0/client-utility-programs.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.0/client-utility-programs.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 670 bytes

@@ -3163,7 +3163,7 @@
 
           <listitem>
             <para>
-              After packing a table, it becomes read-only. This is
+              After packing a table, it becomes read only. This is
               generally intended (such as when accessing packed tables
               on a CD). Allowing writes to a packed table is on our TODO
               list, but with low priority.


Modified: trunk/refman-5.0/errors-problems.xml
===================================================================
--- trunk/refman-5.0/errors-problems.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.0/errors-problems.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 663 bytes

@@ -1837,7 +1837,7 @@
 
               <listitem>
                 <para>
-                  If your large table is read-only, you can use
+                  If your large table is read only, you can use
                   <command>myisampack</command> to compress it.
                   <command>myisampack</command> usually compresses a
                   table by at least 50%, so you can have, in effect,


Modified: trunk/refman-5.0/restrictions.xml
===================================================================
--- trunk/refman-5.0/restrictions.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.0/restrictions.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 459 bytes

@@ -349,7 +349,7 @@
     </para>
 
     <para>
-      Cursors are read-only; you cannot use a cursor to update rows.
+      Cursors are read only; you cannot use a cursor to update rows.
     </para>
 
     <para>


Modified: trunk/refman-5.0/se-myisam.xml
===================================================================
--- trunk/refman-5.0/se-myisam.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.0/se-myisam.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 627 bytes

@@ -953,7 +953,7 @@
 
       <note>
         <para>
-          While a compressed table is read-only, and you cannot
+          While a compressed table is read only, and you cannot
           therefore update or add rows in the table, DDL (Data
           Definition Language) operations are still valid. For example,
           you may still use <literal>DROP</literal> to drop the table,


Modified: trunk/refman-5.0/stored-procedures.xml
===================================================================
--- trunk/refman-5.0/stored-procedures.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.0/stored-procedures.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 29, Lines Deleted: 7; 1588 bytes

@@ -1730,16 +1730,38 @@
 
       <para>
         Cursors are supported inside stored procedures and functions and
-        triggers. The syntax is as in embedded SQL. Cursors are
-        currently asensitive, read-only, and non-scrolling. Asensitive
-        means that the server may or may not make a copy of its result
-        table.
+        triggers. The syntax is as in embedded SQL. Cursors currently
+        have these properties:
       </para>
 
+      <itemizedlist>
+
+        <listitem>
+          <para>
+            Asensitive: The server may or may not make a copy of its
+            result table
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
+            Read only: Not updatable
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
+            Non-scrollable: Can be traversed only in one direction and
+            cannot skip rows
+          </para>
+        </listitem>
+
+      </itemizedlist>
+
       <para>
-        Cursors must be declared before declaring handlers, and
-        variables and conditions must be declared before declaring
-        either cursors or handlers.
+        Cursors must be declared before declaring handlers. Variables
+        and conditions must be declared before declaring either cursors
+        or handlers.
       </para>
 
       <para>


Modified: trunk/refman-5.0/triggers.xml
===================================================================
--- trunk/refman-5.0/triggers.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.0/triggers.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 645 bytes

@@ -777,7 +777,7 @@
     </para>
 
     <para>
-      A column named with <literal>OLD</literal> is read-only. You can
+      A column named with <literal>OLD</literal> is read only. You can
       refer to it (if you have the <literal>SELECT</literal> privilege),
       but not modify it. A column named with <literal>NEW</literal> can
       be referred to if you have the <literal>SELECT</literal> privilege


Modified: trunk/refman-5.1/client-utility-programs.xml
===================================================================
--- trunk/refman-5.1/client-utility-programs.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.1/client-utility-programs.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 670 bytes

@@ -3164,7 +3164,7 @@
 
           <listitem>
             <para>
-              After packing a table, it becomes read-only. This is
+              After packing a table, it becomes read only. This is
               generally intended (such as when accessing packed tables
               on a CD). Allowing writes to a packed table is on our TODO
               list, but with low priority.


Modified: trunk/refman-5.1/errors-problems-core.xml
===================================================================
--- trunk/refman-5.1/errors-problems-core.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.1/errors-problems-core.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 678 bytes

@@ -1841,7 +1841,7 @@
 
               <listitem>
                 <para>
-                  If your large table is read-only, you can use
+                  If your large table is read only, you can use
                   <command>myisampack</command> to compress it.
                   <command>myisampack</command> usually compresses a
                   table by at least 50%, so you can have, in effect,


Modified: trunk/refman-5.1/extending-mysql.xml
===================================================================
--- trunk/refman-5.1/extending-mysql.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.1/extending-mysql.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 459 bytes

@@ -1204,7 +1204,7 @@
 
         <para>
           Plugins should consider the <literal>thd</literal> parameter
-          to be read-only.
+          to be read only.
         </para>
 
       </section>


Modified: trunk/refman-5.1/restrictions.xml
===================================================================
--- trunk/refman-5.1/restrictions.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.1/restrictions.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 459 bytes

@@ -378,7 +378,7 @@
     </para>
 
     <para>
-      Cursors are read-only; you cannot use a cursor to update rows.
+      Cursors are read only; you cannot use a cursor to update rows.
     </para>
 
     <para>


Modified: trunk/refman-5.1/se-myisam.xml
===================================================================
--- trunk/refman-5.1/se-myisam.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.1/se-myisam.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 627 bytes

@@ -924,7 +924,7 @@
 
       <note>
         <para>
-          While a compressed table is read-only, and you cannot
+          While a compressed table is read only, and you cannot
           therefore update or add rows in the table, DDL (Data
           Definition Language) operations are still valid. For example,
           you may still use <literal>DROP</literal> to drop the table,


Modified: trunk/refman-5.1/storage-engines.xml
===================================================================
--- trunk/refman-5.1/storage-engines.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.1/storage-engines.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 647 bytes

@@ -618,7 +618,7 @@
                   <para>
                     Compressed MyISAM tables are only supported when
                     using the compressed row format. Tables using the
-                    compressed row format with MyISAM are read-only.
+                    compressed row format with MyISAM are read only.
                   </para>
 
                 </footnote></entry>


Modified: trunk/refman-5.1/stored-procedures.xml
===================================================================
--- trunk/refman-5.1/stored-procedures.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.1/stored-procedures.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 29, Lines Deleted: 7; 1588 bytes

@@ -1700,16 +1700,38 @@
 
       <para>
         Cursors are supported inside stored procedures and functions and
-        triggers. The syntax is as in embedded SQL. Cursors are
-        currently asensitive, read-only, and non-scrolling. Asensitive
-        means that the server may or may not make a copy of its result
-        table.
+        triggers. The syntax is as in embedded SQL. Cursors currently
+        have these properties:
       </para>
 
+      <itemizedlist>
+
+        <listitem>
+          <para>
+            Asensitive: The server may or may not make a copy of its
+            result table
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
+            Read only: Not updatable
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
+            Non-scrollable: Can be traversed only in one direction and
+            cannot skip rows
+          </para>
+        </listitem>
+
+      </itemizedlist>
+
       <para>
-        Cursors must be declared before declaring handlers, and
-        variables and conditions must be declared before declaring
-        either cursors or handlers.
+        Cursors must be declared before declaring handlers. Variables
+        and conditions must be declared before declaring either cursors
+        or handlers.
       </para>
 
       <para>


Modified: trunk/refman-5.1/triggers.xml
===================================================================
--- trunk/refman-5.1/triggers.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-5.1/triggers.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 645 bytes

@@ -728,7 +728,7 @@
     </para>
 
     <para>
-      A column named with <literal>OLD</literal> is read-only. You can
+      A column named with <literal>OLD</literal> is read only. You can
       refer to it (if you have the <literal>SELECT</literal> privilege),
       but not modify it. A column named with <literal>NEW</literal> can
       be referred to if you have the <literal>SELECT</literal> privilege


Modified: trunk/refman-6.0/client-utility-programs.xml
===================================================================
--- trunk/refman-6.0/client-utility-programs.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-6.0/client-utility-programs.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 670 bytes

@@ -3164,7 +3164,7 @@
 
           <listitem>
             <para>
-              After packing a table, it becomes read-only. This is
+              After packing a table, it becomes read only. This is
               generally intended (such as when accessing packed tables
               on a CD). Allowing writes to a packed table is on our TODO
               list, but with low priority.


Modified: trunk/refman-6.0/errors-problems.xml
===================================================================
--- trunk/refman-6.0/errors-problems.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-6.0/errors-problems.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 663 bytes

@@ -1830,7 +1830,7 @@
 
               <listitem>
                 <para>
-                  If your large table is read-only, you can use
+                  If your large table is read only, you can use
                   <command>myisampack</command> to compress it.
                   <command>myisampack</command> usually compresses a
                   table by at least 50%, so you can have, in effect,


Modified: trunk/refman-6.0/extending-mysql.xml
===================================================================
--- trunk/refman-6.0/extending-mysql.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-6.0/extending-mysql.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 459 bytes

@@ -1204,7 +1204,7 @@
 
         <para>
           Plugins should consider the <literal>thd</literal> parameter
-          to be read-only.
+          to be read only.
         </para>
 
       </section>


Modified: trunk/refman-6.0/restrictions.xml
===================================================================
--- trunk/refman-6.0/restrictions.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-6.0/restrictions.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 459 bytes

@@ -372,7 +372,7 @@
     </para>
 
     <para>
-      Cursors are read-only; you cannot use a cursor to update rows.
+      Cursors are read only; you cannot use a cursor to update rows.
     </para>
 
     <para>


Modified: trunk/refman-6.0/se-myisam.xml
===================================================================
--- trunk/refman-6.0/se-myisam.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-6.0/se-myisam.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 627 bytes

@@ -923,7 +923,7 @@
 
       <note>
         <para>
-          While a compressed table is read-only, and you cannot
+          While a compressed table is read only, and you cannot
           therefore update or add rows in the table, DDL (Data
           Definition Language) operations are still valid. For example,
           you may still use <literal>DROP</literal> to drop the table,


Modified: trunk/refman-6.0/storage-engines.xml
===================================================================
--- trunk/refman-6.0/storage-engines.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-6.0/storage-engines.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 647 bytes

@@ -632,7 +632,7 @@
                   <para>
                     Compressed MyISAM tables are only supported when
                     using the compressed row format. Tables using the
-                    compressed row format with MyISAM are read-only.
+                    compressed row format with MyISAM are read only.
                   </para>
 
                 </footnote></entry>


Modified: trunk/refman-6.0/stored-procedures.xml
===================================================================
--- trunk/refman-6.0/stored-procedures.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-6.0/stored-procedures.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 29, Lines Deleted: 7; 1588 bytes

@@ -1679,16 +1679,38 @@
 
       <para>
         Cursors are supported inside stored procedures and functions and
-        triggers. The syntax is as in embedded SQL. Cursors are
-        currently asensitive, read-only, and non-scrolling. Asensitive
-        means that the server may or may not make a copy of its result
-        table.
+        triggers. The syntax is as in embedded SQL. Cursors currently
+        have these properties:
       </para>
 
+      <itemizedlist>
+
+        <listitem>
+          <para>
+            Asensitive: The server may or may not make a copy of its
+            result table
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
+            Read only: Not updatable
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
+            Non-scrollable: Can be traversed only in one direction and
+            cannot skip rows
+          </para>
+        </listitem>
+
+      </itemizedlist>
+
       <para>
-        Cursors must be declared before declaring handlers, and
-        variables and conditions must be declared before declaring
-        either cursors or handlers.
+        Cursors must be declared before declaring handlers. Variables
+        and conditions must be declared before declaring either cursors
+        or handlers.
       </para>
 
       <para>


Modified: trunk/refman-6.0/triggers.xml
===================================================================
--- trunk/refman-6.0/triggers.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-6.0/triggers.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 645 bytes

@@ -701,7 +701,7 @@
     </para>
 
     <para>
-      A column named with <literal>OLD</literal> is read-only. You can
+      A column named with <literal>OLD</literal> is read only. You can
       refer to it (if you have the <literal>SELECT</literal> privilege),
       but not modify it. A column named with <literal>NEW</literal> can
       be referred to if you have the <literal>SELECT</literal> privilege


Modified: trunk/refman-common/news-innodb.xml
===================================================================
--- trunk/refman-common/news-innodb.xml	2007-11-05 18:49:19 UTC (rev 8538)
+++ trunk/refman-common/news-innodb.xml	2007-11-05 19:45:11 UTC (rev 8539)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 780 bytes

@@ -897,7 +897,7 @@
           <literal>AUTOCOMMIT=1</literal>, then we do not need to make a
           plain <literal>SELECT</literal> set shared locks even on the
           <literal>SERIALIZABLE</literal> isolation level, because we
-          know that the transaction is read-only. A read-only
+          know that the transaction is read only. A read-only
           transaction can always be performed on the <literal>REPEATABLE
           READ</literal> level, and that does not endanger the
           serializability.