maria-developers team mailing list archive

[jerome brauge <j.brauge@xxxxxxxxxxx>]

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.

Attachment: delete_source.diff
Description: delete_source.diff