wpdb::query returns FALSE on TRUNCATE

[marcis20]

When executing a "TRUNCATE" SQL query, wpdb returns FALSE (num_rows = 0) although it's succesfull.

Maybe it should be included in the "if" section of the method check:

if ( preg_match("/^\\s*(insert|delete|update|replace|alter) /i",$query) ) {

And returns the "$this->rows_affected" value (1).

[scribu]

For insert|delete|update|replace statements, rows_affected is set correctly.

The problematic ones are DDL statements: CREATE, DROP, TRUNCATE, ALTER etc.

[hakre]

Current trunk still has preg_match("/^\\s*(insert|delete|update|replace|alter) /i",$query) in there.

Related: #11799

[solarissmoke]

Related/duplicate: #16228

[scribu]

11372.diff​ handles CREATE, TRUNCATE and DROP.

[scribu]

Move 'alter' to the first if () as well

[scribu]

Use single quotes, for readability

[ryan]

In [18063]:

Properly handle return value of DDL statements. Props scribu, marcis20. fixes #11372