Below is the list of changes that have just been committed into a local
mysqldoc repository of paul. When paul does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Install...urce_tree.html

ChangeSet
1.3445 05/08/31 14:09:08 paul (AT) kite-hub (DOT) kitebird.com +4 -0
All aggregate functions indicate the return
value when there are no matching rows.

refman/functions.xml
1.40 05/08/31 14:09:07 paul (AT) kite-hub (DOT) kitebird.com +62 -1
All aggregate functions indicate the return
value when there are no matching rows.

refman-5.1/functions.xml
1.20 05/08/31 14:09:07 paul (AT) kite-hub (DOT) kitebird.com +62 -1
Sync.

refman-5.0/functions.xml
1.34 05/08/31 14:09:07 paul (AT) kite-hub (DOT) kitebird.com +62 -1
Sync.

refman-4.1/functions.xml
1.56 05/08/31 14:09:07 paul (AT) kite-hub (DOT) kitebird.com +42 -1
Sync.

# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: paul
# Host: kite-hub.kitebird.com
# Root: /src/extern/MySQL/bk/mysqldoc

--- 1.19/refman-5.1/functions.xml 2005-08-30 15:45:59 -05:00
+++ 1.20/refman-5.1/functions.xml 2005-08-31 14:09:07 -05:00
@@ -12677,7 +12677,13 @@
</indexterm>

<para>
- If you use a group function in a statement containing no
+ This section describes group (aggregate) functions that operate
+ on sets of values. Unless otherwise stated, group functions
+ ignore <literal>NULL</literal> values.
+ </para>
+
+ <para>
+ If you use an group function in a statement containing no
<literal>GROUP BY</literal> clause, it is equivalent to grouping
on all rows.
</para>
@@ -12714,6 +12720,11 @@
<replaceable>expr</replaceable>.
</para>

+ <para>
+ <literal>AVG()</literal> returns <literal>NULL</literal> if
+ there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -12837,6 +12848,11 @@
statement.
</para>

+ <para>
+ <literal>COUNT()</literal> returns <literal>0</literal> if
+ there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -12904,6 +12920,11 @@
non-<literal>NULL</literal> values.
</para>

+ <para>
+ <literal>COUNT(DISTINCT)</literal> returns
+ <literal>0</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13079,6 +13100,11 @@
<literal>DISTINCT</literal>.
</para>

+ <para>
+ <literal>MIN()</literal> and <literal>MAX()</literal> return
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13142,6 +13168,11 @@
<literal>STDDEV_POP()</literal> can be used instead.
</para>

+ <para>
+ These functions return <literal>NULL</literal> if there were
+ no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13169,6 +13200,11 @@
which are equivalent but not standard SQL.
</para>

+ <para>
+ <literal>STDDEV_POP()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13194,6 +13230,11 @@
MySQL 5.0.3.
</para>

+ <para>
+ <literal>STDDEV_SAMP()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13231,6 +13272,11 @@
values of <replaceable>expr</replaceable>.
</para>

+ <para>
+ <literal>SUM()</literal> returns <literal>NULL</literal> if
+ there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13259,6 +13305,11 @@
not standard SQL.
</para>

+ <para>
+ <literal>VAR_POP()</literal> returns <literal>NULL</literal>
+ if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13284,6 +13335,11 @@
MySQL 5.0.3.
</para>

+ <para>
+ <literal>VAR_SAMP()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13307,6 +13363,11 @@
<replaceable>expr</replaceable>. This is an extension to
standard SQL. As of MySQL 5.0.3, the standard SQL function
<literal>VAR_POP()</literal> can be used instead.
+ </para>
+
+ <para>
+ <literal>VARIANCE()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
</para>

<remark>

--- 1.55/refman-4.1/functions.xml 2005-08-30 15:45:59 -05:00
+++ 1.56/refman-4.1/functions.xml 2005-08-31 14:09:07 -05:00
@@ -12517,7 +12517,13 @@
</indexterm>

