bugs.gh_4954_test. subselect losing the index when where clause includes coalesce() [CORE4640]

Show cross-report outcomes.
Full history of outcomes and elapsed time, ms:
NN SNAP_INFO CS_outcome SS_outcome CS_run_time SS_run_time CS_run_beg CS_run_end SS_run_beg SS_run_end
1 4.0.6.3189 2025.02.25 1a1a5 P P 711 529 2025.06.30 13:08:59.340 2025.06.30 13:09:00.051 2025.06.30 12:09:45.914 2025.06.30 12:09:46.443
2 4.0.6.3184 2025.02.24 9388c P P 718 475 2025.02.25 10:50:48.832 2025.02.25 10:50:49.550 2025.02.25 09:34:40.687 2025.02.25 09:34:41.162
3 4.0.6.3183 2025.02.17 e4762 P P 712 467 2025.02.24 11:22:54.482 2025.02.24 11:22:55.194 2025.02.24 10:25:04.119 2025.02.24 10:25:04.586
4 4.0.6.3169 2024.12.13 42cc1 P P 725 481 2025.02.14 08:10:55.305 2025.02.14 08:10:56.030 2025.02.14 07:12:54.934 2025.02.14 07:12:55.415
5 4.0.6.3169 2024.12.08 50eb6 P P 715 466 2024.12.11 11:07:25.744 2024.12.11 11:07:26.459 2024.12.11 10:09:47.909 2024.12.11 10:09:48.375
6 4.0.6.3168 2024.12.07 98d69 P P 732 478 2024.12.08 03:50:39.522 2024.12.08 03:50:40.254 2024.12.08 02:51:27.788 2024.12.08 02:51:28.266
7 4.0.6.3168 2024.12.05 cee43 P P 717 485 2024.12.06 03:54:11.498 2024.12.06 03:54:12.215 2024.12.06 02:56:08.199 2024.12.06 02:56:08.684
8 4.0.6.3168 2024.11.28 48149 P P 732 481 2024.12.03 10:47:24.052 2024.12.03 10:47:24.784 2024.12.03 09:50:32.335 2024.12.03 09:50:32.816
9 4.0.6.3163 2024.10.30 832db P P 797 505 2024.11.28 10:46:05.048 2024.11.28 10:46:05.845 2024.11.28 09:49:27.489 2024.11.28 09:49:27.994
10 4.0.6.3163 2024.10.16 2bb10 P P 754 478 2024.10.30 10:55:05.885 2024.10.30 10:55:06.639 2024.10.30 09:58:13.516 2024.10.30 09:58:13.994
11 4.0.6.3147 2024.09.10 a4d11 P P 727 482 2024.10.16 04:02:34.235 2024.10.16 04:02:34.962 2024.10.16 02:46:43.648 2024.10.16 02:46:44.130
12 4.0.6.3147 2024.08.31 4655b P P 929 497 2024.09.10 10:59:59.640 2024.09.10 11:00:00.569 2024.09.10 09:59:37.932 2024.09.10 09:59:38.429
13 4.0.6.3140 2024.08.16 1dd8b P P 801 564 2024.09.01 11:22:40.061 2024.09.01 11:22:40.862 2024.09.01 10:04:25.890 2024.09.01 10:04:26.454

Elapsed time, ms. Chart for last 13 runs:

Last commits information (all timestamps in UTC):