Author: mhillyer
Date: 2006-04-11 20:04:36 +0200 (Tue, 11 Apr 2006)
New Revision: 1794
Log:
Document bugfixes: 17336,10878,17953
Modified:
trunk/refman-4.1/storage-engines.xml
trunk/refman-5.0/database-administration.xml
trunk/refman-5.0/storage-engines.xml
trunk/refman-5.1/database-administration.xml
trunk/refman-5.1/storage-engines.xml
trunk/refman-common/news-5.0.xml
trunk/refman-common/news-5.1.xml
trunk/sample-data/sakila/sakila-schema.sql
trunk/sample-data/sakila/sakila.xml
Modified: trunk/refman-4.1/storage-engines.xml
===================================================================
--- trunk/refman-4.1/storage-engines.xml 2006-04-11 13:45:23 UTC (rev 1793)
+++ trunk/refman-4.1/storage-engines.xml 2006-04-11 18:04:36 UTC (rev 1794)
@@ -2045,6 +2045,17 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ If you encounter an error message similar to <literal>ERROR
+ 1017 (HY000): Can't find file:
+ '<replaceable>mm</replaceable>.MRG' (errno: 2)</literal> it
+ generally indicates that some of the base tables are not
+ using the MyISAM storage engine. Confirm that all tables are
+ MyISAM.
+ </para>
+ </listitem>
+
</itemizedlist>
</section>
Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml 2006-04-11 13:45:23 UTC (rev 1793)
+++ trunk/refman-5.0/database-administration.xml 2006-04-11 18:04:36 UTC (rev 1794)
@@ -12318,12 +12318,17 @@
the MySQL Instance Manager to start a server.
</para>
- <remark role="todo">
- Which "default" location? /usr/local/mysql/bin (RPM),
- /usr/sbin (tarfile), /usr/local/libexec (source), or
- /usr/local/mysql/libexec (also commonly used)?
- </remark>
+ <para>
+ Starting with MySQL 5.0.19, you can instead modify the my.cnf
+ file by adding <literal>use-manager</literal> to the
+ <literal>[mysql.server]</literal> section:
+ </para>
+<programlisting>
+[mysql.server]
+use-manager
+</programlisting>
+
<para>
The Instance Manager's behavior in this case depends on the
options given in the MySQL configuration file. If there is no
Modified: trunk/refman-5.0/storage-engines.xml
===================================================================
--- trunk/refman-5.0/storage-engines.xml 2006-04-11 13:45:23 UTC (rev 1793)
+++ trunk/refman-5.0/storage-engines.xml 2006-04-11 18:04:36 UTC (rev 1794)
@@ -2003,6 +2003,17 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ If you encounter an error message similar to <literal>ERROR
+ 1017 (HY000): Can't find file:
+ '<replaceable>mm</replaceable>.MRG' (errno: 2)</literal> it
+ generally indicates that some of the base tables are not
+ using the MyISAM storage engine. Confirm that all tables are
+ MyISAM.
+ </para>
+ </listitem>
+
</itemizedlist>
</section>
Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml 2006-04-11 13:45:23 UTC (rev 1793)
+++ trunk/refman-5.1/database-administration.xml 2006-04-11 18:04:36 UTC (rev 1794)
@@ -12209,17 +12209,16 @@
is started with the <command>mysql.server</command> script,
which usually resides in the <literal>/etc/init.d/</literal>
folder. This script invokes the <command>mysqld_safe</command>
- script by default. However, you can set the
- <literal>use_mysqld_safe</literal> variable in the script to
- <literal>0</literal> (zero) to use the MySQL Instance Manager
- to start a server.
+ script by default. However, you can instead use the instance
+ manager if you modify the my.cnf file by adding
+ <literal>use-manager</literal> to the
+ <literal>[mysql.server]</literal> section:
</para>
- <remark role="todo">
- Which "default" location? /usr/local/mysql/bin (RPM),
- /usr/sbin (tarfile), /usr/local/libexec (source), or
- /usr/local/mysql/libexec (also commonly used)?
- </remark>
+<programlisting>
+[mysql.server]
+use-manager
+</programlisting>
<para>
The Instance Manager's behavior in this case depends on the
Modified: trunk/refman-5.1/storage-engines.xml
===================================================================
--- trunk/refman-5.1/storage-engines.xml 2006-04-11 13:45:23 UTC (rev 1793)
+++ trunk/refman-5.1/storage-engines.xml 2006-04-11 18:04:36 UTC (rev 1794)
@@ -1946,6 +1946,17 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ If you encounter an error message similar to <literal>ERROR
+ 1017 (HY000): Can't find file:
+ '<replaceable>mm</replaceable>.MRG' (errno: 2)</literal> it
+ generally indicates that some of the base tables are not
+ using the MyISAM storage engine. Confirm that all tables are
+ MyISAM.
+ </para>
+ </listitem>
+
</itemizedlist>
</section>
Modified: trunk/refman-common/news-5.0.xml
===================================================================
--- trunk/refman-common/news-5.0.xml 2006-04-11 13:45:23 UTC (rev 1793)
+++ trunk/refman-common/news-5.0.xml 2006-04-11 18:04:36 UTC (rev 1794)
@@ -431,6 +431,13 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ Large file support added to build for <literal>QNX</literal>
+ platform. (Bug #17336)
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml 2006-04-11 13:45:23 UTC (rev 1793)
+++ trunk/refman-common/news-5.1.xml 2006-04-11 18:04:36 UTC (rev 1794)
@@ -491,6 +491,13 @@
<listitem>
<para>
+ Large file support added to build for <literal>QNX</literal>
+ platform. (Bug #17336)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
The deprecated constructs in the following table now generate
warnings. You should not employ them in new applications, as
they are likely to be removed in a future version of MySQL.
Modified: trunk/sample-data/sakila/sakila-schema.sql
===================================================================
--- trunk/sample-data/sakila/sakila-schema.sql 2006-04-11 13:45:23 UTC (rev 1793)
+++ trunk/sample-data/sakila/sakila-schema.sql 2006-04-11 18:04:36 UTC (rev 1794)
@@ -395,6 +395,38 @@
ORDER BY total_sales DESC;
--
+-- View structure for view `actor_info`
+--
+
+CREATE DEFINER=CURRENT_USER SQL SECURITY INVOKER VIEW actor_info
+AS
+SELECT
+a.actor_id,
+a.first_name,
+a.last_name,
+GROUP_CONCAT(DISTINCT CONCAT(c.name, ': ',
+ (SELECT GROUP_CONCAT(f.title ORDER BY f.title SEPARATOR ', ')
+ FROM sakila.film f
+ INNER JOIN sakila.film_category fc
+ ON f.film_id = fc.film_id
+ INNER JOIN sakila.film_actor fa
+ ON f.film_id = fa.film_id
+ WHERE fc.category_id = c.category_id
+ AND fa.actor_id = a.actor_id
+ )
+ )
+ ORDER BY c.name SEPARATOR '; '
+AS film_info
+FROM sakila.actor a
+LEFT JOIN sakila.film_actor fa
+ ON a.actor_id = fa.actor_id
+LEFT JOIN sakila.film_category fc
+ ON fa.film_id = fc.film_id
+LEFT JOIN sakila.category c
+ ON fc.category_id = c.category_id
+GROUP BY a.actor_id, a.first_name, a.last_name;
+
+--
-- Procedure structure for procedure `rewards_report`
--
@@ -544,7 +576,7 @@
CREATE FUNCTION inventory_held_by_customer(p_inventory_id INT) RETURNS INT
BEGIN
DECLARE v_customer_id INT;
- DECLARE CONTINUE HANDLER FOR 1329 RETURN NULL;
+ DECLARE EXIT HANDLER FOR NOT FOUND RETURN NULL;
SELECT customer_id INTO v_customer_id
FROM rental
@@ -563,7 +595,7 @@
DECLARE v_rentals INT;
DECLARE v_out INT;
- #AN ITEM IS IN-STOCK IF EITHER THERE ARE NO ROWS IN THE rental TABLE
+ #AN ITEM IS IN-STOCK IF THERE ARE EITHER NO ROWS IN THE rental TABLE
#FOR THE ITEM OR ALL ROWS HAVE return_date POPULATED
SELECT COUNT(*) INTO v_rentals
Modified: trunk/sample-data/sakila/sakila.xml
===================================================================
--- trunk/sample-data/sakila/sakila.xml 2006-04-11 13:45:23 UTC (rev 1793)
+++ trunk/sample-data/sakila/sakila.xml 2006-04-11 18:04:36 UTC (rev 1794)
@@ -280,7 +280,7 @@
<note>
<para>
- All tables contain a <literal>last_update</literal> column
+ All tables, with the exception of the <literal>film_text</literal> table, contain a <literal>last_update</literal> column
that serves as a timestamp marking the last time each row was
updated. This column will not be listed for each table in the
table's column list.
@@ -1995,7 +1995,7 @@
<para>
<literal>Roland Bouman</literal>,
<ulink url="http://rpbouman.blogspot.com/">Author</ulink> -
- Provided valuable feedback throughout the development process.
+ Provided valuable feedback throughout the development process, contributed sample views and stored procedures.
</para>
</listitem>
@@ -2016,7 +2016,7 @@
<ulink
url="http://www.dell.com/mysql">Dell</ulink>
- Provided schema used in Dell whitepaper and secured
- permission to use parts thereof in &sampdb; sample database.
+ permission to use parts thereof in the &sampdb; sample database.
</para>
</listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1794 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-common sample-data/sakila | mhillyer | 11 Apr |
