List:Commits« Previous MessageNext Message »
From:paul.dubois Date:November 16 2010 2:42am
Subject:svn commit - mysqldoc@docsrva: r23762 - in trunk: . dynamic-docs/changelog refman-5.5 refman-5.6
View as plain text  
Author: paul
Date: 2010-11-16 03:42:39 +0100 (Tue, 16 Nov 2010)
New Revision: 23762

Log:
 r65569@frost:  paul | 2010-11-15 20:38:04 -0500
 Document bug fixes:
 - Bug#30025: Mysqld prints out warnings/errors being run with --no-defaults --help
 - Bug#35269: mysqlcheck behaves different depending on order of parameters
 - Bug#51099: Assertion in mysql_multi_delete_prepare()
 - Bug#55744: GROUP_CONCAT + CASE + ucs return garbage
 - Bug#56822: Add a thread state for sessions waiting on the query cache lock
 - Bug#57039: queries using subtime in the where condition returns incorrect data


Modified:
   trunk/dynamic-docs/changelog/mysqld-1.xml
   trunk/dynamic-docs/changelog/mysqld-2.xml
   trunk/refman-5.5/optimization.xml
   trunk/refman-5.6/optimization.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:44270
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:65561
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
   + 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:44270
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:65569
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546


Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml	2010-11-16 01:13:29 UTC (rev 23761)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml	2010-11-16 02:42:39 UTC (rev 23762)
Changed blocks: 2, Lines Added: 3, Lines Deleted: 2; 1004 bytes

@@ -1694,8 +1694,8 @@
       <para>
         It is now possible to assign indexes on partitioned
         <literal role="se">MyISAM</literal> tables to key caches using
-        the <literal role="stmt">CACHE INDEX</literal> and to preload such
-        indexes into the cache using
+        the <literal role="stmt">CACHE INDEX</literal> and to preload
+        such indexes into the cache using
         <literal role="stmt" condition="load-index">LOAD INDEX INTO
         CACHE</literal> statements. Cache assignment and preloading of
         indexes for such tables can be performed for one, several, or

@@ -48837,6 +48837,7 @@
     </bugs>
 
     <versions>
+      <version ver="5.6.1"/>
       <version ver="6.0.6"/>
     </versions>
 


Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml	2010-11-16 01:13:29 UTC (rev 23761)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml	2010-11-16 02:42:39 UTC (rev 23762)
Changed blocks: 1, Lines Added: 148, Lines Deleted: 0; 2896 bytes

@@ -31853,4 +31853,152 @@
 
   </logentry>
 
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="mysqlcheck"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="35269"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.5.7"/>
+    </versions>
+
+    <message>
+
+      <para>
+        <command>mysqlcheck</command> behaved differently depending on
+        the order in which options were given on the command line.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <bugs>
+      <fixes bugid="30025"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.5.7"/>
+    </versions>
+
+    <message>
+
+      <para>
+        When invoked to display a help message,
+        <command>mysqld</command> also displayed spurious warning or
+        error messages.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="feature">
+
+    <tags>
+      <manual type="query cache"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="56822"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.5.7"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Added a new <literal role="stmt">SHOW PROCESSLIST</literal>
+        state, <literal>Waiting for query cache lock</literal>. This
+        indicates that a session is waiting to take the query cache lock
+        while it performs some query cache operation.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="CASE"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="55744"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.5.7"/>
+    </versions>
+
+    <message>
+
+      <para>
+        <literal role="op">CASE</literal> expressions with a mix of
+        operands in different character sets sometimes returned
+        incorrect results.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="SUBTIME()"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="57039"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.5.7"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Constant <literal role="func">SUBTIME()</literal> expressions
+        could return incorrect results.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <bugs>
+      <fixes bugid="51099"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.5.7"/>
+    </versions>
+
+    <message>
+
+      <para>
+        An assertion could be raised by
+        <literal role="stmt">DELETE</literal> on a view that referenced
+        another view which in turn (directly or indirectly) referenced
+        more than one table.
+      </para>
+
+    </message>
+
+  </logentry>
+
 </changelog>


Modified: trunk/refman-5.5/optimization.xml
===================================================================
--- trunk/refman-5.5/optimization.xml	2010-11-16 01:13:29 UTC (rev 23761)
+++ trunk/refman-5.5/optimization.xml	2010-11-16 02:42:39 UTC (rev 23762)
Changed blocks: 1, Lines Added: 28, Lines Deleted: 0; 1452 bytes

@@ -15255,6 +15255,34 @@
             </para>
           </listitem>
 
+          <listitem>
+            <para>
+              <indexterm>
+                <primary>Waiting for query cache lock</primary>
+                <secondary>thread state</secondary>
+              </indexterm>
+
+              <indexterm>
+                <primary>thread state</primary>
+                <secondary>Waiting for query cache lock</secondary>
+              </indexterm>
+
+              <literal>Waiting for query cache lock</literal>
+            </para>
+
+            <para>
+              This state occurs while a session is waiting to take the
+              query cache lock. This can happen for any statement that
+              needs to perform some query cache operation, such as an
+              <literal role="stmt">INSERT</literal> or
+              <literal role="stmt">DELETE</literal> that invalidates the
+              query cache, a <literal role="stmt">SELECT</literal> that
+              looks for a cached entry,
+              <literal role="stmt" condition="reset">RESET QUERY
+              CACHE</literal>, and so forth.
+            </para>
+          </listitem>
+
         </itemizedlist>
 
       </section>


Modified: trunk/refman-5.6/optimization.xml
===================================================================
--- trunk/refman-5.6/optimization.xml	2010-11-16 01:13:29 UTC (rev 23761)
+++ trunk/refman-5.6/optimization.xml	2010-11-16 02:42:39 UTC (rev 23762)
Changed blocks: 1, Lines Added: 28, Lines Deleted: 0; 1396 bytes

@@ -18032,6 +18032,34 @@
           </para>
         </listitem>
 
+        <listitem>
+          <para>
+            <indexterm>
+              <primary>Waiting for query cache lock</primary>
+              <secondary>thread state</secondary>
+            </indexterm>
+
+            <indexterm>
+              <primary>thread state</primary>
+              <secondary>Waiting for query cache lock</secondary>
+            </indexterm>
+
+            <literal>Waiting for query cache lock</literal>
+          </para>
+
+          <para>
+            This state occurs while a session is waiting to take the
+            query cache lock. This can happen for any statement that
+            needs to perform some query cache operation, such as an
+            <literal role="stmt">INSERT</literal> or
+            <literal role="stmt">DELETE</literal> that invalidates the
+            query cache, a <literal role="stmt">SELECT</literal> that
+            looks for a cached entry,
+            <literal role="stmt" condition="reset">RESET QUERY
+            CACHE</literal>, and so forth.
+          </para>
+        </listitem>
+
       </itemizedlist>
 
     </section>


Thread
svn commit - mysqldoc@docsrva: r23762 - in trunk: . dynamic-docs/changelog refman-5.5 refman-5.6paul.dubois16 Nov