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-01 16:25:49.290
2025-07-01 16:25:49.303 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-01 16:25:49.315
2025-07-01 16:25:49.323 @pytest.mark.version('>=3')
2025-07-01 16:25:49.330 def test_1(act: Action):
2025-07-01 16:25:49.342 act.expected_stdout = expected_stdout
2025-07-01 16:25:49.351 act.execute()
2025-07-01 16:25:49.360 >       assert act.clean_stdout == act.clean_expected_stdout
2025-07-01 16:25:49.372 E       assert
2025-07-01 16:25:49.381 E         + set planonly;
2025-07-01 16:25:49.388 E         + select * from test t where x = 0 plan (t natural); -- 1
2025-07-01 16:25:49.395 E         + PLAN (T NATURAL)
2025-07-01 16:25:49.402 E         + select * from v_test1 v1; -- 2
2025-07-01 16:25:49.417 E         + PLAN (V1 T INDEX (TEST_X_ASC))
2025-07-01 16:25:49.429 E         + select * from v_test1 v2; -- 3
2025-07-01 16:25:49.440 E         + PLAN (V2 T INDEX (TEST_X_ASC))
2025-07-01 16:25:49.453 E         + select * from v_test1 v1 where v1.x = 0 plan (v1 natural); -- 4
2025-07-01 16:25:49.470 E         + PLAN (V1 T NATURAL)
2025-07-01 16:25:49.481 E         + select * from v_test2 v2 where v2.x = 0 plan (v2 natural); -- 5
2025-07-01 16:25:49.491 E         + PLAN (V2 T NATURAL)
2025-07-01 16:25:49.504 E         + select * from v_test1 v1 where v1.x = 0 PLAN (V1 INDEX (TEST_X_DESC)) ; -- 6
2025-07-01 16:25:49.520 E         + PLAN (V1 T INDEX (TEST_X_DESC))
2025-07-01 16:25:49.531 E         + select * from v_test2 v2 where v2.x = 0 PLAN (V2 INDEX (TEST_X_DESC)) ; -- 7
2025-07-01 16:25:49.539 E         + PLAN (V2 T INDEX (TEST_X_DESC))
2025-07-01 16:25:49.551 E         + select * from v_test1 v1 where v1.x = 50 and v1.y = 5000 PLAN (V1 INDEX (test_x_y)) ; -- 8
2025-07-01 16:25:49.559 E         + PLAN (V1 T INDEX (TEST_X_Y))
2025-07-01 16:25:49.567 E         + select * from v_test1 v2 where v2.x = 50 and v2.y = 5000 PLAN (V2 INDEX (test_y_x)) ; -- 9
2025-07-01 16:25:49.578 E         + PLAN (V2 T INDEX (TEST_Y_X))
2025-07-01 16:25:49.587 E         + select * from v_test1 v1 where v1.x + v1.y = 1000 PLAN (V1 INDEX (test_x_y)); -- 10
2025-07-01 16:25:49.600 E         + PLAN (V1 T INDEX (TEST_X_Y))
2025-07-01 16:25:49.611 E         + select * from v_test2 v2 where v2.x - v2.y = 1000 PLAN (V2 INDEX (test_x_y)); -- 11
2025-07-01 16:25:49.621 E         + PLAN (V2 T INDEX (TEST_X_Y))
2025-07-01 16:25:49.638 E         + select * from v_test1 v1 where v1.x + v1.y = 1000 PLAN (V1 INDEX (test_sum_x_y)); -- 12
2025-07-01 16:25:49.647 E         + PLAN (V1 T INDEX (TEST_SUM_X_Y))
2025-07-01 16:25:49.655 E         + select * from v_test2 v2 where v2.x - v2.y = 1000 PLAN (V2 INDEX (test_sub_x_y)); -- 13
2025-07-01 16:25:49.662 E         + PLAN (V2 T INDEX (TEST_SUB_X_Y))
2025-07-01 16:25:49.671 E         + -- NB: here optimizer will use index __NOT__ from view V3 DDL:
2025-07-01 16:25:49.682 E         + -- PLAN (V3 T INDEX (TEST_X_ASC))
2025-07-01 16:25:49.693 E         + select * from v_test3 v3; -- 14
2025-07-01 16:25:49.708 E         + PLAN (V3 T INDEX (TEST_X_ASC))
2025-07-01 16:25:49.721 E         + select * from v_test3 v3 plan ( v3 index(test_x_y) );
2025-07-01 16:25:49.733 E         + PLAN (V3 T INDEX (TEST_X_Y))
2025-07-01 16:25:49.748 E         + -- NB: here optimizer will use index __NOT__ from view V3 DDL:
2025-07-01 16:25:49.760 E         + -- PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
2025-07-01 16:25:49.769 E         + select * from v_test4 v4; -- 15
2025-07-01 16:25:49.783 E         + PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
2025-07-01 16:25:49.795 E         + select * from v_test4 v4 PLAN (V4 V_TEST3 T INDEX (TEST_X_Y)); -- 16
2025-07-01 16:25:49.803 E         + PLAN (V4 V_TEST3 T INDEX (TEST_X_Y))
2025-07-01 16:25:49.810
2025-07-01 16:25:49.818 tests/bugs/core_0203_test.py:124: AssertionError
2025-07-01 16:25:49.830 ---------------------------- Captured stdout setup -----------------------------
2025-07-01 16:25:49.842 Creating db: localhost:/var/tmp/qa_2024/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 5.0.3.1674 2025.06.27 3ee5c F F 1002 799 2025.07.01 11:55:51.694 2025.07.01 11:55:52.696 2025.07.01 10:50:01.636 2025.07.01 10:50:02.435
2 5.0.3.1657 2025.06.19 4bd4c F F 990 754 2025.06.27 11:22:40.521 2025.06.27 11:22:41.511 2025.06.27 10:17:41.810 2025.06.27 10:17:42.564
3 5.0.3.1657 2025.06.11 dae6f P P 856 508 2025.06.17 06:26:35.699 2025.06.17 06:26:36.555 2025.06.17 05:20:34.118 2025.06.17 05:20:34.626
4 5.0.3.1657 2025.06.10 dbc92 P P 1039 603 2025.06.11 11:12:22.496 2025.06.11 11:12:23.535 2025.06.11 09:55:10.525 2025.06.11 09:55:11.128
5 5.0.3.1656 2025.05.20 c4b11 P P 911 575 2025.06.10 11:08:09.896 2025.06.10 11:08:10.807 2025.06.10 09:58:57.518 2025.06.10 09:58:58.093
6 5.0.3.1652 2025.05.13 f51c6 P P 989 563 2025.05.20 04:04:01.169 2025.05.20 04:04:02.158 2025.05.20 02:46:02.657 2025.05.20 02:46:03.220
7 5.0.3.1651 2025.04.30 141ef P P 1017 584 2025.05.13 11:01:53.634 2025.05.13 11:01:54.651 2025.05.13 09:41:38.266 2025.05.13 09:41:38.850
8 5.0.3.1650 2025.04.28 4cbff P P 993 697 2025.05.01 10:35:38.499 2025.05.01 10:35:39.492 2025.05.01 09:16:57.303 2025.05.01 09:16:58.000
9 5.0.3.1649 2025.04.21 5b2d0 P P 946 569 2025.04.28 04:35:22.316 2025.04.28 04:35:23.262 2025.04.28 03:18:20.969 2025.04.28 03:18:21.538
10 5.0.3.1648 2025.04.18 2f4c5 P P 1010 528 2025.04.20 04:27:50.682 2025.04.20 04:27:51.692 2025.04.20 03:13:10.847 2025.04.20 03:13:11.375
11 5.0.3.1635 2025.03.31 22ec6 P P 1005 663 2025.04.18 10:48:03.112 2025.04.18 10:48:04.117 2025.04.18 09:29:31.273 2025.04.18 09:29:31.936
12 5.0.3.1633 2025.03.28 3123a P P 868 577 2025.03.31 09:26:40.975 2025.03.31 09:26:41.843 2025.03.31 08:13:36.821 2025.03.31 08:13:37.398
13 5.0.3.1633 2025.03.27 e0fb8 P P 901 592 2025.03.28 09:58:04.073 2025.03.28 09:58:04.974 2025.03.28 08:41:06.386 2025.03.28 08:41:06.978
14 5.0.3.1631 2025.03.21 1925b P P 983 638 2025.03.27 09:46:39.191 2025.03.27 09:46:40.174 2025.03.27 08:30:59.966 2025.03.27 08:31:00.604
15 5.0.3.1628 2025.03.14 16d05 P P 813 509 2025.03.17 07:13:56.990 2025.03.17 07:13:57.803 2025.03.17 05:50:04.957 2025.03.17 05:50:05.466
16 5.0.3.1627 2025.02.26 4e218 P P 900 425 2025.03.14 10:23:33.497 2025.03.14 10:23:34.397 2025.03.14 09:03:00.044 2025.03.14 09:03:00.469
17 5.0.3.1624 2025.02.25 dc3b2 P P 713 460 2025.02.26 09:21:43.202 2025.02.26 09:21:43.915 2025.02.26 08:03:08.581 2025.02.26 08:03:09.041
18 5.0.2.1615 2025.02.20 4a726 P P 825 445 2025.02.25 09:48:04.469 2025.02.25 09:48:05.294 2025.02.25 08:28:01.364 2025.02.25 08:28:01.809
19 5.0.2.1615 2025.02.14 9cb76 P P 855 460 2025.02.20 06:39:47.907 2025.02.20 06:39:48.762 2025.02.20 05:22:17.019 2025.02.20 05:22:17.479
20 5.0.2.1577 2024.12.24 3c80e P P 845 447 2025.02.14 09:52:53.132 2025.02.14 09:52:53.977 2025.02.14 08:38:03.975 2025.02.14 08:38:04.422
21 5.0.2.1576 2024.12.17 646b0 P P 615 332 2024.12.24 17:32:31.960 2024.12.24 17:32:32.575 2024.12.24 16:34:28.573 2024.12.24 16:34:28.905
22 5.0.2.1575 2024.12.08 63d39 P P 673 326 2024.12.16 07:15:01.106 2024.12.16 07:15:01.779 2024.12.16 06:18:31.076 2024.12.16 06:18:31.402
23 5.0.2.1567 2024.11.26 56e63 P P 630 340 2024.12.04 06:53:47.998 2024.12.04 06:53:48.628 2024.12.04 05:55:11.154 2024.12.04 05:55:11.494
24 5.0.2.1567 2024.11.21 96f61 P P 591 333 2024.11.26 04:38:33.047 2024.11.26 04:38:33.638 2024.11.26 03:43:21.295 2024.11.26 03:43:21.628
25 5.0.2.1567 2024.11.18 e1289 P P 571 330 2024.11.21 06:43:50.674 2024.11.21 06:43:51.245 2024.11.21 05:48:12.357 2024.11.21 05:48:12.687
26 5.0.2.1533 2024.10.23 0ec43 P P 561 330 2024.11.18 06:58:22.348 2024.11.18 06:58:22.909 2024.11.18 06:01:33.381 2024.11.18 06:01:33.711
27 5.0.2.1533 2024.10.22 8af7a P P 652 333 2024.10.23 08:54:21.665 2024.10.23 08:54:22.317 2024.10.23 07:57:18.401 2024.10.23 07:57:18.734
28 5.0.2.1532 2024.10.15 36dc0 P P 614 332 2024.10.22 19:06:41.978 2024.10.22 19:06:42.592 2024.10.22 18:09:54.232 2024.10.22 18:09:54.564
29 5.0.2.1518 2024.10.04 259ba P P 610 330 2024.10.15 08:40:06.416 2024.10.15 08:40:07.026 2024.10.15 07:42:55.283 2024.10.15 07:42:55.613
30 5.0.2.1518 2024.09.26 703cd P P 717 376 2024.10.03 07:05:32.131 2024.10.03 07:05:32.848 2024.10.03 06:07:28.648 2024.10.03 06:07:29.024
31 5.0.2.1489 2024.09.05 40838 P P 661 342 2024.09.25 07:05:35.017 2024.09.25 07:05:35.678 2024.09.25 06:06:40.774 2024.09.25 06:06:41.116
32 5.0.2.1489 2024.08.31 994a6 P P 1275 497 2024.09.05 10:52:34.798 2024.09.05 10:52:36.073 2024.09.05 09:39:39.500 2024.09.05 09:39:39.997
33 5.0.2.1476 2024.08.09 843ea P P 1505 1273 2024.08.31 13:01:23.686 2024.08.31 13:01:25.191 2024.08.31 11:19:30.517 2024.08.31 11:19:31.790
34 5.0.1.1454 2024.08.08 30f9f P P 769 421 2024.08.09 07:41:22.054 2024.08.09 07:41:22.823 2024.08.09 06:41:51.612 2024.08.09 06:41:52.033
35 5.0.1.1453 2024.08.06 1b9d0 P P 848 469 2024.08.08 20:19:50.523 2024.08.08 20:19:51.371 2024.08.08 19:19:21.371 2024.08.08 19:19:21.840
36 5.0.1.1453 2024.07.30 48044 P P 535 308 2024.08.06 06:29:37.586 2024.08.06 06:29:38.121 2024.08.06 05:36:15.526 2024.08.06 05:36:15.834
37 5.0.1.1453 2024.07.28 8d956 P P 592 260 2024.07.30 06:24:37.641 2024.07.30 06:24:38.233 2024.07.30 05:31:35.141 2024.07.30 05:31:35.401
38 5.0.1.1429 2024.07.19 8ee90 P P 492 300 2024.07.27 06:24:00.960 2024.07.27 06:24:01.452 2024.07.27 05:29:31.249 2024.07.27 05:29:31.549
39 5.0.1.1428 2024.07.15 00392 P P 520 309 2024.07.19 06:18:07.220 2024.07.19 06:18:07.740 2024.07.19 05:25:52.417 2024.07.19 05:25:52.726
40 5.0.1.1428 2024.06.30 67a31 P P 564 326 2024.07.15 06:19:16.027 2024.07.15 06:19:16.591 2024.07.15 05:26:01.405 2024.07.15 05:26:01.731
41 5.0.1.1415 2024.06.11 31d74 P P 476 278 2024.06.22 06:08:56.264 2024.06.22 06:08:56.740 2024.06.22 05:18:06.828 2024.06.22 05:18:07.106

Elapsed time, ms. Chart for last 41 runs:

Last commits information (all timestamps in UTC):