• unknown's avatar
    Bug#20691: DATETIME col (NOT NULL, NO DEFAULT) may insert garbage when \ · 19d61b1b
    unknown authored
    	specifying DEFAULT
    
    This was not specific to datetime.  When there is no default value 
    for a column, and the user inserted DEFAULT, we would write 
    uninitialized memory to the table.  
    
    Now, insist on writing a default value, a zero-ish value, the same 
    one that comes from inserting NULL into a not-NULL field.
    
    (This is, at best, really strange behavior that comes from allowing 
    sloppy usage, and serves as a good reason always to run one's server 
    in a strict SQL mode.)
    
    
    mysql-test/r/default.result:
      Verify that all kinds of types work, even others other than datetime.
    mysql-test/t/default.test:
      Verify that all kinds of types work, even others other than datetime.
    sql/item.cc:
      Even if we warn that there is no default value in the table definition,
      we have to insert /something/.
    19d61b1b
default.test 5.15 KB