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 719 517 2025.06.29 15:44:08.779 2025.06.29 15:44:09.498 2025.06.29 14:29:58.099 2025.06.29 14:29:58.616
2 4.0.6.3184 2025.02.24 9388c P P 772 559 2025.02.25 13:37:30.463 2025.02.25 13:37:31.235 2025.02.25 12:19:04.078 2025.02.25 12:19:04.637
3 4.0.6.3183 2025.02.16 cf6ca P P 763 563 2025.02.17 07:31:21.630 2025.02.17 07:31:22.393 2025.02.17 06:12:28.319 2025.02.17 06:12:28.882
4 4.0.6.3169 2024.12.13 42cc1 P P 775 528 2025.02.16 04:29:02.350 2025.02.16 04:29:03.125 2025.02.16 03:12:03.877 2025.02.16 03:12:04.405
5 4.0.6.3169 2024.12.08 50eb6 P P 645 389 2024.12.12 18:48:24.747 2024.12.12 18:48:25.392 2024.12.12 17:46:56.162 2024.12.12 17:46:56.551
6 4.0.6.3168 2024.11.28 48149 P P 578 405 2024.12.06 03:09:47.278 2024.12.06 03:09:47.856 2024.12.06 02:09:49.884 2024.12.06 02:09:50.289
7 4.0.6.3163 2024.10.16 2bb10 P P 610 420 2024.11.27 13:34:03.634 2024.11.27 13:34:04.244 2024.11.27 10:33:10.846 2024.11.27 10:33:11.266
8 4.0.6.3163 2024.10.15 f387e P P 566 359 2024.10.16 04:40:00.768 2024.10.16 04:40:01.334 2024.10.16 03:42:54.038 2024.10.16 03:42:54.397
9 4.0.6.3147 2024.08.31 4655b P P 551 420 2024.09.30 11:55:04.462 2024.09.30 11:55:05.013 2024.09.30 10:51:22.836 2024.09.30 10:51:23.256
10 4.0.6.3140 2024.08.16 1dd8b P P 1486 699 2024.08.31 18:19:11.091 2024.08.31 18:19:12.577 2024.08.31 16:24:53.041 2024.08.31 16:24:53.740

Elapsed time, ms. Chart for last 10 runs:

Last commits information (all timestamps in UTC):