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