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 (0 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 (1182 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (1 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 (1618 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 (103 rows)
11. All tests: outcomes for previous 30 runs (3520 rows)
12. Skipped: tests which was intentionally excluded from execution (78 rows)

Generated UTC 28.06.2025 03:49
Tested: FB60.   Build / date: 6.0.0.881-7035d6ee / 2025.06.27;
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 
Loading data. Please wait...

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.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
6.0.0.755
2025.04.29
Test TITLE
1 SS P 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 F P
Count (DISTINCT ...) is too slow
2 CS P 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 P
Views based on procedures can't be created if the proc's output fields participate in an expression
3 SS P 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 P
Views based on procedures can't be created if the proc's output fields participate in an expression
4 CS P 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 P
Prohibit any improper mixture of explicit and implicit joins
5 SS P 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 P
Prohibit any improper mixture of explicit and implicit joins
6 CS P 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 P
Join condition fails for UTF-8 databases
7 SS P 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 P
Join condition fails for UTF-8 databases
8 CS P 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 P
Natural is used to select instead of primary key index
9 SS P 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 P
Natural is used to select instead of primary key index
10 CS P 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 P
isql should show packaged procedures and functions categorized per package
11 SS P 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 P
isql should show packaged procedures and functions categorized per package
12 CS P 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 P
PK index is not used for derived tables
13 SS P 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 P
PK index is not used for derived tables
14 CS P 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 P
Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1)
15 SS P 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 P
Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1)
16 CS P 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 P
Broken error handling in the case of a conversion error happened during index creation
17 SS P 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 P
Broken error handling in the case of a conversion error happened during index creation
18 CS P 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 P
DROP VIEW drops output parameters of used stored procedures
19 SS P 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 P
DROP VIEW drops output parameters of used stored procedures
20 CS P 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 P
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
21 SS P 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 P
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
22 CS P 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 P
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
23 SS P 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 P
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
24 CS P 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 P
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
25 SS P 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 P
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
26 CS P 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 P
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
27 SS P 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 P
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
28 CS P 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 P
Using both the procedure name and alias inside an explicit plan crashes the server
29 SS P 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 P
Using both the procedure name and alias inside an explicit plan crashes the server
30 CS P 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 P
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
31 SS P 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 P
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
32 CS P 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 P
Cannot alter the domain after migrating from older versions
33 SS P 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 P
Cannot alter the domain after migrating from older versions
34 CS P 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 P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
35 SS P 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 P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
36 CS P 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 P
Expression index with TRIM may lead to incorrect indexed lookup
37 SS P 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 P
Expression index with TRIM may lead to incorrect indexed lookup
38 CS P 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 P
ALTER VIEW with not matched columns in declaration and selection crashes the server
39 SS P 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 P
ALTER VIEW with not matched columns in declaration and selection crashes the server
40 CS P 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 P
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
41 SS P 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 P
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
42 CS P 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 P
UTF8 UNICODE_CI collate can not be used in compound index
43 SS P 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 P
UTF8 UNICODE_CI collate can not be used in compound index
44 CS P 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 P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
45 SS P 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 P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
46 CS P 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 P
"BLOB not found" error after creation/altering of the invalid trigger
47 SS P 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 P
"BLOB not found" error after creation/altering of the invalid trigger
48 CS P 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 P
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
49 SS P 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 P
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
50 CS P 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 P
Sub-optimal join plan when the slave table depends on the master via the "OR" predicate
51 SS P 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 P
Sub-optimal join plan when the slave table depends on the master via the "OR" predicate
52 CS P 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 P
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
53 SS P 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 P
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
54 CS P 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 P
Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB
55 SS P 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 P
Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB
56 CS P 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 P
Generators are set to 0 after restore
57 SS P 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 P
Generators are set to 0 after restore
58 CS P 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 P
Blob filter to translate internal debug info into text representation
59 SS P 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 P
Blob filter to translate internal debug info into text representation
60 CS P 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 P
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
61 SS P 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 P
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
62 CS P 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 P
Recurse leads to hangs/crash server
63 SS P 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 P
Recurse leads to hangs/crash server
64 CS P 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 P
[FB3] AV with "UPDATE OR INSERT"
65 SS P 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 P
[FB3] AV with "UPDATE OR INSERT"
66 CS P 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 P
Inefficient optimization (regression)
67 SS P 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 P
Inefficient optimization (regression)
68 CS P 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 P
Regression in joins on procedures
69 SS P 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 P
Regression in joins on procedures
70 CS P 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 P
Altering of a TYPE OF COLUMN parameter affects the original column
71 SS P 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 P
Altering of a TYPE OF COLUMN parameter affects the original column
72 CS P 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 P
DROP VIEW ignores the existing non-column dependencies
73 SS P 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 P
DROP VIEW ignores the existing non-column dependencies
74 CS P 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 P
Alter procedure allows to add the parameter with the same name
75 SS P 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 P
Alter procedure allows to add the parameter with the same name
76 CS P 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 P
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
77 SS P 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 P
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
78 CS P 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 P
Inconsistent domain's constraint validation in PSQL
79 SS P 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 P
Inconsistent domain's constraint validation in PSQL
80 CS P 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 P
Floating-point negative zero doesn't match positive zero in the index
81 SS P 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 P
Floating-point negative zero doesn't match positive zero in the index
82 CS P 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 P
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
83 SS P 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 P
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
84 CS P 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 P
CHAR(32767) present in XSQLVAR with length 32765
85 SS P 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 P
CHAR(32767) present in XSQLVAR with length 32765
86 CS P 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 P
Include expected and actual string lenght into error message for sqlcode -802
87 SS P 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 P
Include expected and actual string lenght into error message for sqlcode -802
88 CS P 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 P
TRACE: add statistics of actions that were after transaction finished
89 SS P 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 P
TRACE: add statistics of actions that were after transaction finished
90 CS P 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 P
Can insert DUPLICATE keys in UNIQUE index
91 SS P 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 P
Can insert DUPLICATE keys in UNIQUE index
92 CS P 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 P
Server crashes with access violation when inserting row into table with unique index
93 SS P 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 P
Server crashes with access violation when inserting row into table with unique index
94 CS P 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 P
computed index by substring function for long columns
95 SS P 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 P
computed index by substring function for long columns
96 CS P 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 P
Wrong warning message for ambiguous query
97 SS P 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 P
Wrong warning message for ambiguous query
98 CS P 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 P
Wrong warning message for ambiguous query
99 SS P 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 P
Wrong warning message for ambiguous query
100 CS P 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 P
Missing constraint name in foreign key error message in FB 2.1.4
101 SS P 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 P
Missing constraint name in foreign key error message in FB 2.1.4
102 CS P F 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
Restore of encrypted backup of database with SQL dialect 1 fails
103 SS P F 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
Restore of encrypted backup of database with SQL dialect 1 fails

Elapsed time, milliseconds:

NN Test name mode median_ms
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
6.0.0.755
2025.04.29
Test TITLE
1 SS 17657 18033 18471 43018 17628 17353 17350 17966 17874 17656 17539 17454 17664 17824 17772 17658 18107 17539 17657 17626 17705 17683 17286 18185 17489 17382 17799 17343 17332 18053 17286
Count (DISTINCT ...) is too slow
2 CS 586 597 642 585 654 615 595 596 595 597 594 588 598 588 626 580 567 542 566 582 572 574 599 592 544 548 572 539 548 554 570
Views based on procedures can't be created if the proc's output fields participate in an expression
3 SS 375 394 408 2713 420 404 409 397 411 400 402 408 416 405 406 372 373 357 362 373 364 359 377 369 367 362 366 362 364 359 361
Views based on procedures can't be created if the proc's output fields participate in an expression
4 CS 808 820 851 816 855 841 813 815 821 842 818 834 876 828 848 814 753 804 754 754 766 784 768 753 764 750 752 752 756 753 752
Prohibit any improper mixture of explicit and implicit joins
5 SS 543 549 564 3296 576 548 580 781 987 1066 1009 556 998 564 622 502 538 512 516 527 558 519 505 497 512 528 529 503 517 533 533
Prohibit any improper mixture of explicit and implicit joins
6 CS 598 637 604 603 683 613 614 639 649 617 602 635 636 602 597 571 580 558 559 575 554 586 599 590 578 556 569 569 565 561 618
Join condition fails for UTF-8 databases
7 SS 402 407 425 1700 419 420 416 425 421 435 425 424 442 421 711 403 374 376 391 374 377 376 382 379 391 401 377 378 384 373 374
Join condition fails for UTF-8 databases
8 CS 649 687 674 701 702 669 662 664 662 662 689 657 666 652 686 611 616 615 605 647 620 612 612 598 611 608 644 605 617 609 651
Natural is used to select instead of primary key index
9 SS 442 454 465 1201 462 475 485 482 934 474 465 468 883 486 501 422 428 418 420 422 431 426 427 423 428 458 423 425 429 431 430
Natural is used to select instead of primary key index
10 CS 596 603 607 625 641 599 611 601 630 599 606 630 653 677 641 604 561 557 591 562 553 552 594 581 588 560 563 584 586 557 551
isql should show packaged procedures and functions categorized per package
11 SS 384 397 443 1306 419 429 666 424 425 463 417 421 432 423 429 359 382 373 375 374 386 382 375 367 371 359 372 359 377 366 372
isql should show packaged procedures and functions categorized per package
12 CS 775 592 819 809 850 819 795 834 800 821 840 797 808 797 792 778 767 764 771 753 772 755 754 768 771 756 784 746 753 743 740
PK index is not used for derived tables
13 SS 525 392 581 1963 546 544 556 562 561 586 546 543 591 570 837 520 500 498 515 530 512 517 519 497 533 502 516 503 506 519 507
PK index is not used for derived tables
14 CS 589 599 633 598 625 592 594 622 597 630 598 585 641 603 602 638 608 585 585 585 547 556 586 569 583 587 560 549 562 545 548
Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1)
15 SS 388 397 417 1654 409 417 423 408 410 418 403 405 412 418 399 361 367 358 374 376 361 369 357 360 399 360 378 376 378 377 379
Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1)
16 CS 586 622 640 585 620 635 594 607 625 592 588 591 600 603 592 547 598 539 546 547 553 541 545 532 548 545 561 550 550 590 549
Broken error handling in the case of a conversion error happened during index creation
17 SS 378 395 412 1689 403 407 418 409 406 404 404 400 400 402 411 363 359 361 362 360 375 377 362 359 370 367 356 362 372 375 379
Broken error handling in the case of a conversion error happened during index creation
18 CS 787 587 822 798 828 819 816 818 806 835 836 807 826 815 788 782 749 788 750 749 755 750 757 781 766 786 784 785 800 749 739
DROP VIEW drops output parameters of used stored procedures
19 SS 531 390 556 1373 566 558 563 548 563 611 559 563 555 577 560 545 503 518 512 517 531 518 501 501 518 505 524 512 521 532 516
DROP VIEW drops output parameters of used stored procedures
20 CS 805 601 809 835 918 815 810 827 812 814 815 819 864 809 810 771 787 764 803 797 807 765 776 768 789 793 765 775 1051 764 743
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
21 SS 524 390 565 559 604 567 591 855 569 727 850 550 773 569 1128 506 523 522 523 522 523 522 519 522 519 519 523 525 522 525 520
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
22 CS 801 629 874 816 855 821 828 823 825 821 822 808 883 818 807 804 773 765 811 760 754 749 780 758 776 798 783 784 757 748 783
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
23 SS 533 397 562 788 568 569 587 566 561 561 574 558 610 597 589 533 517 526 527 519 529 528 515 522 533 525 534 525 517 525 519
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
24 CS 609 675 621 642 653 628 607 615 647 645 632 613 630 611 620 587 569 603 663 573 605 596 563 560 578 616 591 558 570 566 576
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
25 SS 402 409 439 459 429 442 428 429 430 808 437 438 429 433 428 393 394 391 388 389 381 380 378 395 410 373 378 379 379 380 382
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
26 CS 717 798 758 717 763 718 749 756 748 749 710 718 749 744 759 727 708 675 734 666 655 667 662 682 674 670 680 679 779 657 669
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
27 SS 513 599 537 683 544 543 540 544 553 537 531 524 700 530 534 499 503 658 486 483 477 482 472 479 490 472 492 470 492 489 485
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
28 CS 791 599 802 793 829 833 826 812 839 833 847 789 857 833 823 770 748 752 801 750 758 761 748 753 756 762 749 800 745 813 749
Using both the procedure name and alias inside an explicit plan crashes the server
29 SS 524 387 547 600 539 552 568 540 550 552 544 552 539 566 544 522 507 506 521 495 545 497 506 508 526 520 509 508 508 490 491
Using both the procedure name and alias inside an explicit plan crashes the server
30 CS 594 628 639 600 641 615 610 633 635 607 608 605 656 671 609 575 566 560 614 586 567 554 589 549 555 569 546 579 555 545 552
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
31 SS 412 420 417 558 426 428 420 418 418 428 418 414 419 443 424 811 378 368 379 363 410 376 398 377 366 385 361 377 378 379 376
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
32 CS 925 933 966 984 1088 1009 979 963 946 980 949 967 958 1028 996 890 918 883 915 880 898 886 877 882 911 949 878 883 881 878 896
Cannot alter the domain after migrating from older versions
33 SS 623 644 639 701 641 653 647 626 663 650 652 647 649 652 651 621 602 594 597 582 639 590 592 577 598 585 593 576 587 584 583
Cannot alter the domain after migrating from older versions
34 CS 671 699 683 687 729 720 684 691 684 678 691 711 713 690 740 626 640 637 697 628 634 634 630 628 636 662 664 625 665 644 630
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
35 SS 464 488 493 572 491 497 492 495 536 504 486 515 497 486 479 466 456 449 449 455 463 443 442 441 442 440 439 444 440 445 452
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
36 CS 827 840 843 853 888 858 844 853 859 848 876 842 843 869 850 807 812 802 831 815 797 821 824 820 817 819 787 805 804 801 794
Expression index with TRIM may lead to incorrect indexed lookup
37 SS 571 581 593 608 591 591 593 598 595 620 608 596 669 792 592 548 561 543 553 548 582 543 547 549 554 560 560 553 550 543 548
Expression index with TRIM may lead to incorrect indexed lookup
38 CS 789 592 821 827 848 817 827 836 812 819 839 789 850 803 814 835 785 786 793 744 751 749 759 780 757 789 749 733 738 747 778
ALTER VIEW with not matched columns in declaration and selection crashes the server
39 SS 525 397 561 573 550 567 562 565 559 561 546 559 589 557 549 526 503 515 512 516 549 510 490 505 510 514 525 519 519 508 520
ALTER VIEW with not matched columns in declaration and selection crashes the server
40 CS 797 585 819 798 853 815 804 822 804 852 810 798 828 842 825 766 776 770 828 765 796 794 795 785 758 812 752 772 797 752 758
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
41 SS 534 398 551 568 576 564 555 556 563 569 734 539 774 556 743 517 520 536 515 518 533 516 508 512 508 519 522 515 522 535 516
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
42 CS 618 624 676 657 654 627 664 664 630 660 623 618 623 627 618 623 592 611 607 566 606 580 582 602 581 585 670 610 578 602 580
UTF8 UNICODE_CI collate can not be used in compound index
43 SS 424 414 438 451 455 430 450 440 426 437 824 425 435 424 722 738 392 399 388 393 427 393 388 392 393 392 394 393 396 427 388
UTF8 UNICODE_CI collate can not be used in compound index
44 CS 580 596 599 596 630 590 596 678 592 594 594 599 597 630 626 548 577 557 578 550 544 548 546 536 553 545 576 547 583 547 573
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
45 SS 384 393 404 1331 406 406 419 404 404 436 408 401 404 419 441 380 359 370 353 369 388 363 367 359 359 365 361 367 366 365 361
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
46 CS 582 622 586 590 619 590 599 611 627 595 596 593 592 628 606 556 585 546 553 576 541 546 543 567 552 576 556 541 580 549 548
"BLOB not found" error after creation/altering of the invalid trigger
47 SS 397 393 407 1363 401 410 408 401 401 408 400 404 436 414 410 358 361 438 825 355 394 358 356 359 357 365 367 362 358 362 366
"BLOB not found" error after creation/altering of the invalid trigger
48 CS 794 791 807 798 856 812 843 846 836 835 856 798 843 834 829 832 764 751 753 762 759 763 749 833 753 758 756 752 750 791 756
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
49 SS 544 558 558 913 574 572 571 568 563 576 585 559 556 1033 571 523 533 513 499 513 548 534 517 503 503 502 506 518 541 502 498
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
50 CS 576 586 580 579 618 600 602 596 583 588 589 621 628 595 578 543 544 540 568 550 537 543 545 576 544 542 537 576 550 542 530
Sub-optimal join plan when the slave table depends on the master via the "OR" predicate
51 SS 384 376 393 608 406 402 394 404 412 402 399 406 406 408 396 361 373 363 365 348 395 352 360 356 361 363 360 420 356 344 346
Sub-optimal join plan when the slave table depends on the master via the "OR" predicate
52 CS 589 592 636 592 634 606 594 618 601 627 594 592 597 607 616 574 549 586 541 556 585 618 562 548 553 554 547 552 545 546 543
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
53 SS 396 395 407 608 406 414 413 405 418 424 407 402 808 407 562 397 362 380 370 360 397 359 357 364 360 362 371 377 359 361 366
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
54 CS 572 619 585 623 616 641 596 616 616 578 589 618 639 593 591 575 562 570 552 564 540 534 537 526 553 565 549 565 546 538 539
Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB
55 SS 390 389 412 537 402 409 403 454 405 402 436 411 434 419 437 360 360 392 357 358 394 358 360 358 360 363 361 361 363 356 341
Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB
56 CS 1034 1098 1070 1120 1091 1052 1090 1080 1042 1078 1046 1034 1074 1107 1058 959 949 998 957 947 953 947 1034 962 1018 1048 940 941 965 964 935
Generators are set to 0 after restore
57 SS 748 757 793 1011 785 808 783 781 776 812 779 780 985 791 777 714 719 1003 690 692 739 683 678 693 692 704 706 715 708 692 692
Generators are set to 0 after restore
58 CS 782 787 826 796 813 883 839 797 786 822 793 787 831 788 821 743 750 771 747 779 746 744 815 734 753 766 744 775 750 741 749
Blob filter to translate internal debug info into text representation
59 SS 523 519 543 694 546 559 560 560 565 551 527 545 648 619 541 501 505 720 499 497 527 501 502 490 504 504 506 513 503 500 506
Blob filter to translate internal debug info into text representation
60 CS 577 602 595 619 615 597 627 601 622 600 584 619 626 621 610 537 571 551 547 619 549 548 541 540 544 553 553 544 548 559 538
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
61 SS 389 394 401 2516 406 412 403 564 581 416 586 405 416 585 605 366 365 358 370 362 385 355 362 359 359 360 413 380 363 367 364
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
62 CS 788 829 968 851 859 854 846 853 842 851 857 852 840 851 838 733 806 733 771 727 732 736 728 718 770 735 735 752 731 720 731
Recurse leads to hangs/crash server
63 SS 562 610 601 825 605 620 616 618 618 621 661 602 684 663 640 539 518 535 514 531 517 586 506 521 532 537 534 513 517 520 518
Recurse leads to hangs/crash server
64 CS 806 602 823 819 843 830 848 822 817 818 842 843 830 819 845 789 774 781 750 777 809 819 755 754 763 804 749 757 751 747 744
[FB3] AV with "UPDATE OR INSERT"
65 SS 536 409 567 626 582 583 567 583 579 585 568 565 583 569 565 516 530 501 519 552 525 543 526 504 521 513 504 502 525 513 503
[FB3] AV with "UPDATE OR INSERT"
66 CS 607 650 648 648 639 629 614 618 614 651 674 609 657 611 646 633 605 565 563 571 569 564 567 562 566 563 559 564 588 564 564
Inefficient optimization (regression)
67 SS 397 407 432 440 419 452 448 584 438 430 423 441 439 436 426 380 380 383 391 369 372 380 372 394 373 387 374 374 400 376 376
Inefficient optimization (regression)
68 CS 1128 1174 1170 1130 1193 1149 1175 1175 1146 1172 1199 1142 1143 1193 1166 1122 1116 1095 1084 1095 1153 1127 1099 1087 1118 1110 1085 1088 1096 1098 1072
Regression in joins on procedures
69 SS 812 816 813 902 814 830 814 811 854 825 827 827 1339 817 825 766 816 765 769 788 765 763 754 844 771 790 753 756 801 776 765
Regression in joins on procedures
70 CS 799 591 808 815 837 819 807 805 828 811 803 826 831 805 855 788 814 758 805 778 769 795 747 745 767 771 760 754 794 744 759
Altering of a TYPE OF COLUMN parameter affects the original column
71 SS 543 390 558 583 558 551 557 560 556 558 569 557 560 559 564 515 517 515 517 518 526 549 516 532 517 515 538 524 549 521 511
Altering of a TYPE OF COLUMN parameter affects the original column
72 CS 778 614 811 836 838 830 820 821 814 793 820 828 832 828 834 818 761 744 746 743 751 756 763 743 815 755 758 747 754 755 752
DROP VIEW ignores the existing non-column dependencies
73 SS 528 391 561 596 560 564 635 547 563 571 561 555 572 558 549 500 506 533 577 514 515 511 500 519 497 518 516 522 524 524 500
DROP VIEW ignores the existing non-column dependencies
74 CS 785 797 827 784 837 862 796 794 802 807 787 840 816 837 801 799 762 744 788 755 747 756 735 755 758 745 750 758 738 754 743
Alter procedure allows to add the parameter with the same name
75 SS 516 540 549 617 544 550 549 556 542 560 545 544 586 563 558 501 501 497 502 509 509 500 499 500 506 496 517 516 503 497 504
Alter procedure allows to add the parameter with the same name
76 CS 595 594 617 599 635 602 607 609 605 631 596 602 596 603 602 608 571 582 614 576 542 568 584 588 564 550 555 577 563 551 572
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
77 SS 405 390 404 414 410 410 403 732 406 405 411 479 453 406 409 98 359 431 376 544 559 381 365 364 373 367 407 500 378 358 363
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
78 CS 600 610 648 614 647 631 649 621 619 642 611 622 638 644 669 609 573 574 568 561 579 581 563 573 591 575 567 568 575 568 562
Inconsistent domain's constraint validation in PSQL
79 SS 404 417 429 463 437 433 434 435 435 447 441 447 436 438 437 386 389 385 390 389 395 376 404 374 386 395 387 404 393 388 390
Inconsistent domain's constraint validation in PSQL
80 CS 793 836 860 813 847 839 812 823 848 855 817 813 815 825 875 754 798 783 765 746 751 777 749 748 788 754 786 751 765 749 767
Floating-point negative zero doesn't match positive zero in the index
81 SS 538 549 554 594 569 548 561 567 583 558 563 591 561 580 574 518 522 518 522 534 533 523 540 509 510 536 514 507 501 519 527
Floating-point negative zero doesn't match positive zero in the index
82 CS 575 702 581 586 621 597 614 618 585 612 618 577 583 620 609 554 569 529 561 573 551 543 534 580 571 535 566 529 542 537 538
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
83 SS 395 394 409 396 391 402 401 406 422 406 408 420 410 408 396 545 395 357 360 362 417 358 375 362 359 409 364 357 362 365 347
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
84 CS 583 594 628 622 621 625 605 627 603 601 595 621 611 633 586 581 580 586 552 546 554 575 554 571 555 555 546 535 563 560 569
CHAR(32767) present in XSQLVAR with length 32765
85 SS 386 395 409 417 422 411 410 718 443 416 684 417 840 684 422 361 363 359 369 371 360 374 379 362 394 364 358 361 374 363 362
CHAR(32767) present in XSQLVAR with length 32765
86 CS 582 590 599 593 630 605 596 597 585 598 591 594 590 591 598 592 545 551 541 544 549 575 551 567 551 549 575 539 569 541 580
Include expected and actual string lenght into error message for sqlcode -802
87 SS 370 394 410 408 405 402 405 423 413 405 407 404 421 410 410 359 364 374 358 360 354 355 362 364 359 359 360 362 362 366 360
Include expected and actual string lenght into error message for sqlcode -802
88 CS 2928 2925 3243 2922 2938 2949 2983 3217 2943 2953 2944 2931 3395 2948 2935 2955 2933 2881 2911 2874 2879 2874 2934 2899 2907 2866 2856 2912 2893 2865 2906
TRACE: add statistics of actions that were after transaction finished
89 SS 2684 2701 2692 2738 2707 2703 2726 2708 2735 2782 2704 2715 2824 2862 2718 2669 2672 3007 2669 2666 2673 2653 2656 2660 2669 2660 2672 2677 2654 2662 2663
TRACE: add statistics of actions that were after transaction finished
90 CS 646 642 668 652 678 682 672 667 668 691 681 675 659 682 688 616 650 609 610 627 609 615 620 781 627 619 620 609 613 604 607
Can insert DUPLICATE keys in UNIQUE index
91 SS 392 360 427 438 436 438 440 437 441 440 440 446 424 442 570 380 392 397 391 390 388 390 375 378 392 391 393 392 387 378 388
Can insert DUPLICATE keys in UNIQUE index
92 CS 581 596 585 600 601 594 604 636 596 636 638 596 652 598 600 580 550 557 546 582 581 554 542 547 558 541 554 576 572 572 540
Server crashes with access violation when inserting row into table with unique index
93 SS 389 386 404 423 402 416 406 449 419 406 408 412 414 405 406 364 359 364 372 361 367 485 368 392 371 383 375 364 360 366 362
Server crashes with access violation when inserting row into table with unique index
94 CS 612 614 625 615 647 624 654 621 617 632 630 713 669 675 648 598 622 564 571 610 600 565 578 565 573 579 574 573 569 566 572
computed index by substring function for long columns
95 SS 393 404 416 688 432 419 423 464 435 600 418 433 419 430 437 378 378 387 399 379 376 387 380 368 380 372 382 387 382 388 373
computed index by substring function for long columns
96 CS 569 584 582 582 587 601 589 589 587 623 618 610 580 588 631 569 546 540 537 552 534 556 546 532 545 547 541 552 570 532 537
Wrong warning message for ambiguous query
97 SS 374 390 402 408 420 393 403 803 672 400 402 397 727 410 409 359 371 358 359 351 365 357 365 361 361 378 364 360 362 358 360
Wrong warning message for ambiguous query
98 CS 575 580 594 583 611 596 617 620 585 595 584 623 605 591 578 568 598 541 543 544 537 548 566 536 572 549 541 548 573 540 542
Wrong warning message for ambiguous query
99 SS 377 388 393 406 402 429 408 400 397 405 405 406 414 407 413 357 360 365 360 362 350 371 355 346 370 359 357 357 357 383 361
Wrong warning message for ambiguous query
100 CS 595 606 597 614 642 632 600 648 630 607 626 600 667 627 593 604 587 547 551 585 556 613 561 550 545 555 546 548 548 582 550
Missing constraint name in foreign key error message in FB 2.1.4
101 SS 380 391 409 415 415 420 440 416 434 421 407 428 413 407 422 360 379 369 374 371 381 367 357 364 377 377 377 356 375 372 372
Missing constraint name in foreign key error message in FB 2.1.4
102 CS 1558 1618 12423 12380 1627 1636 1651 1650 1621 1624 1632 1611 1656 1629 1661 1550 1567 1523 1524 1540 1527 1526 1522 1519 1541 1532 1526 1529 1528 1518 1517
Restore of encrypted backup of database with SQL dialect 1 fails
103 SS 1153 1212 12009 11930 1257 1174 1190 1195 1214 1189 1208 1184 1224 1189 1204 1113 1100 1105 1102 1095 1119 1115 1100 1106 1132 1104 1317 1128 1104 1106 1099
Restore of encrypted backup of database with SQL dialect 1 fails

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-214
http://tracker.firebirdsql.org/browse/CORE-2806
http://tracker.firebirdsql.org/browse/CORE-2812
http://tracker.firebirdsql.org/browse/CORE-2826
http://tracker.firebirdsql.org/browse/CORE-2835
http://tracker.firebirdsql.org/browse/CORE-2881
http://tracker.firebirdsql.org/browse/CORE-2910
http://tracker.firebirdsql.org/browse/CORE-2912
http://tracker.firebirdsql.org/browse/CORE-2916
http://tracker.firebirdsql.org/browse/CORE-2930
http://tracker.firebirdsql.org/browse/CORE-2985
http://tracker.firebirdsql.org/browse/CORE-3029
http://tracker.firebirdsql.org/browse/CORE-3055
http://tracker.firebirdsql.org/browse/CORE-3056
http://tracker.firebirdsql.org/browse/CORE-3064
http://tracker.firebirdsql.org/browse/CORE-3085
http://tracker.firebirdsql.org/browse/CORE-3101
http://tracker.firebirdsql.org/browse/CORE-3103
http://tracker.firebirdsql.org/browse/CORE-3174
http://tracker.firebirdsql.org/browse/CORE-3180
http://tracker.firebirdsql.org/browse/CORE-3222
http://tracker.firebirdsql.org/browse/CORE-3239
http://tracker.firebirdsql.org/browse/CORE-3283
http://tracker.firebirdsql.org/browse/CORE-3305
http://tracker.firebirdsql.org/browse/CORE-3311
http://tracker.firebirdsql.org/browse/CORE-3312
http://tracker.firebirdsql.org/browse/CORE-3338
http://tracker.firebirdsql.org/browse/CORE-3353
http://tracker.firebirdsql.org/browse/CORE-3357
http://tracker.firebirdsql.org/browse/CORE-3364
http://tracker.firebirdsql.org/browse/CORE-3394
http://tracker.firebirdsql.org/browse/CORE-3419
http://tracker.firebirdsql.org/browse/CORE-3421
http://tracker.firebirdsql.org/browse/CORE-3450
http://tracker.firebirdsql.org/browse/CORE-3474
http://tracker.firebirdsql.org/browse/CORE-3491
http://tracker.firebirdsql.org/browse/CORE-3502
http://tracker.firebirdsql.org/browse/CORE-3509
http://tracker.firebirdsql.org/browse/CORE-3530
http://tracker.firebirdsql.org/browse/CORE-3545
http://tracker.firebirdsql.org/browse/CORE-3547
http://tracker.firebirdsql.org/browse/CORE-3553
http://tracker.firebirdsql.org/browse/CORE-3569
http://tracker.firebirdsql.org/browse/CORE-3594
http://tracker.firebirdsql.org/browse/CORE-3598
http://tracker.firebirdsql.org/browse/CORE-3610
http://tracker.firebirdsql.org/browse/CORE-3627
http://tracker.firebirdsql.org/browse/CORE-3672
http://tracker.firebirdsql.org/browse/CORE-3690
http://tracker.firebirdsql.org/browse/CORE-3691
http://tracker.firebirdsql.org/browse/CORE-6071
=== end of list ===

Last commits information (all timestamps in UTC):