• unknown's avatar
    BUG#14770 - LOAD DATA INFILE doesn't respect default values for · a1bd0bd1
    unknown authored
                columns
    Fixed confusing warning.
    
    Quoting INSERT section of the manual:
    ----
    Inserting NULL into a column that has been declared NOT NULL. For
    multiple-row INSERT statements or INSERT INTO ... SELECT statements, the
    column is set to the implicit default value for the column data type. This
    is 0 for numeric types, the empty string ('') for string types, and the
    "zero" value for date and time types. INSERT INTO ... SELECT statements are
    handled the same way as multiple-row inserts because the server does not
    examine the result set from the SELECT to see whether it returns a single
    row. (For a single-row INSERT, no warning occurs when NULL is inserted into
    a NOT NULL column. Instead, the statement fails with an error.)
    ----
    This is also true for LOAD DATA INFILE. For INSERT user can specify
    DEFAULT keyword as a value to set column default. There is no similiar
    feature available for LOAD DATA INFILE.
    
    
    mysql-test/r/auto_increment.result:
      Fixed confusing warning.
    mysql-test/r/create.result:
      Fixed confusing warning.
    mysql-test/r/insert.result:
      Fixed confusing warning.
    mysql-test/r/insert_select.result:
      Fixed confusing warning.
    mysql-test/r/key.result:
      Fixed confusing warning.
    mysql-test/r/null.result:
      Fixed confusing warning.
    mysql-test/r/null_key.result:
      Fixed confusing warning.
    mysql-test/r/ps_2myisam.result:
      Fixed confusing warning.
    mysql-test/r/ps_3innodb.result:
      Fixed confusing warning.
    mysql-test/r/ps_4heap.result:
      Fixed confusing warning.
    mysql-test/r/ps_5merge.result:
      Fixed confusing warning.
    mysql-test/r/ps_6bdb.result:
      Fixed confusing warning.
    mysql-test/r/strict.result:
      Fixed confusing warning.
    mysql-test/r/view.result:
      Fixed confusing warning.
    mysql-test/r/warnings.result:
      Fixed confusing warning.
    sql/share/errmsg.txt:
      Fixed confusing warning.
    a1bd0bd1
null.result 14.3 KB