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 3.0.13.33809 2025.05.06 28ad0 P P 1128 538 2025.06.30 15:06:37.768 2025.06.30 15:06:38.896 2025.06.30 14:09:53.509 2025.06.30 14:09:54.047
2 3.0.13.33808 2025.04.25 28426 P P 1243 679 2025.05.06 14:09:25.339 2025.05.06 14:09:26.582 2025.05.06 13:02:28.151 2025.05.06 13:02:28.830
3 3.0.13.33803 2025.02.25 08ebd P P 1325 687 2025.04.25 17:24:19.259 2025.04.25 17:24:20.584 2025.04.25 16:18:03.819 2025.04.25 16:18:04.506
4 3.0.13.33796 2025.01.29 0ab85 P P 981 500 2025.02.25 15:56:47.022 2025.02.25 15:56:48.003 2025.02.25 14:50:21.051 2025.02.25 14:50:21.551
5 3.0.13.33796 2025.01.14 99b3b P P 944 535 2025.01.28 18:11:57.358 2025.01.28 18:11:58.302 2025.01.28 17:03:23.647 2025.01.28 17:03:24.182
6 3.0.13.33795 2024.11.24 b8847 P P 984 516 2025.01.13 15:48:50.869 2025.01.13 15:48:51.853 2025.01.13 14:41:43.270 2025.01.13 14:41:43.786
7 3.0.13.33794 2024.10.15 abe09 P P 767 379 2024.11.23 06:49:47.290 2024.11.23 06:49:48.057 2024.11.23 05:59:18.670 2024.11.23 05:59:19.049
8 3.0.13.33793 2024.10.04 82ccc P P 922 439 2024.10.14 04:47:47.389 2024.10.14 04:47:48.311 2024.10.14 03:51:26.901 2024.10.14 03:51:27.340
9 3.0.13.33792 2024.08.31 d8791 P P 1016 434 2024.10.03 09:55:29.404 2024.10.03 09:55:30.420 2024.10.03 08:55:16.486 2024.10.03 08:55:16.920
10 3.0.13.33787 2024.08.17 2e0d6 P P 2913 1351 2024.08.25 16:07:03.446 2024.08.25 16:07:06.359 2024.08.25 13:53:10.739 2024.08.25 13:53:12.090

Elapsed time, ms. Chart for last 10 runs:

Last commits information (all timestamps in UTC):