maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

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.
> 
>