Check firebird.log [no messages found for interval when this test was running]
Jump to: output_first_mismatch    outcomes_full_history    elapsed_time_chart
Show cross-report outcomes.

Annotation type Annotation details
2 @message
assert   
  + set planonly;
  + select * from test t where x = 0 plan (t natural); -- 1
  + PLAN (T NATURAL)
  + select * from v_test1 v1; -- 2
  + PLAN (V1 T INDEX (TEST_X_ASC))
  + select * from v_test1 v2; -- 3
  + PLAN (V2 T INDEX (TEST_X_ASC))
  + select * from v_test1 v1 where v1.x = 0 plan (v1 natural); -- 4
  + PLAN (V1 T NATURAL)
  + select * from v_test2 v2 where v2.x = 0 plan (v2 natural); -- 5
  + PLAN (V2 T NATURAL)
  + select * from v_test1 v1 where v1.x = 0 PLAN (V1 INDEX (TEST_X_DESC)) ; -- 6
  + PLAN (V1 T INDEX (TEST_X_DESC))
  + select * from v_test2 v2 where v2.x = 0 PLAN (V2 INDEX (TEST_X_DESC)) ; -- 7
  + PLAN (V2 T INDEX (TEST_X_DESC))
  + select * from v_test1 v1 where v1.x = 50 and v1.y = 5000 PLAN (V1 INDEX (test_x_y)) ; -- 8
  + PLAN (V1 T INDEX (TEST_X_Y))
  + select * from v_test1 v2 where v2.x = 50 and v2.y = 5000 PLAN (V2 INDEX (test_y_x)) ; -- 9
  + PLAN (V2 T INDEX (TEST_Y_X))
  + select * from v_test1 v1 where v1.x + v1.y = 1000 PLAN (V1 INDEX (test_x_y)); -- 10
  + PLAN (V1 T INDEX (TEST_X_Y))
  + select * from v_test2 v2 where v2.x - v2.y = 1000 PLAN (V2 INDEX (test_x_y)); -- 11
  + PLAN (V2 T INDEX (TEST_X_Y))
  + select * from v_test1 v1 where v1.x + v1.y = 1000 PLAN (V1 INDEX (test_sum_x_y)); -- 12
  + PLAN (V1 T INDEX (TEST_SUM_X_Y))
  + select * from v_test2 v2 where v2.x - v2.y = 1000 PLAN (V2 INDEX (test_sub_x_y)); -- 13
  + PLAN (V2 T INDEX (TEST_SUB_X_Y))
  + -- NB: here optimizer will use index __NOT__ from view V3 DDL:
  + -- PLAN (V3 T INDEX (TEST_X_ASC))
  + select * from v_test3 v3; -- 14
  + PLAN (V3 T INDEX (TEST_X_ASC))
  + select * from v_test3 v3 plan ( v3 index(test_x_y) );
  + PLAN (V3 T INDEX (TEST_X_Y))
  + -- NB: here optimizer will use index __NOT__ from view V3 DDL:
  + -- PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
  + select * from v_test4 v4; -- 15
  + PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
  + select * from v_test4 v4 PLAN (V4 V_TEST3 T INDEX (TEST_X_Y)); -- 16
  + PLAN (V4 V_TEST3 T INDEX (TEST_X_Y))

LOG DETAILS:

2025-06-29 16:33:31.249
2025-06-29 16:33:31.249 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-29 16:33:31.249
2025-06-29 16:33:31.249     @pytest.mark.version('>=3')
2025-06-29 16:33:31.249     def test_1(act: Action):
2025-06-29 16:33:31.249         act.expected_stdout = expected_stdout
2025-06-29 16:33:31.249         act.execute()
2025-06-29 16:33:31.249 >       assert act.clean_stdout == act.clean_expected_stdout
2025-06-29 16:33:31.249 E       assert
2025-06-29 16:33:31.249 E         + set planonly;
2025-06-29 16:33:31.249 E         + select * from test t where x = 0 plan (t natural); -- 1
2025-06-29 16:33:31.249 E         + PLAN (T NATURAL)
2025-06-29 16:33:31.249 E         + select * from v_test1 v1; -- 2
2025-06-29 16:33:31.249 E         + PLAN (V1 T INDEX (TEST_X_ASC))
2025-06-29 16:33:31.249 E         + select * from v_test1 v2; -- 3
2025-06-29 16:33:31.249 E         + PLAN (V2 T INDEX (TEST_X_ASC))
2025-06-29 16:33:31.249 E         + select * from v_test1 v1 where v1.x = 0 plan (v1 natural); -- 4
2025-06-29 16:33:31.249 E         + PLAN (V1 T NATURAL)
2025-06-29 16:33:31.250 E         + select * from v_test2 v2 where v2.x = 0 plan (v2 natural); -- 5
2025-06-29 16:33:31.250 E         + PLAN (V2 T NATURAL)
2025-06-29 16:33:31.250 E         + select * from v_test1 v1 where v1.x = 0 PLAN (V1 INDEX (TEST_X_DESC)) ; -- 6
2025-06-29 16:33:31.250 E         + PLAN (V1 T INDEX (TEST_X_DESC))
2025-06-29 16:33:31.250 E         + select * from v_test2 v2 where v2.x = 0 PLAN (V2 INDEX (TEST_X_DESC)) ; -- 7
2025-06-29 16:33:31.250 E         + PLAN (V2 T INDEX (TEST_X_DESC))
2025-06-29 16:33:31.250 E         + select * from v_test1 v1 where v1.x = 50 and v1.y = 5000 PLAN (V1 INDEX (test_x_y)) ; -- 8
2025-06-29 16:33:31.250 E         + PLAN (V1 T INDEX (TEST_X_Y))
2025-06-29 16:33:31.250 E         + select * from v_test1 v2 where v2.x = 50 and v2.y = 5000 PLAN (V2 INDEX (test_y_x)) ; -- 9
2025-06-29 16:33:31.250 E         + PLAN (V2 T INDEX (TEST_Y_X))
2025-06-29 16:33:31.250 E         + select * from v_test1 v1 where v1.x + v1.y = 1000 PLAN (V1 INDEX (test_x_y)); -- 10
2025-06-29 16:33:31.250 E         + PLAN (V1 T INDEX (TEST_X_Y))
2025-06-29 16:33:31.250 E         + select * from v_test2 v2 where v2.x - v2.y = 1000 PLAN (V2 INDEX (test_x_y)); -- 11
2025-06-29 16:33:31.250 E         + PLAN (V2 T INDEX (TEST_X_Y))
2025-06-29 16:33:31.250 E         + select * from v_test1 v1 where v1.x + v1.y = 1000 PLAN (V1 INDEX (test_sum_x_y)); -- 12
2025-06-29 16:33:31.250 E         + PLAN (V1 T INDEX (TEST_SUM_X_Y))
2025-06-29 16:33:31.250 E         + select * from v_test2 v2 where v2.x - v2.y = 1000 PLAN (V2 INDEX (test_sub_x_y)); -- 13
2025-06-29 16:33:31.250 E         + PLAN (V2 T INDEX (TEST_SUB_X_Y))
2025-06-29 16:33:31.251 E         + -- NB: here optimizer will use index __NOT__ from view V3 DDL:
2025-06-29 16:33:31.251 E         + -- PLAN (V3 T INDEX (TEST_X_ASC))
2025-06-29 16:33:31.251 E         + select * from v_test3 v3; -- 14
2025-06-29 16:33:31.251 E         + PLAN (V3 T INDEX (TEST_X_ASC))
2025-06-29 16:33:31.251 E         + select * from v_test3 v3 plan ( v3 index(test_x_y) );
2025-06-29 16:33:31.251 E         + PLAN (V3 T INDEX (TEST_X_Y))
2025-06-29 16:33:31.251 E         + -- NB: here optimizer will use index __NOT__ from view V3 DDL:
2025-06-29 16:33:31.251 E         + -- PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
2025-06-29 16:33:31.251 E         + select * from v_test4 v4; -- 15
2025-06-29 16:33:31.251 E         + PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
2025-06-29 16:33:31.251 E         + select * from v_test4 v4 PLAN (V4 V_TEST3 T INDEX (TEST_X_Y)); -- 16
2025-06-29 16:33:31.251 E         + PLAN (V4 V_TEST3 T INDEX (TEST_X_Y))
2025-06-29 16:33:31.251
2025-06-29 16:33:31.251 tests\bugs\core_0203_test.py:124: AssertionError
2025-06-29 16:33:31.251 ---------------------------- Captured stdout setup ----------------------------
2025-06-29 16:33:31.251 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_139\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
3 #text
act = <firebird.qa.plugin.Action pytest object at [hex]>

    @pytest.mark.version('>=3')
    def test_1(act: Action):
        act.expected_stdout = expected_stdout
        act.execute()
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E         + set planonly;
E         + select * from test t where x = 0 plan (t natural); -- 1
E         + PLAN (T NATURAL)
E         + select * from v_test1 v1; -- 2
E         + PLAN (V1 T INDEX (TEST_X_ASC))
E         + select * from v_test1 v2; -- 3
E         + PLAN (V2 T INDEX (TEST_X_ASC))
E         + select * from v_test1 v1 where v1.x = 0 plan (v1 natural); -- 4
E         + PLAN (V1 T NATURAL)
E         + select * from v_test2 v2 where v2.x = 0 plan (v2 natural); -- 5
E         + PLAN (V2 T NATURAL)
E         + select * from v_test1 v1 where v1.x = 0 PLAN (V1 INDEX (TEST_X_DESC)) ; -- 6
E         + PLAN (V1 T INDEX (TEST_X_DESC))
E         + select * from v_test2 v2 where v2.x = 0 PLAN (V2 INDEX (TEST_X_DESC)) ; -- 7
E         + PLAN (V2 T INDEX (TEST_X_DESC))
E         + select * from v_test1 v1 where v1.x = 50 and v1.y = 5000 PLAN (V1 INDEX (test_x_y)) ; -- 8
E         + PLAN (V1 T INDEX (TEST_X_Y))
E         + select * from v_test1 v2 where v2.x = 50 and v2.y = 5000 PLAN (V2 INDEX (test_y_x)) ; -- 9
E         + PLAN (V2 T INDEX (TEST_Y_X))
E         + select * from v_test1 v1 where v1.x + v1.y = 1000 PLAN (V1 INDEX (test_x_y)); -- 10
E         + PLAN (V1 T INDEX (TEST_X_Y))
E         + select * from v_test2 v2 where v2.x - v2.y = 1000 PLAN (V2 INDEX (test_x_y)); -- 11
E         + PLAN (V2 T INDEX (TEST_X_Y))
E         + select * from v_test1 v1 where v1.x + v1.y = 1000 PLAN (V1 INDEX (test_sum_x_y)); -- 12
E         + PLAN (V1 T INDEX (TEST_SUM_X_Y))
E         + select * from v_test2 v2 where v2.x - v2.y = 1000 PLAN (V2 INDEX (test_sub_x_y)); -- 13
E         + PLAN (V2 T INDEX (TEST_SUB_X_Y))
E         + -- NB: here optimizer will use index __NOT__ from view V3 DDL:
E         + -- PLAN (V3 T INDEX (TEST_X_ASC))
E         + select * from v_test3 v3; -- 14
E         + PLAN (V3 T INDEX (TEST_X_ASC))
E         + select * from v_test3 v3 plan ( v3 index(test_x_y) );
E         + PLAN (V3 T INDEX (TEST_X_Y))
E         + -- NB: here optimizer will use index __NOT__ from view V3 DDL:
E         + -- PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
E         + select * from v_test4 v4; -- 15
E         + PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
E         + select * from v_test4 v4 PLAN (V4 V_TEST3 T INDEX (TEST_X_Y)); -- 16
E         + PLAN (V4 V_TEST3 T INDEX (TEST_X_Y))

