setting DATE field to NULL yields inconsistent behavior

[Michael Widenius]

Hi!

>>>>> "tbrannon" == tbrannon  <tbrannon@stripped> writes:

>> Description:
tbrannon> The same command applied to 2 different records of a table yields
tbrannon> different results.
>> How-To-Repeat:
tbrannon> use UPDATE to bind the DATE field to NULL. In one application you
tbrannon> get back a NULL. On another, you get '0000-00-00'.
>> Fix:
tbrannon> Wish I knew :-)

<cut>

The problem is that check if the row did change failed in MySQL
3.23.3. This is fixed in MySQL 3.23.8.

Regards,
Monty