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> <userinput>SET GLOBAL sql_mode='ANSI';</userinput>
+mysql> <userinput>SELECT @@global.sql_mode;</userinput>
+ -> '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> <userinput>SET GLOBAL sql_mode='ansi';</userinput>
-mysql> <userinput>SELECT @@global.sql_mode;</userinput>
- -> '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> <userinput>SET GLOBAL sql_mode='ANSI';</userinput>
+mysql> <userinput>SELECT @@global.sql_mode;</userinput>
+ -> '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> <userinput>SET GLOBAL sql_mode='ansi';</userinput>
-mysql> <userinput>SELECT @@global.sql_mode;</userinput>
- -> '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> <userinput>SET GLOBAL sql_mode='ANSI';</userinput>
+mysql> <userinput>SELECT @@global.sql_mode;</userinput>
+ -> '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> <userinput>SET GLOBAL sql_mode='ansi';</userinput>
-mysql> <userinput>SELECT @@global.sql_mode;</userinput>
- -> '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.1 | paul | 4 Jan |
