On Mon, May 31, 1999 at 12:25:49PM +0200, Michael Widenius wrote:
Hi!
You can currently get the above behaviour if you add the flag
CLIENT_FOUND_ROWS to the last argument of mysql_real_connect().
One problem is that ANY SQL server is allowed to optimize the query:
UPDATE foo SET col=col
to
UPDATE foo SET col=col WHERE col<>col
I think that one should strongly discourage the use of affected rows in the
above manner as any SQL server may add the above optimisation in any
updated version!
What makes you say that? Specifically. Is it specified somewhere in
a standards document somewhere? (The word "affected" is, sadly, rather
too ambiguous to be relied upon by itself.)
I know of no other SQL server that does that. Do you?
Tim.
12 messages in com.mysql.lists.perlRe: Drivers giving different results
