I can however understand that some applications may want to check the result from the above query (Thats why I added CLIENT_FOUND_ROWS in the first place).

On the other hand, I can also think of applications that really want to know if the status really did change (as this may indicate that some other client did change the status first). This is actually VERY useful and it's a pity that most other databases doesn't support this!

Tim> Assuming it's made an option then the fix for the rare soul who Tim> actually wants a 'physically modified' count will be trivial.

I agree.

Tim> Meanwhile, I'll leave you with this rather sad bit of code I found in Tim> the Catalog.pm support modules:

Tim> my $affected = $stmt->execute() or ... Tim> # Tim> # Return 1 if update occured at least on a row, even Tim> # if nothing was modified in that row. Tim> # Tim> $ret = 1 unless $affected == 0 and $stmt->{info} =~ /matched: 0 /;

I agree that the above is very sad! It will only work if you are using MySQL with the English language file!

It should be:

$ret = 1 unless $affected == 0 and $stmt->{info} =~ /^[^:]: 0 /;