List:Commits« Previous MessageNext Message »
From:paul.dubois Date:August 20 2010 6:55pm
Subject:svn commit - mysqldoc@docsrva: r22366 - in trunk: . refman-5.0 refman-5.1 refman-5.5 refman-5.6 refman-6.0
View as plain text  
Author: paul
Date: 2010-08-20 20:55:22 +0200 (Fri, 20 Aug 2010)
New Revision: 22366

Log:
 r62530@frost:  paul | 2010-08-20 13:08:10 -0500
 Fix docs bug:
 Bug#43151: default values doesn't mention implicit default for columns in pkey


Modified:
   trunk/refman-5.0/data-types.xml
   trunk/refman-5.1/data-types.xml
   trunk/refman-5.5/data-types.xml
   trunk/refman-5.6/data-types.xml
   trunk/refman-6.0/data-types.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:41634
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:62526
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:41634
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:62530
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/refman-5.0/data-types.xml
===================================================================
--- trunk/refman-5.0/data-types.xml	2010-08-20 17:37:30 UTC (rev 22365)
+++ trunk/refman-5.0/data-types.xml	2010-08-20 18:55:22 UTC (rev 22366)
Changed blocks: 1, Lines Added: 14, Lines Deleted: 1; 1388 bytes

@@ -2251,7 +2251,20 @@
       <para>
         If the column cannot take <literal>NULL</literal> as the value,
         MySQL defines the column with no explicit
-        <literal>DEFAULT</literal> clause. For data entry, if an
+        <literal>DEFAULT</literal> clause. Exception: If the column is
+        defined as part of a <literal>PRIMARY KEY</literal> but not
+        explicitly as <literal>NOT NULL</literal>, MySQL creates it as a
+        <literal>NOT NULL</literal> column (because <literal>PRIMARY
+        KEY</literal> columns must be <literal>NOT NULL</literal>), but
+        also assigns it a <literal>DEFAULT</literal> clause using the
+        implicit default value. To prevent this, include an explicit
+        <literal>NOT NULL</literal> in the definition of any
+        <literal>PRIMARY KEY</literal> column.
+      </para>
+
+      <para>
+        For data entry for a <literal>NOT NULL</literal> column that has
+        no explicit <literal>DEFAULT</literal> clause, if an
         <literal role="stmt">INSERT</literal> or
         <literal role="stmt">REPLACE</literal> statement includes no
         value for the column, or an


Modified: trunk/refman-5.1/data-types.xml
===================================================================
--- trunk/refman-5.1/data-types.xml	2010-08-20 17:37:30 UTC (rev 22365)
+++ trunk/refman-5.1/data-types.xml	2010-08-20 18:55:22 UTC (rev 22366)
Changed blocks: 1, Lines Added: 14, Lines Deleted: 1; 1388 bytes

@@ -2075,7 +2075,20 @@
       <para>
         If the column cannot take <literal>NULL</literal> as the value,
         MySQL defines the column with no explicit
-        <literal>DEFAULT</literal> clause. For data entry, if an
+        <literal>DEFAULT</literal> clause. Exception: If the column is
+        defined as part of a <literal>PRIMARY KEY</literal> but not
+        explicitly as <literal>NOT NULL</literal>, MySQL creates it as a
+        <literal>NOT NULL</literal> column (because <literal>PRIMARY
+        KEY</literal> columns must be <literal>NOT NULL</literal>), but
+        also assigns it a <literal>DEFAULT</literal> clause using the
+        implicit default value. To prevent this, include an explicit
+        <literal>NOT NULL</literal> in the definition of any
+        <literal>PRIMARY KEY</literal> column.
+      </para>
+
+      <para>
+        For data entry for a <literal>NOT NULL</literal> column that has
+        no explicit <literal>DEFAULT</literal> clause, if an
         <literal role="stmt">INSERT</literal> or
         <literal role="stmt">REPLACE</literal> statement includes no
         value for the column, or an


Modified: trunk/refman-5.5/data-types.xml
===================================================================
--- trunk/refman-5.5/data-types.xml	2010-08-20 17:37:30 UTC (rev 22365)
+++ trunk/refman-5.5/data-types.xml	2010-08-20 18:55:22 UTC (rev 22366)
Changed blocks: 1, Lines Added: 14, Lines Deleted: 1; 1388 bytes

