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-07-03 12:26:34.751
2025-07-03 12:26:34.751 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-03 12:26:34.751
2025-07-03 12:26:34.751     @pytest.mark.version('>=3')
2025-07-03 12:26:34.751     def test_1(act: Action):
2025-07-03 12:26:34.751         act.expected_stdout = expected_stdout
2025-07-03 12:26:34.751         act.execute()
2025-07-03 12:26:34.751 >       assert act.clean_stdout == act.clean_expected_stdout
2025-07-03 12:26:34.751 E       assert
2025-07-03 12:26:34.751 E         + set planonly;
2025-07-03 12:26:34.751 E         + select * from test t where x = 0 plan (t natural); -- 1
2025-07-03 12:26:34.751 E         + PLAN (T NATURAL)
2025-07-03 12:26:34.751 E         + select * from v_test1 v1; -- 2
2025-07-03 12:26:34.751 E         + PLAN (V1 T INDEX (TEST_X_ASC))
2025-07-03 12:26:34.751 E         + select * from v_test1 v2; -- 3
2025-07-03 12:26:34.752 E         + PLAN (V2 T INDEX (TEST_X_ASC))
2025-07-03 12:26:34.752 E         + select * from v_test1 v1 where v1.x = 0 plan (v1 natural); -- 4
2025-07-03 12:26:34.752 E         + PLAN (V1 T NATURAL)
2025-07-03 12:26:34.752 E         + select * from v_test2 v2 where v2.x = 0 plan (v2 natural); -- 5
2025-07-03 12:26:34.752 E         + PLAN (V2 T NATURAL)
2025-07-03 12:26:34.752 E         + select * from v_test1 v1 where v1.x = 0 PLAN (V1 INDEX (TEST_X_DESC)) ; -- 6
2025-07-03 12:26:34.752 E         + PLAN (V1 T INDEX (TEST_X_DESC))
2025-07-03 12:26:34.752 E         + select * from v_test2 v2 where v2.x = 0 PLAN (V2 INDEX (TEST_X_DESC)) ; -- 7
2025-07-03 12:26:34.752 E         + PLAN (V2 T INDEX (TEST_X_DESC))
2025-07-03 12:26:34.752 E         + select * from v_test1 v1 where v1.x = 50 and v1.y = 5000 PLAN (V1 INDEX (test_x_y)) ; -- 8
2025-07-03 12:26:34.752 E         + PLAN (V1 T INDEX (TEST_X_Y))
2025-07-03 12:26:34.752 E         + select * from v_test1 v2 where v2.x = 50 and v2.y = 5000 PLAN (V2 INDEX (test_y_x)) ; -- 9
2025-07-03 12:26:34.752 E         + PLAN (V2 T INDEX (TEST_Y_X))
2025-07-03 12:26:34.752 E         + select * from v_test1 v1 where v1.x + v1.y = 1000 PLAN (V1 INDEX (test_x_y)); -- 10
2025-07-03 12:26:34.752 E         + PLAN (V1 T INDEX (TEST_X_Y))
2025-07-03 12:26:34.752 E         + select * from v_test2 v2 where v2.x - v2.y = 1000 PLAN (V2 INDEX (test_x_y)); -- 11
2025-07-03 12:26:34.752 E         + PLAN (V2 T INDEX (TEST_X_Y))
2025-07-03 12:26:34.752 E         + select * from v_test1 v1 where v1.x + v1.y = 1000 PLAN (V1 INDEX (test_sum_x_y)); -- 12
2025-07-03 12:26:34.753 E         + PLAN (V1 T INDEX (TEST_SUM_X_Y))
2025-07-03 12:26:34.753 E         + select * from v_test2 v2 where v2.x - v2.y = 1000 PLAN (V2 INDEX (test_sub_x_y)); -- 13
2025-07-03 12:26:34.753 E         + PLAN (V2 T INDEX (TEST_SUB_X_Y))
2025-07-03 12:26:34.753 E         + -- NB: here optimizer will use index __NOT__ from view V3 DDL:
2025-07-03 12:26:34.753 E         + -- PLAN (V3 T INDEX (TEST_X_ASC))
2025-07-03 12:26:34.753 E         + select * from v_test3 v3; -- 14
2025-07-03 12:26:34.753 E         + PLAN (V3 T INDEX (TEST_X_ASC))
2025-07-03 12:26:34.753 E         + select * from v_test3 v3 plan ( v3 index(test_x_y) );
2025-07-03 12:26:34.753 E         + PLAN (V3 T INDEX (TEST_X_Y))
2025-07-03 12:26:34.753 E         + -- NB: here optimizer will use index __NOT__ from view V3 DDL:
2025-07-03 12:26:34.753 E         + -- PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
2025-07-03 12:26:34.753 E         + select * from v_test4 v4; -- 15
2025-07-03 12:26:34.753 E         + PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
2025-07-03 12:26:34.753 E         + select * from v_test4 v4 PLAN (V4 V_TEST3 T INDEX (TEST_X_Y)); -- 16
2025-07-03 12:26:34.753 E         + PLAN (V4 V_TEST3 T INDEX (TEST_X_Y))
2025-07-03 12:26:34.753
2025-07-03 12:26:34.753 tests\bugs\core_0203_test.py:124: AssertionError
2025-07-03 12:26:34.753 ---------------------------- Captured stdout setup ----------------------------
2025-07-03 12:26:34.753 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_141\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 3.0.13.33814 2025.06.21 85255 F F 967 752 2025.07.03 08:50:16.639 2025.07.03 08:50:17.606 2025.07.03 08:22:14.363 2025.07.03 08:22:15.115
2 3.0.13.33813 2025.06.14 222a9 P P 593 411 2025.06.21 08:38:32.565 2025.06.21 08:38:33.158 2025.06.21 08:09:58.305 2025.06.21 08:09:58.716
3 3.0.13.33811 2025.05.07 16491 P P 628 391 2025.06.14 09:07:31.302 2025.06.14 09:07:31.930 2025.06.14 08:37:56.424 2025.06.14 08:37:56.815
4 3.0.13.33810 2025.05.06 02b1d P P 591 397 2025.05.07 07:22:14.971 2025.05.07 07:22:15.562 2025.05.07 06:54:26.057 2025.05.07 06:54:26.454
5 3.0.13.33809 2025.05.05 4ec6d P P 591 389 2025.05.06 07:22:08.241 2025.05.06 07:22:08.832 2025.05.06 06:54:19.251 2025.05.06 06:54:19.640
6 3.0.13.33808 2025.04.18 bf513 P P 603 393 2025.04.29 12:44:35.928 2025.04.29 12:44:36.531 2025.04.29 12:16:41.794 2025.04.29 12:16:42.187
7 3.0.13.33807 2025.04.14 73e94 P P 593 394 2025.04.17 07:24:35.195 2025.04.17 07:24:35.788 2025.04.17 06:56:55.962 2025.04.17 06:56:56.356
8 3.0.13.33806 2025.03.26 b6cfe P P 596 394 2025.04.10 07:23:02.654 2025.04.10 07:23:03.250 2025.04.10 06:54:06.829 2025.04.10 06:54:07.223
9 3.0.13.33805 2025.03.17 98320 P P 595 463 2025.03.24 07:28:31.914 2025.03.24 07:28:32.509 2025.03.24 06:59:37.636 2025.03.24 06:59:38.099
10 3.0.13.33804 2025.02.25 1439d P P 616 403 2025.03.13 07:23:32.083 2025.03.13 07:23:32.699 2025.03.13 06:54:01.730 2025.03.13 06:54:02.133
11 3.0.13.33803 2025.01.29 f1848 P P 655 404 2025.02.24 07:07:52.295 2025.02.24 07:07:52.950 2025.02.24 06:40:03.941 2025.02.24 06:40:04.345
12 3.0.13.33802 2025.01.28 650bd P P 598 409 2025.01.29 00:44:41.280 2025.01.29 00:44:41.878 2025.01.29 00:16:48.338 2025.01.29 00:16:48.747
13 3.0.13.33800 2025.01.20 f20ab P P 583 389 2025.01.25 12:44:24.263 2025.01.25 12:44:24.846 2025.01.25 12:16:29.059 2025.01.25 12:16:29.448
14 3.0.13.33798 2025.01.16 0c3bb P P 585 392 2025.01.20 06:56:31.259 2025.01.20 06:56:31.844 2025.01.20 06:28:49.042 2025.01.20 06:28:49.434
15 3.0.13.33795 2024.12.23 1bf0b P P 591 398 2025.01.16 07:00:10.500 2025.01.16 07:00:11.091 2025.01.16 06:32:22.145 2025.01.16 06:32:22.543
16 3.0.13.33794 2024.10.23 e2a6b P P 605 437 2024.12.22 00:45:20.039 2024.12.22 00:45:20.644 2024.12.22 00:16:57.942 2024.12.22 00:16:58.379
17 3.0.13.33793 2024.09.02 3e627 P P 605 399 2024.10.23 06:45:26.889 2024.10.23 06:45:27.494 2024.10.23 06:17:28.279 2024.10.23 06:17:28.678
18 3.0.13.33792 2024.08.30 d9f38 P P 601 391 2024.09.02 06:37:00.536 2024.09.02 06:37:01.137 2024.09.02 06:06:42.522 2024.09.02 06:06:42.913
19 3.0.13.33791 2024.08.21 c8a36 P P 614 405 2024.08.30 06:30:41.404 2024.08.30 06:30:42.018 2024.08.30 06:01:37.813 2024.08.30 06:01:38.218
20 3.0.13.33790 2024.08.20 3bf52 P P 636 421 2024.08.21 06:24:10.148 2024.08.21 06:24:10.784 2024.08.21 05:54:40.413 2024.08.21 05:54:40.834
21 3.0.13.33789 2024.08.09 7933a P P 682 459 2024.08.19 06:35:21.823 2024.08.19 06:35:22.505 2024.08.19 06:05:00.981 2024.08.19 06:05:01.440
22 3.0.12.33787 2024.08.06 bf180 P P 671 470 2024.08.10 06:39:22.922 2024.08.10 06:39:23.593 2024.08.10 06:05:16.373 2024.08.10 06:05:16.843
23 3.0.12.33784 2024.08.01 cd857 P P 532 350 2024.08.06 04:17:32.784 2024.08.06 04:17:33.316 2024.08.06 03:49:34.029 2024.08.06 03:49:34.379
24 3.0.12.33779 2024.07.31 ae35d P P 507 363 2024.08.01 12:47:28.554 2024.08.01 12:47:29.061 2024.08.01 12:20:54.909 2024.08.01 12:20:55.272
25 3.0.12.33778 2024.07.21 4680d P P 499 349 2024.07.30 05:56:40.649 2024.07.30 05:56:41.148 2024.07.30 05:29:45.359 2024.07.30 05:29:45.708
26 3.0.12.33777 2024.07.19 8e912 P P 547 328 2024.07.21 05:52:24.437 2024.07.21 05:52:24.984 2024.07.21 05:25:58.553 2024.07.21 05:25:58.881
27 3.0.12.33766 2024.07.13 b5086 P P 506 326 2024.07.19 05:51:29.554 2024.07.19 05:51:30.060 2024.07.19 05:25:17.655 2024.07.19 05:25:17.981
28 3.0.12.33765 2024.07.10 06f2a P P 484 328 2024.07.13 05:51:01.955 2024.07.13 05:51:02.439 2024.07.13 05:25:24.083 2024.07.13 05:25:24.411
29 3.0.12.33764 2024.06.18 4d0c0 P P 504 331 2024.07.10 06:06:26.542 2024.07.10 06:06:27.046 2024.07.10 05:40:21.755 2024.07.10 05:40:22.086
30 3.0.12.33761 2024.06.17 b259d P P 534 331 2024.06.18 06:03:06.252 2024.06.18 06:03:06.786 2024.06.18 05:36:59.958 2024.06.18 05:37:00.289
31 3.0.12.33758 2024.06.14 4f9bc P P 521 328 2024.06.17 06:01:51.848 2024.06.17 06:01:52.369 2024.06.17 05:35:45.810 2024.06.17 05:35:46.138
32 3.0.12.33746 2024.05.29 21bb4 P P 484 266 2024.06.10 03:27:29.131 2024.06.10 03:27:29.615 2024.06.10 03:04:24.839 2024.06.10 03:04:25.105
33 3.0.12.33744 2024.04.19 ecf36 P P 485 265 2024.05.25 03:26:53.634 2024.05.25 03:26:54.119 2024.05.25 03:03:49.856 2024.05.25 03:03:50.121
34 3.0.12.33743 2024.04.16 ed298 P P 453 266 2024.04.19 03:23:26.363 2024.04.19 03:23:26.816 2024.04.19 03:00:37.963 2024.04.19 03:00:38.229
35 3.0.12.33740 2024.03.19 da67d P P 500 266 2024.04.13 03:15:34.256 2024.04.13 03:15:34.756 2024.04.13 02:52:52.031 2024.04.13 02:52:52.297
36 3.0.12.33736 2024.03.19 22b3b P P 421 374 2024.03.19 20:31:59.548 2024.03.19 20:31:59.969 2024.03.19 20:06:10.505 2024.03.19 20:06:10.879
37 3.0.12.33736 2024.03.19 7a9a3 P P 421 265 2024.03.19 21:27:10.661 2024.03.19 21:27:11.082 2024.03.19 21:04:53.718 2024.03.19 21:04:53.983
38 3.0.12.33735 2024.03.15 342f0 P P 438 265 2024.04.04 15:34:57.769 2024.04.04 15:34:58.207 2024.04.04 15:12:10.767 2024.04.04 15:12:11.032
39 3.0.12.33735 2024.03.08 ef0b7 P P 438 266 2024.04.05 10:46:45.396 2024.04.05 10:46:45.834 2024.04.05 10:23:53.946 2024.04.05 10:23:54.212
40 3.0.12.33734 2024.03.05 25001 P P 438 266 2024.04.04 20:35:12.395 2024.04.04 20:35:12.833 2024.04.04 20:12:30.966 2024.04.04 20:12:31.232
41 3.0.12.33733 2024.03.05 0550b P P 422 266 2024.04.05 17:06:08.920 2024.04.05 17:06:09.342 2024.04.05 16:43:30.808 2024.04.05 16:43:31.074
42 3.0.12.33733 2024.02.29 5e6ae P P 422 266 2024.04.05 12:40:25.370 2024.04.05 12:40:25.792 2024.04.05 12:17:43.838 2024.04.05 12:17:44.104
43 3.0.12.33731 2024.02.14 44e13 P P 453 266 2024.04.05 18:08:03.016 2024.04.05 18:08:03.469 2024.04.05 17:45:25.927 2024.04.05 17:45:26.193
44 3.0.12.33730 2024.02.14 e8106 P P 421 265 2024.04.04 18:35:52.365 2024.04.04 18:35:52.786 2024.04.04 18:13:04.881 2024.04.04 18:13:05.146
45 3.0.12.33730 2024.02.06 167da P P 410 266 2024.04.05 20:05:24.511 2024.04.05 20:05:24.921 2024.04.05 19:42:43.770 2024.04.05 19:42:44.036
46 3.0.12.33729 2024.02.06 7a8b2 P P 422 265 2024.04.05 11:42:36.367 2024.04.05 11:42:36.789 2024.04.05 11:19:53.939 2024.04.05 11:19:54.204
47 3.0.12.33728 2024.01.30 5fe6d P P 422 266 2024.04.04 19:32:47.793 2024.04.04 19:32:48.215 2024.04.04 19:10:15.878 2024.04.04 19:10:16.144
48 3.0.12.33728 2024.01.25 85dc8 P P 422 266 2024.04.05 14:23:01.195 2024.04.05 14:23:01.617 2024.04.05 14:00:19.823 2024.04.05 14:00:20.089
49 3.0.12.33727 2024.01.25 0f3dc P P 422 265 2024.04.05 09:30:21.448 2024.04.05 09:30:21.870 2024.04.05 09:07:35.645 2024.04.05 09:07:35.910
50 3.0.12.33726 2024.01.15 406ce P P 437 266 2024.04.04 16:32:14.839 2024.04.04 16:32:15.276 2024.04.04 16:09:35.850 2024.04.04 16:09:36.116

Elapsed time, ms. Chart for last 50 runs:

Last commits information (all timestamps in UTC):