Hello Jerome,

Sergei Golubchik will review your patch.

Thanks!


On 05/05/2017 07:24 PM, jerome brauge wrote:
> Hello everyone,
> I've done a patch for MDEV-12137 based on branch bb-10.2-ext (DELETE 
> statement with the same source and target).
> At this time the patch is for all sql_mode.
> It could be interesting to add an information in explain plan to indicate the 
> extra step.
> Something like :
> +------+--------------------+------------+------+---------------+---------------+---------+--------------------+------+-------------+
> | id   | select_type        | table      | type | possible_keys | key         
>   | key_len | ref                | rows | Extra       |
> +------+--------------------+------------+------+---------------+---------------+---------+--------------------+------+-------------+
> |    1 | DELETE             | tab_delete | RND  | NULL          | NULL        
>   | NULL    | NULL               |    1 | Using rowid |
> |    1 | PRIMARY            | tab_delete | ALL  | NULL          | NULL        
>   | NULL    | NULL               |    1 | Using where |
> |    2 | DEPENDENT SUBQUERY | b          | ref  | tab_delete_c1 | 
> tab_delete_c1 | 4       | test.tab_delete.c1 |    1 | Using index |
> +------+--------------------+------------+------+---------------+---------------+---------+--------------------+------+-------------+
> 
> Can anyone review it ?
> 
> Best regards,
> Jérôme.
> 
> 

_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to