List:Commits« Previous MessageNext Message »
From:mhillyer Date:January 19 2006 10:35pm
Subject:svn commit - mysqldoc@docsrva: r938 - in trunk: refman-common sample-data/sakila
View as plain text  
Author: mhillyer
Date: 2006-01-19 23:35:26 +0100 (Thu, 19 Jan 2006)
New Revision: 938

Log:
Document changes: 15094,11827,12440,15734,12268,14016,12564

Make some modifications to the new sample db schema as per feedback.

Modified:
   trunk/refman-common/news-4.1.xml
   trunk/refman-common/news-5.0.xml
   trunk/refman-common/news-5.1.xml
   trunk/sample-data/sakila/sakila-schema.sql

Modified: trunk/refman-common/news-4.1.xml
===================================================================
--- trunk/refman-common/news-4.1.xml	2006-01-19 21:18:11 UTC (rev 937)
+++ trunk/refman-common/news-4.1.xml	2006-01-19 22:35:26 UTC (rev 938)
@@ -172,6 +172,13 @@
         </para>
       </listitem>
 
+      <listitem>
+        <para>
+          Support files for compiling with Visual Studio 6 have been
+          removed. (Bug #15094)
+        </para>
+      </listitem>
+
     </itemizedlist>
 
     <para>
@@ -182,6 +189,14 @@
 
       <listitem>
         <para>
+          Using <function>CAST()</function> to convert values with long
+          fractional and/or exponent parts to TIME returned wrong
+          results. (Bug #12440)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           An <literal>INSERT ... SELECT</literal> statement between
           tables in a <literal>MERGE</literal> set can return errors
           when statement involves insert into child table from merge
@@ -459,6 +474,23 @@
 
       <listitem>
         <para>
+          When the <function>DATE_FORMAT()</function> function appeared
+          in both the <literal>SELECT</literal> and <literal>ORDER
+          BY</literal> clauses of a query but with arguments that differ
+          by case (i.e. %m and %M), incorrect sorting may have occurred.
+          (Bug #14016)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Make failed when attempting to build MySQL in different
+          directory than source. (Bug #11827)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           <literal>PROCEDURE ANALYSE()</literal> could suggest a data
           type with a negative display width. (Bug #10716)
         </para>

Modified: trunk/refman-common/news-5.0.xml
===================================================================
--- trunk/refman-common/news-5.0.xml	2006-01-19 21:18:11 UTC (rev 937)
+++ trunk/refman-common/news-5.0.xml	2006-01-19 22:35:26 UTC (rev 938)
@@ -423,6 +423,21 @@
 
       <listitem>
         <para>
+          Server could not be built on default Debian systems with BDB
+          enabled. (Bug #15734)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Using <function>CAST()</function> to convert values with long
+          fractional and/or exponent parts to TIME returned wrong
+          results. (Bug #12440)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           Creating a trigger caused a server crash if the table or
           trigger database was not known because no default database had
           been selected. (Bug #14863)
@@ -712,6 +727,13 @@
         </para>
       </listitem>
 
+      <listitem>
+        <para>
+          Support files for compiling with Visual Studio 6 have been
+          removed. (Bug #15094)
+        </para>
+      </listitem>
+
     </itemizedlist>
 
     <para>
@@ -722,6 +744,13 @@
 
       <listitem>
         <para>
+          Make failed when attempting to build MySQL in different
+          directory than source. (Bug #11827)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           Corrected an error-handling problem within stored routines on
           64-bit platforms. (Bug #15630)
         </para>
@@ -1511,6 +1540,16 @@
 
       <listitem>
         <para>
+          When the <function>DATE_FORMAT()</function> function appeared
+          in both the <literal>SELECT</literal> and <literal>ORDER
+          BY</literal> clauses of a query but with arguments that differ
+          by case (i.e. %m and %M), incorrect sorting may have occurred.
+          (Bug #14016)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           For <literal>InnoDB</literal> tables, using a column prefix
           for a <literal>utf8</literal> column in a primary key caused
           <literal>Cannot find record</literal> errors when attempting

Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml	2006-01-19 21:18:11 UTC (rev 937)
+++ trunk/refman-common/news-5.1.xml	2006-01-19 22:35:26 UTC (rev 938)
@@ -54,7 +54,7 @@
     </para>
 
     <itemizedlist>
-      
+
       <listitem>
         <para>
           <literal>SHOW CREATE TABLE</literal> did not display the
@@ -301,10 +301,14 @@
           <literal>LIST</literal> a value less than any specified in one
           of the table's partition definitions resulted in a server
           crash. In such cases, <command>mysqld</command> now returns
+
           <errortext>ERROR 1500 (HY000): Table has no partition for
-          value <replaceable>v</replaceable></errortext>, where
-          <replaceable>v</replaceable> is the out-of-range value. (Bug
-          #15819)
+          value <replaceable>v</replaceable>
+
+          </errortext>
+
+          , where <replaceable>v</replaceable> is the out-of-range
+          value. (Bug #15819)
         </para>
       </listitem>
 
@@ -397,6 +401,13 @@
 
       <listitem>
         <para>
+          Server could not be built on default Debian systems with BDB
+          enabled. (Bug #15734)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           <literal>BDB</literal>: A <literal>DELETE</literal>,
           <literal>INSERT</literal>, or <literal>UPDATE</literal> of a
           <literal>BDB</literal> table could cause the server to crash
@@ -443,8 +454,11 @@
 
         <para>
           Previously, attempting to do so would produce the error
+
           <errortext>All partitions must have unique names in the
-          table</errortext>. (Bug #15521)
+          table</errortext>
+
+          . (Bug #15521)
         </para>
       </listitem>
 

Modified: trunk/sample-data/sakila/sakila-schema.sql
===================================================================
--- trunk/sample-data/sakila/sakila-schema.sql	2006-01-19 21:18:11 UTC (rev 937)
+++ trunk/sample-data/sakila/sakila-schema.sql	2006-01-19 22:35:26 UTC (rev 938)
@@ -2,9 +2,9 @@
 -- Version 0.1
 -- Copyright 2006 MySQL AB
 
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL' */;
+SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
+SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
+SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
 
 
 DROP SCHEMA IF EXISTS sakila;
@@ -33,7 +33,7 @@
   address2 VARCHAR(50) DEFAULT NULL,
   district VARCHAR(50) NOT NULL,
   city_id INT UNSIGNED NOT NULL,
-  postal_code VARCHAR(10) NOT NULL,
+  postal_code VARCHAR(10) DEFAULT NULL,
   phone VARCHAR(20) NOT NULL,
   PRIMARY KEY  (address_id),
   KEY idx_fk_city_id (city_id),
@@ -175,7 +175,6 @@
   film_id INT UNSIGNED NOT NULL,
   store_id INT UNSIGNED NOT NULL,
   PRIMARY KEY  (inventory_id),
-  KEY idx_fk_store_id (store_id),
   KEY idx_fk_film_id (film_id),
   KEY idx_store_id_film_id (store_id,film_id),
   CONSTRAINT fk_inventory_store FOREIGN KEY (store_id) REFERENCES store (store_id) ON DELETE RESTRICT ON UPDATE CASCADE,
@@ -229,7 +228,7 @@
   address_id INT UNSIGNED NOT NULL,
   picture BLOB DEFAULT NULL,
   store_id INT UNSIGNED NOT NULL,
-  active BOOL NOT NULL DEFAULT TRUE,
+  active BOOLEAN NOT NULL DEFAULT TRUE,
   PRIMARY KEY  (staff_id),
   KEY idx_fk_store_id (store_id),
   KEY idx_fk_address_id (address_id),
@@ -300,8 +299,8 @@
 FROM staff AS s JOIN address AS a ON s.address_id = a.address_id JOIN city ON a.city_id = city.city_id 
 	JOIN country ON city.country_id = country.country_id;
 
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+SET SQL_MODE=@OLD_SQL_MODE;
+SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
+SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
 
 

Thread
svn commit - mysqldoc@docsrva: r938 - in trunk: refman-common sample-data/sakilamhillyer19 Jan