| List: | Commits | « Previous MessageNext Message » | |
| From: | paul | Date: | November 14 2006 5:40am |
| Subject: | svn commit - mysqldoc@docsrva: r3926 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | ||
| View as plain text | |||
Author: paul Date: 2006-11-14 05:40:09 +0100 (Tue, 14 Nov 2006) New Revision: 3926 Log: r12071@frost: paul | 2006-11-13 22:38:57 -0600 Documenting bugfixes: Bug#17039 Bug#20100 Bug#20953 Bug#21811 Bug#22913 Bug#23411 Modified: trunk/refman-4.1/functions.xml trunk/refman-4.1/news-4.1.xml trunk/refman-5.0/functions.xml trunk/refman-5.0/releasenotes-es-5.0.xml trunk/refman-5.1/functions.xml trunk/refman-5.1/news-5.1.xml Property changes on: trunk ___________________________________________________________________ Name: svk:merge - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:15646 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:12012 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:11757 + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:15646 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:12071 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:11757 Modified: trunk/refman-4.1/functions.xml =================================================================== --- trunk/refman-4.1/functions.xml 2006-11-13 20:09:13 UTC (rev 3925) +++ trunk/refman-4.1/functions.xml 2006-11-14 04:40:09 UTC (rev 3926) Changed blocks: 3, Lines Added: 39, Lines Deleted: 1; 1802 bytes @@ -4668,6 +4668,39 @@ </para> </listitem> + <listitem> + <remark role="help-topic" condition="%"/> + + <remark role="help-keywords"> + MOD + </remark> + + <remark role="help-syntax-begin"/> + + <para> + <indexterm type="function"> + <primary>%</primary> + </indexterm> + + <literal><replaceable>N</replaceable> % + <replaceable>M</replaceable></literal> + </para> + + <remark role="help-syntax-end"/> + + <remark role="help-description-begin"/> + + <para> + Modulo operation. Returns the remainder of + <replaceable>N</replaceable> divided by + <replaceable>M</replaceable>. For more information, see the + description for the <literal>MOD()</literal> function in + <xref linkend="mathematical-functions"/>. + </para> + + <remark role="help-description-end"/> + </listitem> + </itemizedlist> </section> @@ -5336,7 +5369,7 @@ </listitem> <listitem> - <remark role="help-topic" condition="%"/> + <remark role="help-topic" condition="MOD"/> <remark role="help-keywords"> MOD @@ -5425,6 +5458,11 @@ mysql> <userinput>SELECT MOD(34.5,3);</userinput> -> 2 </programlisting> + + <para> + <literal>MOD(<replaceable>N</replaceable>,0)</literal> + returns <literal>NULL</literal>. + </para> </listitem> <listitem> Modified: trunk/refman-4.1/news-4.1.xml =================================================================== --- trunk/refman-4.1/news-4.1.xml 2006-11-13 20:09:13 UTC (rev 3925) +++ trunk/refman-4.1/news-4.1.xml 2006-11-14 04:40:09 UTC (rev 3926) Changed blocks: 1, Lines Added: 17, Lines Deleted: 0; 1027 bytes @@ -185,6 +185,23 @@ <listitem> <para> + <command>mysql</command> did not check for errors when + fetching data during result set printing. (Bug #22913) + </para> + </listitem> + + <listitem> + <para> + Adding a day, month, or year interval to a + <literal>DATE</literal> value produced a + <literal>DATE</literal>, but adding a week interval produced a + <literal>DATETIME</literal> value. Now all produce a + <literal>DATE</literal> value. (Bug #21811) + </para> + </listitem> + + <listitem> + <para> For not-yet-authenticated connections, the <literal>Time</literal> column in <literal>SHOW PROCESSLIST</literal> was a random value rather than Modified: trunk/refman-5.0/functions.xml =================================================================== --- trunk/refman-5.0/functions.xml 2006-11-13 20:09:13 UTC (rev 3925) +++ trunk/refman-5.0/functions.xml 2006-11-14 04:40:09 UTC (rev 3926) Changed blocks: 3, Lines Added: 39, Lines Deleted: 1; 1804 bytes @@ -4756,6 +4756,39 @@ </programlisting> </listitem> + <listitem> + <remark role="help-topic" condition="%"/> + + <remark role="help-keywords"> + MOD + </remark> + + <remark role="help-syntax-begin"/> + + <para> + <indexterm type="function"> + <primary>%</primary> + </indexterm> + + <literal><replaceable>N</replaceable> % + <replaceable>M</replaceable></literal> + </para> + + <remark role="help-syntax-end"/> + + <remark role="help-description-begin"/> + + <para> + Modulo operation. Returns the remainder of + <replaceable>N</replaceable> divided by + <replaceable>M</replaceable>. For more information, see the + description for the <literal>MOD()</literal> function in + <xref linkend="mathematical-functions"/>. + </para> + + <remark role="help-description-end"/> + </listitem> + </itemizedlist> </section> @@ -5439,7 +5472,7 @@ </listitem> <listitem> - <remark role="help-topic" condition="%"/> + <remark role="help-topic" condition="MOD"/> <remark role="help-keywords"> MOD @@ -5515,6 +5548,11 @@ mysql> <userinput>SELECT MOD(34.5,3);</userinput> -> 1.5 </programlisting> + + <para> + <literal>MOD(<replaceable>N</replaceable>,0)</literal> + returns <literal>NULL</literal>. + </para> </listitem> <listitem> Modified: trunk/refman-5.0/releasenotes-es-5.0.xml =================================================================== --- trunk/refman-5.0/releasenotes-es-5.0.xml 2006-11-13 20:09:13 UTC (rev 3925) +++ trunk/refman-5.0/releasenotes-es-5.0.xml 2006-11-14 04:40:09 UTC (rev 3926) Changed blocks: 2, Lines Added: 65, Lines Deleted: 0; 2953 bytes @@ -90,6 +90,16 @@ </para> </listitem> + <listitem> + <para> + <literal>mysql_upgrade</literal> now passes all the parameters + specified on the command line to both + <literal>mysqlcheck</literal> and <literal>mysql</literal> + using the <filename>upgrade_defaults</filename> file. (Bug + #20100) + </para> + </listitem> + </itemizedlist> <para> @@ -394,6 +404,61 @@ <listitem> <para> + <literal><replaceable>M</replaceable> % 0</literal> returns + <literal>NULL</literal>, but + (<literal><replaceable>M</replaceable> % 0) IS NULL</literal> + evaluated to false. (Bug #23411) + </para> + </listitem> + + <listitem> + <para> + Within a stored routine, a view definition cannot refer to + routine parameters or local variables. However, an error did + not occur until the routine was called. Now it occurs during + parsing of the routine creation statement. (Bug #20953) + </para> + + <para> + <emphasis role="bold">Note</emphasis>: A side effect of this + fix is that if you have already created such routines, and + error will occur if you execute <literal>SHOW CREATE + PROCEDURE</literal> or <literal>SHOW CREATE + FUNCTION</literal>. You should drop these routines because + they are erroneous. + </para> + </listitem> + + <listitem> + <para> + A client library crash was caused by executing a statement + such as <literal>SELECT * FROM t1 PROCEDURE + ANALYSE()</literal> using a server side cursor on a table + <literal>t1</literal> that does not have the same number of + columns as the output from <literal>PROCEDURE + ANALYSE()</literal>. (Bug #17039) + </para> + </listitem> + + <listitem> + <para> + <command>mysql</command> did not check for errors when + fetching data during result set printing. (Bug #22913) + </para> + </listitem> + + <listitem> + <para> + Adding a day, month, or year interval to a + <literal>DATE</literal> value produced a + <literal>DATE</literal>, but adding a week interval produced a + <literal>DATETIME</literal> value. Now all produce a + <literal>DATE</literal> value. (Bug #21811) + </para> + </listitem> + + <listitem> + <para> The column default value in the output from <literal>SHOW COLUMNS</literal> or <literal>SELECT FROM INFORMATION_SCHEMA.COLUMNS</literal> was truncated to 64 Modified: trunk/refman-5.1/functions.xml =================================================================== --- trunk/refman-5.1/functions.xml 2006-11-13 20:09:13 UTC (rev 3925) +++ trunk/refman-5.1/functions.xml 2006-11-14 04:40:09 UTC (rev 3926) Changed blocks: 3, Lines Added: 39, Lines Deleted: 1; 1804 bytes @@ -4727,6 +4727,39 @@ </programlisting> </listitem> + <listitem> + <remark role="help-topic" condition="%"/> + + <remark role="help-keywords"> + MOD + </remark> + + <remark role="help-syntax-begin"/> + + <para> + <indexterm type="function"> + <primary>%</primary> + </indexterm> + + <literal><replaceable>N</replaceable> % + <replaceable>M</replaceable></literal> + </para> + + <remark role="help-syntax-end"/> + + <remark role="help-description-begin"/> + + <para> + Modulo operation. Returns the remainder of + <replaceable>N</replaceable> divided by + <replaceable>M</replaceable>. For more information, see the + description for the <literal>MOD()</literal> function in + <xref linkend="mathematical-functions"/>. + </para> + + <remark role="help-description-end"/> + </listitem> + </itemizedlist> </section> @@ -5410,7 +5443,7 @@ </listitem> <listitem> - <remark role="help-topic" condition="%"/> + <remark role="help-topic" condition="MOD"/> <remark role="help-keywords"> MOD @@ -5486,6 +5519,11 @@ mysql> <userinput>SELECT MOD(34.5,3);</userinput> -> 1.5 </programlisting> + + <para> + <literal>MOD(<replaceable>N</replaceable>,0)</literal> + returns <literal>NULL</literal>. + </para> </listitem> <listitem> Modified: trunk/refman-5.1/news-5.1.xml =================================================================== --- trunk/refman-5.1/news-5.1.xml 2006-11-13 20:09:13 UTC (rev 3925) +++ trunk/refman-5.1/news-5.1.xml 2006-11-14 04:40:09 UTC (rev 3926) Changed blocks: 2, Lines Added: 65, Lines Deleted: 0; 2922 bytes @@ -106,6 +106,16 @@ </para> </listitem> + <listitem> + <para> + <literal>mysql_upgrade</literal> now passes all the parameters + specified on the command line to both + <literal>mysqlcheck</literal> and <literal>mysql</literal> + using the <filename>upgrade_defaults</filename> file. (Bug + #20100) + </para> + </listitem> + </itemizedlist> <para> @@ -125,6 +135,61 @@ <listitem> <para> + <literal><replaceable>M</replaceable> % 0</literal> returns + <literal>NULL</literal>, but + (<literal><replaceable>M</replaceable> % 0) IS NULL</literal> + evaluated to false. (Bug #23411) + </para> + </listitem> + + <listitem> + <para> + Within a stored routine, a view definition cannot refer to + routine parameters or local variables. However, an error did + not occur until the routine was called. Now it occurs during + parsing of the routine creation statement. (Bug #20953) + </para> + + <para> + <emphasis role="bold">Note</emphasis>: A side effect of this + fix is that if you have already created such routines, and + error will occur if you execute <literal>SHOW CREATE + PROCEDURE</literal> or <literal>SHOW CREATE + FUNCTION</literal>. You should drop these routines because + they are erroneous. + </para> + </listitem> + + <listitem> + <para> + A client library crash was caused by executing a statement + such as <literal>SELECT * FROM t1 PROCEDURE + ANALYSE()</literal> using a server side cursor on a table + <literal>t1</literal> that does not have the same number of + columns as the output from <literal>PROCEDURE + ANALYSE()</literal>. (Bug #17039) + </para> + </listitem> + + <listitem> + <para> + <command>mysql</command> did not check for errors when + fetching data during result set printing. (Bug #22913) + </para> + </listitem> + + <listitem> + <para> + Adding a day, month, or year interval to a + <literal>DATE</literal> value produced a + <literal>DATE</literal>, but adding a week interval produced a + <literal>DATETIME</literal> value. Now all produce a + <literal>DATE</literal> value. (Bug #21811) + </para> + </listitem> + + <listitem> + <para> The column default value in the output from <literal>SHOW COLUMNS</literal> or <literal>SELECT FROM INFORMATION_SCHEMA.COLUMNS</literal> was truncated to 64
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r3926 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 14 Nov |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.456 sec. using MySQL 5.1.14-beta-log