1
0
mirror of https://github.com/MariaDB/server.git synced 2025-07-30 16:24:05 +03:00
Files
bsrikanth-mariadb db937cc971 MDEV-37207: dumping tables for multi delete query doesn't work always
It was observed that, when doing multiple DELETE on tables:
-> if there was duplicate data to delete, then no ddls were dumped to the trace.
-> However, when tested with no data being deleted from the tables,
   then ddls of the tables were getting dumped to the trace.

The problem is that store_tables_context_in_trace() is not getting
invoked, from mysql_execute_command() in all the situations.

The reason is that multi-table DELETE returned error when it had deleted duplicate rows.
Multi-table DELETE actually finds record combinations to delete,
and when it has found let's say {t1.rowX, t2.rowY, t3.rowZ}, it will attempt to
save t1.rowX in the temptable for t1, t2.rowY in the temptable for t2 and so forth.
When saving the row to be deleted, in the temp table, it can encounter error
121 (HA_ERR_FOUND_DUPP_KEY), and it is propagated to the caller.

As a fix, I have marked that there is no error when HA_ERR_FOUND_DUPP_KEY error_code is
noticed in the multi_delete::send_data()
2025-06-28 07:35:08 -04:00
..
2025-03-14 12:08:56 +04:00
2025-06-18 07:50:39 +02:00
2024-08-12 09:32:30 +01:00
2024-11-13 16:38:53 +01:00
2024-11-10 19:22:21 +01:00
2024-11-05 14:00:48 -08:00
2024-11-05 14:00:48 -08:00
2025-06-18 07:50:39 +02:00
2024-12-02 17:51:17 +02:00
2024-01-19 09:07:48 +02:00
2025-03-14 12:08:56 +04:00
2025-03-14 12:08:56 +04:00
2024-12-02 11:35:34 +02:00
2024-12-02 17:51:17 +02:00
2024-12-02 17:51:17 +02:00
2024-10-30 15:11:17 +01:00
2025-02-06 16:46:36 +01:00
2024-12-02 11:35:34 +02:00
2025-05-22 09:22:55 +02:00
2023-12-21 02:14:59 +01:00
2024-01-27 12:09:54 +01:00
2024-01-27 12:09:54 +01:00
2024-11-08 07:17:00 +01:00
2025-06-18 07:50:39 +02:00
2025-06-18 07:50:39 +02:00
2024-11-29 13:43:17 +02:00
2025-05-22 09:22:55 +02:00
2024-12-05 10:11:58 +01:00
2025-05-22 09:22:55 +02:00
2025-05-22 09:22:55 +02:00
2024-07-16 15:54:22 +08:00
2024-07-16 15:54:22 +08:00
2025-04-18 17:11:01 +02:00
2025-04-22 16:26:36 -04:00
2025-05-22 09:22:55 +02:00
2025-04-29 11:18:00 +10:00
2025-04-29 11:18:00 +10:00
2025-05-22 09:22:55 +02:00
2024-11-10 19:22:21 +01:00
2025-05-22 09:22:55 +02:00
2024-07-22 15:14:50 +02:00
2024-12-02 11:35:34 +02:00
2024-12-02 11:35:34 +02:00
2024-12-02 11:35:34 +02:00
2024-12-02 17:51:17 +02:00
2024-07-08 22:40:16 +02:00
2025-05-03 12:06:36 +02:00
2025-04-29 11:18:00 +10:00
2025-04-18 17:11:01 +02:00
2025-05-22 09:22:55 +02:00
2025-05-22 09:22:55 +02:00
2025-03-14 12:08:56 +04:00
2024-10-03 15:59:20 +10:00
2025-03-14 12:08:56 +04:00
2024-11-29 12:37:46 +02:00
2024-05-30 16:04:00 +03:00
2025-04-29 11:18:00 +10:00
2025-04-02 14:07:01 +03:00
2025-04-29 11:18:00 +10:00
2025-06-18 07:50:39 +02:00
2024-10-30 15:11:17 +01:00
2025-05-22 09:22:55 +02:00
2024-06-24 13:09:47 +03:00
2025-05-22 09:22:55 +02:00
2024-12-02 17:51:17 +02:00
2024-12-02 11:35:34 +02:00
2024-12-02 17:51:17 +02:00
2024-07-22 15:14:50 +02:00
2025-04-29 11:18:00 +10:00
2025-03-14 12:08:56 +04:00
2025-05-22 09:22:55 +02:00
2025-05-22 09:22:55 +02:00
2025-05-22 09:22:55 +02:00
2025-03-14 12:08:56 +04:00
2025-03-14 12:08:56 +04:00
2025-01-29 11:17:38 +01:00
2025-05-03 12:06:36 +02:00
2024-12-02 17:51:17 +02:00
2025-05-22 09:22:55 +02:00
2025-05-22 09:22:55 +02:00
2025-04-18 17:11:01 +02:00
2024-12-02 17:51:17 +02:00
2024-12-05 09:20:36 +01:00
2025-05-03 12:06:36 +02:00
2025-06-18 07:50:39 +02:00
2024-06-24 13:09:47 +03:00
2024-12-02 17:51:17 +02:00
2024-12-02 17:51:17 +02:00
2025-06-18 07:50:39 +02:00
2025-05-22 09:22:55 +02:00
2024-01-18 19:22:23 +02:00
2025-05-22 09:22:55 +02:00
2025-06-18 07:50:39 +02:00
2025-04-29 11:18:00 +10:00
2025-03-14 12:08:56 +04:00
2025-03-14 12:08:56 +04:00
2025-03-14 12:08:56 +04:00
2025-03-03 11:07:56 +02:00
2025-05-22 09:22:55 +02:00
2024-06-27 10:26:09 +03:00
2024-12-02 17:51:17 +02:00
2025-05-22 09:22:55 +02:00
2025-04-26 10:47:03 +02:00
2025-05-22 09:22:55 +02:00
2025-05-22 09:22:55 +02:00
2025-04-29 11:18:00 +10:00
2025-03-14 12:08:56 +04:00
2024-07-03 12:45:30 +02:00
2025-01-09 09:41:38 +02:00
2025-06-18 07:50:39 +02:00
2023-12-17 11:20:43 +01:00
2024-12-02 17:51:17 +02:00
2025-04-29 11:18:00 +10:00
2025-06-18 09:27:49 +02:00
2025-03-14 12:08:56 +04:00
2025-05-22 09:22:55 +02:00
2025-06-18 09:27:49 +02:00
2025-04-29 11:18:00 +10:00
2025-03-14 12:08:56 +04:00
2025-03-14 12:08:56 +04:00
2024-12-02 17:51:17 +02:00
2025-06-18 07:50:39 +02:00
2025-05-22 09:22:55 +02:00
2024-12-02 17:51:17 +02:00
2025-06-18 07:50:39 +02:00
2024-01-10 18:01:46 +11:00
2025-04-29 11:18:00 +10:00
2024-06-24 13:09:47 +03:00
2025-06-18 07:50:39 +02:00
2025-03-14 12:08:56 +04:00
2024-12-02 17:51:17 +02:00
2024-12-02 11:35:34 +02:00
2025-03-14 12:08:56 +04:00
2025-03-14 12:08:56 +04:00
2025-03-14 12:08:56 +04:00
2023-11-21 15:43:20 +01:00
2024-01-02 17:37:58 +02:00
2024-06-27 10:26:09 +03:00
2025-06-18 07:50:39 +02:00
2024-05-10 20:02:18 +02:00
2024-01-03 15:55:17 +02:00
2025-06-18 07:43:24 +02:00
2025-06-18 07:50:39 +02:00
2024-10-03 13:24:43 +03:00
2024-09-09 13:50:38 +03:00
2025-04-18 17:11:01 +02:00
2025-02-06 16:46:36 +01:00
2024-11-08 07:17:00 +01:00
2025-03-03 11:07:56 +02:00