Hi,

I'd found a bug when I'd tried to use blob fields and innoDb. To see the bug, do the follow:

*) Create a database. *) Import the dump file that is attached to this e-mail. (cfgimpressao.dump) *) Use the following commands:

select Ci_Descricao from cfgimpressao; You will see that there is a row where Ci_Descricao is "Padrão".

source mysql_blob_bug.sql

select Ci_Descricao from cfgimpressao; Now, the record where Ci_Descricao is "Padrão" has disappear. The script you just executed didn't erase that. There are only update commands to change the blob contents.

The bug is: The record where Ci_Descricao is "Padrão" mustn't be erased.

The files are:

cfgimpressao.dump <- The Dump Of Table mysql_blob_bug.sql <- The File of Blob Bug

stored in the support.mysql.com/pub/mysql/secret

Tnks in advance !

innodb,mysql,help !

------------------------------------------------------------------------- ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento

------------------------------------------------------------------------- E S C R I B A I N F O R M A T I C A

------------------------------------------------------------------------- The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- ICQ : 1647350 $ look into "my eyes" Phone : +55 041 296-2311 look: cannot open my eyes Fax : +55 041 296-6640