[wp-trac] Re: [WordPress Trac] #8857: Make WP MySQL strict mode compliant (was: Incorrect Mysql scheme)

[WordPress Trac]

#8857: Make WP MySQL strict mode compliant
--------------------------+-------------------------------------------------
 Reporter:  ghostks       |       Owner:  anonymous     
     Type:  defect (bug)  |      Status:  new           
 Priority:  lowest        |   Milestone:  Future Release
Component:  General       |     Version:  2.7           
 Severity:  minor         |    Keywords:  needs-patch   
--------------------------+-------------------------------------------------
Changes (by Denis-de-Bernardy):

  * keywords:  => needs-patch
  * priority:  normal => lowest
  * severity:  normal => minor
  * milestone:  2.8 => Future Release


Comment:

 the reported bug is valid if and only if you switch mysql's strict mode
 off. but when that is on, essentially nothing works in WP anyway.

 this is one of those huge changes, like getting rid of magic quotes at
 some point. we'd need to do things such as:

  - use null values for dates and datetimes rather than the 0000-00-00
 00:00:00 equivalents
  - not use single quotes on integer values
  - make sure data will fit in the columns
  - the list goes on and on

 if you're in for a good laugh, hop to:

 http://sql-info.de/mysql/gotchas.html

 suggesting wontfix, myself. else needs a big patch and lots of testing,
 because quite a few plugins have come to expect null dates to return
 0000-00-00 00:00:00.

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