Author: paul
Date: 2008-11-17 22:13:28 +0100 (Mon, 17 Nov 2008)
New Revision: 12503
Log:
r35779@frost: paul | 2008-11-17 14:57:42 -0500
Split SHOW FUNCTION|PROCEDURE CODE into separate sections,
add auto-link markup
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/dynamic-docs/changelog/mysqld.xml
trunk/refman-5.0/sql-syntax-server-administration.xml
trunk/refman-5.1-maria/sql-syntax-server-administration.xml
trunk/refman-5.1/sql-syntax-server-administration.xml
trunk/refman-6.0/sql-syntax-server-administration.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:39854
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:35776
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:34365
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:39854
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:35779
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:34365
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-11-17 20:39:42 UTC (rev 12502)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-11-17 21:13:28 UTC (rev 12503)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 5; 1101 bytes
@@ -28555,11 +28555,12 @@
<message>
<para>
- The <literal>SHOW FUNCTION CODE</literal> and <literal>SHOW
- PROCEDURE CODE</literal> statements are not present in non-debug
- builds, but attempting to use them resulted in a <quote>syntax
- error</quote> message. Now the error message indicates that the
- statements are disabled and that you must use a debug build.
+ The <literal role="stmt">SHOW FUNCTION CODE</literal> and
+ <literal role="stmt">SHOW PROCEDURE CODE</literal> statements
+ are not present in non-debug builds, but attempting to use them
+ resulted in a <quote>syntax error</quote> message. Now the error
+ message indicates that the statements are disabled and that you
+ must use a debug build.
</para>
</message>
Modified: trunk/dynamic-docs/changelog/mysqld.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld.xml 2008-11-17 20:39:42 UTC (rev 12502)
+++ trunk/dynamic-docs/changelog/mysqld.xml 2008-11-17 21:13:28 UTC (rev 12503)
Changed blocks: 2, Lines Added: 6, Lines Deleted: 6; 1174 bytes
@@ -27215,10 +27215,10 @@
<message>
<para>
- Added the <literal>SHOW FUNCTION CODE</literal> and
- <literal>SHOW PROCEDURE CODE</literal> statements (available
- only for servers that have been built with debugging support).
- See <xref linkend="show-procedure-code"/>.
+ Added the <literal role="stmt">SHOW FUNCTION CODE</literal> and
+ <literal role="stmt">SHOW PROCEDURE CODE</literal> statements
+ (available only for servers that have been built with debugging
+ support). See <xref linkend="show-procedure-code"/>.
</para>
</message>
@@ -123419,8 +123419,8 @@
<message>
<para>
- A possible buffer overflow in <literal>SHOW PROCEDURE
- CODE</literal> was removed.
+ A possible buffer overflow in <literal role="stmt">SHOW
+ PROCEDURE CODE</literal> was removed.
</para>
</message>
Modified: trunk/refman-5.0/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-5.0/sql-syntax-server-administration.xml 2008-11-17 20:39:42 UTC (rev 12502)
+++ trunk/refman-5.0/sql-syntax-server-administration.xml 2008-11-17 21:13:28 UTC (rev 12503)
Changed blocks: 3, Lines Added: 48, Lines Deleted: 15; 3644 bytes
@@ -5159,6 +5159,37 @@
</section>
+ <section id="show-function-code">
+
+ <title><literal role="stmt">SHOW FUNCTION CODE</literal> Syntax</title>
+
+ <indexterm>
+ <primary>SHOW FUNCTION CODE</primary>
+ </indexterm>
+
+ <remark role="help-topic" condition="SHOW FUNCTION CODE"/>
+
+ <remark role="help-keywords">
+ SHOW FUNCTION CODE
+ </remark>
+
+ <remark role="help-syntax"/>
+
+<programlisting>
+SHOW FUNCTION CODE <replaceable>sp_name</replaceable>
+</programlisting>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ This statement is similar to <literal role="stmt">SHOW PROCEDURE
+ CODE</literal> but for stored functions. See
+ <xref linkend="show-procedure-code"/>. <literal role="stmt">SHOW
+ FUNCTION CODE</literal> was added in MySQL 5.0.17.
+ </para>
+
+ </section>
+
<section id="show-grants">
<title><literal role="stmt">SHOW GRANTS</literal> Syntax</title>
@@ -5940,41 +5971,42 @@
<section id="show-procedure-code">
- <title><literal>SHOW PROCEDURE CODE</literal> and <literal>SHOW FUNCTION
- CODE</literal> Syntax</title>
+ <title><literal role="stmt">SHOW PROCEDURE CODE</literal> Syntax</title>
<indexterm>
<primary>SHOW PROCEDURE CODE</primary>
</indexterm>
- <indexterm>
- <primary>SHOW FUNCTION CODE</primary>
- </indexterm>
-
<remark role="help-topic" condition="SHOW PROCEDURE CODE"/>
<remark role="help-keywords">
- SHOW PROCEDURE FUNCTION CODE
+ SHOW PROCEDURE CODE
</remark>
<remark role="help-syntax"/>
<programlisting>
-SHOW {PROCEDURE | FUNCTION} CODE <replaceable>sp_name</replaceable>
+SHOW PROCEDURE CODE <replaceable>sp_name</replaceable>
</programlisting>
<remark role="help-description-begin"/>
<para>
- These statements are MySQL extensions that are available only
- for servers that have been built with debugging support. They
- display a representation of the internal implementation of the
- named routine. The statements require that you be the owner of
- the routine or have <literal role="stmt">SELECT</literal> access
- to the <literal>mysql.proc</literal> table.
+ This statement is a MySQL extensions that is available only for
+ servers that have been built with debugging support. It displays
+ a representation of the internal implementation of the named
+ stored procedure. A similar statement, <literal role="stmt">SHOW
+ FUNCTION CODE</literal>, displays information about stored
+ functions (see <xref linkend="show-function-code"/>).
</para>
<para>
+ Both statements require that you be the owner of the routine or
+ have <literal role="stmt">SELECT</literal> access to the
+ <literal>mysql.proc</literal> table.
+ </para>
+
+ <para>
If the named routine is available, each statement produces a
result set. Each row in the result set corresponds to one
<quote>instruction</quote> in the routine. The first column is
@@ -6028,7 +6060,8 @@
</para>
<para>
- These statements were added in MySQL 5.0.17.
+ <literal role="stmt">SHOW PROCEDURE CODE</literal> was added in
+ MySQL 5.0.17.
</para>
</section>
Modified: trunk/refman-5.1/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-5.1/sql-syntax-server-administration.xml 2008-11-17 20:39:42 UTC (rev 12502)
+++ trunk/refman-5.1/sql-syntax-server-administration.xml 2008-11-17 21:13:28 UTC (rev 12503)
Changed blocks: 2, Lines Added: 45, Lines Deleted: 14; 3333 bytes
@@ -6168,6 +6168,36 @@
</section>
+ <section id="show-function-code">
+
+ <title><literal role="stmt">SHOW FUNCTION CODE</literal> Syntax</title>
+
+ <indexterm>
+ <primary>SHOW FUNCTION CODE</primary>
+ </indexterm>
+
+ <remark role="help-topic" condition="SHOW FUNCTION CODE"/>
+
+ <remark role="help-keywords">
+ SHOW FUNCTION CODE
+ </remark>
+
+ <remark role="help-syntax"/>
+
+<programlisting>
+SHOW FUNCTION CODE <replaceable>sp_name</replaceable>
+</programlisting>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ This statement is similar to <literal role="stmt">SHOW PROCEDURE
+ CODE</literal> but for stored functions. See
+ <xref linkend="show-procedure-code"/>.
+ </para>
+
+ </section>
+
<section id="show-grants">
<title><literal role="stmt">SHOW GRANTS</literal> Syntax</title>
@@ -6797,41 +6827,42 @@
<section id="show-procedure-code">
- <title><literal>SHOW PROCEDURE CODE</literal> and <literal>SHOW FUNCTION
- CODE</literal> Syntax</title>
+ <title><literal role="stmt">SHOW PROCEDURE CODE</literal> Syntax</title>
<indexterm>
<primary>SHOW PROCEDURE CODE</primary>
</indexterm>
- <indexterm>
- <primary>SHOW FUNCTION CODE</primary>
- </indexterm>
-
<remark role="help-topic" condition="SHOW PROCEDURE CODE"/>
<remark role="help-keywords">
- SHOW PROCEDURE FUNCTION CODE
+ SHOW PROCEDURE CODE
</remark>
<remark role="help-syntax"/>
<programlisting>
-SHOW {PROCEDURE | FUNCTION} CODE <replaceable>sp_name</replaceable>
+SHOW PROCEDURE CODE <replaceable>sp_name</replaceable>
</programlisting>
<remark role="help-description-begin"/>
<para>
- These statements are MySQL extensions that are available only
- for servers that have been built with debugging support. They
- display a representation of the internal implementation of the
- named routine. The statements require that you be the owner of
- the routine or have <literal role="stmt">SELECT</literal> access
- to the <literal>mysql.proc</literal> table.
+ This statement is a MySQL extensions that is available only for
+ servers that have been built with debugging support. It displays
+ a representation of the internal implementation of the named
+ stored procedure. A similar statement, <literal role="stmt">SHOW
+ FUNCTION CODE</literal>, displays information about stored
+ functions (see <xref linkend="show-function-code"/>).
</para>
<para>
+ Both statements require that you be the owner of the routine or
+ have <literal role="stmt">SELECT</literal> access to the
+ <literal>mysql.proc</literal> table.
+ </para>
+
+ <para>
If the named routine is available, each statement produces a
result set. Each row in the result set corresponds to one
<quote>instruction</quote> in the routine. The first column is
Modified: trunk/refman-5.1-maria/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-5.1-maria/sql-syntax-server-administration.xml 2008-11-17 20:39:42 UTC (rev 12502)
+++ trunk/refman-5.1-maria/sql-syntax-server-administration.xml 2008-11-17 21:13:28 UTC (rev 12503)
Changed blocks: 2, Lines Added: 45, Lines Deleted: 14; 3351 bytes
@@ -6249,6 +6249,36 @@
</section>
+ <section id="show-function-code">
+
+ <title><literal role="stmt">SHOW FUNCTION CODE</literal> Syntax</title>
+
+ <indexterm>
+ <primary>SHOW FUNCTION CODE</primary>
+ </indexterm>
+
+ <remark role="help-topic" condition="SHOW FUNCTION CODE"/>
+
+ <remark role="help-keywords">
+ SHOW FUNCTION CODE
+ </remark>
+
+ <remark role="help-syntax"/>
+
+<programlisting>
+SHOW FUNCTION CODE <replaceable>sp_name</replaceable>
+</programlisting>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ This statement is similar to <literal role="stmt">SHOW PROCEDURE
+ CODE</literal> but for stored functions. See
+ <xref linkend="show-procedure-code"/>.
+ </para>
+
+ </section>
+
<section id="show-grants">
<title><literal role="stmt">SHOW GRANTS</literal> Syntax</title>
@@ -6878,41 +6908,42 @@
<section id="show-procedure-code">
- <title><literal>SHOW PROCEDURE CODE</literal> and <literal>SHOW FUNCTION
- CODE</literal> Syntax</title>
+ <title><literal role="stmt">SHOW PROCEDURE CODE</literal> Syntax</title>
<indexterm>
<primary>SHOW PROCEDURE CODE</primary>
</indexterm>
- <indexterm>
- <primary>SHOW FUNCTION CODE</primary>
- </indexterm>
-
<remark role="help-topic" condition="SHOW PROCEDURE CODE"/>
<remark role="help-keywords">
- SHOW PROCEDURE FUNCTION CODE
+ SHOW PROCEDURE CODE
</remark>
<remark role="help-syntax"/>
<programlisting>
-SHOW {PROCEDURE | FUNCTION} CODE <replaceable>sp_name</replaceable>
+SHOW PROCEDURE CODE <replaceable>sp_name</replaceable>
</programlisting>
<remark role="help-description-begin"/>
<para>
- These statements are MySQL extensions that are available only
- for servers that have been built with debugging support. They
- display a representation of the internal implementation of the
- named routine. The statements require that you be the owner of
- the routine or have <literal role="stmt">SELECT</literal> access
- to the <literal>mysql.proc</literal> table.
+ This statement is a MySQL extensions that is available only for
+ servers that have been built with debugging support. It displays
+ a representation of the internal implementation of the named
+ stored procedure. A similar statement, <literal role="stmt">SHOW
+ FUNCTION CODE</literal>, displays information about stored
+ functions (see <xref linkend="show-function-code"/>).
</para>
<para>
+ Both statements require that you be the owner of the routine or
+ have <literal role="stmt">SELECT</literal> access to the
+ <literal>mysql.proc</literal> table.
+ </para>
+
+ <para>
If the named routine is available, each statement produces a
result set. Each row in the result set corresponds to one
<quote>instruction</quote> in the routine. The first column is
Modified: trunk/refman-6.0/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-6.0/sql-syntax-server-administration.xml 2008-11-17 20:39:42 UTC (rev 12502)
+++ trunk/refman-6.0/sql-syntax-server-administration.xml 2008-11-17 21:13:28 UTC (rev 12503)
Changed blocks: 2, Lines Added: 45, Lines Deleted: 14; 3333 bytes
@@ -6017,6 +6017,36 @@
</section>
+ <section id="show-function-code">
+
+ <title><literal role="stmt">SHOW FUNCTION CODE</literal> Syntax</title>
+
+ <indexterm>
+ <primary>SHOW FUNCTION CODE</primary>
+ </indexterm>
+
+ <remark role="help-topic" condition="SHOW FUNCTION CODE"/>
+
+ <remark role="help-keywords">
+ SHOW FUNCTION CODE
+ </remark>
+
+ <remark role="help-syntax"/>
+
+<programlisting>
+SHOW FUNCTION CODE <replaceable>sp_name</replaceable>
+</programlisting>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ This statement is similar to <literal role="stmt">SHOW PROCEDURE
+ CODE</literal> but for stored functions. See
+ <xref linkend="show-procedure-code"/>.
+ </para>
+
+ </section>
+
<section id="show-grants">
<title><literal role="stmt">SHOW GRANTS</literal> Syntax</title>
@@ -6619,41 +6649,42 @@
<section id="show-procedure-code">
- <title><literal>SHOW PROCEDURE CODE</literal> and <literal>SHOW FUNCTION
- CODE</literal> Syntax</title>
+ <title><literal role="stmt">SHOW PROCEDURE CODE</literal> Syntax</title>
<indexterm>
<primary>SHOW PROCEDURE CODE</primary>
</indexterm>
- <indexterm>
- <primary>SHOW FUNCTION CODE</primary>
- </indexterm>
-
<remark role="help-topic" condition="SHOW PROCEDURE CODE"/>
<remark role="help-keywords">
- SHOW PROCEDURE FUNCTION CODE
+ SHOW PROCEDURE CODE
</remark>
<remark role="help-syntax"/>
<programlisting>
-SHOW {PROCEDURE | FUNCTION} CODE <replaceable>sp_name</replaceable>
+SHOW PROCEDURE CODE <replaceable>sp_name</replaceable>
</programlisting>
<remark role="help-description-begin"/>
<para>
- These statements are MySQL extensions that are available only
- for servers that have been built with debugging support. They
- display a representation of the internal implementation of the
- named routine. The statements require that you be the owner of
- the routine or have <literal role="stmt">SELECT</literal> access
- to the <literal>mysql.proc</literal> table.
+ This statement is a MySQL extensions that is available only for
+ servers that have been built with debugging support. It displays
+ a representation of the internal implementation of the named
+ stored procedure. A similar statement, <literal role="stmt">SHOW
+ FUNCTION CODE</literal>, displays information about stored
+ functions (see <xref linkend="show-function-code"/>).
</para>
<para>
+ Both statements require that you be the owner of the routine or
+ have <literal role="stmt">SELECT</literal> access to the
+ <literal>mysql.proc</literal> table.
+ </para>
+
+ <para>
If the named routine is available, each statement produces a
result set. Each row in the result set corresponds to one
<quote>instruction</quote> in the routine. The first column is
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r12503 - in trunk: . dynamic-docs/changelog refman-5.0 refman-5.1 refman-5.1-maria refman-6.0 | paul.dubois | 17 Nov |
