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

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

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.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.835
2025.06.12
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
6.0.0.753
2025.04.27
Test TITLE
1 CS 1061 1079 1099 606 937 1088 615 1053 665 1070 709 625 646 678 1130 1045 1252 1076 1078 1161 1040 1152 678 612 602 1088 1102 1239 1049 1148 1259
Views based on procedures can't be created if the proc's output fields participate in an expression
2 SS 436 418 473 436 398 407 459 388 445 518 369 440 453 431 436 457 402 456 458 425 429 391 413 441 447 438 426 413 359 488 444
Views based on procedures can't be created if the proc's output fields participate in an expression
3 CS 1272 1354 1306 1249 1257 835 739 1131 864 1348 778 808 851 767 1401 1327 1424 1288 1235 1387 1123 1307 909 813 802 1454 1373 1518 1389 1497 1363
Prohibit any improper mixture of explicit and implicit joins
4 SS 567 527 564 583 554 544 667 518 564 532 534 530 561 550 551 582 574 589 623 578 598 586 595 542 558 509 585 570 602 591 608
Prohibit any improper mixture of explicit and implicit joins
5 CS 1074 1072 859 1027 1092 691 692 620 703 1105 608 645 597 608 1080 1092 1076 1080 1061 1164 957 1108 760 1165 818 1211 1137 1205 1167 1115 1365
Join condition fails for UTF-8 databases
6 SS 459 435 451 447 434 432 453 447 468 534 446 462 451 441 500 486 467 456 438 522 523 471 438 469 470 413 513 470 441 485 546
Join condition fails for UTF-8 databases
7 CS 1229 1259 762 1293 1244 734 663 1326 857 1181 680 925 711 787 718 1301 1533 1016 1267 1322 1214 1346 824 1185 679 1263 1353 1345 1293 1334 1299
Natural is used to select instead of primary key index
8 SS 542 515 462 493 476 528 746 552 576 607 496 569 504 558 558 526 540 582 564 552 621 547 554 524 515 540 522 545 508 591 514
Natural is used to select instead of primary key index
9 CS 1037 1033 1087 981 1044 635 671 1234 671 1167 656 627 624 647 1077 1110 1034 1074 1033 1065 904 1076 756 1122 645 1121 1041 1100 1056 1012 1182
isql should show packaged procedures and functions categorized per package
10 SS 439 398 395 471 429 449 472 474 457 441 472 471 436 406 416 446 467 438 422 429 495 461 415 468 465 409 431 425 425 441 433
isql should show packaged procedures and functions categorized per package
11 CS 1257 1068 1276 1322 1291 810 811 1374 789 1252 758 803 957 888 1225 1387 1339 1092 1196 1382 1285 858 929 1278 751 1400 1301 1381 1262 1324 1409
PK index is not used for derived tables
12 SS 535 461 505 491 537 531 522 586 531 530 540 552 540 684 527 532 552 592 522 573 583 523 485 560 497 522 537 553 534 536 593
PK index is not used for derived tables
13 CS 1052 978 1193 1164 1053 683 667 1237 679 1052 644 649 628 630 1143 1058 1116 1020 1013 1069 849 1163 771 1092 682 1159 1090 1154 987 1292 1175
Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1)
14 SS 429 462 418 389 413 469 484 392 438 436 402 471 403 432 373 385 438 455 422 427 413 505 433 427 412 471 446 437 399 419 439
Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1)
15 CS 1019 1152 1014 1066 1024 1091 591 928 793 1081 572 660 590 647 1048 1069 910 958 1064 1114 612 950 716 988 632 1085 1060 1165 1172 1201 1132
Broken error handling in the case of a conversion error happened during index creation
16 SS 416 409 427 418 395 399 438 447 461 464 407 445 480 436 408 373 391 466 399 422 468 403 424 399 448 414 404 408 422 392 379
Broken error handling in the case of a conversion error happened during index creation
17 CS 1261 944 1254 756 1256 1099 751 1383 1700 1355 865 789 788 712 1528 1266 1314 1086 1157 1365 786 1272 870 1356 758 1370 1269 1325 1300 1312 1318
DROP VIEW drops output parameters of used stored procedures
18 SS 538 403 512 532 536 512 546 495 592 631 540 570 583 547 529 521 558 559 526 507 574 536 492 583 570 540 537 522 574 504 588
DROP VIEW drops output parameters of used stored procedures
19 CS 1294 615 1239 906 740 781 1320 769 868 791 900 1412 954 725 1562 1522 1434 1304 1602 882 1444 1356 806 756 1433 1409 1437 1398 1285 1412 1386
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
20 SS 554 370 452 648 516 555 574 553 486 623 556 622 578 557 559 534 579 541 573 587 561 603 509 541 557 494 533 497 463 511 540
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
21 CS 1140 1069 855 733 715 710 1423 767 838 804 799 1364 819 782 1359 1008 1428 1357 1212 1413 872 1300 952 1462 1015 1353 1303 1375 1388 1483 1444
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
22 SS 571 432 570 553 599 569 626 620 572 616 578 596 600 571 567 566 571 619 614 561 582 586 477 577 597 555 524 496 530 536 516
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
23 CS 1222 749 676 875 716 681 1229 671 835 670 726 1288 813 729 1131 1225 1219 1311 1320 1402 1301 1317 773 1312 1243 1268 1303 1350 1380 1385 1215
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
24 SS 546 504 500 536 502 569 572 613 528 539 550 583 614 544 545 532 538 521 567 544 561 489 554 542 593 602 557 572 533 547 548
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
25 CS 1413 953 765 824 704 787 1470 771 863 986 782 1760 838 832 1419 1597 1436 1592 1673 1902 1491 1664 1107 1629 1078 1732 1360 1714 1407 1576 1533
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
26 SS 871 811 645 708 692 762 893 813 837 903 722 909 785 884 874 906 899 852 921 845 921 844 939 988 879 869 882 893 806 904 827
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
27 CS 1271 568 1315 1358 1236 1218 719 1269 776 929 738 804 1315 788 1260 1338 1383 1304 1558 1361 1302 1516 867 1335 1247 793 1309 1205 1315 1274 1366
Using both the procedure name and alias inside an explicit plan crashes the server
28 SS 537 385 430 538 531 482 576 495 561 621 504 558 602 565 511 539 561 532 553 509 598 498 527 573 555 517 522 537 538 580 499
Using both the procedure name and alias inside an explicit plan crashes the server
29 CS 1087 588 602 1142 591 1014 647 1106 688 813 601 826 934 670 1085 1143 1181 1192 1241 1079 1097 1212 720 1144 1233 1209 1066 1185 1128 1089 1180
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
30 SS 463 458 421 457 430 397 443 498 491 492 485 439 456 531 467 439 470 463 455 476 502 482 419 435 435 476 515 514 502 464 338
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
31 CS 1636 920 1592 1634 1157 1663 1786 1642 2038 1334 916 1744 973 1730 1735 1694 1703 966 1499 1439 1536 1922 1074 1825 1762 1513 1928 1635 1637 1615 1819
Cannot alter the domain after migrating from older versions
32 SS 733 759 701 685 732 734 813 737 785 805 690 679 794 785 676 766 836 742 706 711 757 745 717 787 673 679 640 722 748 716 714
Cannot alter the domain after migrating from older versions
33 CS 1351 664 1363 1266 1296 1424 1427 1189 1571 853 729 1430 739 1222 1348 1252 1446 801 1568 1511 1527 1358 855 1386 1404 1321 1109 1669 1380 1355 1290
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
34 SS 602 546 572 522 564 545 561 576 601 653 689 567 603 639 568 602 630 636 659 654 651 718 676 647 596 565 604 638 564 622 575
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
35 CS 1416 793 832 1398 1507 1478 796 1395 1575 1153 820 846 1001 803 1576 1470 1589 1441 1760 1852 1306 1448 1069 1530 1435 1329 846 1490 1342 1618 1524
Expression index with TRIM may lead to incorrect indexed lookup
36 SS 661 618 624 604 625 564 647 599 656 773 664 672 691 649 636 711 671 704 773 702 679 677 639 636 716 701 625 676 638 659 676
Expression index with TRIM may lead to incorrect indexed lookup
37 CS 1289 565 748 1353 1199 1313 951 1263 1335 845 761 947 945 752 1465 1275 1509 1443 1388 1675 1374 1193 888 1276 1302 1447 801 1332 1345 1356 1464
ALTER VIEW with not matched columns in declaration and selection crashes the server
38 SS 548 369 541 500 493 479 525 590 599 558 592 567 603 586 534 559 518 581 590 553 536 519 514 572 550 547 482 577 501 569 539
ALTER VIEW with not matched columns in declaration and selection crashes the server
39 CS 1311 682 748 1266 1372 1376 739 1351 1299 946 749 819 947 1341 1637 1297 1382 1351 1553 1647 1364 833 841 1420 1366 1385 837 780 1389 1323 1269
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
40 SS 551 374 488 546 558 542 607 537 598 572 544 569 591 576 602 538 579 525 596 573 613 540 547 534 575 554 534 506 548 578 517
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
41 CS 1188 661 690 1181 1151 1206 691 1196 1246 760 697 763 804 1263 1292 1314 1376 1286 1352 1382 1351 1285 818 1293 1332 881 757 702 1168 1281 1171
UTF8 UNICODE_CI collate can not be used in compound index
42 SS 469 426 452 430 470 448 485 577 562 464 505 468 541 485 467 464 527 489 583 453 476 487 490 459 428 426 420 449 471 508 463
UTF8 UNICODE_CI collate can not be used in compound index
43 CS 1027 612 586 1012 936 1044 574 736 1109 681 617 639 736 1113 1187 1166 1149 1210 1210 1278 1206 1015 699 1075 1039 1105 1148 685 662 990 1261
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
44 SS 426 368 426 426 379 372 441 437 470 479 453 382 426 407 419 386 409 457 464 444 463 406 466 422 408 462 412 412 443 406 455
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
45 CS 1059 553 645 1217 1012 1043 544 661 1309 825 677 638 749 1139 1114 1172 1352 1100 1236 1078 1211 1035 666 1072 1067 1063 602 1056 605 1095 1220
"BLOB not found" error after creation/altering of the invalid trigger
46 SS 422 413 456 353 401 441 493 402 469 487 426 394 417 420 418 403 394 446 417 442 425 415 432 444 404 404 428 449 477 420 428
"BLOB not found" error after creation/altering of the invalid trigger
47 CS 1238 689 768 890 1200 900 751 788 1494 969 796 791 922 1300 1362 1281 1324 1366 1497 1662 1342 1276 821 787 1332 1488 1399 1339 795 813 1355
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
48 SS 558 574 516 489 513 533 599 558 610 666 566 582 566 548 524 558 559 602 594 588 568 536 536 520 524 466 562 549 520 575 575
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
49 CS 956 570 564 611 957 585 602 684 1080 765 642 636 700 1096 1177 1060 1293 999 1224 981 1430 1032 632 575 956 1052 1152 1060 590 594 1017
Sub-optimal join plan when the slave table depends on the master via the "OR" predicate
50 SS 405 426 386 375 360 404 406 399 430 411 432 420 429 432 349 421 400 395 389 434 450 382 393 376 370 410 423 414 436 373 358
Sub-optimal join plan when the slave table depends on the master via the "OR" predicate
51 CS 1052 593 664 599 1083 582 739 638 1137 758 910 602 692 1151 1104 1152 1074 1158 1555 1134 1051 1054 627 1081 1078 1162 1037 1086 1114 574 625
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
52 SS 425 369 360 443 425 409 472 408 462 500 435 429 423 397 405 414 441 426 421 478 472 503 423 448 414 407 450 462 421 382 449
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
53 CS 1007 549 680 604 1030 699 734 579 1076 727 569 641 628 1092 988 1025 1152 1069 1225 1095 1090 1070 652 1087 1087 1017 961 1192 998 1078 654
Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB
54 SS 410 338 452 372 418 426 460 458 453 483 408 465 402 396 411 426 415 420 384 415 474 409 409 386 405 361 385 396 418 409 368
Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB
55 CS 1676 929 998 1008 1982 1028 995 1064 1880 1317 972 1078 1181 1969 1733 1717 2003 1880 2100 1748 1963 1755 1120 1653 1719 1682 1596 1778 952 1671 1687
Generators are set to 0 after restore
56 SS 811 710 866 860 846 737 832 815 913 987 799 826 837 859 770 779 778 777 772 855 846 733 761 816 828 726 808 720 749 755 823
Generators are set to 0 after restore
57 CS 1277 759 792 715 1351 706 785 781 1388 968 765 883 839 1182 1270 1364 1372 1328 1629 1450 1339 1217 856 1296 1390 1367 1407 1252 1405 1284 1365
Blob filter to translate internal debug info into text representation
58 SS 529 534 538 518 533 462 565 529 514 557 516 592 573 524 529 529 542 522 511 585 548 555 543 511 571 521 501 509 516 529 489
Blob filter to translate internal debug info into text representation
59 CS 1041 646 561 658 1009 648 1127 656 1148 745 573 590 732 1154 1044 1055 1134 1049 1185 1178 1036 1038 623 1135 1064 1063 647 1156 1073 565 1074
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
60 SS 413 379 387 469 398 367 494 407 415 497 407 564 414 383 437 405 413 410 481 457 474 462 420 404 434 377 390 414 385 454 391
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
61 CS 1396 768 879 844 1391 828 937 865 1701 950 919 1872 1055 1748 1612 1263 1618 1482 1750 1472 1510 1492 979 1319 1470 1544 922 1402 1245 1416 1471
Recurse leads to hangs/crash server
62 SS 689 556 721 688 661 744 764 813 829 708 690 768 715 714 689 644 664 708 669 694 656 704 666 693 679 663 692 686 660 657 663
Recurse leads to hangs/crash server
63 CS 1282 649 751 711 1287 767 762 1151 874 889 848 1520 870 1283 1496 1341 1371 1298 1456 1421 1400 1415 822 1281 1393 1272 756 746 1312 1365 1335
[FB3] AV with "UPDATE OR INSERT"
64 SS 552 459 535 519 547 541 583 534 634 538 554 579 539 569 585 566 571 649 601 509 532 614 563 573 573 533 534 544 550 524 565
[FB3] AV with "UPDATE OR INSERT"
65 CS 1124 1175 605 1167 1014 1132 1165 615 682 854 618 1235 809 1116 1165 1167 1107 1197 1217 1139 957 1200 684 1242 659 867 1231 672 1167 1087 1351
Inefficient optimization (regression)
66 SS 480 421 475 476 435 447 475 550 514 508 459 424 554 519 448 495 490 475 484 498 456 565 486 467 489 396 490 471 463 508 541
Inefficient optimization (regression)
67 CS 1845 1703 1120 1149 1102 1170 1757 1133 1206 1803 1184 2548 1659 2045 2820 2621 2102 2787 2747 3459 1995 2483 1756 1872 1755 1335 2704 1818 2027 2282 2391
Regression in joins on procedures
68 SS 1466 1157 1487 1175 1148 1340 1377 1403 1543 1378 1183 1268 1415 1403 1442 1644 1586 1562 1652 1526 1567 1656 1579 1477 1478 1436 1453 1486 1587 1455 1656
Regression in joins on procedures
69 CS 1281 1072 702 686 716 803 1249 750 797 987 893 1556 1045 1313 1259 1303 1388 1384 1342 1596 1428 1327 836 1336 1413 826 1548 1340 778 1361 1451
Altering of a TYPE OF COLUMN parameter affects the original column
70 SS 554 473 525 524 544 495 555 556 573 620 604 545 568 555 589 569 586 616 601 538 596 586 529 553 470 549 541 479 536 541 572
Altering of a TYPE OF COLUMN parameter affects the original column
71 CS 1264 1090 727 722 1237 723 1291 697 753 989 732 1567 879 1384 1374 1350 1357 1319 1426 1433 1384 1363 837 1401 1378 715 1265 1415 806 1255 1264
DROP VIEW ignores the existing non-column dependencies
72 SS 549 428 499 572 526 490 598 556 612 549 523 551 621 565 498 533 552 605 563 582 524 533 510 520 550 532 550 531 569 526 562
DROP VIEW ignores the existing non-column dependencies
73 CS 1295 1320 699 1245 1229 930 1327 741 785 998 771 1541 961 1297 1368 1349 1354 1388 1476 1461 1296 1348 815 1294 1251 848 736 1307 1147 1296 1315
Alter procedure allows to add the parameter with the same name
74 SS 544 502 516 454 470 534 577 525 569 549 513 589 549 544 536 496 564 567 561 605 593 522 511 546 582 555 544 567 521 539 528
Alter procedure allows to add the parameter with the same name
75 CS 963 1023 595 569 949 607 1038 674 607 695 624 1376 732 558 978 1019 1215 1073 1118 1184 1227 1132 633 1019 1251 588 646 984 1071 742 938
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
76 SS 439 389 401 367 413 388 491 452 469 411 439 445 472 423 420 413 439 441 452 414 519 433 435 409 448 458 423 460 457 466 448
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
77 CS 1120 1153 673 623 1213 682 1217 650 680 718 787 1227 811 1112 1216 1139 1179 1128 1306 1294 1222 1220 757 1246 1156 705 669 894 1160 1097 726
Inconsistent domain's constraint validation in PSQL
78 SS 493 481 457 465 481 441 508 490 560 524 473 515 525 561 467 497 483 467 514 513 581 483 526 496 491 451 509 523 489 528 489
Inconsistent domain's constraint validation in PSQL
79 CS 1280 1227 1407 743 1273 812 1345 709 855 897 767 1459 885 1380 1272 1388 1356 1388 1558 1545 1430 1456 883 1240 1287 774 1384 772 1377 1288 859
Floating-point negative zero doesn't match positive zero in the index
80 SS 543 552 511 528 542 542 581 543 633 562 581 532 578 569 571 501 605 522 524 544 622 516 518 590 598 526 524 548 516 596 529
Floating-point negative zero doesn't match positive zero in the index
81 CS 1011 1055 1039 558 991 576 977 598 633 711 586 1096 660 995 1155 1047 1080 1116 1201 1079 1110 1091 694 1027 1063 661 964 1029 929 979 1158
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
82 SS 397 396 363 369 355 356 401 395 441 487 376 449 433 417 363 381 408 411 409 404 390 398 467 375 398 344 401 388 383 426 393
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
83 CS 1250 1227 1370 879 913 767 1220 775 804 916 779 1408 946 936 1367 1392 1266 1437 1436 1492 1532 1265 834 1325 1538 787 1360 816 1235 1408 1442
CHAR(32767) present in XSQLVAR with length 32765
84 SS 605 582 616 528 533 523 586 562 620 632 614 605 606 565 572 556 623 645 584 567 641 705 653 556 618 569 605 623 624 584 691
CHAR(32767) present in XSQLVAR with length 32765
85 CS 1056 1072 941 611 1038 607 981 558 613 705 567 1185 719 1267 1127 1178 1033 1096 1185 1270 1156 1068 681 1140 1046 617 1023 1103 1102 1066 1147
Include expected and actual string lenght into error message for sqlcode -802
86 SS 429 447 387 357 408 407 467 392 432 431 419 434 448 450 448 421 433 493 385 428 435 443 353 377 425 376 405 444 460 476 382
Include expected and actual string lenght into error message for sqlcode -802
87 CS 4113 4304 4459 3026 4235 2926 3426 2893 2963 3094 3121 4522 3059 4504 3444 4543 4567 4340 3991 4708 4589 3531 3094 4477 4447 3066 3938 4573 3127 4661 4563
TRACE: add statistics of actions that were after transaction finished
88 SS 2730 2722 2709 2737 2669 2699 2753 2717 2816 2724 2772 2695 2762 2770 2677 2773 2730 2796 2693 2692 2785 2746 2641 2764 2730 2734 2766 2678 2704 2704 2785
TRACE: add statistics of actions that were after transaction finished
89 CS 1193 1170 1258 703 878 670 1125 653 1196 882 1048 1354 878 702 1278 1221 1260 1348 1415 1350 1229 1165 811 1190 1310 747 1343 1365 833 1226 1274
Can insert DUPLICATE keys in UNIQUE index
90 SS 477 374 399 434 421 506 460 482 436 482 509 527 498 529 449 480 445 435 466 478 522 476 433 498 534 429 399 459 489 499 484
Can insert DUPLICATE keys in UNIQUE index
91 CS 1057 997 1092 596 998 616 1092 611 605 673 633 1001 787 1041 1045 1177 1094 1120 1140 1303 1091 1069 723 1188 1253 819 1282 1102 1103 696 1116
Server crashes with access violation when inserting row into table with unique index
92 SS 429 386 414 494 402 368 464 458 409 435 397 490 471 387 451 405 393 475 392 484 459 454 430 395 425 428 415 397 443 445 446
Server crashes with access violation when inserting row into table with unique index
93 CS 1115 1086 1224 1159 965 616 1059 832 635 707 1130 1449 894 974 1233 1216 1375 1230 1291 1323 1240 1048 819 1236 1100 773 1259 1235 1222 1052 686
computed index by substring function for long columns
94 SS 451 452 462 446 471 437 479 436 497 467 423 525 502 521 427 449 478 482 456 445 426 546 442 451 448 447 438 513 425 424 522
computed index by substring function for long columns
95 CS 1037 1007 957 983 1068 1035 988 560 1117 749 610 1150 713 1039 1118 984 1115 1058 1168 1283 1047 1125 694 1129 1222 645 647 994 1061 586 1120
Wrong warning message for ambiguous query
96 SS 421 375 438 394 349 376 458 436 420 470 535 592 679 396 432 415 367 365 371 434 447 422 386 455 453 396 381 345 370 438 423
Wrong warning message for ambiguous query
97 CS 1025 1033 1027 1051 1067 926 1014 594 782 708 645 1383 715 1029 1105 952 1165 1036 1219 1069 1120 1116 664 1024 1058 626 595 1012 1012 787 1047
Wrong warning message for ambiguous query
98 SS 401 370 353 381 378 421 409 430 435 441 350 418 454 456 425 396 360 350 398 457 390 401 390 340 400 408 426 408 402 441 395
Wrong warning message for ambiguous query
99 CS 1056 1049 1085 1061 918 1037 1009 669 718 700 564 1188 785 772 1016 1273 1127 1156 1187 1172 1126 1162 723 1059 1053 572 635 1091 1104 1076 1119
Missing constraint name in foreign key error message in FB 2.1.4
100 SS 429 396 405 413 402 398 457 400 524 429 490 425 438 509 417 450 450 468 410 453 480 441 407 410 459 407 449 429 419 424 459
Missing constraint name in foreign key error message in FB 2.1.4

List of tests in this report:


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
=== end of list ===

Last commits information (all timestamps in UTC):