List:Commits« Previous MessageNext Message »
From:paul Date:January 4 2006 12:27am
Subject:svn commit - mysqldoc@docsrva: r659 - in trunk: . refman-4.1 refman-5.0 refman-5.1
View as plain text  
Author: paul
Date: 2006-01-04 01:27:03 +0100 (Wed, 04 Jan 2006)
New Revision: 659

Log:
 r5801@frost:  paul | 2006-01-03 18:26:28 -0600
 Clarify that "running the server in ANSI mode" (with --ansi) is not _quite_
 the same as setting sql_mode to ANSI.  (The latter doesn't affect the
 transaction isolation level.)


Modified:
   trunk/
   trunk/refman-4.1/introduction.xml
   trunk/refman-5.0/introduction.xml
   trunk/refman-5.1/introduction.xml


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:5797
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1848
   + b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:5801
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1848

Modified: trunk/refman-4.1/introduction.xml
===================================================================
--- trunk/refman-4.1/introduction.xml	2006-01-03 23:34:28 UTC (rev 658)
+++ trunk/refman-4.1/introduction.xml	2006-01-04 00:27:03 UTC (rev 659)
@@ -1263,60 +1263,51 @@
       </indexterm>
 
       <para>
-        You can tell <command>mysqld</command> to use the ANSI mode with
-        the <option>--ansi</option> startup option. See
-        <xref linkend="server-options"/>.
+        You can tell <command>mysqld</command> to run in ANSI mode with
+        the <option>--ansi</option> startup option. Running the server
+        in ANSI mode is the same as starting it with the following
+        options:
       </para>
 
-      <para>
-        Running the server in ANSI mode is the same as starting it with
-        these options (specify the <option>--sql_mode</option> value on
-        a single line):
-      </para>
-
 <programlisting>
---transaction-isolation=SERIALIZABLE
---sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
-IGNORE_SPACE
+--transaction-isolation=SERIALIZABLE --sql-mode=ANSI
 </programlisting>
 
       <para>
-        In MySQL 4.1, you can achieve the same effect with these two
-        statements (specify the <literal>sql_mode</literal> value on a
-        single line):
+        As of MySQL 4.1.1, you can achieve the same effect at runtime by
+        executing these two statements:
       </para>
 
 <programlisting>
 SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
-SET GLOBAL sql_mode = 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
-IGNORE_SPACE';
+SET GLOBAL sql_mode = 'ANSI';
 </programlisting>
 
       <para>
-        See <xref linkend="sql-mode"/>.
+        You can see that setting the <literal>sql_mode</literal> system
+        variable to <literal>'ANSI'</literal> enables all SQL mode
+        options that are relevant for ANSI mode as follows:
       </para>
 
-      <para>
-        In MySQL 4.1.1, the <literal>sql_mode</literal> options shown
-        can be also be set with this statement:
-      </para>
-
 <programlisting>
-SET GLOBAL sql_mode='ansi';
+mysql&gt; <userinput>SET GLOBAL sql_mode='ANSI';</userinput>
+mysql&gt; <userinput>SELECT @@global.sql_mode;</userinput>
+        -&gt; 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI'
 </programlisting>
 
       <para>
-        In this case, the value of the <literal>sql_mode</literal>
-        variable is set to all options that are relevant for ANSI mode.
-        You can check the result like this:
+        Note that running the server in ANSI mode with
+        <option>--ansi</option> is not quite the same as setting the SQL
+        mode to <literal>'ANSI'</literal>. The <option>--ansi</option>
+        option affects the SQL mode and also sets the transaction
+        isolation level. Setting the SQL mode to
+        <literal>'ANSI'</literal> has no effect on the isolation level.
       </para>
 
-<programlisting>
-mysql&gt; <userinput>SET GLOBAL sql_mode='ansi';</userinput>
-mysql&gt; <userinput>SELECT @@global.sql_mode;</userinput>
-        -&gt; 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
-            IGNORE_SPACE,ANSI';
-</programlisting>
+      <para>
+        See <xref linkend="server-options"/>, and
+        <xref linkend="sql-mode"/>.
+      </para>
 
     </section>
 

Modified: trunk/refman-5.0/introduction.xml
===================================================================
--- trunk/refman-5.0/introduction.xml	2006-01-03 23:34:28 UTC (rev 658)
+++ trunk/refman-5.0/introduction.xml	2006-01-04 00:27:03 UTC (rev 659)
@@ -869,60 +869,51 @@
       </indexterm>
 
       <para>
-        You can tell <command>mysqld</command> to use the ANSI mode with
-        the <option>--ansi</option> startup option. See
-        <xref linkend="server-options"/>.
+        You can tell <command>mysqld</command> to run in ANSI mode with
+        the <option>--ansi</option> startup option. Running the server
+        in ANSI mode is the same as starting it with the following
+        options:
       </para>
 
-      <para>
-        Running the server in ANSI mode is the same as starting it with
-        these options (specify the <option>--sql_mode</option> value on
-        a single line):
-      </para>
-
 <programlisting>
---transaction-isolation=SERIALIZABLE
---sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
-IGNORE_SPACE
+--transaction-isolation=SERIALIZABLE --sql-mode=ANSI
 </programlisting>
 
       <para>
-        In MySQL 4.1, you can achieve the same effect with these two
-        statements (specify the <literal>sql_mode</literal> value on a
-        single line):
+        As of MySQL 4.1.1, you can achieve the same effect at runtime by
+        executing these two statements:
       </para>
 
 <programlisting>
 SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
