1
0
mirror of https://github.com/MariaDB/server.git synced 2026-10-23 18:49:29 +03:00
Files
bsrikanth-mariadb bd366d81b8 MDEV-39942: use actual_rec_per_key in loose scan sj optimization
While performing loose scan semi-join optimization in
Loose_scan_opt::check_ref_access_part1() [opt_subselect.h],
the filtered value in the explain plan was in-consistent for a table
with index when same data was inserted using "insert into t1 values()...",
and "insert into t1 select * from t2". This is noticed when
rec_per_key[] was used to get the number of records during optimization.

However, when actual_rec_per_key() is used to get the number of records,
we don't notice this discrepancy.

This PR changes the rec_per_key[] usage to actual_rec_per_key() in the
method Loose_scan_opt::check_ref_access_part1() [opt_subselect.h]
2026-07-01 09:36:53 +05:30
..
2026-06-16 12:24:32 +02:00
2026-06-15 16:53:03 +02:00
…
2025-07-28 21:29:29 +02:00
2024-11-05 14:00:48 -08:00
2025-09-29 18:25:09 +03:00
…
2025-03-14 12:08:56 +04:00
2026-02-16 21:55:18 +01: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
2026-01-31 14:08:54 +01:00
2024-10-30 15:11:17 +01:00
…
2026-01-31 14:08:54 +01:00
2026-06-29 07:41:06 +03:00
2024-12-02 11:35:34 +02:00
2026-05-26 21:15:58 +02:00
2026-03-24 09:49:17 +02:00
2026-03-24 09:49:17 +02:00
…
…
2026-05-26 21:15:58 +02:00
2026-06-15 16:53:03 +02:00
2026-05-26 21:15:58 +02:00
2024-11-29 13:43:17 +02:00
…
…
2026-05-26 21:15:58 +02:00
2024-12-05 10:11:58 +01:00
2026-06-29 07:40:04 +03:00
2026-02-03 14:53:15 +01:00
2026-06-29 07:40:04 +03:00
2026-05-26 21:15:58 +02:00
2026-02-03 14:53:15 +01:00
2026-02-03 14:53:15 +01:00
2026-02-03 14:53:15 +01:00
2026-06-23 12:52:39 +02:00
2026-06-29 07:41:06 +03:00
2026-03-24 09:49:17 +02:00
2026-01-31 14:08:54 +01:00
2026-04-01 15:03:59 +03:00
2026-04-02 09:15:17 +03:00
2026-01-08 12:02:45 +01:00
2024-07-08 22:40:16 +02:00
2026-05-26 21:15:58 +02:00
2026-06-16 12:24:32 +02:00
…
2026-06-16 12:24:32 +02:00
2026-06-15 16:53:03 +02:00
2026-06-16 12:44:36 +02:00
2026-06-16 15:03:05 +02:00
2026-05-26 21:15:58 +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
2026-05-26 21:15:58 +02:00
2026-06-29 08:38:07 +03:00
2026-05-26 21:15:58 +02:00
2025-04-02 14:07:01 +03:00
2026-05-26 21:15:58 +02:00
2026-02-03 14:53:15 +01:00
2026-05-26 21:15:58 +02:00
2026-02-03 14:53:15 +01:00
2024-06-24 13:09:47 +03:00
2026-05-08 08:00:01 +02:00
2026-03-27 14:15:54 +01:00
2026-01-31 14:08:54 +01:00
2026-05-26 21:15:58 +02:00
2026-02-03 14:53:15 +01:00
2025-09-29 18:25:09 +03:00
2024-07-22 15:14:50 +02:00
2026-05-26 21:15:58 +02:00
2026-05-26 21:15:58 +02:00
2026-02-07 22:06:40 +01:00
2026-05-26 21:15:58 +02:00
2026-06-16 12:24:32 +02:00
2025-07-31 20:55:47 +02:00
2026-05-08 08:00:01 +02:00
2026-02-07 22:06:40 +01:00
2026-06-16 12:24:32 +02:00
2026-06-15 16:53:03 +02:00
2026-06-15 16:53:03 +02:00
2025-03-14 12:08:56 +04:00
2026-04-02 09:15:17 +03:00
2026-05-26 21:15:58 +02:00
2026-05-26 21:15:58 +02:00
2026-06-16 12:24:32 +02:00
2026-02-06 17:46:50 +01:00
2025-11-04 12:39:27 +01:00
2026-06-16 12:24:32 +02:00
2026-06-16 12:24:32 +02:00
2026-05-26 21:15:58 +02:00
2026-06-16 12:24:32 +02:00
2026-02-06 17:46:51 +01:00
2026-06-29 07:40:04 +03:00
2026-01-08 12:02:45 +01:00
2025-09-04 18:08:39 +03:00
2026-05-26 21:15:58 +02:00
2026-02-16 21:55:18 +01:00
2026-05-26 21:15:58 +02:00
2024-06-24 13:09:47 +03:00
2026-05-26 21:15:58 +02:00
2026-06-15 15:15:10 +02:00
2026-06-15 15:15:10 +02:00
2026-01-08 21:41:40 +01:00
2026-05-26 21:15:58 +02:00
2026-04-02 09:15:17 +03:00
2026-01-31 14:08:54 +01:00
2026-01-05 20:34:44 +01:00
2026-06-24 12:27:13 +02:00
2026-03-24 09:49:17 +02:00
2026-06-29 07:40:04 +03:00
2026-01-08 12:02:45 +01:00
2026-05-26 21:15:58 +02:00
2026-02-06 17:46:51 +01:00
2026-03-17 18:57:42 +01:00
2026-06-29 07:40:04 +03:00
…
2026-02-06 17:46:51 +01:00
2026-02-06 17:46:51 +01:00
2025-09-29 18:25:09 +03:00
2024-06-27 10:26:09 +03:00
2025-08-04 12:05:53 +02:00
2024-12-02 17:51:17 +02:00
2026-05-27 12:49:36 +02:00
2025-09-19 12:31:14 +03:00
2026-06-16 12:24:32 +02:00
2026-05-26 21:15:58 +02:00
2025-03-14 12:08:56 +04:00
2026-05-26 21:15:58 +02:00
2024-07-03 12:45:30 +02:00
2026-06-15 16:53:03 +02:00
2026-04-17 09:31:38 +10:00
2026-05-26 21:15:58 +02:00
2025-01-09 09:41:38 +02:00
2026-05-26 21:15:58 +02:00
2024-12-02 17:51:17 +02:00
2026-02-03 14:53:15 +01:00
2026-06-29 07:41:06 +03:00
2026-05-27 12:49:36 +02:00
2026-05-26 21:15:58 +02:00
2026-05-26 21:15:58 +02:00
2026-03-24 09:49:17 +02:00
2026-05-27 12:49:36 +02:00
2026-04-01 10:49:05 +03:00
2026-05-27 12:49:36 +02:00
2026-02-07 22:12:32 +01:00
2025-04-29 11:18:00 +10:00
2026-05-26 21:15:58 +02:00
…
2026-05-22 09:52:05 +02:00
2026-05-22 09:52:05 +02:00
2026-05-22 09:52:05 +02:00
2026-06-16 15:03:05 +02:00
2025-03-14 12:08:56 +04:00
2024-12-02 17:51:17 +02:00
2026-05-26 21:15:58 +02:00
2026-05-26 21:15:58 +02:00
2026-05-26 21:15:58 +02:00
2026-06-15 16:53:03 +02:00
2026-06-29 08:38:07 +03:00
2026-06-23 12:52:39 +02:00
2026-05-26 21:15:58 +02:00
2026-06-24 12:27:13 +02:00
2026-05-26 21:15:58 +02:00
2026-05-26 21:15:58 +02:00
2025-04-29 11:18:00 +10:00
2026-03-24 09:49:17 +02:00
2025-09-04 18:08:39 +03:00
2024-06-24 13:09:47 +03:00
2025-03-14 12:08:56 +04:00
2026-05-22 09:52:05 +02: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
2026-06-16 12:24:32 +02:00
2025-11-28 12:56:27 +02:00
2024-06-27 10:26:09 +03:00
2026-06-16 15:03:05 +02:00
2026-06-21 15:32:20 +02:00
2026-06-15 16:53:03 +02:00
2026-04-02 09:15:17 +03:00
2024-10-03 13:24:43 +03:00
2024-09-09 13:50:38 +03:00
2026-06-25 14:49:32 +02:00
2026-02-07 22:12:32 +01:00
2026-06-23 12:52:39 +02:00
2026-06-23 12:52:39 +02:00
2026-06-25 14:49:32 +02:00