[wp-trac] Re: [WordPress Trac] #9224: sql-mode 'TRADITIONAL' breaks installation

[WordPress Trac]

#9224: sql-mode 'TRADITIONAL' breaks installation
--------------------------+-------------------------------------------------
 Reporter:  tsunami7      |       Owner:  anonymous        
     Type:  defect (bug)  |      Status:  new              
 Priority:  normal        |   Milestone:  2.8              
Component:  General       |     Version:  2.7              
 Severity:  normal        |    Keywords:  reporter-feedback
--------------------------+-------------------------------------------------

Comment(by tsunami7):

 See http://dev.mysql.com/doc/refman/5.1/en/server-sql-
 mode.html#sqlmode_traditional

 Zero dates are not allowed when using TRADITIONAL.  This mode is used to
 "Make MySQL behave like a “traditional” SQL database system. A simple
 description of this mode is “give an error instead of a warning” when
 inserting an incorrect value into a column." - from the top of that
 document.

 The reason I found out about this is, the standard configuration of MySQL
 allows you to insert an empty string, even when the column type is an ENUM
 and the field is set to NOT NULL.  This caused a major problem in another
 database, so now I configure all installations to act according the SQL
 standard.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/9224#comment:3>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software