From: Daevid Vincent
Date: May 7 2003 4:03am
Subject: Bug with CONCAT and NULL values?
List-Archive: http://lists.mysql.com/mysql/139304
Message-Id: <008b01c3144d$967456f0$b60aa8c0@Locutus>
MIME-Version: 1.0
Content-Type: text/plain;	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Is this a bug? It seems that if I have a "ku_appliance_notes text" field
defined in a schema, then this UPDATE will fail. It will work however if =
I
change the schema to "ku_appliance_notes text NOT NULL,". So it appears =
that
CONCAT will not work if the original value is NULL. *sigh*

UPDATE sku_appliance_table SET sku_appliance_notes =3D CONCAT('Daevid
Wrote:<BR>',sku_appliance_notes) WHERE sku_appliance_id =3D '1' LIMIT 1;

Also, I tried to set the default in the schema to "default ''", but it =
seems
that it doesn't take.