1 message in com.mysql.lists.gui-toolsPossible Bug?
FromSent OnAttachments
Jason Reid13 Apr 2003 09:11 
Subject:Possible Bug?
From:Jason Reid (jas@exumweb.net)
Date:04/13/2003 09:11:59 AM
List:com.mysql.lists.gui-tools

From what I'm thinking, if you remove the value from a field, it should default
back to NULL (or give an error if the field isn't allowed to be NULL). However
when I try doing this using the latest version, and all previous ones, it gives
a nice error, as mysqlcc produces a query looking like this:

UPDATE `Table` SET `Field`= WHERE `Column`=1

which I'd have to say probably should be:

UPDATE `Table` SET `Field`= NULL WHERE `Column`=1

This only appears to occur in the case of interger fields, as varchar, char and
text fields do not seem to have this happen.

Hopefully I'm correct that this is probaly how it should be.