-SET GLOBAL sql_mode = 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
-IGNORE_SPACE';
+SET GLOBAL sql_mode = 'ANSI';
 </programlisting>
 
       <para>
-        See <xref linkend="sql-mode"/>.
+        You can see that setting the <literal>sql_mode</literal> system
+        variable to <literal>'ANSI'</literal> enables all SQL mode
+        options that are relevant for ANSI mode as follows:
       </para>
 
-      <para>
-        In MySQL 4.1.1, the <literal>sql_mode</literal> options shown
-        can be also be set with this statement:
-      </para>
-
 <programlisting>
-SET GLOBAL sql_mode='ansi';
+mysql&gt; <userinput>SET GLOBAL sql_mode='ANSI';</userinput>
+mysql&gt; <userinput>SELECT @@global.sql_mode;</userinput>
+        -&gt; 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI'
 </programlisting>
 
       <para>
-        In this case, the value of the <literal>sql_mode</literal>
-        variable is set to all options that are relevant for ANSI mode.
-        You can check the result like this:
+        Note that running the server in ANSI mode with
+        <option>--ansi</option> is not quite the same as setting the SQL
+        mode to <literal>'ANSI'</literal>. The <option>--ansi</option>
+        option affects the SQL mode and also sets the transaction
+        isolation level. Setting the SQL mode to
+        <literal>'ANSI'</literal> has no effect on the isolation level.
       </para>
 
-<programlisting>
-mysql&gt; <userinput>SET GLOBAL sql_mode='ansi';</userinput>
-mysql&gt; <userinput>SELECT @@global.sql_mode;</userinput>
-        -&gt; 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
-            IGNORE_SPACE,ANSI';
-</programlisting>
+      <para>
+        See <xref linkend="server-options"/>, and
+        <xref linkend="sql-mode"/>.
+      </para>
 
     </section>
 

Modified: trunk/refman-5.1/introduction.xml
===================================================================
--- trunk/refman-5.1/introduction.xml	2006-01-03 23:34:28 UTC (rev 658)
+++ trunk/refman-5.1/introduction.xml	2006-01-04 00:27:03 UTC (rev 659)
@@ -623,60 +623,51 @@
       </indexterm>
 
       <para>
-        You can tell <command>mysqld</command> to use the ANSI mode with
-        the <option>--ansi</option> startup option. See
-        <xref linkend="server-options"/>.
+        You can tell <command>mysqld</command> to run in ANSI mode with
+        the <option>--ansi</option> startup option. Running the server
+        in ANSI mode is the same as starting it with the following
+        options:
       </para>
 
-      <para>
-        Running the server in ANSI mode is the same as starting it with
-        these options (specify the <option>--sql_mode</option> value on
-        a single line):
-      </para>
-
 <programlisting>
---transaction-isolation=SERIALIZABLE
---sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
-IGNORE_SPACE
+--transaction-isolation=SERIALIZABLE --sql-mode=ANSI
 </programlisting>
 
       <para>
-        In MySQL 4.1, you can achieve the same effect with these two
-        statements (specify the <literal>sql_mode</literal> value on a
-        single line):
+        As of MySQL 4.1.1, you can achieve the same effect at runtime by
+        executing these two statements:
       </para>
 
 <programlisting>
 SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
-SET GLOBAL sql_mode = 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
-IGNORE_SPACE';
+SET GLOBAL sql_mode = 'ANSI';
 </programlisting>
 
       <para>
-        See <xref linkend="sql-mode"/>.
+        You can see that setting the <literal>sql_mode</literal> system
+        variable to <literal>'ANSI'</literal> enables all SQL mode
+        options that are relevant for ANSI mode as follows:
       </para>
 
-      <para>
-        In MySQL 4.1.1, the <literal>sql_mode</literal> options shown
-        can be also be set with this statement:
-      </para>
-
 <programlisting>
-SET GLOBAL sql_mode='ansi';
+mysql&gt; <userinput>SET GLOBAL sql_mode='ANSI';</userinput>
+mysql&gt; <userinput>SELECT @@global.sql_mode;</userinput>
+        -&gt; 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI'
 </programlisting>
 
       <para>
-        In this case, the value of the <literal>sql_mode</literal>
-        variable is set to all options that are relevant for ANSI mode.
-        You can check the result like this:
+        Note that running the server in ANSI mode with
+        <option>--ansi</option> is not quite the same as setting the SQL
+        mode to <literal>'ANSI'</literal>. The <option>--ansi</option>
+        option affects the SQL mode and also sets the transaction
+        isolation level. Setting the SQL mode to
+        <literal>'ANSI'</literal> has no effect on the isolation level.
       </para>
 
-<programlisting>
-mysql&gt; <userinput>SET GLOBAL sql_mode='ansi';</userinput>
-mysql&gt; <userinput>SELECT @@global.sql_mode;</userinput>
-        -&gt; 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
-            IGNORE_SPACE,ANSI';
-</programlisting>
+      <para>
+        See <xref linkend="server-options"/>, and
+        <xref linkend="sql-mode"/>.
+      </para>
 
     </section>
 

Thread
svn commit - mysqldoc@docsrva: r659 - in trunk: . refman-4.1 refman-5.0 refman-5.1paul4 Jan