Re: multi-table delete bug - Sinisa Milivojevic - com.mysql.lists.bugs

4 messages in com.mysql.lists.bugsRe: multi-table delete bug

From	Sent On	Attachments
Sinisa Milivojevic	25 May 2002 03:57
Jocelyn Fournier	27 May 2002 04:29
Sinisa Milivojevic	27 May 2002 07:24
Sinisa Milivojevic	29 May 2002 11:17

Subject:	Re: multi-table delete bug
From:	Sinisa Milivojevic (sin...@mysql.com)
Date:	05/29/2002 11:17:40 AM
List:	com.mysql.lists.bugs

Jocelyn Fournier writes:

Hi,

I've just taken a look to return_zero_rows. I added DBUG entry before each return_zero_rows call in sql_select.cc and it appears the following condition calls return_zero_rows in my testcase :

[skip]

Hope this could help.

Regards, Jocelyn

Hi!

Thank you for your bug report.

It was very difficult to repeat your case as bug was due to an unitialized field, which took random values, so it worked on some systems ....

Here is a patch that fixes a problem :

===== /mnt/hdc/Sinisa/mysql-4.0/sql/sql_parse.cc 1.227 vs edited ===== *** /tmp/sql_parse.cc-1.227-14955 Wed May 29 15:21:03 2002 --- edited//mnt/hdc/Sinisa/mysql-4.0/sql/sql_parse.cc Wed May 29 21:03:24 2002 *************** *** 1792,1797 **** --- 1792,1798 ---- tables->grant.want_privilege=(SELECT_ACL & ~tables->grant.privilege); if ((res=open_and_lock_tables(thd,tables))) break; + thd->select_limit=HA_POS_ERROR; if (!setup_fields(thd,tables,select_lex->item_list,1,0,0) && !setup_fields(thd,tables,lex->value_list,0,0,0) && ! thd->fatal_error && (result=new multi_update(thd,tables,select_lex->item_list,lex->duplicates, *************** *** 2741,2747 **** { lex->sql_command = SQLCOM_DELETE_MULTI; mysql_init_select(lex); ! lex->select->select_limit=HA_POS_ERROR; lex->auxilliary_table_list=lex->select_lex.table_list; lex->select->table_list.elements=0; lex->select->table_list.first=0; --- 2742,2748 ---- { lex->sql_command = SQLCOM_DELETE_MULTI; mysql_init_select(lex); ! lex->select->select_limit=lex->thd->select_limit=HA_POS_ERROR; lex->auxilliary_table_list=lex->select_lex.table_list; lex->select->table_list.elements=0; lex->select->table_list.first=0;