Dyego, thank you for an excellent bug report. You probably tested the 4.0.14 tree? That was where I was able to repeat the bug.
The bug was that InnoDB first deleted the old record and only after that tested if the new record is too long (table handler error 139). You have lots of BLOBs in the table, and in 4.0.14 each takes 534 bytes also in the record itself, only the rest is stored externally on a separate page. That was why the max record length 8000 bytes was exceeded. The fix will be in 4.0.15 and 4.1.1. Regards, Heikki ----- Original Message ----- From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 9:14 PM Subject: The MySQL Bug ? > 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 > ------------------------------------------------------------------------- > Reply: [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
