MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:paul Date:August 1 2006 5:37pm
Subject:svn commit - mysqldoc@docsrva: r2914 - in trunk: . refman-4.1 refman-5.0 refman-5.1
View as plain text  
Author: paul
Date: 2006-08-01 19:37:34 +0200 (Tue, 01 Aug 2006)
New Revision: 2914

Log:
 r12395@polar:  paul | 2006-08-01 11:36:57 -0500
 Clarify behavior for LOAD DATA when you load NULL into NOT NULL
 columns.


Modified:
   trunk/refman-4.1/sql-syntax.xml
   trunk/refman-5.0/sql-syntax.xml
   trunk/refman-5.1/sql-syntax.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:12375
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:13155
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:9385
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:12395
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:13155
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:9385


Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2006-08-01 10:49:34 UTC (rev 2913)
+++ trunk/refman-4.1/sql-syntax.xml	2006-08-01 17:37:34 UTC (rev 2914)
Changed blocks: 1, Lines Added: 7, Lines Deleted: 0; 719 bytes

@@ -5789,6 +5789,13 @@
       </itemizedlist>
 
       <para>
+        An attempt to load <literal>NULL</literal> into a <literal>NOT
+        NULL</literal> column causes assignment of the implicit default
+        value for the column's data type and a warning. Implicit default
+        values are discussed in <xref linkend="data-type-defaults"/>.
+      </para>
+
+      <para>
         Some cases are not supported by <literal>LOAD DATA
         INFILE</literal>:
       </para>


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2006-08-01 10:49:34 UTC (rev 2913)
+++ trunk/refman-5.0/sql-syntax.xml	2006-08-01 17:37:34 UTC (rev 2914)
Changed blocks: 1, Lines Added: 8, Lines Deleted: 0; 759 bytes

@@ -5704,6 +5704,14 @@
       </itemizedlist>
 
       <para>
+        An attempt to load <literal>NULL</literal> into a <literal>NOT
+        NULL</literal> column causes assignment of the implicit default
+        value for the column's data type and a warning, or an error in
+        strict SQL mode. Implicit default values are discussed in
+        <xref linkend="data-type-defaults"/>.
+      </para>
+
+      <para>
         Some cases are not supported by <literal>LOAD DATA
         INFILE</literal>:
       </para>


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2006-08-01 10:49:34 UTC (rev 2913)
+++ trunk/refman-5.1/sql-syntax.xml	2006-08-01 17:37:34 UTC (rev 2914)
Changed blocks: 1, Lines Added: 8, Lines Deleted: 0; 759 bytes

@@ -7055,6 +7055,14 @@
       </itemizedlist>
 
       <para>
+        An attempt to load <literal>NULL</literal> into a <literal>NOT
+        NULL</literal> column causes assignment of the implicit default
+        value for the column's data type and a warning, or an error in
+        strict SQL mode. Implicit default values are discussed in
+        <xref linkend="data-type-defaults"/>.
+      </para>
+
+      <para>
         Some cases are not supported by <literal>LOAD DATA
         INFILE</literal>:
       </para>


Thread
svn commit - mysqldoc@docsrva: r2914 - in trunk: . refman-4.1 refman-5.0 refman-5.1paul1 Aug