Dyego Souza do Carmo writes:
> How-To-Repeat:
>
> create table teste ( id integer auto_increment unique,imagem LONGBLOB not null);
> insert into teste (id) values (1);
> update teste set image = (IMG OF 300K) where id = 1;
> select if(imagem is null, "ERRO", "OK") from escriba2.teste where id = 1;
>
> * My System is Linux 2.4.18
> * Table table : MyISAM and InnoDB the crash is same.
> * With "not null" or without "not null" the crash is same.
>
>
> The MySQL 4.0.9 and 4.0.10 ( build from bk tree today ) crash and says this on
> .err file:
>
>
> sql,query
>
> -------------------------------------------------------------------------
> ++ 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
> --
> $ look into "my eyes" Phone : +55 041 296-2311 r.112
> look: cannot open my eyes Fax : +55 041 296-6640
> -------------------------------------------------------------------------
> Reply: [EMAIL PROTECTED]
>
Hi!
Thank you very much for your bug report.
It helped us fix a bug in updating BLOB columns with long strings.
Table was corrupted due to a crash, which is prevented with this
patch:
===== sql/sql_update.cc 1.74 vs edited =====
*** /tmp/sql_update.cc-1.74-30953 Wed Dec 18 18:59:56 2002
--- edited/sql/sql_update.cc Tue Feb 4 19:11:08 2003
***************
*** 116,121 ****
--- 116,122 ----
// Don't count on usage of 'only index' when calculating which key to use
table->used_keys=0;
+ table->copy_blobs=1;
select=make_select(table,0,0,conds,&error);
if (error ||
(select && select->check_quick(safe_update, limit)) || !limit)
***************
*** 474,479 ****
--- 475,481 ----
tl->shared= table_count++;
table->no_keyread=1;
table->used_keys=0;
+ table->copy_blobs=1;
table->pos_in_table_list= tl;
}
}
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