<para>
- If you use a group function in a statement containing no
+ This section describes group (aggregate) functions that operate
+ on sets of values. Unless otherwise stated, group functions
+ ignore <literal>NULL</literal> values.
+ </para>
+
+ <para>
+ If you use an group function in a statement containing no
<literal>GROUP BY</literal> clause, it is equivalent to grouping
on all rows.
</para>
@@ -12538,6 +12544,11 @@
<literal><replaceable>expr</replaceable></literal>.
</para>

+ <para>
+ <literal>AVG()</literal> returns <literal>NULL</literal> if
+ there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -12667,6 +12678,11 @@
statement.
</para>

+ <para>
+ <literal>COUNT()</literal> returns <literal>0</literal> if
+ there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -12735,6 +12751,11 @@
non-<literal>NULL</literal> values.
</para>

+ <para>
+ <literal>COUNT(DISTINCT)</literal> returns
+ <literal>0</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -12910,6 +12931,11 @@
See <xref linkend="mysql-indexes"/>.
</para>

+ <para>
+ <literal>MIN()</literal> and <literal>MAX()</literal> return
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -12968,6 +12994,11 @@
function is provided for Oracle compatibility.
</para>

+ <para>
+ These functions return <literal>NULL</literal> if there were
+ no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -12992,6 +13023,11 @@
<literal>NULL</literal>.
</para>

+ <para>
+ <literal>SUM()</literal> returns <literal>NULL</literal> if
+ there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13010,6 +13046,11 @@
Returns the population standard variance of
<replaceable>expr</replaceable>. This is an extension to
standard SQL, available in MySQL 4.1 or later.
+ </para>
+
+ <para>
+ <literal>VARIANCE()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
</para>

<remark>

--- 1.39/refman/functions.xml 2005-08-30 15:45:59 -05:00
+++ 1.40/refman/functions.xml 2005-08-31 14:09:07 -05:00
@@ -11700,7 +11700,13 @@
</indexterm>

<para>
- If you use a group function in a statement containing no
+ This section describes group (aggregate) functions that operate
+ on sets of values. Unless otherwise stated, group functions
+ ignore <literal>NULL</literal> values.
+ </para>
+
+ <para>
+ If you use an group function in a statement containing no
<literal>GROUP BY</literal> clause, it is equivalent to grouping
on all rows.
</para>
@@ -11735,6 +11741,11 @@
<replaceable>expr</replaceable>.
</para>

+ <para>
+ <literal>AVG()</literal> returns <literal>NULL</literal> if
+ there were no matching rows.
+ </para>
+
<!-- end_description_for_help_topic -->

<!-- example_for_help_topic AVG -->
@@ -11846,6 +11857,11 @@
statement.
</para>

+ <para>
+ <literal>COUNT()</literal> returns <literal>0</literal> if
+ there were no matching rows.
+ </para>
+
<!-- end_description_for_help_topic -->

<!-- example_for_help_topic COUNT -->
@@ -11908,6 +11924,11 @@
non-<literal>NULL</literal> values.
</para>

+ <para>
+ <literal>COUNT(DISTINCT)</literal> returns
+ <literal>0</literal> if there were no matching rows.
+ </para>
+
<!-- end_description_for_help_topic -->

<!-- example_for_help_topic COUNT DISTINCT -->
@@ -12090,6 +12111,11 @@
<literal>DISTINCT</literal>.
</para>

+ <para>
+ <literal>MIN()</literal> and <literal>MAX()</literal> return
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<!-- end_description_for_help_topic -->

<!-- example_for_help_topic MIN MAX -->
@@ -12146,6 +12172,11 @@
<literal>STDDEV_POP()</literal> can be used instead.
</para>

+ <para>
+ These functions return <literal>NULL</literal> if there were
+ no matching rows.
+ </para>
+
<!-- end_description_for_help_topic -->

<!-- description_for_help_topic STDDEV_POP -->
@@ -12169,6 +12200,11 @@
which are equivalent but not standard SQL.
</para>

+ <para>
+ <literal>STDDEV_POP()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<!-- end_description_for_help_topic -->

<!-- description_for_help_topic STDDEV_SAMP -->
@@ -12190,6 +12226,11 @@
MySQL 5.0.3.
</para>

+ <para>
+ <literal>STDDEV_SAMP()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<!-- end_description_for_help_topic -->

