Author: paul
Date: 2008-02-05 19:42:33 +0100 (Tue, 05 Feb 2008)
New Revision: 9708
Log:
r28966@arctic: paul | 2008-02-05 12:27:10 -0600
Update for 5.0 re: how database charset/collation affect stored routine
execution.
Some rearrangement of list items (5.0 .. 6.0)
Modified:
trunk/refman-5.0/stored-procedures.xml
trunk/refman-5.1/stored-procedures.xml
trunk/refman-6.0/stored-procedures.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:28949
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:28933
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:28949
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:28966
Modified: trunk/refman-5.0/stored-procedures.xml
===================================================================
--- trunk/refman-5.0/stored-procedures.xml 2008-02-05 18:41:05 UTC (rev 9707)
+++ trunk/refman-5.0/stored-procedures.xml 2008-02-05 18:42:33 UTC (rev 9708)
Changed blocks: 1, Lines Added: 24, Lines Deleted: 12; 2711 bytes
@@ -675,26 +675,38 @@
<listitem>
<para>
+ Only scalar values can be assigned to parameters or
+ variables. For example, a statement such as <literal>SET x =
+ (SELECT 1, 2)</literal> is invalid.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
For character data types, if there is a <literal>CHARACTER
SET</literal> clause in the declaration, the specified
character set and its default collation are used. If there
- is no such clause, the database character set and collation
- that are in effect at the time the routine is created are
+ is no such clause, as of MySQL 5.0.25, the database
+ character set and collation that are in effect at the time
+ the server loads the routine into the routine cache are
used. (These are given by the values of the
<literal>character_set_database</literal> and
- <literal>collation_database</literal> system variables.) The
- <literal>COLLATE</literal> attribute is not supported. (This
- includes use of <literal>BINARY</literal>, because in this
- context <literal>BINARY</literal> specifies the binary
- collation of the character set.)
+ <literal>collation_database</literal> system variables.) If
+ the database character set or collation change while the
+ routine is in the cache, routine execution is unaffected by
+ the change until the next time the server reloads the
+ routine into the cache. The <literal>COLLATE</literal>
+ attribute is not supported. (This includes use of
+ <literal>BINARY</literal>, because in this context
+ <literal>BINARY</literal> specifies the binary collation of
+ the character set.)
</para>
- </listitem>
- <listitem>
<para>
- Only scalar values can be assigned to parameters or
- variables. For example, a statement such as <literal>SET x =
- (SELECT 1, 2)</literal> is invalid.
+ In MySQL 5.1, the database character set and collation in
+ effect at the time the routine is created are used.
+ Subsequent changes to the database character set or
+ collation do not affect routine execution.
</para>
</listitem>
Modified: trunk/refman-5.1/stored-procedures.xml
===================================================================
--- trunk/refman-5.1/stored-procedures.xml 2008-02-05 18:41:05 UTC (rev 9707)
+++ trunk/refman-5.1/stored-procedures.xml 2008-02-05 18:42:33 UTC (rev 9708)
Changed blocks: 2, Lines Added: 8, Lines Deleted: 8; 1150 bytes
@@ -665,6 +665,14 @@
<listitem>
<para>
+ Only scalar values can be assigned to parameters or
+ variables. For example, a statement such as <literal>SET x =
+ (SELECT 1, 2)</literal> is invalid.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
For character data types, if there is a <literal>CHARACTER
SET</literal> clause in the declaration, the specified
character set and its default collation are used. If there
@@ -680,14 +688,6 @@
</para>
</listitem>
- <listitem>
- <para>
- Only scalar values can be assigned to parameters or
- variables. For example, a statement such as <literal>SET x =
- (SELECT 1, 2)</literal> is invalid.
- </para>
- </listitem>
-
</itemizedlist>
<para>
Modified: trunk/refman-6.0/stored-procedures.xml
===================================================================
--- trunk/refman-6.0/stored-procedures.xml 2008-02-05 18:41:05 UTC (rev 9707)
+++ trunk/refman-6.0/stored-procedures.xml 2008-02-05 18:42:33 UTC (rev 9708)
Changed blocks: 2, Lines Added: 8, Lines Deleted: 8; 1150 bytes
@@ -650,6 +650,14 @@
<listitem>
<para>
+ Only scalar values can be assigned to parameters or
+ variables. For example, a statement such as <literal>SET x =
+ (SELECT 1, 2)</literal> is invalid.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
For character data types, if there is a <literal>CHARACTER
SET</literal> clause in the declaration, the specified
character set and its default collation are used. If there
@@ -665,14 +673,6 @@
</para>
</listitem>
- <listitem>
- <para>
- Only scalar values can be assigned to parameters or
- variables. For example, a statement such as <literal>SET x =
- (SELECT 1, 2)</literal> is invalid.
- </para>
- </listitem>
-
</itemizedlist>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r9708 - in trunk: . refman-5.0 refman-5.1 refman-6.0 | paul | 5 Feb |
