Author: paul
Date: 2007-11-15 21:40:51 +0100 (Thu, 15 Nov 2007)
New Revision: 8749
Log:
r32921@polar: paul | 2007-11-15 13:27:58 -0600
Add markup.
Modified:
trunk/dynamic-docs/opsfunctions/opfunctions.xml
trunk/refman-5.0/functions-core.xml
trunk/refman-5.1/functions-core.xml
trunk/refman-6.0/functions-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:32920
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:27052
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:22167
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:32921
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:27052
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:22167
Modified: trunk/dynamic-docs/opsfunctions/opfunctions.xml
===================================================================
--- trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-11-15 20:40:35 UTC (rev 8748)
+++ trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-11-15 20:40:51 UTC (rev 8749)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 774 bytes
@@ -3914,6 +3914,16 @@
<manual version="6.0"/>
</versions>
</opfunction>
+
+ <opfunction type="operator" id="is-not" class="string-comparison">
+ <display>IS NOT</display>
+ <description lang="en">Test a value against a boolean</description>
+ <versions>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ <manual version="6.0"/>
+ </versions>
+ </opfunction>
<opfunction type="operator" id="and" class="logical">
<display>AND</display>
Modified: trunk/refman-5.0/functions-core.xml
===================================================================
--- trunk/refman-5.0/functions-core.xml 2007-11-15 20:40:35 UTC (rev 8748)
+++ trunk/refman-5.0/functions-core.xml 2007-11-15 20:40:51 UTC (rev 8749)
Changed blocks: 3, Lines Added: 65, Lines Deleted: 8; 3371 bytes
@@ -746,6 +746,10 @@
<listitem>
<remark role="help-topic" condition="IS"/>
+ <remark role="help-keywords">
+ IS
+ </remark>
+
<remark role="help-syntax-begin"/>
<para id="operator_is">
@@ -768,14 +772,69 @@
<primary>IS boolean_value</primary>
</indexterm>
+ <function role="sqlop" condition="operator_is">IS
+ <replaceable>boolean_value</replaceable></function>,
+ </para>
+
+ <remark role="help-syntax-end"/>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ Tests a value against a boolean value, where
+ <replaceable>boolean_value</replaceable> can be
+ <literal>TRUE</literal>, <literal>FALSE</literal>, or
+ <literal>UNKNOWN</literal>.
+ </para>
+
+ <remark role="help-description-end"/>
+
+ <remark role="help-example"/>
+
+<programlisting>
+mysql> <userinput>SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;</userinput>
+ -> 1, 1, 1
+ -> 1, 1, 0
+</programlisting>
+
+ <para>
+ <function role="sqlop" condition="operator_is">IS
+ <replaceable>boolean_value</replaceable></function> syntax
+ was added in MySQL 5.0.2.
+ </para>
+ </listitem>
+
+ <listitem>
+ <remark role="help-topic" condition="IS NOT"/>
+
+ <remark role="help-keywords">
+ IS NOT
+ </remark>
+
+ <remark role="help-syntax-begin"/>
+
+ <para id="operator_is-not">
<indexterm>
+ <primary>TRUE</primary>
+ <secondary>testing for</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>FALSE</primary>
+ <secondary>testing for</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>UNKNOWN</primary>
+ <secondary>testing for</secondary>
+ </indexterm>
+
+ <indexterm>
<primary>IS NOT boolean_value</primary>
</indexterm>
- <literal>IS
- <replaceable>boolean_value</replaceable></literal>,
- <literal>IS NOT
- <replaceable>boolean_value</replaceable></literal>
+ <function role="sqlop" condition="operator_is-not">IS NOT
+ <replaceable>boolean_value</replaceable></function>
</para>
<remark role="help-syntax-end"/>
@@ -794,15 +853,13 @@
<remark role="help-example"/>
<programlisting>
-mysql> <userinput>SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;</userinput>
- -> 1, 1, 1
mysql> <userinput>SELECT 1 IS NOT UNKNOWN, 0 IS NOT UNKNOWN, NULL IS NOT UNKNOWN;</userinput>
-> 1, 1, 0
</programlisting>
<para>
- <literal>IS [NOT]
- <replaceable>boolean_value</replaceable></literal> syntax
+ <function role="sqlop" condition="operator_is-not">IS NOT
+ <replaceable>boolean_value</replaceable></function> syntax
was added in MySQL 5.0.2.
</para>
</listitem>
Modified: trunk/refman-5.1/functions-core.xml
===================================================================
--- trunk/refman-5.1/functions-core.xml 2007-11-15 20:40:35 UTC (rev 8748)
+++ trunk/refman-5.1/functions-core.xml 2007-11-15 20:40:51 UTC (rev 8749)
Changed blocks: 3, Lines Added: 57, Lines Deleted: 6; 2827 bytes
@@ -745,6 +745,10 @@
<listitem>
<remark role="help-topic" condition="IS"/>
+ <remark role="help-keywords">
+ IS
+ </remark>
+
<remark role="help-syntax-begin"/>
<para id="operator_is">
@@ -767,14 +771,63 @@
<primary>IS boolean_value</primary>
</indexterm>
+ <function role="sqlop" condition="operator_is">IS
+ <replaceable>boolean_value</replaceable></function>,
+ </para>
+
+ <remark role="help-syntax-end"/>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ Tests a value against a boolean value, where
+ <replaceable>boolean_value</replaceable> can be
+ <literal>TRUE</literal>, <literal>FALSE</literal>, or
+ <literal>UNKNOWN</literal>.
+ </para>
+
+ <remark role="help-description-end"/>
+
+ <remark role="help-example"/>
+
+<programlisting>
+mysql> <userinput>SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;</userinput>
+ -> 1, 1, 1
+ -> 1, 1, 0
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <remark role="help-topic" condition="IS NOT"/>
+
+ <remark role="help-keywords">
+ IS NOT
+ </remark>
+
+ <remark role="help-syntax-begin"/>
+
+ <para id="operator_is-not">
<indexterm>
+ <primary>TRUE</primary>
+ <secondary>testing for</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>FALSE</primary>
+ <secondary>testing for</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>UNKNOWN</primary>
+ <secondary>testing for</secondary>
+ </indexterm>
+
+ <indexterm>
<primary>IS NOT boolean_value</primary>
</indexterm>
- <literal>IS
- <replaceable>boolean_value</replaceable></literal>,
- <literal>IS NOT
- <replaceable>boolean_value</replaceable></literal>
+ <function role="sqlop" condition="operator_is-not">IS NOT
+ <replaceable>boolean_value</replaceable></function>
</para>
<remark role="help-syntax-end"/>
@@ -793,8 +846,6 @@
<remark role="help-example"/>
<programlisting>
-mysql> <userinput>SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;</userinput>
- -> 1, 1, 1
mysql> <userinput>SELECT 1 IS NOT UNKNOWN, 0 IS NOT UNKNOWN, NULL IS NOT UNKNOWN;</userinput>
-> 1, 1, 0
</programlisting>
Modified: trunk/refman-6.0/functions-core.xml
===================================================================
--- trunk/refman-6.0/functions-core.xml 2007-11-15 20:40:35 UTC (rev 8748)
+++ trunk/refman-6.0/functions-core.xml 2007-11-15 20:40:51 UTC (rev 8749)
Changed blocks: 3, Lines Added: 57, Lines Deleted: 6; 2827 bytes
@@ -745,6 +745,10 @@
<listitem>
<remark role="help-topic" condition="IS"/>
+ <remark role="help-keywords">
+ IS
+ </remark>
+
<remark role="help-syntax-begin"/>
<para id="operator_is">
@@ -767,14 +771,63 @@
<primary>IS boolean_value</primary>
</indexterm>
+ <function role="sqlop" condition="operator_is">IS
+ <replaceable>boolean_value</replaceable></function>,
+ </para>
+
+ <remark role="help-syntax-end"/>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ Tests a value against a boolean value, where
+ <replaceable>boolean_value</replaceable> can be
+ <literal>TRUE</literal>, <literal>FALSE</literal>, or
+ <literal>UNKNOWN</literal>.
+ </para>
+
+ <remark role="help-description-end"/>
+
+ <remark role="help-example"/>
+
+<programlisting>
+mysql> <userinput>SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;</userinput>
+ -> 1, 1, 1
+ -> 1, 1, 0
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <remark role="help-topic" condition="IS NOT"/>
+
+ <remark role="help-keywords">
+ IS NOT
+ </remark>
+
+ <remark role="help-syntax-begin"/>
+
+ <para id="operator_is-not">
<indexterm>
+ <primary>TRUE</primary>
+ <secondary>testing for</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>FALSE</primary>
+ <secondary>testing for</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>UNKNOWN</primary>
+ <secondary>testing for</secondary>
+ </indexterm>
+
+ <indexterm>
<primary>IS NOT boolean_value</primary>
</indexterm>
- <literal>IS
- <replaceable>boolean_value</replaceable></literal>,
- <literal>IS NOT
- <replaceable>boolean_value</replaceable></literal>
+ <function role="sqlop" condition="operator_is-not">IS NOT
+ <replaceable>boolean_value</replaceable></function>
</para>
<remark role="help-syntax-end"/>
@@ -793,8 +846,6 @@
<remark role="help-example"/>
<programlisting>
-mysql> <userinput>SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;</userinput>
- -> 1, 1, 1
mysql> <userinput>SELECT 1 IS NOT UNKNOWN, 0 IS NOT UNKNOWN, NULL IS NOT UNKNOWN;</userinput>
-> 1, 1, 0
</programlisting>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r8749 - in trunk: . dynamic-docs/opsfunctions refman-5.0 refman-5.1 refman-6.0 | paul | 15 Nov |
