[wp-trac] [WordPress Trac] #14978: MySQL strict mode

WordPress Trac wp-trac at lists.automattic.com
Mon Sep 27 20:36:12 UTC 2010


#14978: MySQL strict mode
-----------------------------+----------------------------------------------
 Reporter:  christian_gnoth  |       Owner:                 
     Type:  feature request  |      Status:  new            
 Priority:  normal           |   Milestone:  Awaiting Review
Component:  General          |     Version:  3.1            
 Severity:  normal           |    Keywords:  close          
-----------------------------+----------------------------------------------

Comment(by Denis-de-Bernardy):

 It can also be worth the effort in the long run, as it'll make some
 potential bugs appear where we're not looking.

 It's a lot of work, however:

 http://core.trac.wordpress.org/ticket/8857#comment:3

 One of the two big changes needed relates to date handlers, but my guess
 is that'll be the easy part.

 The other, which is trickier, relates to wpdb's various escape and prepare
 methods. My guess is we'd end up introducing a %d placeholder for
 "digits"; one that doesn't add quotes but casts to int or float instead.
 We'd additionally need to inject NULL in queries where appropriate, rather
 than empty strings as we're currently doing.

 Both changes will introduce incompatibilities with plugins.

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


More information about the wp-trac mailing list