bugs.gh_8061_test. Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm

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 5.0.3.1674 2025.06.26 d366d P P 1391 1135 2025.06.27 05:08:53.452 2025.06.27 05:08:54.843 2025.06.27 03:50:03.707 2025.06.27 03:50:04.842
2 5.0.3.1673 2025.06.25 f0e1f P P 1303 1046 2025.06.26 05:13:33.061 2025.06.26 05:13:34.364 2025.06.26 03:54:16.119 2025.06.26 03:54:17.165
3 5.0.3.1668 2025.06.21 b8e22 P P 1412 1224 2025.06.25 05:12:52.504 2025.06.25 05:12:53.916 2025.06.25 03:53:08.541 2025.06.25 03:53:09.765
4 5.0.3.1667 2025.06.15 4374a P P 1405 1067 2025.06.21 04:54:12.983 2025.06.21 04:54:14.388 2025.06.21 03:34:00.840 2025.06.21 03:34:01.907
5 5.0.3.1666 2025.06.14 97178 P P 1305 1100 2025.06.15 05:20:57.632 2025.06.15 05:20:58.937 2025.06.15 04:00:54.550 2025.06.15 04:00:55.650
6 5.0.3.1665 2025.06.11 d8b62 P P 1615 1130 2025.06.14 05:42:48.186 2025.06.14 05:42:49.801 2025.06.14 04:17:39.758 2025.06.14 04:17:40.888
7 5.0.3.1661 2025.06.10 cfcf0 P P 1576 1340 2025.06.11 04:11:00.753 2025.06.11 04:11:02.329 2025.06.11 02:39:56.862 2025.06.11 02:39:58.202
8 5.0.3.1660 2025.06.07 db691 P P 1654 1167 2025.06.10 04:10:00.438 2025.06.10 04:10:02.092 2025.06.10 02:38:00.303 2025.06.10 02:38:01.470
9 5.0.3.1659 2025.05.28 f4c0f P P 1750 1419 2025.06.06 04:07:39.036 2025.06.06 04:07:40.786 2025.06.06 02:35:30.617 2025.06.06 02:35:32.036
10 5.0.3.1658 2025.05.27 e3aa4 P P 1299 1391 2025.05.28 04:23:11.416 2025.05.28 04:23:12.715 2025.05.28 02:49:50.287 2025.05.28 02:49:51.678
11 5.0.3.1657 2025.05.22 a6c19 P P 1782 1444 2025.05.25 04:13:13.184 2025.05.25 04:13:14.966 2025.05.25 02:40:37.023 2025.05.25 02:40:38.467
12 5.0.3.1656 2025.05.12 37a12 P P 1786 1450 2025.05.21 04:10:03.205 2025.05.21 04:10:04.991 2025.05.21 02:37:04.079 2025.05.21 02:37:05.529
13 5.0.3.1654 2025.05.11 789ca P P 1790 1374 2025.05.12 03:49:43.641 2025.05.12 03:49:45.431 2025.05.12 02:15:44.202 2025.05.12 02:15:45.576
14 5.0.3.1653 2025.05.07 8e48a P P 1652 1188 2025.05.08 03:46:06.663 2025.05.08 03:46:08.315 2025.05.08 02:14:54.220 2025.05.08 02:14:55.408
15 5.0.3.1652 2025.05.06 1de2f P P 1654 1274 2025.05.07 03:45:18.214 2025.05.07 03:45:19.868 2025.05.07 02:14:15.238 2025.05.07 02:14:16.512
16 5.0.3.1651 2025.05.05 c8191 P P 1685 1319 2025.05.06 03:43:25.752 2025.05.06 03:43:27.437 2025.05.06 02:12:57.663 2025.05.06 02:12:58.982
17 5.0.3.1650 2025.04.23 41dca P P 1692 1093 2025.05.01 03:36:21.502 2025.05.01 03:36:23.194 2025.05.01 02:04:59.955 2025.05.01 02:05:01.048
18 5.0.3.1649 2025.04.18 da7bd P P 1585 1248 2025.04.23 03:52:59.564 2025.04.23 03:53:01.149 2025.04.23 02:20:52.740 2025.04.23 02:20:53.988
19 5.0.3.1648 2025.04.17 a54ad F F 1851 1559 2025.04.18 03:44:40.575 2025.04.18 03:44:42.426 2025.04.18 02:13:27.019 2025.04.18 02:13:28.578
20 5.0.3.1647 2025.04.14 8993a P P 1752 1309 2025.04.17 03:36:02.438 2025.04.17 03:36:04.190 2025.04.17 02:05:53.416 2025.04.17 02:05:54.725

Elapsed time, ms. Chart for last 20 runs:

Last commits information (all timestamps in UTC):