<!-- description_for_help_topic SUM DISTINCT -->
@@ -12223,6 +12264,11 @@
distinct values of <replaceable>expr</replaceable>.
</para>

+ <para>
+ <literal>SUM()</literal> returns <literal>NULL</literal> if
+ there were no matching rows.
+ </para>
+
<!-- end_description_for_help_topic -->

<!-- description_for_help_topic VAR_POP -->
@@ -12247,6 +12293,11 @@
standard SQL.
</para>

+ <para>
+ <literal>VAR_POP()</literal> returns <literal>NULL</literal>
+ if there were no matching rows.
+ </para>
+
<!-- end_description_for_help_topic -->

<!-- description_for_help_topic VAR_SAMP -->
@@ -12268,6 +12319,11 @@
MySQL 5.0.3.
</para>

+ <para>
+ <literal>VAR_SAMP()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<!-- end_description_for_help_topic -->

<!-- description_for_help_topic VARIANCE -->
@@ -12288,6 +12344,11 @@
standard SQL, available in MySQL 4.1 or later. As of MySQL
5.0.3, the standard SQL function
<literal>VAR_POP()</literal> can be used instead.
+ </para>
+
+ <para>
+ <literal>VARIANCE()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
</para>

<!-- end_description_for_help_topic -->

--- 1.33/refman-5.0/functions.xml 2005-08-30 15:45:59 -05:00
+++ 1.34/refman-5.0/functions.xml 2005-08-31 14:09:07 -05:00
@@ -12679,7 +12679,13 @@
</indexterm>

<para>
- If you use a group function in a statement containing no
+ This section describes group (aggregate) functions that operate
+ on sets of values. Unless otherwise stated, group functions
+ ignore <literal>NULL</literal> values.
+ </para>
+
+ <para>
+ If you use an group function in a statement containing no
<literal>GROUP BY</literal> clause, it is equivalent to grouping
on all rows.
</para>
@@ -12716,6 +12722,11 @@
<replaceable>expr</replaceable>.
</para>

+ <para>
+ <literal>AVG()</literal> returns <literal>NULL</literal> if
+ there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -12839,6 +12850,11 @@
statement.
</para>

+ <para>
+ <literal>COUNT()</literal> returns <literal>0</literal> if
+ there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -12906,6 +12922,11 @@
non-<literal>NULL</literal> values.
</para>

+ <para>
+ <literal>COUNT(DISTINCT)</literal> returns
+ <literal>0</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13079,6 +13100,11 @@
<literal>DISTINCT</literal>.
</para>

+ <para>
+ <literal>MIN()</literal> and <literal>MAX()</literal> return
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13140,6 +13166,11 @@
<literal>STDDEV_POP()</literal> can be used instead.
</para>

+ <para>
+ These functions return <literal>NULL</literal> if there were
+ no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13167,6 +13198,11 @@
which are equivalent but not standard SQL.
</para>

+ <para>
+ <literal>STDDEV_POP()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13192,6 +13228,11 @@
MySQL 5.0.3.
</para>

+ <para>
+ <literal>STDDEV_SAMP()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13227,6 +13268,11 @@
values of <replaceable>expr</replaceable>.
</para>

+ <para>
+ <literal>SUM()</literal> returns <literal>NULL</literal> if
+ there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13255,6 +13301,11 @@
not standard SQL.
</para>

+ <para>
+ <literal>VAR_POP()</literal> returns <literal>NULL</literal>
+ if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13280,6 +13331,11 @@
MySQL 5.0.3.
</para>

+ <para>
+ <literal>VAR_SAMP()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
+ </para>
+
<remark>
end_description_for_help_topic
</remark>
@@ -13303,6 +13359,11 @@
<replaceable>expr</replaceable>. This is an extension to
standard SQL. As of MySQL 5.0.3, the standard SQL function
<literal>VAR_POP()</literal> can be used instead.
+ </para>
+
+ <para>
+ <literal>VARIANCE()</literal> returns
+ <literal>NULL</literal> if there were no matching rows.
</para>

<remark>

--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...ie.nctu.edu.tw