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/sakila | mhillyer | 19 Jan |