tests\bugs\core_0203_test.py:124: AssertionError
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 F F 1045 827 2025.06.29 12:32:04.394 2025.06.29 12:32:05.439 2025.06.29 11:41:32.785 2025.06.29 11:41:33.612
2 4.0.6.3184 2025.02.24 9388c P P 708 487 2025.02.25 10:13:59.689 2025.02.25 10:14:00.397 2025.02.25 09:05:14.112 2025.02.25 09:05:14.599
3 4.0.6.3183 2025.02.17 e4762 P P 728 512 2025.02.24 10:46:13.866 2025.02.24 10:46:14.594 2025.02.24 09:55:26.543 2025.02.24 09:55:27.055
4 4.0.6.3169 2024.12.13 42cc1 P P 692 512 2025.02.14 07:33:52.645 2025.02.14 07:33:53.337 2025.02.14 06:43:13.163 2025.02.14 06:43:13.675
5 4.0.6.3169 2024.12.08 50eb6 P P 716 509 2024.12.11 10:30:43.743 2024.12.11 10:30:44.459 2024.12.11 09:40:30.793 2024.12.11 09:40:31.302
6 4.0.6.3168 2024.12.07 98d69 P P 722 540 2024.12.08 03:11:44.743 2024.12.08 03:11:45.465 2024.12.08 02:20:10.366 2024.12.08 02:20:10.906
7 4.0.6.3168 2024.12.05 cee43 P P 723 488 2024.12.06 03:16:10.358 2024.12.06 03:16:11.081 2024.12.06 02:26:01.634 2024.12.06 02:26:02.122
8 4.0.6.3168 2024.11.28 48149 P P 726 481 2024.12.03 10:10:26.295 2024.12.03 10:10:27.021 2024.12.03 09:20:51.203 2024.12.03 09:20:51.684
9 4.0.6.3163 2024.10.30 832db P P 689 487 2024.11.28 10:09:33.193 2024.11.28 10:09:33.882 2024.11.28 09:20:23.449 2024.11.28 09:20:23.936
10 4.0.6.3163 2024.10.16 2bb10 P P 727 524 2024.10.30 10:18:20.156 2024.10.30 10:18:20.883 2024.10.30 09:28:39.975 2024.10.30 09:28:40.499
11 4.0.6.3147 2024.09.10 a4d11 P P 698 507 2024.10.16 03:26:11.172 2024.10.16 03:26:11.870 2024.10.16 02:17:51.550 2024.10.16 02:17:52.057
12 4.0.6.3147 2024.08.31 4655b P P 732 486 2024.09.10 10:19:40.624 2024.09.10 10:19:41.356 2024.09.10 09:29:59.797 2024.09.10 09:30:00.283
13 4.0.6.3140 2024.08.16 1dd8b P P 758 529 2024.09.01 10:43:39.711 2024.09.01 10:43:40.469 2024.09.01 09:33:36.805 2024.09.01 09:33:37.334
14 4.0.6.3140 2024.08.09 34747 P P 758 548 2024.08.16 10:23:03.846 2024.08.16 10:23:04.604 2024.08.16 09:32:22.505 2024.08.16 09:32:23.053
15 4.0.5.3110 2024.08.06 f851c P P 776 537 2024.08.09 10:02:47.837 2024.08.09 10:02:48.613 2024.08.09 09:12:44.715 2024.08.09 09:12:45.252
16 4.0.5.3110 2024.07.30 c6527 P P 581 392 2024.08.06 05:43:31.392 2024.08.06 05:43:31.973 2024.08.06 04:57:25.424 2024.08.06 04:57:25.816
17 4.0.5.3109 2024.06.11 6addf P P 571 407 2024.07.30 09:03:08.367 2024.07.30 09:03:08.938 2024.07.30 08:18:18.019 2024.07.30 08:18:18.426
18 4.0.5.3097 2024.05.09 27fa6 P P 531 313 2024.06.11 05:23:52.295 2024.06.11 05:23:52.826 2024.06.11 04:44:38.078 2024.06.11 04:44:38.391
19 4.0.5.3091 2024.04.29 bd0aa P P 532 312 2024.05.09 18:03:22.661 2024.05.09 18:03:23.193 2024.05.09 17:24:29.887 2024.05.09 17:24:30.199
20 4.0.5.3089 2024.04.20 9eb9b P P 531 313 2024.04.29 06:12:06.252 2024.04.29 06:12:06.783 2024.04.29 05:33:36.856 2024.04.29 05:33:37.169
21 4.0.5.3083 2024.04.06 300f9 P P 516 313 2024.04.20 06:35:12.592 2024.04.20 06:35:13.108 2024.04.20 05:56:31.149 2024.04.20 05:56:31.462
22 4.0.5.3052 2024.03.16 0f422 P P 515 297 2024.04.05 03:02:58.655 2024.04.05 03:02:59.170 2024.04.05 02:25:41.550 2024.04.05 02:25:41.847
23 4.0.5.3052 2024.03.16 ce273 P P 483 296 2024.03.29 14:30:45.703 2024.03.29 14:30:46.186 2024.03.29 13:53:44.393 2024.03.29 13:53:44.689
24 4.0.5.3052 2024.02.12 cd058 P P 484 296 2024.03.29 15:59:07.977 2024.03.29 15:59:08.461 2024.03.29 15:22:12.457 2024.03.29 15:22:12.753
25 4.0.5.3052 2024.02.07 be290 P P 468 296 2024.03.29 18:10:37.958 2024.03.29 18:10:38.426 2024.03.29 17:33:39.655 2024.03.29 17:33:39.951
26 4.0.5.3052 2024.02.07 6409b P P 467 312 2024.03.29 19:54:54.031 2024.03.29 19:54:54.498 2024.03.29 19:17:52.554 2024.03.29 19:17:52.866
27 4.0.5.3052 2024.02.02 bbc3f P P 468 296 2024.03.29 22:03:54.115 2024.03.29 22:03:54.583 2024.03.29 21:26:58.625 2024.03.29 21:26:58.921
28 4.0.5.3052 2024.01.26 48b7c P P 484 296 2024.03.29 23:31:06.947 2024.03.29 23:31:07.431 2024.03.29 22:54:05.574 2024.03.29 22:54:05.870
29 4.0.5.3052 2024.01.26 9a7b3 P P 484 312 2024.03.30 06:32:01.836 2024.03.30 06:32:02.320 2024.03.30 05:54:58.546 2024.03.30 05:54:58.858
30 4.0.5.3049 2024.01.25 f6b9d P P 483 295 2024.03.30 08:39:33.616 2024.03.30 08:39:34.099 2024.03.30 08:02:52.258 2024.03.30 08:02:52.553
31 4.0.5.3049 2024.01.08 b67ce P P 655 343 2024.03.30 10:18:40.014 2024.03.30 10:18:40.669 2024.03.30 09:38:41.471 2024.03.30 09:38:41.814
32 4.0.5.3049 2024.01.08 97577 P P 640 343 2024.03.30 15:24:09.624 2024.03.30 15:24:10.264 2024.03.30 14:44:05.262 2024.03.30 14:44:05.605
33 4.0.5.3049 2024.01.05 2d8b0 P P 655 342 2024.03.30 18:41:49.625 2024.03.30 18:41:50.280 2024.03.30 18:02:03.256 2024.03.30 18:02:03.598
34 4.0.5.3049 2024.01.04 431e5 P P 452 296 2024.03.30 20:28:33.625 2024.03.30 20:28:34.077 2024.03.30 19:51:55.458 2024.03.30 19:51:55.754
35 4.0.5.3049 2024.01.04 e33b4 P P 483 296 2024.03.30 22:40:23.445 2024.03.30 22:40:23.928 2024.03.30 22:03:39.239 2024.03.30 22:03:39.535
36 4.0.5.3049 2024.01.04 207ef P P 468 296 2024.03.31 00:23:51.497 2024.03.31 00:23:51.965 2024.03.30 23:47:01.239 2024.03.30 23:47:01.535
37 4.0.5.3034 2023.12.12 c05ff P P 468 296 2024.03.31 06:16:22.687 2024.03.31 06:16:23.155 2024.03.31 05:39:35.226 2024.03.31 05:39:35.522
38 4.0.5.3034 2023.12.12 3a40e P P 467 296 2024.03.31 14:51:06.903 2024.03.31 14:51:07.370 2024.03.31 14:14:18.545 2024.03.31 14:14:18.841
39 4.0.5.3034 2023.12.02 5934b P P 468 296 2024.03.31 09:24:09.846 2024.03.31 09:24:10.314 2024.03.31 08:47:24.314 2024.03.31 08:47:24.610
40 4.0.5.3034 2023.12.02 7ea5a P P 468 296 2024.03.31 17:15:28.603 2024.03.31 17:15:29.071 2024.03.31 16:38:35.561 2024.03.31 16:38:35.857
41 4.0.5.3034 2023.11.30 4fbc9 P P 468 295 2024.03.31 19:16:20.800 2024.03.31 19:16:21.268 2024.03.31 18:39:29.470 2024.03.31 18:39:29.765

Elapsed time, ms. Chart for last 41 runs:

Last commits information (all timestamps in UTC):