id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
19467,wpdb does not always set rows_affected or insert_id properties when needed,GeertDD,nacin,"If SQL keywords like `INSERT` or `UPDATE` are not followed by a space, the `rows_affected` and `insert_id` properties of the `wpdb` class are not updated. Those keywords might be followed by a newline or a tab character. A simple regex tweak fixes this issue.

{{{
#!php
<?php

// Note the newline after ""UPDATE""
$wpdb->query('
	UPDATE
	test_table
	SET foo = ""bar""
	WHERE id = 5
');

// Should not be int(0) in this case
var_dump($wpdb->rows_affected);
}}}",defect (bug),closed,normal,3.5,Database,3.3,minor,fixed,has-patch commit,bpetty Bellfalasch