At 6:00p -0400 on 21 Oct 2007, andy wrote:
> I think your comparing apples and oranges.
That's why I ask the list! To learn when I'm doing that. ;-)
> I'll bet that mysql is
> taking a shortcut and testing the value before updating it.
Heh. And as Tom points out downthread, that "shortcut" probably doesn't
gain anything in the long run.
Kevin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
