From e2285c541b027503e3040a85fc618f9c6357a91e Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 30 May 2005 20:48:40 +0300 Subject: Fixed bug in multiple-table-delete where some rows was not deleted mysql-test/r/delete.result: Test case for bug in multiple-table-delete where some rows was not deleted mysql-test/t/delete.test: Test case for bug in multiple-table-delete where some rows was not deleted sql/item_subselect.cc: Code cleanup sql/opt_range.cc: Code cleanup sql/sql_delete.cc: Fixed bug in multiple-table-delete where some rows was not deleted This happend when the first table-to-delete-from was not the the table that was scanned. Fixed this by only doing 'delete-on-the-fly' for the first table. Fixed also some wrong error handling in multi-table-delete --- sql/item_subselect.cc | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'sql/item_subselect.cc') diff --git a/sql/item_subselect.cc b/sql/item_subselect.cc index 0fbcf32a83c..7f8f0d5d527 100644 --- a/sql/item_subselect.cc +++ b/sql/item_subselect.cc @@ -773,9 +773,8 @@ Item_in_subselect::single_value_transformer(JOIN *join, Comp_creator *func) { Item_subselect::trans_res result= RES_ERROR; - DBUG_ENTER("Item_in_subselect::single_value_transformer"); - SELECT_LEX *select_lex= join->select_lex; + DBUG_ENTER("Item_in_subselect::single_value_transformer"); /* Check that the right part of the subselect contains no more than one -- cgit v1.2.1