Author: paul
Date: 2008-05-23 17:30:03 +0200 (Fri, 23 May 2008)
New Revision: 10831
Log:
r31442@arctic: paul | 2008-05-23 10:29:00 -0500
Clarification for FOUND_ROWS() - reset for *successful* SELECTS, value
undefined except as described in manual. (Bug#36719)
Modified:
trunk/it/refman-5.1/functions-core.xml
trunk/pt/refman-5.1/functions-core.xml
trunk/refman-4.1/functions-core.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:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31651
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31428
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31651
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31442
Modified: trunk/it/refman-5.1/functions-core.xml
===================================================================
--- trunk/it/refman-5.1/functions-core.xml 2008-05-23 11:08:35 UTC (rev 10830)
+++ trunk/it/refman-5.1/functions-core.xml 2008-05-23 15:30:03 UTC (rev 10831)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 4; 1353 bytes
@@ -16169,10 +16169,10 @@
<para>
In the absence of the <literal>SQL_CALC_FOUND_ROWS</literal>
- option in the most recent <literal>SELECT</literal>
- statement, <function role="sql">FOUND_ROWS()</function>
- returns the number of rows in the result set returned by
- that statement.
+ option in the most recent successful
+ <literal>SELECT</literal> statement,
+ <function role="sql">FOUND_ROWS()</function> returns the
+ number of rows in the result set returned by that statement.
</para>
<para>
@@ -16266,6 +16266,14 @@
</itemizedlist>
+ <para>
+ Beyond the cases described here, the behavior of
+ <function role="sql">FOUND_ROWS()</function> is undefined
+ (for example, its value following a
+ <literal>SELECT</literal> statement that fails with an
+ error).
+ </para>
+
<important>
<para>
<function role="sql">FOUND_ROWS()</function> is not
Modified: trunk/pt/refman-5.1/functions-core.xml
===================================================================
--- trunk/pt/refman-5.1/functions-core.xml 2008-05-23 11:08:35 UTC (rev 10830)
+++ trunk/pt/refman-5.1/functions-core.xml 2008-05-23 15:30:03 UTC (rev 10831)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 4; 1353 bytes
@@ -16169,10 +16169,10 @@
<para>
In the absence of the <literal>SQL_CALC_FOUND_ROWS</literal>
- option in the most recent <literal>SELECT</literal>
- statement, <function role="sql">FOUND_ROWS()</function>
- returns the number of rows in the result set returned by
- that statement.
+ option in the most recent successful
+ <literal>SELECT</literal> statement,
+ <function role="sql">FOUND_ROWS()</function> returns the
+ number of rows in the result set returned by that statement.
</para>
<para>
@@ -16266,6 +16266,14 @@
</itemizedlist>
+ <para>
+ Beyond the cases described here, the behavior of
+ <function role="sql">FOUND_ROWS()</function> is undefined
+ (for example, its value following a
+ <literal>SELECT</literal> statement that fails with an
+ error).
+ </para>
+
<important>
<para>
<function role="sql">FOUND_ROWS()</function> is not
Modified: trunk/refman-4.1/functions-core.xml
===================================================================
--- trunk/refman-4.1/functions-core.xml 2008-05-23 11:08:35 UTC (rev 10830)
+++ trunk/refman-4.1/functions-core.xml 2008-05-23 15:30:03 UTC (rev 10831)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 4; 1416 bytes
@@ -14785,10 +14785,10 @@
<para>
In the absence of the <literal>SQL_CALC_FOUND_ROWS</literal>
- option in the most recent <literal>SELECT</literal>
- statement, <function role="sql">FOUND_ROWS()</function>
- returns the number of rows in the result set returned by
- that statement.
+ option in the most recent successful
+ <literal>SELECT</literal> statement,
+ <function role="sql">FOUND_ROWS()</function> returns the
+ number of rows in the result set returned by that statement.
</para>
<para>
@@ -14883,6 +14883,14 @@
</itemizedlist>
<para>
+ Beyond the cases described here, the behavior of
+ <function role="sql">FOUND_ROWS()</function> is undefined
+ (for example, its value following a
+ <literal>SELECT</literal> statement that fails with an
+ error).
+ </para>
+
+ <para>
<literal>SQL_CALC_FOUND_ROWS</literal> and
<function role="sql">FOUND_ROWS()</function> are available
starting at MySQL 4.0.0.
Modified: trunk/refman-5.0/functions-core.xml
===================================================================
--- trunk/refman-5.0/functions-core.xml 2008-05-23 11:08:35 UTC (rev 10830)
+++ trunk/refman-5.0/functions-core.xml 2008-05-23 15:30:03 UTC (rev 10831)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 4; 1344 bytes
@@ -14934,10 +14934,10 @@
<para>
In the absence of the <literal>SQL_CALC_FOUND_ROWS</literal>
- option in the most recent <literal>SELECT</literal>
- statement, <function role="sql">FOUND_ROWS()</function>
- returns the number of rows in the result set returned by
- that statement.
+ option in the most recent successful
+ <literal>SELECT</literal> statement,
+ <function role="sql">FOUND_ROWS()</function> returns the
+ number of rows in the result set returned by that statement.
</para>
<para>
@@ -15031,6 +15031,14 @@
</itemizedlist>
+ <para>
+ Beyond the cases described here, the behavior of
+ <function role="sql">FOUND_ROWS()</function> is undefined
+ (for example, its value following a
+ <literal>SELECT</literal> statement that fails with an
+ error).
+ </para>
+
<important>
<para>
<function role="sql">FOUND_ROWS()</function> is not
Modified: trunk/refman-5.1/functions-core.xml
===================================================================
--- trunk/refman-5.1/functions-core.xml 2008-05-23 11:08:35 UTC (rev 10830)
+++ trunk/refman-5.1/functions-core.xml 2008-05-23 15:30:03 UTC (rev 10831)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 4; 1344 bytes
@@ -16169,10 +16169,10 @@
<para>
In the absence of the <literal>SQL_CALC_FOUND_ROWS</literal>
- option in the most recent <literal>SELECT</literal>
- statement, <function role="sql">FOUND_ROWS()</function>
- returns the number of rows in the result set returned by
- that statement.
+ option in the most recent successful
+ <literal>SELECT</literal> statement,
+ <function role="sql">FOUND_ROWS()</function> returns the
+ number of rows in the result set returned by that statement.
</para>
<para>
@@ -16266,6 +16266,14 @@
</itemizedlist>
+ <para>
+ Beyond the cases described here, the behavior of
+ <function role="sql">FOUND_ROWS()</function> is undefined
+ (for example, its value following a
+ <literal>SELECT</literal> statement that fails with an
+ error).
+ </para>
+
<important>
<para>
<function role="sql">FOUND_ROWS()</function> is not
Modified: trunk/refman-6.0/functions-core.xml
===================================================================
--- trunk/refman-6.0/functions-core.xml 2008-05-23 11:08:35 UTC (rev 10830)
+++ trunk/refman-6.0/functions-core.xml 2008-05-23 15:30:03 UTC (rev 10831)
Changed blocks: 2, Lines Added: 21, Lines Deleted: 4; 1646 bytes
@@ -16631,10 +16631,10 @@
<para>
In the absence of the <literal>SQL_CALC_FOUND_ROWS</literal>
- option in the most recent <literal>SELECT</literal>
- statement, <function role="sql">FOUND_ROWS()</function>
- returns the number of rows in the result set returned by
- that statement.
+ option in the most recent successful
+ <literal>SELECT</literal> statement,
+ <function role="sql">FOUND_ROWS()</function> returns the
+ number of rows in the result set returned by that statement.
</para>
<para>
@@ -16727,6 +16727,23 @@
</listitem>
</itemizedlist>
+
+ <para>
+ Beyond the cases described here, the behavior of
+ <function role="sql">FOUND_ROWS()</function> is undefined
+ (for example, its value following a
+ <literal>SELECT</literal> statement that fails with an
+ error).
+ </para>
+
+ <important>
+ <para>
+ <function role="sql">FOUND_ROWS()</function> is not
+ replicated reliably using statement-based replication.
+ Starting with MySQL 6.0.4, this function is automatically
+ replicated using row-based replication.
+ </para>
+ </important>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10831 - in trunk: . it/refman-5.1 pt/refman-5.1 refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul | 23 May |
