Author: paul
Date: 2006-01-21 20:01:04 +0100 (Sat, 21 Jan 2006)
New Revision: 970
Log:
r6524@frost: paul | 2006-01-21 12:16:55 -0600
IGNORE_SPACE doesn't apply to stored routines.
Modified:
trunk/
trunk/refman-5.0/database-administration.xml
trunk/refman-5.0/stored-procedures.xml
trunk/refman-5.1/database-administration.xml
trunk/refman-5.1/stored-procedures.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6523
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2396
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6524
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2396
Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml 2006-01-21 19:00:50 UTC (rev 969)
+++ trunk/refman-5.0/database-administration.xml 2006-01-21 19:01:04 UTC (rev 970)
@@ -4676,6 +4676,13 @@
<programlisting>
SELECT "User" FROM mysql."user";
</programlisting>
+
+ <para>
+ The <literal>IGNORE_SPACE</literal> SQL mode applies to
+ built-in functions, not to stored routines. it is always
+ allowable to have spaces after a routine name, regardless
+ of whether <literal>IGNORE_SPACE</literal> is enabled.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.0/stored-procedures.xml
===================================================================
--- trunk/refman-5.0/stored-procedures.xml 2006-01-21 19:00:50 UTC (rev 969)
+++ trunk/refman-5.0/stored-procedures.xml 2006-01-21 19:01:04 UTC (rev 970)
@@ -318,6 +318,13 @@
</para>
<para>
+ The <literal>IGNORE_SPACE</literal> SQL mode applies to built-in
+ functions, not to stored routines. it is always allowable to
+ have spaces after a routine name, regardless of whether
+ <literal>IGNORE_SPACE</literal> is enabled.
+ </para>
+
+ <para>
The parameter list enclosed within parentheses must always be
present. If there are no parameters, an empty parameter list of
<literal>()</literal> should be used. Each parameter is an
Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml 2006-01-21 19:00:50 UTC (rev 969)
+++ trunk/refman-5.1/database-administration.xml 2006-01-21 19:01:04 UTC (rev 970)
@@ -4650,6 +4650,13 @@
<programlisting>
SELECT "User" FROM mysql."user";
</programlisting>
+
+ <para>
+ The <literal>IGNORE_SPACE</literal> SQL mode applies to
+ built-in functions, not to stored routines. it is always
+ allowable to have spaces after a routine name, regardless
+ of whether <literal>IGNORE_SPACE</literal> is enabled.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.1/stored-procedures.xml
===================================================================
--- trunk/refman-5.1/stored-procedures.xml 2006-01-21 19:00:50 UTC (rev 969)
+++ trunk/refman-5.1/stored-procedures.xml 2006-01-21 19:01:04 UTC (rev 970)
@@ -308,6 +308,13 @@
</para>
<para>
+ The <literal>IGNORE_SPACE</literal> SQL mode applies to built-in
+ functions, not to stored routines. it is always allowable to
+ have spaces after a routine name, regardless of whether
+ <literal>IGNORE_SPACE</literal> is enabled.
+ </para>
+
+ <para>
The parameter list enclosed within parentheses must always be
present. If there are no parameters, an empty parameter list of
<literal>()</literal> should be used. Each parameter is an
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r970 - in trunk: . refman-5.0 refman-5.1 | paul | 21 Jan |