@@ -2075,7 +2075,20 @@
       <para>
         If the column cannot take <literal>NULL</literal> as the value,
         MySQL defines the column with no explicit
-        <literal>DEFAULT</literal> clause. For data entry, if an
+        <literal>DEFAULT</literal> clause. Exception: If the column is
+        defined as part of a <literal>PRIMARY KEY</literal> but not
+        explicitly as <literal>NOT NULL</literal>, MySQL creates it as a
+        <literal>NOT NULL</literal> column (because <literal>PRIMARY
+        KEY</literal> columns must be <literal>NOT NULL</literal>), but
+        also assigns it a <literal>DEFAULT</literal> clause using the
+        implicit default value. To prevent this, include an explicit
+        <literal>NOT NULL</literal> in the definition of any
+        <literal>PRIMARY KEY</literal> column.
+      </para>
+
+      <para>
+        For data entry for a <literal>NOT NULL</literal> column that has
+        no explicit <literal>DEFAULT</literal> clause, if an
         <literal role="stmt">INSERT</literal> or
         <literal role="stmt">REPLACE</literal> statement includes no
         value for the column, or an


Modified: trunk/refman-5.6/data-types.xml
===================================================================
--- trunk/refman-5.6/data-types.xml	2010-08-20 17:37:30 UTC (rev 22365)
+++ trunk/refman-5.6/data-types.xml	2010-08-20 18:55:22 UTC (rev 22366)
Changed blocks: 1, Lines Added: 14, Lines Deleted: 1; 1388 bytes

@@ -2075,7 +2075,20 @@
       <para>
         If the column cannot take <literal>NULL</literal> as the value,
         MySQL defines the column with no explicit
-        <literal>DEFAULT</literal> clause. For data entry, if an
+        <literal>DEFAULT</literal> clause. Exception: If the column is
+        defined as part of a <literal>PRIMARY KEY</literal> but not
+        explicitly as <literal>NOT NULL</literal>, MySQL creates it as a
+        <literal>NOT NULL</literal> column (because <literal>PRIMARY
+        KEY</literal> columns must be <literal>NOT NULL</literal>), but
+        also assigns it a <literal>DEFAULT</literal> clause using the
+        implicit default value. To prevent this, include an explicit
+        <literal>NOT NULL</literal> in the definition of any
+        <literal>PRIMARY KEY</literal> column.
+      </para>
+
+      <para>
+        For data entry for a <literal>NOT NULL</literal> column that has
+        no explicit <literal>DEFAULT</literal> clause, if an
         <literal role="stmt">INSERT</literal> or
         <literal role="stmt">REPLACE</literal> statement includes no
         value for the column, or an


Modified: trunk/refman-6.0/data-types.xml
===================================================================
--- trunk/refman-6.0/data-types.xml	2010-08-20 17:37:30 UTC (rev 22365)
+++ trunk/refman-6.0/data-types.xml	2010-08-20 18:55:22 UTC (rev 22366)
Changed blocks: 1, Lines Added: 14, Lines Deleted: 1; 1388 bytes

@@ -2075,7 +2075,20 @@
       <para>
         If the column cannot take <literal>NULL</literal> as the value,
         MySQL defines the column with no explicit
-        <literal>DEFAULT</literal> clause. For data entry, if an
+        <literal>DEFAULT</literal> clause. Exception: If the column is
+        defined as part of a <literal>PRIMARY KEY</literal> but not
+        explicitly as <literal>NOT NULL</literal>, MySQL creates it as a
+        <literal>NOT NULL</literal> column (because <literal>PRIMARY
+        KEY</literal> columns must be <literal>NOT NULL</literal>), but
+        also assigns it a <literal>DEFAULT</literal> clause using the
+        implicit default value. To prevent this, include an explicit
+        <literal>NOT NULL</literal> in the definition of any
+        <literal>PRIMARY KEY</literal> column.
+      </para>
+
+      <para>
+        For data entry for a <literal>NOT NULL</literal> column that has
+        no explicit <literal>DEFAULT</literal> clause, if an
         <literal role="stmt">INSERT</literal> or
         <literal role="stmt">REPLACE</literal> statement includes no
         value for the column, or an


Thread
svn commit - mysqldoc@docsrva: r22366 - in trunk: . refman-5.0 refman-5.1 refman-5.5 refman-5.6 refman-6.0paul.dubois20 Aug