Author: paul
Date: 2007-07-30 22:11:54 +0200 (Mon, 30 Jul 2007)
New Revision: 7274
Log:
r28038@polar: paul | 2007-07-30 14:16:50 -0500
Document bug#22902: SYSDATE() precludes use of indexes.
Modified:
trunk/refman-5.0/functions-core.xml
trunk/refman-5.0/installing-cs.xml
trunk/refman-5.1/functions-core.xml
trunk/refman-5.2/functions-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:28037
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:23143
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18941
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:28038
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:23143
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18941
Modified: trunk/refman-5.0/functions-core.xml
===================================================================
--- trunk/refman-5.0/functions-core.xml 2007-07-30 20:11:10 UTC (rev 7273)
+++ trunk/refman-5.0/functions-core.xml 2007-07-30 20:11:54 UTC (rev 7274)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 739 bytes
@@ -9394,7 +9394,9 @@
can start the server with the
<option>--sysdate-is-now</option> option to cause
<literal>SYSDATE()</literal> to be an alias for
- <literal>NOW()</literal>.
+ <literal>NOW()</literal>. The non-deterministic nature of
+ <literal>SYSDATE()</literal> also means that indexes cannot be
+ used for evaluating expressions that refer to it.
</para>
<remark role="help-description-end"/>
Modified: trunk/refman-5.0/installing-cs.xml
===================================================================
--- trunk/refman-5.0/installing-cs.xml 2007-07-30 20:11:10 UTC (rev 7273)
+++ trunk/refman-5.0/installing-cs.xml 2007-07-30 20:11:54 UTC (rev 7274)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 4; 1185 bytes
@@ -12592,10 +12592,10 @@
<literal>SYSDATE()</literal> return the same value (the time
at which the statement in which the function occurs begins
executing). As of MySQL 5.0.13, <literal>SYSDATE()</literal>
- returns the time at which it it executes, which can differ
- from the value returned by <literal>NOW()</literal>. For
- information about the implications for binary logging and
- replication, see the description for
+ returns the time at which it executes, which can differ from
+ the value returned by <literal>NOW()</literal>. For
+ information about the implications for binary logging,
+ replication, and use of indexes, see the description for
<literal>SYSDATE()</literal> in
<xref linkend="date-and-time-functions"/> and for
<literal>SET TIMESTAMP</literal> in
Modified: trunk/refman-5.1/functions-core.xml
===================================================================
--- trunk/refman-5.1/functions-core.xml 2007-07-30 20:11:10 UTC (rev 7273)
+++ trunk/refman-5.1/functions-core.xml 2007-07-30 20:11:54 UTC (rev 7274)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 747 bytes
@@ -9357,7 +9357,9 @@
logging, or start the server with the
<option>--sysdate-is-now</option> option to cause
<literal>SYSDATE()</literal> to be an alias for
- <literal>NOW()</literal>.
+ <literal>NOW()</literal>. The non-deterministic nature of
+ <literal>SYSDATE()</literal> also means that indexes cannot be
+ used for evaluating expressions that refer to it.
</para>
<remark role="help-description-end"/>
Modified: trunk/refman-5.2/functions-core.xml
===================================================================
--- trunk/refman-5.2/functions-core.xml 2007-07-30 20:11:10 UTC (rev 7273)
+++ trunk/refman-5.2/functions-core.xml 2007-07-30 20:11:54 UTC (rev 7274)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 747 bytes
@@ -9357,7 +9357,9 @@
logging, or start the server with the
<option>--sysdate-is-now</option> option to cause
<literal>SYSDATE()</literal> to be an alias for
- <literal>NOW()</literal>.
+ <literal>NOW()</literal>. The non-deterministic nature of
+ <literal>SYSDATE()</literal> also means that indexes cannot be
+ used for evaluating expressions that refer to it.
</para>
<remark role="help-description-end"/>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7274 - in trunk: . refman-5.0 refman-5.1 refman-5.2 | paul | 30 Jul |
