01. Total results for each kind of outcome and server mode, for previous 30 runs
02. NEW CRASHES/BUGCHECKS: tests that caused FB abnormal termination for LAST run (0 rows)
[CURRENT] 03. NEW FAILS: tests which failed for LAST run (17 rows)
04. NEW ERRORS: tests which raised runtime error for LAST run (0 rows)
04. STILL FAILS: tests which fail for at least TWO LAST runs (9 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (4 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (9 rows)
07. Has fails: tests with at least one fail for previous 30 runs (117 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (705 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (0 rows)
10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (752 rows)
11. All tests: outcomes for previous 30 runs (3253 rows)
12. Skipped: tests which was intentionally excluded from execution (74 rows)

Generated UTC 28.06.2025 13:42
Tested: HQ40.   Build / date: 4.0.6.3189-1a1a50e4 / 2025.02.25;
Test machine: Windows 10 10.0.19045; logical CPUs: 8; RAM: 31 Gb 
QA software: Python: 3.11.2; pytest: 7.4.4; firebird.driver: 1.10.9; firebird.Qa: 0.19.3 
Jump to the list of unique test names from this report
Jump to the list with last developing commits information

Tests with result = "FAIL" for LAST run:

NN Test name mode
4.0.6.3189
2025.02.25
1a1a5
4.0.6.3184
2025.02.24
9388c
4.0.6.3183
2025.02.17
e4762
4.0.6.3169
2024.12.13
42cc1
4.0.6.3169
2024.12.08
50eb6
4.0.6.3168
2024.12.07
98d69
4.0.6.3168
2024.12.05
cee43
4.0.6.3168
2024.11.28
48149
4.0.6.3163
2024.10.30
832db
4.0.6.3163
2024.10.16
2bb10
4.0.6.3147
2024.09.10
a4d11
4.0.6.3147
2024.08.31
4655b
4.0.6.3140
2024.08.16
1dd8b
4.0.6.3140
2024.08.09
34747
4.0.5.3110
2024.08.06
f851c
4.0.5.3110
2024.07.30
c6527
4.0.5.3109
2024.06.11
6addf
4.0.5.3097
2024.05.09
27fa6
4.0.5.3091
2024.04.29
bd0aa
4.0.5.3089
2024.04.20
9eb9b
4.0.5.3083
2024.04.06
300f9
4.0.5.3052
2024.03.16
0f422
4.0.5.3052
2024.03.16
ce273
4.0.5.3052
2024.02.12
cd058
4.0.5.3052
2024.02.07
be290
4.0.5.3052
2024.02.07
6409b
4.0.5.3052
2024.02.02
bbc3f
4.0.5.3052
2024.01.26
48b7c
4.0.5.3052
2024.01.26
9a7b3
4.0.5.3049
2024.01.25
f6b9d
Test TITLE
1
bugs core 0203 
 tracker
 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW ignores PLAN
2
bugs core 0203 
 tracker
 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW ignores PLAN
3
bugs gh 8182 
 tracker
 CS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
4
bugs gh 8182 
 tracker
 SS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
5
bugs gh 8462 
 tracker
 CS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
6
bugs gh 8462 
 tracker
 SS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
7
bugs gh 8477 
 tracker
 CS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Inheritance of WINDOW does not work
8
bugs gh 8477 
 tracker
 SS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Inheritance of WINDOW does not work
9
bugs gh 8520 
 tracker
 CS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Error in iTransaction.getInfo() on embedded connection
10
bugs gh 8520 
 tracker
 SS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Error in iTransaction.getInfo() on embedded connection
11
bugs gh 8589 
 tracker
 CS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
PERCENT_RANK may return NaN instead of 0
12
bugs gh 8589 
 tracker
 SS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
PERCENT_RANK may return NaN instead of 0
13
bugs gh 8592 
 tracker
 CS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
14
bugs gh 8592 
 tracker
 SS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
15
functional arno optimizer opt sort by index 10 
 SS F E F F F F F F F F E F E F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
16
functional arno optimizer opt sort by index 13 
 SS F E F F F F F F F F E F E F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi)
17
functional arno optimizer opt sort by index 19 
 SS F E F F F F F F F F E F E F F F F F F F F F F F F F F F F F
ORDER BY ASC using index (multi) and WHERE clause

Elapsed time, milliseconds:

NN Test name mode median_ms
4.0.6.3189
2025.02.25
1a1a5
4.0.6.3184
2025.02.24
9388c
4.0.6.3183
2025.02.17
e4762
4.0.6.3169
2024.12.13
42cc1
4.0.6.3169
2024.12.08
50eb6
4.0.6.3168
2024.12.07
98d69
4.0.6.3168
2024.12.05
cee43
4.0.6.3168
2024.11.28
48149
4.0.6.3163
2024.10.30
832db
4.0.6.3163
2024.10.16
2bb10
4.0.6.3147
2024.09.10
a4d11
4.0.6.3147
2024.08.31
4655b
4.0.6.3140
2024.08.16
1dd8b
4.0.6.3140
2024.08.09
34747
4.0.5.3110
2024.08.06
f851c
4.0.5.3110
2024.07.30
c6527
4.0.5.3109
2024.06.11
6addf
4.0.5.3097
2024.05.09
27fa6
4.0.5.3091
2024.04.29
bd0aa
4.0.5.3089
2024.04.20
9eb9b
4.0.5.3083
2024.04.06
300f9
4.0.5.3052
2024.03.16
0f422
4.0.5.3052
2024.03.16
ce273
4.0.5.3052
2024.02.12
cd058
4.0.5.3052
2024.02.07
be290
4.0.5.3052
2024.02.07
6409b
4.0.5.3052
2024.02.02
bbc3f
4.0.5.3052
2024.01.26
48b7c
4.0.5.3052
2024.01.26
9a7b3
4.0.5.3049
2024.01.25
f6b9d
Test TITLE
1
bugs core 0203 
 tracker
 CS 635 1119 708 728 692 716 722 723 726 689 727 698 732 758 758 776 581 571 531 532 531 516 515 483 484 468 467 468 484 484 483
CREATE VIEW ignores PLAN
2
bugs core 0203 
 tracker
 SS 444 835 487 512 512 509 540 488 481 487 524 507 486 529 548 537 392 407 313 312 313 313 297 296 296 296 312 296 296 312 295
CREATE VIEW ignores PLAN
3
bugs gh 8182 
 tracker
 CS 610 610 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
4
bugs gh 8182 
 tracker
 SS 431 431 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
5
bugs gh 8462 
 tracker
 CS 1747 1747 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
6
bugs gh 8462 
 tracker
 SS 1071 1071 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
A user with "GRANT_REVOKE_ON_ANY_OBJECT" privilege can't revoke a role from himself if he is not a grantor
7
bugs gh 8477 
 tracker
 CS 637 637 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inheritance of WINDOW does not work
8
bugs gh 8477 
 tracker
 SS 410 410 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inheritance of WINDOW does not work
9
bugs gh 8520 
 tracker
 CS 769 769 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Error in iTransaction.getInfo() on embedded connection
10
bugs gh 8520 
 tracker
 SS 467 467 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Error in iTransaction.getInfo() on embedded connection
11
bugs gh 8589 
 tracker
 CS 604 604 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PERCENT_RANK may return NaN instead of 0
12
bugs gh 8589 
 tracker
 SS 425 425 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PERCENT_RANK may return NaN instead of 0
13
bugs gh 8592 
 tracker
 CS 643 643 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
14
bugs gh 8592 
 tracker
 SS 429 429 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Presence of 'ROWS <n_limit>' causes garbage in error message when string conversion problem raises
15
functional arno optimizer opt sort by index 10 
 SS 546 567 2242 593 577 598 609 822 604 583 580 2391 574 2244 610 621 525 489 390 391 375 375 360 358 359 453 359 453 468 421 421
ORDER BY ASC using index (multi)
16
functional arno optimizer opt sort by index 13 
 SS 542 569 2410 577 569 578 587 581 584 568 575 2235 574 2414 618 620 516 489 391 391 375 391 359 358 359 358 359 358 359 359 358
ORDER BY ASC using index (multi)
17
functional arno optimizer opt sort by index 19 
 SS 417 421 2244 443 418 423 448 445 417 450 426 2230 433 2407 471 478 422 348 265 250 266 250 235 234 233 233 233 233 233 233 234
ORDER BY ASC using index (multi) and WHERE clause

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-203
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_10.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_13.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_19.py
https://github.com/FirebirdSQL/firebird/issues/8182
https://github.com/FirebirdSQL/firebird/issues/8462
https://github.com/FirebirdSQL/firebird/issues/8477
https://github.com/FirebirdSQL/firebird/issues/8520
https://github.com/FirebirdSQL/firebird/issues/8589
https://github.com/FirebirdSQL/firebird/issues/8592
=== end of list ===

Last commits information (all timestamps in UTC):