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)
03. NEW FAILS: tests which failed for LAST run (250 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 (871 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (3 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (27 rows)
07. Has fails: tests with at least one fail for previous 30 runs (1853 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (5 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (24 rows)
[CURRENT] 10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (93 rows)
11. All tests: outcomes for previous 30 runs (3637 rows)
12. Skipped: tests which was intentionally excluded from execution (78 rows)

Generated UTC 02.07.2025 03:53
Tested: FB60.   Build / date: 6.0.0.889-969ac2c0 / 2025.07.01;
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 = "PASSED" after previous outcome = FAIL/ERROR/SKIPPED or absent:

NN Test name mode
6.0.0.889
2025.07.01
6.0.0.881
2025.06.27
6.0.0.877
2025.06.26
6.0.0.876
2025.06.25
6.0.0.863
2025.06.24
6.0.0.858
2025.06.24
6.0.0.858
2025.06.23
6.0.0.854
2025.06.23
6.0.0.849
2025.06.20
6.0.0.848
2025.06.19
6.0.0.845
2025.06.18
6.0.0.843
2025.06.16
6.0.0.840
2025.06.14
6.0.0.838
2025.06.13
6.0.0.834
2025.06.11
6.0.0.800
2025.06.10
6.0.0.799
2025.06.07
6.0.0.797
2025.06.06
6.0.0.795
2025.05.29
6.0.0.792
2025.05.28
6.0.0.791
2025.05.27
6.0.0.789
2025.05.21
6.0.0.787
2025.05.20
6.0.0.783
2025.05.12
6.0.0.779
2025.05.11
6.0.0.778
2025.05.07
6.0.0.776
2025.05.06
6.0.0.770
2025.05.05
6.0.0.767
2025.05.01
6.0.0.762
2025.04.30
Test TITLE
1 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Description (COMMENT ON) for package procedures and functions, and its parameters
2 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Description (COMMENT ON) for package procedures and functions, and its parameters
3 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: ORDER BY clause on compound index may disable usage of other indices
4 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: ORDER BY clause on compound index may disable usage of other indices
5 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: incorrect calculation of byte-length for view columns
6 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: incorrect calculation of byte-length for view columns
7 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
CHAR_TO_UUID on column with index throws expression evaluation not supported. Human readable UUID argument for CHAR_TO_UUID must be of exact length 36
8 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
CHAR_TO_UUID on column with index throws expression evaluation not supported. Human readable UUID argument for CHAR_TO_UUID must be of exact length 36
9 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
10 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
11 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Compound index cannot be used for filtering in some ORDER/GROUP BY queries
12 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Compound index cannot be used for filtering in some ORDER/GROUP BY queries
13 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Lost the charset ID in selection of array element
14 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Lost the charset ID in selection of array element
15 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Alter computed field type does not work
16 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Alter computed field type does not work
17 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Indices on computed fields are broken after restore (all keys are NULL)
18 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Indices on computed fields are broken after restore (all keys are NULL)
19 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Expression index may not be used by the optimizer if created and used in different connection charsets
20 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Expression index may not be used by the optimizer if created and used in different connection charsets
21 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Compiler issues message about "invalid request BLR" when attempt to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL
22 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Compiler issues message about "invalid request BLR" when attempt to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL
23 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Suboptimal join order if one table has a selective predicate and MIN is calculated for the other one
24 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Suboptimal join order if one table has a selective predicate and MIN is calculated for the other one
25 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Unique index could be created on non-unique data
26 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Unique index could be created on non-unique data
27 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Wrong error message with UNIQUE BOOLEAN field
28 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Wrong error message with UNIQUE BOOLEAN field
29 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Invalid computed by definition generated by isql -x
30 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Invalid computed by definition generated by isql -x
31 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Return nonzero result code when restore fails on activating and creating deferred user index
32 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Return nonzero result code when restore fails on activating and creating deferred user index
33 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
ISQL -X may generate invalid GRANT USAGE statements for domains
34 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK
35 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK
36 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
37 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
38 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
39 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
40 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
41 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
42 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Data type unknown error with LIST
43 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Data type unknown error with LIST
44 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Malformed string error when using cyrilic symbols and x'0d0a' in exception
45 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Malformed string error when using cyrilic symbols and x'0d0a' in exception
46 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: (boolean) parameters as search condition no longer allowed
47 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: (boolean) parameters as search condition no longer allowed
48 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Allow subroutines to call others subroutines and themself recursively
49 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Allow subroutines to call others subroutines and themself recursively
50 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Dependencies in Package not recognised
51 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Dependencies in Package not recognised
52 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Inconsistent column/line references when PSQL definitions return errors
53 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Inconsistent column/line references when PSQL definitions return errors
54 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Dependencies are not stored when using some type of contructions in subroutines
55 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Dependencies are not stored when using some type of contructions in subroutines
56 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Performance degradation in FB 3.0.2 compared to FB 2.5.7
57 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Performance degradation in FB 3.0.2 compared to FB 2.5.7
58 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: "Invalid usage of boolean expression" when use "BETWEEN" and "IS" operators
59 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: "Invalid usage of boolean expression" when use "BETWEEN" and "IS" operators
60 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Support for DROP IDENTITY clause
61 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Support for DROP IDENTITY clause
62 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Badly selective index could be used for extra filtering even if selective index is used for sorting
63 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Badly selective index could be used for extra filtering even if selective index is used for sorting
64 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Support GENERATED ALWAYS identity columns and OVERRIDE clause
65 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Support GENERATED ALWAYS identity columns and OVERRIDE clause
66 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Provide ability to filter out info and warnings from trace log
67 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Provide ability to filter out info and warnings from trace log
68 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Available indices are not used in some cases if ORDER BY expression is a filtered one
69 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Available indices are not used in some cases if ORDER BY expression is a filtered one
70 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Bad performance for NULLs filtering inside a navigational index scan
71 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Bad performance for NULLs filtering inside a navigational index scan
72 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Creating a column of type BLOB SUB_TYPE BINARY fails with a Token unknown
73 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Creating a column of type BLOB SUB_TYPE BINARY fails with a Token unknown
74 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Connections compressed and encrypted in MON$ATTACHMENTS table
75 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Connections compressed and encrypted in MON$ATTACHMENTS table
76 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Direct system table modifications are not completely prohibited
77 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Direct system table modifications are not completely prohibited
78 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Bugcheck on queries containing WITH LOCK clause
79 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Bugcheck on queries containing WITH LOCK clause
80 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Signature of packaged functions is not checked for mismatch with [NOT] DETERMINISTIC attribute
81 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Signature of packaged functions is not checked for mismatch with [NOT] DETERMINISTIC attribute
82 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
83 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
84 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field
85 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field
86 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
CREATE DATABASE grant is lost in security.db after backup/restore cycle
87 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
CREATE DATABASE grant is lost in security.db after backup/restore cycle
88 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
89 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
90 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: ISQL extracts metadata with non-compilable 'COLLATE' clause if table has column with charset that differ from DB charset
91 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Regression: ISQL extracts metadata with non-compilable 'COLLATE' clause if table has column with charset that differ from DB charset
92 CS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Misplaced collation when extracting metadata with isql
93 SS P F F F F F F F F F F F F F F P P P P P P P P P P P P P P P
Misplaced collation when extracting metadata with isql

Elapsed time, milliseconds:

NN Test name mode median_ms
6.0.0.889
2025.07.01
6.0.0.881
2025.06.27
6.0.0.877
2025.06.26
6.0.0.876
2025.06.25
6.0.0.863
2025.06.24
6.0.0.858
2025.06.24
6.0.0.858
2025.06.23
6.0.0.854
2025.06.23
6.0.0.849
2025.06.20
6.0.0.848
2025.06.19
6.0.0.845
2025.06.18
6.0.0.843
2025.06.16
6.0.0.840
2025.06.14
6.0.0.838
2025.06.13
6.0.0.834
2025.06.11
6.0.0.800
2025.06.10
6.0.0.799
2025.06.07
6.0.0.797
2025.06.06
6.0.0.795
2025.05.29
6.0.0.792
2025.05.28
6.0.0.791
2025.05.27
6.0.0.789
2025.05.21
6.0.0.787
2025.05.20
6.0.0.783
2025.05.12
6.0.0.779
2025.05.11
6.0.0.778
2025.05.07
6.0.0.776
2025.05.06
6.0.0.770
2025.05.05
6.0.0.767
2025.05.01
6.0.0.762
2025.04.30
Test TITLE
1 CS 594 593 612 598 595 642 616 639 636 598 652 606 645 611 629 599 611 588 584 586 553 542 548 583 579 554 582 584 549 546 539
Description (COMMENT ON) for package procedures and functions, and its parameters
2 SS 422 403 737 499 422 408 429 426 732 693 420 709 423 685 686 713 818 811 807 378 372 359 375 362 382 659 383 373 376 377 375
Description (COMMENT ON) for package procedures and functions, and its parameters
3 CS 687 741 682 702 695 695 738 758 697 693 695 732 724 746 698 680 642 649 646 671 647 774 667 646 639 646 693 666 633 642 679
Regression: ORDER BY clause on compound index may disable usage of other indices
4 SS 448 451 473 480 461 470 468 481 480 468 468 468 466 486 476 477 423 417 434 421 423 414 417 424 420 426 445 426 422 419 420
Regression: ORDER BY clause on compound index may disable usage of other indices
5 CS 585 630 625 584 608 632 628 655 601 593 620 661 587 616 608 593 557 572 579 573 552 570 570 576 547 548 549 604 549 549 537
Regression: incorrect calculation of byte-length for view columns
6 SS 406 396 417 409 406 414 419 421 421 418 441 419 415 408 407 406 600 374 369 360 370 362 369 378 370 372 399 362 410 374 376
Regression: incorrect calculation of byte-length for view columns
7 CS 674 701 673 680 684 687 689 718 678 669 685 702 680 687 721 684 660 631 621 660 628 676 646 633 671 633 634 690 619 660 657
CHAR_TO_UUID on column with index throws expression evaluation not supported. Human readable UUID argument for CHAR_TO_UUID must be of exact length 36
8 SS 443 440 461 456 467 456 450 471 450 452 466 451 446 467 465 453 403 400 419 416 417 417 424 426 402 408 452 420 399 404 423
CHAR_TO_UUID on column with index throws expression evaluation not supported. Human readable UUID argument for CHAR_TO_UUID must be of exact length 36
9 CS 598 615 593 626 619 648 628 672 605 620 593 597 605 654 626 621 599 552 573 581 542 735 573 553 542 578 552 609 546 538 548
Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
10 SS 391 423 406 401 428 402 405 416 436 407 416 413 409 423 416 433 370 370 378 371 370 359 359 381 351 380 377 364 364 370 374
Add datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
11 CS 590 702 626 622 602 628 641 657 586 635 591 589 589 599 592 596 600 608 544 543 546 736 552 545 584 569 550 572 555 552 570
Compound index cannot be used for filtering in some ORDER/GROUP BY queries
12 SS 400 442 406 409 409 409 417 410 404 404 459 422 406 436 413 428 369 377 358 368 364 369 357 376 366 358 397 372 360 371 381
Compound index cannot be used for filtering in some ORDER/GROUP BY queries
13 CS 592 590 612 593 598 627 594 678 599 594 591 594 595 596 594 589 545 598 540 548 548 742 588 545 542 563 548 615 543 567 540
Lost the charset ID in selection of array element
14 SS 390 388 405 403 412 411 393 408 409 421 413 405 405 422 405 420 365 370 359 359 364 371 358 375 361 359 396 360 365 360 377
Lost the charset ID in selection of array element
15 CS 977 1064 840 819 844 857 839 897 815 818 817 872 801 804 839 823 978 981 998 1030 988 1147 985 976 986 1017 985 1063 989 997 987
Alter computed field type does not work
16 SS 656 718 596 585 577 566 588 567 581 561 559 582 561 592 568 561 686 676 686 685 656 678 676 677 662 657 723 671 688 665 660
Alter computed field type does not work
17 CS 1067 1069 1074 1106 1100 1117 1092 1226 1077 1066 1079 1098 1126 1069 1154 1111 984 993 993 974 992 1049 979 978 1002 1000 998 1113 987 992 1025
Indices on computed fields are broken after restore (all keys are NULL)
18 SS 791 786 810 825 831 796 811 802 837 799 804 818 806 848 832 807 730 722 721 705 711 716 724 714 711 722 905 722 719 705 718
Indices on computed fields are broken after restore (all keys are NULL)
19 CS 668 669 667 702 686 706 699 782 686 712 679 693 742 720 713 662 694 675 633 625 647 659 621 625 609 618 626 663 624 664 650
Expression index may not be used by the optimizer if created and used in different connection charsets
20 SS 443 441 447 483 466 451 452 451 445 447 459 487 450 464 450 466 406 414 440 416 407 408 583 404 409 418 441 407 405 423 409
Expression index may not be used by the optimizer if created and used in different connection charsets
21 CS 591 623 581 591 593 625 593 691 622 624 597 590 665 630 617 594 561 592 541 553 557 645 546 550 545 560 549 560 554 553 592
Compiler issues message about "invalid request BLR" when attempt to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL
22 SS 390 407 410 411 464 407 398 402 407 407 407 410 408 413 402 401 362 374 370 359 371 376 372 358 356 363 382 361 373 378 361
Compiler issues message about "invalid request BLR" when attempt to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL
23 CS 592 603 602 631 622 640 607 662 602 608 591 593 627 622 626 623 549 549 575 574 553 577 549 547 541 552 568 621 556 553 554
Suboptimal join order if one table has a selective predicate and MIN is calculated for the other one
24 SS 389 386 414 411 416 401 411 414 402 416 414 408 412 434 417 432 371 379 367 362 371 360 382 359 363 376 392 369 380 374 364
Suboptimal join order if one table has a selective predicate and MIN is calculated for the other one
25 CS 688 710 721 692 690 699 698 766 721 718 715 691 695 690 716 707 675 647 639 662 643 675 680 640 667 645 644 686 641 669 673
Unique index could be created on non-unique data
26 SS 484 487 484 485 499 498 505 493 496 497 496 488 500 538 512 546 454 471 454 452 472 455 459 447 458 462 485 461 457 457 458
Unique index could be created on non-unique data
27 CS 595 595 626 632 632 638 625 676 637 598 633 630 604 596 643 604 550 594 560 579 577 620 575 574 540 561 550 589 550 553 560
Wrong error message with UNIQUE BOOLEAN field
28 SS 403 408 418 404 415 408 420 422 424 424 405 405 405 425 436 428 378 379 367 373 364 373 374 379 373 378 402 376 377 378 375
Wrong error message with UNIQUE BOOLEAN field
29 CS 1251 1362 1122 1129 1165 1130 1175 1225 1128 1124 1131 1131 1112 1125 1178 1214 1268 1267 1311 1274 1267 1379 1271 1267 1257 1294 1285 1489 1286 1258 1246
Invalid computed by definition generated by isql -x
30 SS 877 944 816 794 780 785 797 789 782 779 798 781 779 794 778 802 897 901 893 903 878 885 878 886 882 879 968 877 879 880 888
Invalid computed by definition generated by isql -x
31 CS 1038 1079 1048 1062 1040 1088 1093 1158 1038 1083 1057 1038 1042 1061 1078 1070 971 942 946 949 930 1020 953 935 967 951 958 1191 937 982 948
Return nonzero result code when restore fails on activating and creating deferred user index
32 SS 729 750 757 763 1000 764 765 757 778 756 767 765 764 764 782 794 686 674 673 672 658 674 673 673 662 665 708 687 658 670 658
Return nonzero result code when restore fails on activating and creating deferred user index
33 CS 932 932 953 957 965 937 938 1020 945 971 969 937 955 972 960 933 851 879 837 832 831 884 841 841 843 841 846 1097 834 829 824
ISQL -X may generate invalid GRANT USAGE statements for domains
34 CS 600 599 637 614 602 666 629 699 617 597 631 635 635 612 603 605 574 568 552 588 555 621 556 554 583 554 560 749 546 584 561
Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK
35 SS 405 392 417 417 415 411 422 419 424 416 454 433 415 435 427 425 386 395 377 399 374 365 378 373 374 371 415 370 386 387 371
Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK
36 CS 842 842 856 829 849 892 843 913 890 894 847 847 865 912 877 842 779 821 819 785 784 875 784 782 787 799 794 1051 775 849 777
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
37 SS 569 564 573 585 589 578 582 603 575 593 573 592 571 809 607 634 554 555 542 603 548 536 538 537 533 536 568 532 532 551 531
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
38 CS 4193 4221 4196 4223 4198 4231 4464 4572 4487 4190 4213 4238 4406 4341 4392 4217 3962 4032 3911 3930 4030 4221 3872 4103 3873 3911 3983 4097 4121 3914 3894
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
39 SS 2376 2438 2393 2415 2408 2394 2429 2407 2370 2413 2422 2383 2395 2428 2430 2460 2214 2201 2195 2200 2200 2233 2233 2250 2182 2210 2593 2227 2198 2235 2291
Improve consistency in GRANT syntax between roles and privileges according to SQL standard
40 CS 11175 11165 11210 11175 11190 11229 11147 11258 11206 11198 11160 11205 11198 11269 11137 11154 11243 11154 11173 11212 11191 11181 11165 11169 11145 11160 11152 11176 11205 11155 11151
Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
41 SS 10737 10753 10755 10757 10765 10742 10775 10767 10759 10761 10774 10772 10753 10768 10760 10840 10716 10727 10710 10724 10715 10732 10713 10711 10693 10721 10701 10708 10714 10723 10722
Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
42 CS 581 588 584 582 585 620 627 671 612 591 584 586 618 642 634 580 548 550 554 541 551 576 596 557 540 540 546 563 565 545 542
Data type unknown error with LIST
43 SS 390 391 407 403 417 406 390 413 406 439 394 408 421 393 395 418 376 361 360 364 362 360 364 358 361 356 361 373 413 358 352
Data type unknown error with LIST
44 CS 593 616 594 599 593 644 652 639 601 614 620 619 594 621 599 621 550 551 546 572 547 568 561 610 537 552 548 558 558 574 531
Malformed string error when using cyrilic symbols and x'0d0a' in exception
45 SS 387 388 409 420 398 397 411 404 410 393 403 397 406 414 405 414 360 363 354 371 386 374 382 362 357 371 360 380 372 374 367
Malformed string error when using cyrilic symbols and x'0d0a' in exception
46 CS 796 584 842 798 839 857 817 901 849 789 874 830 795 831 835 804 811 745 786 748 752 812 749 812 770 766 750 758 745 741 759
Regression: (boolean) parameters as search condition no longer allowed
47 SS 524 396 548 531 564 547 553 564 573 543 591 543 540 594 541 838 499 499 497 498 497 503 505 497 957 516 517 504 500 512 508
Regression: (boolean) parameters as search condition no longer allowed
48 CS 642 628 705 696 694 728 709 763 748 707 733 705 693 737 707 697 600 597 610 596 595 651 595 634 618 595 615 593 605 625 618
Allow subroutines to call others subroutines and themself recursively
49 SS 463 438 505 490 493 490 488 492 491 501 527 501 498 517 496 526 407 428 420 424 408 410 412 410 616 424 423 410 410 409 408
Allow subroutines to call others subroutines and themself recursively
50 CS 620 643 623 623 622 647 659 709 696 625 653 621 619 615 705 642 569 645 599 579 604 606 566 607 622 606 588 568 599 598 570
Dependencies in Package not recognised
51 SS 420 418 426 426 436 422 425 434 440 440 468 443 446 440 437 471 401 405 390 391 398 397 389 381 605 393 381 380 386 381 396
Dependencies in Package not recognised
52 CS 583 584 590 627 583 631 603 665 659 584 618 605 584 629 593 642 542 577 556 595 552 572 570 580 574 544 537 548 540 543 575
Inconsistent column/line references when PSQL definitions return errors
53 SS 390 389 404 404 663 417 410 411 414 407 422 404 404 414 402 421 363 357 361 356 357 356 391 365 350 368 357 364 366 362 363
Inconsistent column/line references when PSQL definitions return errors
54 CS 614 613 625 657 616 653 651 694 661 651 612 653 617 651 653 618 571 628 570 600 602 620 564 589 557 600 581 568 590 567 592
Dependencies are not stored when using some type of contructions in subroutines
55 SS 410 410 439 434 454 440 410 437 426 441 422 425 431 428 436 464 376 385 382 377 388 394 380 377 376 430 376 388 391 390 385
Dependencies are not stored when using some type of contructions in subroutines
56 CS 617 615 625 627 620 665 639 698 645 624 625 656 658 625 631 616 612 601 574 586 612 618 607 635 566 580 577 580 570 580 578
Performance degradation in FB 3.0.2 compared to FB 2.5.7
57 SS 416 423 439 439 429 454 426 438 437 441 436 441 446 431 436 466 376 409 388 388 408 398 392 390 395 406 386 396 387 403 390
Performance degradation in FB 3.0.2 compared to FB 2.5.7
58 CS 579 580 577 573 616 645 607 649 648 594 591 628 579 644 588 619 541 570 549 541 541 583 536 558 572 588 569 546 542 583 568
Regression: "Invalid usage of boolean expression" when use "BETWEEN" and "IS" operators
59 SS 382 396 391 406 396 404 389 402 398 402 401 405 415 406 410 434 364 356 376 362 359 360 362 364 346 357 364 358 363 363 358
Regression: "Invalid usage of boolean expression" when use "BETWEEN" and "IS" operators
60 CS 591 668 597 589 601 614 603 690 660 595 638 630 608 619 623 593 597 577 551 545 545 580 549 563 539 550 548 543 551 580 537
Support for DROP IDENTITY clause
61 SS 389 393 404 407 425 414 409 420 406 403 401 400 407 431 403 439 358 363 370 373 374 363 359 376 360 381 386 359 360 359 368
Support for DROP IDENTITY clause
62 CS 3616 3827 3636 3635 3617 3637 3703 3688 3832 3626 3675 3653 3633 3674 3673 3676 3587 3584 3574 3599 3579 3616 3577 3613 3593 3592 3570 3605 3590 3592 3584
Badly selective index could be used for extra filtering even if selective index is used for sorting
63 SS 3375 3382 3366 3387 3386 3390 3387 3397 3385 3379 3408 3387 3389 3396 3397 3431 3338 3350 3413 3327 3320 3364 3330 3355 3341 3322 3354 3355 3367 3371 3337
Badly selective index could be used for extra filtering even if selective index is used for sorting
64 CS 597 645 608 663 632 653 680 672 628 594 604 604 601 602 602 614 588 580 582 579 558 616 572 589 551 558 562 582 557 586 577
Support GENERATED ALWAYS identity columns and OVERRIDE clause
65 SS 396 393 412 412 449 418 411 418 400 425 421 429 407 426 432 444 373 372 374 370 375 376 368 377 460 376 373 375 380 366 365
Support GENERATED ALWAYS identity columns and OVERRIDE clause
66 CS 3407 3455 3255 3274 3277 3322 3311 3333 3360 3299 3287 3308 3269 3416 3337 3266 3439 3442 3415 3420 3414 3438 3414 3446 3398 3417 3442 3417 3401 3457 3438
Provide ability to filter out info and warnings from trace log
67 SS 2994 2944 3110 3131 3073 3085 3053 3051 3041 3072 3080 3067 3078 3088 3071 3114 2921 2945 2925 2936 2945 2913 2962 2919 3021 2937 2968 2920 2936 2921 2922
Provide ability to filter out info and warnings from trace log
68 CS 605 607 613 613 610 666 633 716 641 604 657 611 607 617 602 648 563 588 571 561 593 635 569 595 554 617 570 560 566 562 549
Available indices are not used in some cases if ORDER BY expression is a filtered one
69 SS 409 401 421 421 422 429 430 418 420 443 423 421 472 424 419 451 375 377 375 381 375 382 381 374 467 397 379 396 378 379 373
Available indices are not used in some cases if ORDER BY expression is a filtered one
70 CS 3629 3672 3679 3643 3628 3652 3803 3709 3687 3675 3630 3622 3738 3646 3626 3683 3623 3570 3623 3577 3642 3718 3602 3635 3605 3592 3609 3592 3613 3605 3607
Bad performance for NULLs filtering inside a navigational index scan
71 SS 3384 3379 3383 3389 3398 3401 3422 3400 3377 3391 3493 3398 3385 3387 3380 3458 3413 3355 3326 3392 3341 3332 3354 3331 4062 3337 3338 3399 3358 3337 3339
Bad performance for NULLs filtering inside a navigational index scan
72 CS 593 592 629 643 596 632 665 675 705 594 598 596 592 633 598 623 562 554 546 552 600 582 553 615 549 548 550 549 548 554 572
Creating a column of type BLOB SUB_TYPE BINARY fails with a Token unknown
73 SS 405 408 410 407 405 408 408 411 413 430 427 422 409 409 406 427 376 365 361 358 358 360 372 365 458 377 378 363 361 363 400
Creating a column of type BLOB SUB_TYPE BINARY fails with a Token unknown
74 CS 579 589 625 617 591 614 613 641 585 616 593 594 586 582 591 587 541 549 549 541 552 547 532 566 528 577 570 552 541 533 574
Connections compressed and encrypted in MON$ATTACHMENTS table
75 SS 390 386 404 403 398 406 416 416 407 404 420 407 402 404 407 421 353 359 359 361 362 379 367 357 395 359 357 360 357 360 360
Connections compressed and encrypted in MON$ATTACHMENTS table
76 CS 582 581 620 623 594 628 627 662 602 601 591 619 586 597 638 584 640 543 542 544 574 571 551 560 536 555 555 564 536 570 554
Direct system table modifications are not completely prohibited
77 SS 385 390 414 394 401 411 404 404 392 408 412 408 407 407 419 440 365 360 363 356 362 371 362 380 367 362 363 374 370 375 359
Direct system table modifications are not completely prohibited
78 CS 1841 1844 1860 1876 1871 1859 1985 1969 1869 1870 1915 1894 1854 1877 1910 1839 1767 1799 1770 1814 1812 1845 1750 1778 1731 1765 1758 1795 1751 1720 1753
Bugcheck on queries containing WITH LOCK clause
79 SS 1230 1276 1262 1244 1267 1253 1300 1246 1248 1264 1277 1267 1264 1284 1282 1383 1149 1153 1172 1154 1152 1164 1144 1147 1150 1163 1171 1152 1146 1216 1197
Bugcheck on queries containing WITH LOCK clause
80 CS 589 590 595 597 589 645 629 668 596 589 601 622 589 625 602 602 543 571 549 580 546 610 561 554 582 593 557 545 558 567 551
Signature of packaged functions is not checked for mismatch with [NOT] DETERMINISTIC attribute
81 SS 388 387 409 409 421 424 399 417 400 414 410 421 422 420 412 453 365 368 372 366 378 367 366 379 371 373 365 376 366 384 390
Signature of packaged functions is not checked for mismatch with [NOT] DETERMINISTIC attribute
82 CS 5276 5802 5417 5214 5275 5486 5618 5271 5193 5534 5516 5543 5339 5417 5484 5136 5061 5066 5231 5202 5291 5573 5278 5051 5300 5204 5213 5204 5302 5199 5192
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
83 SS 4445 4492 4305 4808 4340 4420 4562 4342 4352 4575 4567 4543 4739 4602 4609 4671 4222 4215 5303 4329 4430 4476 4460 4795 4364 4360 4412 4383 4419 4418 5224
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
84 CS 1126 1170 1183 1143 1132 1150 1136 1157 1120 2031 2450 2072 2945 2377 2010 1933 1101 1127 1125 1058 1062 1066 1072 1092 1055 1068 1120 1069 1053 1091 1058
Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field
85 SS 785 797 791 823 792 784 796 811 787 1907 1730 1764 2637 1743 2387 2287 787 751 743 770 743 757 776 781 759 739 745 776 742 742 742
Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field
86 CS 981 1041 1071 1089 1084 1088 1041 1083 1069 1080 1070 1082 1091 1076 1136 1097 896 913 913 918 907 917 898 909 901 899 903 908 912 921 897
CREATE DATABASE grant is lost in security.db after backup/restore cycle
87 SS 805 871 864 995 957 902 865 1024 885 866 878 889 865 901 857 859 710 714 750 705 718 754 709 699 697 714 709 707 707 715 704
CREATE DATABASE grant is lost in security.db after backup/restore cycle
88 CS 1462 1461 1477 1527 1480 1517 1508 1533 1532 1506 1472 1504 1529 1489 1518 1501 1453 1458 1369 1380 1464 1404 1377 1392 1427 1405 1375 1365 1395 1381 1359
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
89 SS 986 986 1063 1060 1040 1059 986 1019 1045 983 1025 1045 1023 1340 1004 1010 963 947 932 950 934 958 987 954 918 954 921 916 991 906 988
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
90 CS 1272 1298 1317 1320 1279 1315 1312 1353 1284 1279 1289 1282 1285 1316 1287 1266 1316 1230 1213 1235 1207 1220 1202 1217 1208 1205 1230 1186 1198 1188 1207
Regression: ISQL extracts metadata with non-compilable 'COLLATE' clause if table has column with charset that differ from DB charset
91 SS 874 884 892 893 883 877 890 896 910 870 898 942 866 918 888 892 857 877 847 871 855 850 887 837 833 865 861 810 849 854 841
Regression: ISQL extracts metadata with non-compilable 'COLLATE' clause if table has column with charset that differ from DB charset
92 CS 1281 1354 1301 1328 1323 1329 1293 1398 1295 2050 2012 2552 3202 2446 2599 2693 1227 1225 1262 1260 1235 1222 1231 1222 1208 1269 1255 1227 1233 1253 1252
Misplaced collation when extracting metadata with isql
93 SS 883 929 887 899 919 894 884 886 907 2210 2730 2404 2828 2110 2242 1680 833 873 861 861 848 846 882 870 849 848 848 830 864 847 846
Misplaced collation when extracting metadata with isql

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-4484
http://tracker.firebirdsql.org/browse/CORE-5020
http://tracker.firebirdsql.org/browse/CORE-5049
http://tracker.firebirdsql.org/browse/CORE-5062
http://tracker.firebirdsql.org/browse/CORE-5064
http://tracker.firebirdsql.org/browse/CORE-5070
http://tracker.firebirdsql.org/browse/CORE-5074
http://tracker.firebirdsql.org/browse/CORE-5093
http://tracker.firebirdsql.org/browse/CORE-5118
http://tracker.firebirdsql.org/browse/CORE-5122
http://tracker.firebirdsql.org/browse/CORE-5130
http://tracker.firebirdsql.org/browse/CORE-5146
http://tracker.firebirdsql.org/browse/CORE-5161
http://tracker.firebirdsql.org/browse/CORE-5166
http://tracker.firebirdsql.org/browse/CORE-5194
http://tracker.firebirdsql.org/browse/CORE-5201
http://tracker.firebirdsql.org/browse/CORE-5207
http://tracker.firebirdsql.org/browse/CORE-5216
http://tracker.firebirdsql.org/browse/CORE-5218
http://tracker.firebirdsql.org/browse/CORE-5248
http://tracker.firebirdsql.org/browse/CORE-5275
http://tracker.firebirdsql.org/browse/CORE-5313
http://tracker.firebirdsql.org/browse/CORE-5325
http://tracker.firebirdsql.org/browse/CORE-5367
http://tracker.firebirdsql.org/browse/CORE-5380
http://tracker.firebirdsql.org/browse/CORE-5383
http://tracker.firebirdsql.org/browse/CORE-5404
http://tracker.firebirdsql.org/browse/CORE-5410
http://tracker.firebirdsql.org/browse/CORE-5421
http://tracker.firebirdsql.org/browse/CORE-5423
http://tracker.firebirdsql.org/browse/CORE-5431
http://tracker.firebirdsql.org/browse/CORE-5435
http://tracker.firebirdsql.org/browse/CORE-5463
http://tracker.firebirdsql.org/browse/CORE-5475
http://tracker.firebirdsql.org/browse/CORE-5481
http://tracker.firebirdsql.org/browse/CORE-5489
http://tracker.firebirdsql.org/browse/CORE-5494
http://tracker.firebirdsql.org/browse/CORE-5536
http://tracker.firebirdsql.org/browse/CORE-5567
http://tracker.firebirdsql.org/browse/CORE-5576
http://tracker.firebirdsql.org/browse/CORE-5580
http://tracker.firebirdsql.org/browse/CORE-5598
http://tracker.firebirdsql.org/browse/CORE-6040
http://tracker.firebirdsql.org/browse/CORE-6208
http://tracker.firebirdsql.org/browse/CORE-6527
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_misplaced_collation_in_extracted_metadata.py
https://github.com/FirebirdSQL/firebird/issues/7786
=== end of list ===

Last commits information (all timestamps in UTC):