The MySQL Bug ?

[Dyego Souza do Carmo]

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 : [phone]
look: cannot open my eyes Fax : [phone]
-------------------------------------------------------------------------
Reply: dy***@escriba.com.br
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw