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 (271 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 (958 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (22 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 (1874 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 (76 rows)
11. All tests: outcomes for previous 30 runs (3633 rows)
12. Skipped: tests which was intentionally excluded from execution (78 rows)

Generated UTC 01.07.2025 03:20
Tested: FB60.   Build / date: 6.0.0.884-f7e5f554 / 2025.06.30;
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 
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.884
2025.06.30
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
Test TITLE
1 CS P F F F E E E E E E E E E E P P P P P P P P P P P P P P P P
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
2 SS P F F F E E E E E E E E E E P P P P P P P P P P P P P P P P
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
3 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
Index is not used when view has "subselect" column
4 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
Index is not used when view has "subselect" column
5 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
Description (COMMENT ON) for package procedures and functions, and its parameters
6 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
Description (COMMENT ON) for package procedures and functions, and its parameters
7 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
Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
8 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
Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
9 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 result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N }
10 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 result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N }
11 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: computed index based on a computed column stores NULL for all its keys
12 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: computed index based on a computed column stores NULL for all its keys
13 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
"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
14 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
"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
15 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: Join order in v3 is less optimal than in v2.x
16 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: Join order in v3 is less optimal than in v2.x
17 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
Implement ability to validate tables and indices online (without exclusive access to database)
18 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
Implement ability to validate tables and indices online (without exclusive access to database)
19 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
Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
20 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
Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
21 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
Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR
22 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
Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR
23 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 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
24 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 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
25 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
Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..."
26 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
Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..."
27 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 DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used
28 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 DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used
29 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 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles)
30 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 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles)
31 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
Parameterized exception: wrong output when number of arguments greater than 7
32 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
Parameterized exception: wrong output when number of arguments greater than 7
33 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
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
34 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
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
35 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
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
36 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
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
37 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
Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL
38 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
Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL
39 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
Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
40 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
Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
41 CS P F F F F F F F F F F F F F P P P P P P P P P F F P P P P P
Regression: generators can be seen/modified by unprivileged users
42 SS P F F F F F F F F F F F F F P P P P P P P P P F F P P P P P
Regression: generators can be seen/modified by unprivileged users
43 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: List of aggregation is not checked properly
44 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: List of aggregation is not checked properly
45 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
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
46 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
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
47 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
Make user names behave according to SQL identifiers rules
48 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
Make user names behave according to SQL identifiers rules
49 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
EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
50 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
EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
51 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
Make ISQL display character set when sqlda_display is on
52 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
Make ISQL display character set when sqlda_display is on
53 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
Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke
54 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
Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke
55 CS P F F F F F F F F F F F F F P P P P P P P P P F F P P P P P
SHOW GRANTS does not display info about exceptions which were granted to user
56 SS P F F F F F F F F F F F F F P P P P P P P P P F F P P P P P
SHOW GRANTS does not display info about exceptions which were granted to user
57 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 a trigger indicating other table than the original does not reflect the change
58 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 a trigger indicating other table than the original does not reflect the change
59 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
Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672"
60 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
Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672"
61 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
Crash on pasring of script containing `execute block` with lot of nested begin..end statements
62 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
Crash on pasring of script containing `execute block` with lot of nested begin..end statements
63 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
Invalid internal BLR filter conversion
64 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
Invalid internal BLR filter conversion
65 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 DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
66 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 DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
67 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 IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
68 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 IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
69 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
IIF function prevents the condition from being pushed into the union for better optimization
70 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
IIF function prevents the condition from being pushed into the union for better optimization
71 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 label about deterministic flag for stored function in SHOW and extract commands
72 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 label about deterministic flag for stored function in SHOW and extract commands
73 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
Operator REVOKE can modify rights granted to system tables at DB creation time
74 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
Operator REVOKE can modify rights granted to system tables at DB creation time
75 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
Non-privileged user can implicitly count records in a restricted table
76 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
Non-privileged user can implicitly count records in a restricted table

Elapsed time, milliseconds:

NN Test name mode median_ms
6.0.0.884
2025.06.30
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
Test TITLE
1 CS 1573 1560 2372 2354 1420 539 567 558 557 613 931 528 651 921 541 1400 1444 1699 1339 2304 2543 2403 2256 1586 2535 2792 2165 2278 2446 2198 2328
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
2 SS 1208 1231 1550 1216 1253 389 513 475 472 522 578 455 523 482 479 1251 1220 1361 1344 1230 1281 1258 1305 1306 1326 1238 1167 1157 1117 1200 1146
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
3 CS 1286 676 1423 759 1236 1376 1248 773 1325 1249 1014 748 769 823 798 1425 1323 1480 1368 1466 1716 1353 1328 944 1298 1190 1381 834 1303 1404 1274
Index is not used when view has "subselect" column
4 SS 538 417 620 535 539 537 497 566 546 586 572 541 531 573 580 524 513 546 529 555 529 580 531 518 535 524 533 560 539 533 542
Index is not used when view has "subselect" column
5 CS 760 733 690 635 789 754 708 741 766 741 685 749 676 746 719 783 1180 1092 1079 1207 1322 668 1001 687 684 1181 1099 1105 1318 1107 1113
Description (COMMENT ON) for package procedures and functions, and its parameters
6 SS 449 358 461 401 371 456 488 516 495 438 497 443 497 475 438 398 443 419 456 473 494 447 451 404 455 421 484 492 431 427 398
Description (COMMENT ON) for package procedures and functions, and its parameters
7 CS 1123 915 1104 1031 1027 995 1079 957 1143 1103 965 1192 1067 1052 1190 1384 883 1562 1635 2049 1018 1644 1701 1022 1576 1599 1940 1148 1017 1632 1500
Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
8 SS 705 669 708 654 657 686 667 727 740 757 722 712 704 677 671 683 707 643 739 713 801 736 776 706 711 678 667 652 692 740 629
Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
9 CS 765 654 729 681 740 721 773 669 732 771 671 699 703 759 736 950 584 1225 1128 1371 634 1045 1079 820 1192 1073 1318 684 1079 1035 1043
Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N }
10 SS 448 427 471 466 448 413 463 506 425 461 443 490 462 419 448 421 416 426 487 424 511 475 417 443 411 487 461 448 485 485 445
Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N }
11 CS 970 993 965 907 986 822 925 975 895 950 957 907 932 854 907 1229 819 1481 1469 1600 831 1246 1173 901 1225 1325 1608 1165 1279 883 1412
Regression: computed index based on a computed column stores NULL for all its keys
12 SS 552 522 572 537 525 539 502 635 557 614 552 507 559 601 524 552 521 580 550 553 611 653 541 616 607 546 536 518 552 564 503
Regression: computed index based on a computed column stores NULL for all its keys
13 CS 749 621 757 676 797 679 708 727 775 713 664 798 737 726 739 1028 601 1166 762 1068 616 1054 878 741 1016 660 1234 1207 1192 556 1077
"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
14 SS 418 397 412 423 403 381 404 467 386 450 437 454 479 485 466 419 385 416 396 426 452 427 414 379 447 431 418 397 400 421 400
"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
15 CS 5204 4554 4380 4505 4329 4250 4561 4968 4309 4594 4515 4340 4522 4321 4324 6012 5080 9145 6316 7088 5783 8582 6068 5779 7648 5329 9769 8340 10667 6602 5482
Regression: Join order in v3 is less optimal than in v2.x
16 SS 4857 3841 4300 4290 3952 3960 3866 4086 4096 4578 4110 3949 4196 4205 4362 5528 5101 5187 5153 6410 6080 5080 5627 5770 5272 5570 5492 5221 4662 5230 5053
Regression: Join order in v3 is less optimal than in v2.x
17 CS 5022 4986 4998 5009 5157 4990 4941 5002 5036 4982 4950 5179 5062 5004 4968 4884 4873 4980 5318 5623 5647 5497 5553 4960 5481 4936 5524 5620 5448 5456 5538
Implement ability to validate tables and indices online (without exclusive access to database)
18 SS 4602 4549 4672 4613 4525 4602 4566 4536 4589 4654 4606 4630 4665 4586 4664 4558 4576 4552 4607 4578 4610 4596 4587 4622 4644 4602 4658 4576 4629 4610 4528
Implement ability to validate tables and indices online (without exclusive access to database)
19 CS 987 904 935 969 940 893 875 957 1097 857 794 1115 999 975 912 678 657 1472 1128 1412 1347 1197 1268 971 668 1382 1532 1510 1205 1124 1184
Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
20 SS 654 557 747 583 573 579 665 663 506 684 689 594 640 670 593 666 730 722 663 640 615 612 660 653 733 714 619 603 651 656 705
Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
21 CS 774 679 757 779 722 744 716 700 770 736 745 731 724 794 892 731 639 1223 1343 1437 1108 695 789 748 1246 1224 1315 1288 1204 1217 1188
Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR
22 SS 494 437 589 467 429 504 424 522 490 522 528 447 462 468 510 448 496 517 477 531 535 517 483 496 530 492 492 445 465 498 532
Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR
23 CS 750 651 728 723 774 756 633 713 687 678 684 752 749 782 695 697 637 1181 1262 975 1124 689 587 740 1148 1101 1057 1275 1111 1203 1150
Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
24 SS 426 389 465 428 400 425 387 535 405 475 545 424 404 458 407 415 458 450 427 441 468 389 423 404 462 480 434 385 415 441 369
Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
25 CS 721 691 683 718 769 649 681 680 602 705 704 776 748 685 743 621 625 1360 1183 606 1169 661 627 725 1150 1134 1080 1247 1073 1124 1182
Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..."
26 SS 429 429 412 425 433 427 423 445 410 460 507 429 472 492 422 426 400 413 430 457 494 478 430 424 478 435 368 478 404 460 407
Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..."
27 CS 843 696 807 798 847 705 705 841 749 697 704 724 785 845 739 621 578 1232 913 1355 1208 626 1180 847 1231 1135 1124 1237 1132 1124 1032
ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used
28 SS 477 395 550 465 411 466 415 491 458 494 489 436 501 509 479 476 528 496 493 514 498 456 465 478 497 407 409 434 424 424 495
ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used
29 CS 826 915 857 795 823 758 774 723 773 816 750 702 840 777 763 1184 779 1310 801 1342 1377 801 1225 829 758 1327 1310 1752 1190 1236 1253
Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles)
30 SS 476 362 526 475 410 482 420 530 452 527 564 464 450 497 470 498 477 444 474 473 476 557 498 455 526 525 464 526 503 434 476
Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles)
31 CS 723 675 677 756 720 705 670 702 762 697 671 671 727 677 728 993 583 1120 672 1135 1103 708 1100 719 563 1119 1190 1208 1044 1076 1200
Parameterized exception: wrong output when number of arguments greater than 7
32 SS 422 411 458 403 382 382 404 448 463 441 505 402 396 442 427 435 427 412 461 419 439 435 396 387 416 401 467 425 409 423 421
Parameterized exception: wrong output when number of arguments greater than 7
33 CS 1009 950 1016 1089 984 872 956 922 851 1003 894 1022 1079 1015 953 829 895 1588 899 1448 1524 933 1488 993 941 1486 1552 1610 1420 1276 1322
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
34 SS 545 596 469 546 511 600 555 488 492 594 615 520 573 579 566 559 543 528 557 540 552 549 535 533 544 541 527 556 597 531 533
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
35 CS 754 602 775 716 692 697 679 670 712 675 707 760 680 752 738 1084 859 879 993 1000 582 902 568 757 579 985 1387 1182 1023 1023 1042
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
36 SS 429 431 397 415 460 429 417 507 368 445 460 421 430 429 398 403 395 443 429 398 483 420 413 438 434 412 425 432 453 415 456
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
37 CS 752 688 782 650 668 737 696 644 672 693 749 660 757 737 694 953 612 897 991 1089 663 1061 756 765 619 1059 1132 1109 1059 1183 1213
Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL
38 SS 431 449 420 441 391 424 407 447 467 470 534 443 405 464 445 409 427 418 447 390 442 430 432 372 431 437 407 466 462 419 411
Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL
39 CS 797 722 844 687 701 766 798 736 751 721 796 720 726 759 750 1175 663 945 973 1143 682 973 1107 828 551 1108 1226 1060 1245 1207 1136
Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
40 SS 472 462 525 476 542 441 543 454 463 492 537 465 511 522 516 500 471 471 477 474 491 479 459 426 398 489 419 453 460 453 456
Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
41 CS 3758 3347 3753 3586 3428 3304 3187 3410 3456 3736 3521 3620 3561 3408 3635 5620 4876 4902 4897 5867 5154 4793 5507 3763 3182 4087 6049 5633 5601 5477 5502
Regression: generators can be seen/modified by unprivileged users
42 SS 2022 1752 2078 1861 1837 1902 1681 2009 1874 2053 2489 1792 2272 2187 1897 1860 1950 2015 2058 2054 2124 2262 2035 2131 2154 1985 1954 1907 2098 2029 2141
Regression: generators can be seen/modified by unprivileged users
43 CS 730 652 682 724 673 670 617 647 736 682 638 641 696 649 681 1033 981 927 899 1121 663 908 940 753 599 937 996 1039 983 1113 1018
Regression: List of aggregation is not checked properly
44 SS 416 410 441 371 468 406 387 434 393 447 425 385 421 433 447 402 429 373 395 436 381 443 424 410 363 399 421 400 432 442 412
Regression: List of aggregation is not checked properly
45 CS 1058 812 1010 1006 1064 1052 876 973 956 986 1176 1039 972 1098 990 1284 724 1207 1195 1411 780 1143 1224 1003 762 1104 1208 1221 1192 1448 1410
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
46 SS 653 495 676 676 735 628 735 683 724 705 795 694 823 692 894 616 601 633 647 641 659 643 593 621 668 587 666 641 569 631 620
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
47 CS 3090 2802 3153 2681 2840 2786 2725 2787 2873 2930 2972 2897 2977 3113 3039 4528 3946 3884 4213 4956 2936 4242 4209 3067 2756 4008 4776 4714 4556 4759 4572
Make user names behave according to SQL identifiers rules
48 SS 1660 1539 1718 1484 1592 1525 1471 1629 1682 1803 1664 1579 1687 1817 1679 1511 1614 1714 1718 1706 1741 1907 1570 1526 1790 1598 1765 1604 1582 1656 1668
Make user names behave according to SQL identifiers rules
49 CS 789 698 728 745 750 696 691 788 728 791 769 788 764 766 771 1261 1119 957 944 1208 731 906 875 731 1004 1002 1067 1148 1097 1076 1152
EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
50 SS 487 423 504 510 527 461 405 532 498 534 559 488 548 476 521 445 513 486 493 482 485 532 481 512 495 447 483 484 474 464 468
EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
51 CS 810 766 739 770 646 698 715 699 656 744 837 689 768 783 733 1068 1054 946 1082 1209 687 998 1019 724 1055 1148 1079 1016 1044 1119 1159
Make ISQL display character set when sqlda_display is on
52 SS 436 428 487 358 430 403 484 463 432 485 474 431 432 419 491 440 406 449 504 502 470 437 414 447 434 420 435 463 442 433 402
Make ISQL display character set when sqlda_display is on
53 CS 2297 1960 2193 1879 1960 1708 1891 1904 1766 2122 2181 2010 2100 2198 1946 2883 2983 2535 2593 2837 2472 2655 2396 1985 2999 2948 3475 3152 3234 3147 2920
Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke
54 SS 1155 1068 1213 1112 1177 1093 1104 1157 1127 1191 1215 1052 1226 1142 1153 1131 1067 1275 1194 1301 1265 1178 1093 1105 1163 1086 1062 1203 1224 1010 1173
Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke
55 CS 1460 1439 1438 1298 1468 1292 1332 1261 1353 1396 1440 1358 1422 1453 1372 2244 2043 1886 1775 1190 2406 1873 1930 1441 2096 2120 2257 2103 2337 2252 2112
SHOW GRANTS does not display info about exceptions which were granted to user
56 SS 824 698 882 794 824 808 833 814 844 806 930 768 833 787 863 866 825 826 700 794 899 812 784 797 857 812 873 885 871 814 938
SHOW GRANTS does not display info about exceptions which were granted to user
57 CS 757 679 758 709 692 730 681 749 720 812 652 756 744 804 729 719 1066 1041 1026 986 1177 634 1033 724 1172 704 1100 1261 1084 1199 1037
Altering a trigger indicating other table than the original does not reflect the change
58 SS 474 490 584 474 440 414 449 452 477 526 522 510 477 497 474 442 461 486 446 434 508 396 455 444 475 504 450 452 497 482 495
Altering a trigger indicating other table than the original does not reflect the change
59 CS 6897 6752 6808 6721 6855 6805 6794 6812 6759 6811 6834 6846 6895 6820 6767 7054 7267 7083 7050 7408 7280 7101 7190 6841 7264 6899 7392 7288 7335 7225 7303
Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672"
60 SS 6452 6416 6546 6409 6443 6507 6424 6450 6516 6473 6522 6449 6470 6467 6499 6454 6388 6421 6447 6431 6463 6472 6473 6400 6407 6429 6490 6444 6484 6433 6466
Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672"
61 CS 899 761 799 748 789 696 801 805 858 728 680 780 785 737 720 1121 1184 1142 1091 1339 1226 1248 1159 783 1205 941 1176 1337 1206 1355 1144
Crash on pasring of script containing `execute block` with lot of nested begin..end statements
62 SS 506 514 408 520 490 470 448 566 452 437 724 505 618 599 658 475 497 542 480 538 545 520 504 537 499 463 507 464 541 516 484
Crash on pasring of script containing `execute block` with lot of nested begin..end statements
63 CS 827 656 703 703 661 700 728 640 653 617 637 740 783 728 699 1127 1182 1168 1164 1091 1115 1106 1002 696 1072 871 996 1047 1036 1052 1000
Invalid internal BLR filter conversion
64 SS 425 437 500 387 368 425 399 573 464 445 432 325 307 608 423 412 472 405 377 458 434 432 383 472 432 445 405 399 425 367 391
Invalid internal BLR filter conversion
65 CS 848 678 805 687 682 758 704 735 669 699 798 651 696 689 658 1105 1022 1162 1090 1181 1188 1210 1118 679 1092 892 1306 1054 1079 997 1131
ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
66 SS 432 399 494 379 382 356 354 631 512 531 648 440 320 599 492 422 438 440 412 450 474 359 448 425 465 416 381 355 419 427 494
ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
67 CS 963 804 921 934 765 861 947 862 823 959 847 890 908 892 872 1467 1341 1384 1345 1600 1304 1380 1353 968 1412 816 1442 1299 1272 1331 1292
Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
68 SS 584 696 754 554 582 578 499 803 741 605 708 586 788 775 836 577 576 593 575 613 634 549 604 554 604 571 559 545 561 483 533
Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
69 CS 3176 3018 3118 3082 3124 3057 3139 3078 3141 3178 3115 3197 3148 3156 3174 4688 4551 3900 4796 4639 4699 4575 4659 3108 4623 2977 3356 4656 2960 3508 4610
IIF function prevents the condition from being pushed into the union for better optimization
70 SS 2804 2982 2744 2822 2737 2806 2761 3063 2728 2796 2987 2781 2885 2731 2980 2795 2789 2795 2805 2789 2804 2835 2822 2794 2808 2817 2782 2740 2862 2826 2850
IIF function prevents the condition from being pushed into the union for better optimization
71 CS 766 747 955 644 684 703 673 669 768 755 657 733 722 760 765 1053 1096 1074 1087 1088 1045 1176 1131 672 1104 593 1084 1156 710 1014 1151
Add label about deterministic flag for stored function in SHOW and extract commands
72 SS 448 607 551 418 433 401 388 450 460 353 568 446 555 468 583 424 489 412 443 417 457 452 409 454 444 452 457 396 490 434 432
Add label about deterministic flag for stored function in SHOW and extract commands
73 CS 1453 1457 1479 1507 1449 1405 1386 1236 1417 1582 1372 1441 1398 1610 1427 2376 2402 2280 2280 2569 2496 2237 2279 1457 2206 1372 1259 1239 1424 1391 1236
Operator REVOKE can modify rights granted to system tables at DB creation time
74 SS 889 1090 1098 789 845 895 825 1422 1139 776 1194 969 1140 1138 1129 839 685 877 868 846 902 907 888 781 950 851 881 890 891 790 852
Operator REVOKE can modify rights granted to system tables at DB creation time
75 CS 1506 1421 1502 1401 1395 1428 1329 1498 1442 1556 1511 1583 1635 1501 1379 2199 2320 2338 1324 2514 2492 2352 2195 1420 2482 2543 1888 1284 2495 1237 1294
Non-privileged user can implicitly count records in a restricted table
76 SS 890 1099 1134 929 772 852 776 1384 1112 1091 1330 999 1068 653 1236 866 864 878 864 903 912 966 855 819 928 872 847 815 907 848 864
Non-privileged user can implicitly count records in a restricted table

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1725
http://tracker.firebirdsql.org/browse/CORE-3176
http://tracker.firebirdsql.org/browse/CORE-4484
http://tracker.firebirdsql.org/browse/CORE-4653
http://tracker.firebirdsql.org/browse/CORE-4665
http://tracker.firebirdsql.org/browse/CORE-4673
http://tracker.firebirdsql.org/browse/CORE-4694
http://tracker.firebirdsql.org/browse/CORE-4702
http://tracker.firebirdsql.org/browse/CORE-4707
http://tracker.firebirdsql.org/browse/CORE-4725
http://tracker.firebirdsql.org/browse/CORE-4733
http://tracker.firebirdsql.org/browse/CORE-4735
http://tracker.firebirdsql.org/browse/CORE-4738
http://tracker.firebirdsql.org/browse/CORE-4744
http://tracker.firebirdsql.org/browse/CORE-4754
http://tracker.firebirdsql.org/browse/CORE-4755
http://tracker.firebirdsql.org/browse/CORE-4766
http://tracker.firebirdsql.org/browse/CORE-4774
http://tracker.firebirdsql.org/browse/CORE-4782
http://tracker.firebirdsql.org/browse/CORE-4786
http://tracker.firebirdsql.org/browse/CORE-4806
http://tracker.firebirdsql.org/browse/CORE-4807
http://tracker.firebirdsql.org/browse/CORE-4809
http://tracker.firebirdsql.org/browse/CORE-4811
http://tracker.firebirdsql.org/browse/CORE-4819
http://tracker.firebirdsql.org/browse/CORE-4826
http://tracker.firebirdsql.org/browse/CORE-4836
http://tracker.firebirdsql.org/browse/CORE-4839
http://tracker.firebirdsql.org/browse/CORE-4846
http://tracker.firebirdsql.org/browse/CORE-4855
http://tracker.firebirdsql.org/browse/CORE-4884
http://tracker.firebirdsql.org/browse/CORE-4905
http://tracker.firebirdsql.org/browse/CORE-4917
http://tracker.firebirdsql.org/browse/CORE-4921
http://tracker.firebirdsql.org/browse/CORE-4927
http://tracker.firebirdsql.org/browse/CORE-4940
http://tracker.firebirdsql.org/browse/CORE-4980
http://tracker.firebirdsql.org/browse/CORE-4985
=== end of list ===

Last commits information (all timestamps in UTC):