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 (8 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 (0 rows)
[CURRENT] 07. Has fails: tests with at least one fail for previous 30 runs (69 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (752 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (0 rows)
10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (1 rows)
11. All tests: outcomes for previous 30 runs (3450 rows)
12. Skipped: tests which was intentionally excluded from execution (82 rows)

Generated UTC 02.05.2025 02:32
Tested: FB60.   Build / date: 6.0.0.767-cdd2943f / 2025.05.01;
Test machine: Windows 10 10.0.19045; logical CPUs: 8; RAM: 31 Gb 
QA software: Python: 3.11.2; pytest: 7.4.4; firebird.driver: 1.10.9; firebird.Qa: 0.19.3 
Jump to the list of unique test names from this report
Jump to the list with last developing commits information

Test with at least one result = "FAIL" for last 30 runs:

NN Test name mode
6.0.0.767
2025.05.01
cdd29
6.0.0.762
2025.04.30
5cb15
6.0.0.755
2025.04.29
739c6
6.0.0.753
2025.04.27
29ab3
6.0.0.745
2025.04.21
78ad8
6.0.0.744
2025.04.19
e883a
6.0.0.742
2025.04.17
abc3b
6.0.0.737
2025.04.16
fe52b
6.0.0.736
2025.04.14
3e6be
6.0.0.735
2025.04.13
6635c
6.0.0.734
2025.04.12
e2fd1
6.0.0.730
2025.04.11
240b8
6.0.0.726
2025.04.10
d79c6
6.0.0.725
2025.04.09
a2b05
6.0.0.722
2025.04.08
a8b86
6.0.0.719
2025.04.06
90fd9
6.0.0.717
2025.04.04
53d70
6.0.0.716
2025.04.03
fc636
6.0.0.715
2025.04.02
907ed
6.0.0.710
2025.04.01
40651
6.0.0.708
2025.03.31
cb069
6.0.0.707
2025.03.28
4bd4f
6.0.0.702
2025.03.27
86f4d
6.0.0.698
2025.03.26
d72a7
6.0.0.693
2025.03.25
8aac2
6.0.0.693
2025.03.24
0b559
6.0.0.687
2025.03.22
730aa
6.0.0.686
2025.03.20
71bf6
6.0.0.685
2025.03.19
a8577
6.0.0.680
2025.03.18
90d29
Test TITLE
1
bugs core 0214 
 tracker
 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 P P
Count (DISTINCT ...) is too slow
2
bugs core 1263 
 tracker
 SS P P P P P P P P P P P P P P P P P P P P P P P F F F P P P P
GSec incorrectly processes some switches
3
bugs core 1361 
 tracker
 CS P P P P P P P P P P P P P P P P P P P P F P P P P P P P P P
Index operations for global temporary tables are not visible for the active connection
4
bugs core 2484 
 tracker
 CS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Success message when connecting to tiny trash database file
5
bugs core 2484 
 tracker
 SS F F F F F F F F F F F F F F F F F F F F F F F F F F F F F F
Success message when connecting to tiny trash database file
6
bugs core 3168 
 tracker
 CS P P P P P P P P P P P P P P P P P P F P P P P P P P P P P P
exclude_filter doesn't work for <services></section> section of the Trace facility
7
bugs core 3168 
 tracker
 SS P P P P P P P P P P P P P P P P P P F P P P P P P P P P P P
exclude_filter doesn't work for <services></section> section of the Trace facility
8
bugs core 3658 
 tracker
 CS P P P P P P P P P P P P P P P P P P F P P P P P P P P P P P
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
9
bugs core 3658 
 tracker
 SS P P P P P P P P P P P P P P P P P P F P P P P P P P P P P P
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
10
bugs core 4236 
 tracker
 CS P P P P P P P P P P P P P P P P P P P P F P P P P P P P P P
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
11
bugs core 4977 
 tracker
 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
Detach using Linux client takes much longer than from Windows
12
bugs core 4977 
 tracker
 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
Detach using Linux client takes much longer than from Windows
13
bugs core 5236 
 tracker
 CS F F F F F F F F F F F F F F F F F F F F F F F P F F F P P P
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
14
bugs core 5236 
 tracker
 SS F F F F F F F F F F F F F F F F F F F F F F F P F F F P P P
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
15
bugs core 5488 running sttm 
 tracker
 CS P P P P P P P P P P P P F P P P P P P P P P P P P P P P P P
Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>)
16
bugs core 5833 
 tracker
 CS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process
17
bugs core 5833 
 tracker
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process
18
bugs core 6248 
 tracker
 CS P P P P P P P P P P P P P P P P P P P P P P P F F F P P P P
A number of errors when database name is longer than 255 symbols
19
bugs core 6248 
 tracker
 SS P P P P P P P P P P P P P P P P P P P P P P P F F F P P P P
A number of errors when database name is longer than 255 symbols
20
bugs core 6329 
 tracker
 CS P P P P P P P P P P P P P P P P P P P P P P P F F F P P P P
GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API
21
bugs core 6329 
 tracker
 SS P P P P P P P P P P P P P P P P P P P P P P P F F F P P P P
GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API
22
bugs core 6438 
 tracker
 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
ISQL: bad headers when text columns has >= 80 characters
23
bugs core 6438 
 tracker
 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
ISQL: bad headers when text columns has >= 80 characters
24
bugs gh 0310 
 tracker
 CS F F P P P P P P P P P P P P P F P P P P P P P P F F P P P P
System table with keywords
25
bugs gh 0310 
 tracker
 SS F F P P P P P P P P P P P P P F P P P P P P P P F F P P P P
System table with keywords
26
bugs gh 2388 
 tracker
 CS P P P P P P P P P P P F P P P P P P P P P P F P P P P P P P
Implement SQL standard FORMAT clause for CAST between string types and datetime types [CORE6507]
27
bugs gh 2388 
 tracker
 SS P P P P P P P P P P P F P P P P P P P P P P F P P P P P P P
Implement SQL standard FORMAT clause for CAST between string types and datetime types [CORE6507]
28
bugs gh 6802 
 tracker
 CS P P P P P P P P P P F P P P P P P P P P P P P P P P P P P P
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
29
bugs gh 6802 
 tracker
 SS P P P P P P P P P P F P P P P P P P P P P P P P P P P P P P
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
30
bugs gh 6935 
 tracker
 CS P P 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
SQL SECURITY DEFINER has inconsistent behaviour if the object owner is non-privileged
31
bugs gh 6941 
 tracker
 CS P P P P P P P P P P P P P P P P P P P P P P P F F F F P P P
Dummy (always true) conditions may change the join order
32
bugs gh 6941 
 tracker
 SS P P P P P P P P P P P P P P P P P P P P P P P F F F F P P P
Dummy (always true) conditions may change the join order
33
bugs gh 7141 
 tracker
 SS P P P P P P P P P P P F P P P P P P P P P P P P P P P P P P
Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query()
34
bugs gh 7200 
 tracker
 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress
35
bugs gh 7200 
 tracker
 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress
36
bugs gh 8113 
 tracker
 CS P P P P P P P P P P P P P P P P P P P P P P P F F F F P P P
UNION ALL optimization with constant false condition
37
bugs gh 8113 
 tracker
 SS P P P P P P P P P P P P P P P P P P P P P P P F F F F P P P
UNION ALL optimization with constant false condition
38
bugs gh 8115 
 tracker
 CS 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 F F P P P
Avoid reading/hashing the inner stream(s) if the leader stream is empty
39
bugs gh 8115 
 tracker
 SS 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 F F P P P
Avoid reading/hashing the inner stream(s) if the leader stream is empty
40
bugs gh 8223 
 tracker
 CS F F F F F F F F X X X X X X X X X X X X X X X X X X X X X X
SubQueryConversion = true: error "no current record for fetch operation" with complex joins
41
bugs gh 8223 
 tracker
 SS F F F F F F F F X X X X X X X X X X X X X X X X X X X X X X
SubQueryConversion = true: error "no current record for fetch operation" with complex joins
42
bugs gh 8391 
 tracker
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
gbak: Incorrect total statistics for restore
43
functional basic isql 07 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Add REPLICA MODE to the output of the isql SHOW DATABASE command
44
functional basic isql 08 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
ISQL showing publication status
45
functional gtcs cast datatypes 
 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P F
Check result or CAST() for misc agruments // from GTCS.
46
functional gtcs cast datatypes 
 SS P P P P P P P P P P P P P P P P P P P P P P E P P P P P P F
Check result or CAST() for misc agruments // from GTCS.
47
functional gtcs gtcs proc cast isql 
 CS S S S S S S S S S S S S S S S S S S S S S S S S S S S S S F
PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
48
functional gtcs gtcs proc cast isql 
 SS S S S S S S S S S S S S S S S S S S S S S S S S S S S S S F
PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
49
functional replication blob characters garbled when conn charset differs 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
50
functional replication blob not found in rw replica if target row exists 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
51
functional replication blob segments longer 32kb are not replicated 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Problem with replication of BLOB segments longer than 32KB
52
functional replication bugcheck in rw replica after conflicting insert 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Bugcheck 183 (wrong record length) could happen on replica database after UK violation on insert
53
functional replication dblevel triggers must not fire on replica 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
54
functional replication ddl triggers must not fire on replica 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
DDL-triggers must fire only on master DB
55
functional replication disallow rdb backup history replication 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Disallow replication of RDB$BACKUP_HISTORY
56
functional replication duplicates in rw replica after conflicting insert 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
57
functional replication failed ddl commands can be replicated 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Failed DDL commands can be replicated
58
functional replication generator could not be transferred to replica 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Generator values may not replicate after commit
59
functional replication invalid msg if target db has no replica flag 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
60
functional replication make async reinit reliable 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Make asynchronous replica re-initialization reliable #8324
61
functional replication oltp emul ddl 
 CS S S S S S S S S S S S S S S S S S S S S S S S S S S S S S F
Applying full DDL from OLTP-EMUL test on master with further check replica
62
functional replication oltp emul ddl 
 SS S S S S S S S S S S S S S S S S S S S S S S S S S S S S S F
Applying full DDL from OLTP-EMUL test on master with further check replica
63
functional replication shutdown during applying segments leads to crash 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Crash or hang while shutting down the replica database if segments are being applied
64
functional replication some updates crash server on replica side 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Some updates can crash Firebird server on replica side
65
functional replication updating blob with empty string stops replication 
 SS P P P P P P P P P P P P P P P P P P P P P P F P P P P P P P
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
66
functional services role in service attachment 
 CS P P P P P P P P P P P P P P P P P P F P P P P P P P P P P P
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
67
functional services role in service attachment 
 SS P P P P P P P P P P P P P P P P P P F P P P E P P P P P P P
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
68
functional tabloid dbp 2146 distinct not in 
 CS P P P P P P P P P P P P P P P P P P P P P P P F F F F P P P
Common SQL. Check correctness of the results
69
functional tabloid dbp 2146 distinct not in 
 SS P P P P P P P P P P P P P P P P P P P P P P E F F F F P P P
Common SQL. Check correctness of the results

Elapsed time, milliseconds:

NN Test name mode median_ms
6.0.0.767
2025.05.01
cdd29
6.0.0.762
2025.04.30
5cb15
6.0.0.755
2025.04.29
739c6
6.0.0.753
2025.04.27
29ab3
6.0.0.745
2025.04.21
78ad8
6.0.0.744
2025.04.19
e883a
6.0.0.742
2025.04.17
abc3b
6.0.0.737
2025.04.16
fe52b
6.0.0.736
2025.04.14
3e6be
6.0.0.735
2025.04.13
6635c
6.0.0.734
2025.04.12
e2fd1
6.0.0.730
2025.04.11
240b8
6.0.0.726
2025.04.10
d79c6
6.0.0.725
2025.04.09
a2b05
6.0.0.722
2025.04.08
a8b86
6.0.0.719
2025.04.06
90fd9
6.0.0.717
2025.04.04
53d70
6.0.0.716
2025.04.03
fc636
6.0.0.715
2025.04.02
907ed
6.0.0.710
2025.04.01
40651
6.0.0.708
2025.03.31
cb069
6.0.0.707
2025.03.28
4bd4f
6.0.0.702
2025.03.27
86f4d
6.0.0.698
2025.03.26
d72a7
6.0.0.693
2025.03.25
8aac2
6.0.0.693
2025.03.24
0b559
6.0.0.687
2025.03.22
730aa
6.0.0.686
2025.03.20
71bf6
6.0.0.685
2025.03.19
a8577
6.0.0.680
2025.03.18
90d29
Test TITLE
1
bugs core 0214 
 tracker
 SS 17426 17332 18053 17286 17855 17722 17543 17744 18113 17367 17597 17110 17382 17823 17468 17488 17159 17163 17114 17073 17047 17673 17248 18030 17211 17317 17736 17711 17547 17384 17281
Count (DISTINCT ...) is too slow
2
bugs core 1263 
 tracker
 SS 320 332 330 300 296 344 336 316 317 316 316 297 320 316 334 312 235 317 320 324 318 316 323 329 661 680 679 348 325 319 415
GSec incorrectly processes some switches
3
bugs core 1361 
 tracker
 CS 983 965 952 953 978 991 978 962 958 970 969 922 1004 980 984 980 982 988 1010 995 990 2816 1004 1026 1023 1067 1015 1068 970 981 1011
Index operations for global temporary tables are not visible for the active connection
4
bugs core 2484 
 tracker
 CS 789 774 764 762 771 789 811 778 788 768 750 766 770 780 819 819 813 790 776 817 811 421 791 789 804 818 824 826 816 810 775
Success message when connecting to tiny trash database file
5
bugs core 2484 
 tracker
 SS 603 596 259 595 586 674 634 604 596 599 596 578 636 634 658 630 632 630 598 602 622 590 600 649 291 277 518 849 622 627 656
Success message when connecting to tiny trash database file
6
bugs core 3168 
 tracker
 CS 2700 2695 2687 2678 2682 2701 2687 2704 3150 2695 2683 2665 2721 2918 3229 2697 3001 2680 2700 2691 2675 2703 2698 3112 2723 2709 2717 2727 3137 2729 2697
exclude_filter doesn't work for <services></section> section of the Trace facility
7
bugs core 3168 
 tracker
 SS 2524 2498 2493 2500 2509 2523 2506 3016 2531 2526 3042 3055 2516 2514 2541 2535 2509 2503 2506 2536 2512 2507 2525 2514 2538 2804 2527 2528 2516 2532 2560
exclude_filter doesn't work for <services></section> section of the Trace facility
8
bugs core 3658 
 tracker
 CS 2374 2367 2368 2368 2383 2381 2371 2374 2364 2367 2364 2586 2366 2375 2382 2370 2373 2374 2371 2375 2371 2369 2394 2671 2395 2388 2401 2406 2381 2373 2378
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
9
bugs core 3658 
 tracker
 SS 2216 2272 2200 2203 2207 2216 2214 2209 2211 2214 2216 2209 2234 2215 2212 2230 2274 2215 2211 2229 2251 2218 2223 2237 2230 2230 2232 2237 2212 2218 2214
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
10
bugs core 4236 
 tracker
 CS 11225 11178 11183 11213 11307 11245 11247 11224 11258 11216 11214 11196 11212 11242 11225 11233 11259 11215 11267 11175 11177 11226 11253 11286 11238 11285 11195 11281 11253 11173 11212
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
11
bugs core 4977 
 tracker
 CS 551 591 544 536 551 582 544 559 535 588 544 531 540 624 574 551 552 545 546 580 547 551 548 581 570 562 632 589 554 560 551
Detach using Linux client takes much longer than from Windows
12
bugs core 4977 
 tracker
 SS 366 381 364 348 363 362 371 361 369 363 398 328 373 377 360 368 362 363 394 362 388 364 363 371 390 393 403 364 392 354 403
Detach using Linux client takes much longer than from Windows
13
bugs core 5236 
 tracker
 CS 858 852 870 861 836 863 865 866 865 835 830 797 837 885 828 1442 861 866 861 847 840 905 839 831 904 908 855 833 820 870 837
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
14
bugs core 5236 
 tracker
 SS 595 583 595 587 583 598 813 581 590 582 614 562 622 584 591 607 607 614 637 593 595 605 589 599 616 861 860 578 614 595 575
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
15
bugs core 5488 running sttm 
 tracker
 CS 3030 3023 3024 3006 3024 3040 3024 3227 3144 3031 3027 3000 3022 3317 3028 3047 3026 3029 3044 3014 3030 3031 3034 3033 3067 3067 3033 3041 3026 3040 3021
Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>)
16
bugs core 5833 
 tracker
 CS 1858 1883 1796 1829 1808 1865 1870 1845 1834 1840 1826 1735 1848 1961 1880 1860 1859 1857 1843 1864 1856 1834 1850 2334 1943 1960 1963 1972 1862 1872 1843
DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process
17
bugs core 5833 
 tracker
 SS 1315 1294 1522 1304 1332 1297 1267 1278 1286 1283 1324 1234 1373 1274 1295 1311 1293 1299 1327 1299 1345 1320 1318 2039 1352 1380 1358 1408 1313 1339 1351
DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process
18
bugs core 6248 
 tracker
 CS 17832 17934 17670 18780 17623 17924 17872 17737 17681 17832 17723 17297 17789 19226 17843 17832 17833 17891 17799 17802 17873 17862 17942 18769 15903 15793 15730 18984 18039 17832 17934
A number of errors when database name is longer than 255 symbols
19
bugs core 6248 
 tracker
 SS 13066 12947 12998 12961 12980 13242 12998 13060 12987 13043 13784 11907 13055 13203 13100 13084 13139 13145 13194 13116 13118 13082 13156 13671 11525 11800 11666 13791 13046 13072 13051
A number of errors when database name is longer than 255 symbols
20
bugs core 6329 
 tracker
 CS 992 954 956 996 1014 961 993 1026 942 1011 1012 984 992 1024 976 951 1010 987 1024 975 976 997 1022 1071 948 956 929 1023 971 1009 1010
GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API
21
bugs core 6329 
 tracker
 SS 677 649 671 658 664 672 690 694 677 671 718 625 680 693 692 699 677 677 695 676 666 673 682 733 656 917 1138 735 664 665 665
GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API
22
bugs core 6438 
 tracker
 CS 562 567 545 628 541 562 582 562 545 559 580 562 555 625 561 553 577 592 549 575 561 555 552 607 591 619 580 553 555 564 574
ISQL: bad headers when text columns has >= 80 characters
23
bugs core 6438 
 tracker
 SS 385 376 387 355 355 398 412 359 376 386 398 359 389 387 374 369 375 373 377 374 397 375 386 416 392 396 392 406 378 384 407
ISQL: bad headers when text columns has >= 80 characters
24
bugs gh 0310 
 tracker
 CS 588 580 586 613 550 595 592 592 551 591 591 562 588 588 564 593 595 565 567 562 563 570 577 602 590 629 652 566 596 569 598
System table with keywords
25
bugs gh 0310 
 tracker
 SS 384 410 480 366 378 392 400 383 362 376 394 359 404 377 375 373 411 373 377 382 378 398 385 380 408 441 689 426 379 385 405
System table with keywords
26
bugs gh 2388 
 tracker
 CS 104875 114629 115054 115571 115188 104881 103046 103714 102971 104703 103393 100188 104018 104757 103798 104824 104108 104802 105279 104637 105037 104869 104824 105273 109667 110695 109631 110960 115231 114822 115219
Implement SQL standard FORMAT clause for CAST between string types and datetime types [CORE6507]
27
bugs gh 2388 
 tracker
 SS 105519 116217 115223 116324 115460 104279 102789 108162 103586 104861 103635 100766 104549 104252 104545 106523 105093 105507 105532 105079 105500 105249 103754 105608 111448 110916 109177 112183 115561 115816 115557
Implement SQL standard FORMAT clause for CAST between string types and datetime types [CORE6507]
28
bugs gh 6802 
 tracker
 CS 21628 21630 21593 21615 21610 21618 21620 21608 21618 21625 21670 21641 21647 21841 21634 21628 21857 21631 21617 21615 21619 21630 22058 21628 21645 21657 21662 21651 21623 21629 21601
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
29
bugs gh 6802 
 tracker
 SS 21426 21426 21445 21396 21462 21955 21437 21421 21426 21418 21475 21406 21441 21431 21424 21427 21415 21416 21417 21435 21416 21423 21406 21403 21513 21436 21449 21447 21425 21436 21443
When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired
30
bugs gh 6935 
 tracker
 CS 1258 1222 1282 1269 1250 1281 1240 1238 1234 1234 1229 1265 1284 1327 1263 1246 1248 1236 1252 1276 1280 1274 1307 1253 1293 1275 1305 1400 1254 1244 1241
SQL SECURITY DEFINER has inconsistent behaviour if the object owner is non-privileged
31
bugs gh 6941 
 tracker
 CS 1436 1410 1524 1511 1407 1430 1418 1434 1402 1429 1412 1454 1468 1477 1419 1440 1448 1428 1435 1436 1434 1442 1474 1423 1486 1486 1478 1526 1436 1437 1444
Dummy (always true) conditions may change the join order
32
bugs gh 6941 
 tracker
 SS 1128 1158 1113 1153 1113 1174 1175 1105 1119 1128 1128 1109 1104 1120 1179 1107 1166 1121 1583 1581 1118 1097 1113 1099 1150 1186 1136 1207 1113 1183 1184
Dummy (always true) conditions may change the join order
33
bugs gh 7141 
 tracker
 SS 2661 2656 2657 2653 2648 2676 2645 2675 2651 2663 2649 2653 2730 2659 2661 2661 2675 2667 2651 2661 2671 2661 2664 2698 2694 2675 2661 2671 2659 2668 2872
Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query()
34
bugs gh 7200 
 tracker
 CS 1011 1011 1012 1011 1011 1011 1012 1011 1010 1011 1011 1016 1011 1012 1011 1011 1012 1011 1011 1011 1011 1010 1011 1012 1011 1012 1011 1011 1012 1012 1016
DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress
35
bugs gh 7200 
 tracker
 SS 1011 1012 1010 1011 1012 1010 1011 1012 1011 1010 1011 1016 1011 1012 1011 1012 1012 1011 1011 1011 1012 1011 1012 1011 1012 1011 1012 1012 1011 1011 1028
DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress
36
bugs gh 8113 
 tracker
 CS 659 646 646 653 638 711 658 680 640 649 685 640 661 665 652 696 657 660 651 650 652 653 662 693 707 685 677 673 690 658 688
UNION ALL optimization with constant false condition
37
bugs gh 8113 
 tracker
 SS 440 426 414 417 455 439 425 429 447 426 433 422 429 430 443 434 445 469 430 448 443 449 430 481 453 717 731 604 443 430 441
UNION ALL optimization with constant false condition
38
bugs gh 8115 
 tracker
 CS 682 668 679 667 662 683 672 681 679 698 662 657 708 677 682 678 693 685 690 719 678 693 674 727 729 744 736 697 682 680 685
Avoid reading/hashing the inner stream(s) if the leader stream is empty
39
bugs gh 8115 
 tracker
 SS 488 472 480 467 536 484 491 479 515 506 488 469 499 477 468 487 472 488 502 489 496 476 487 533 475 540 598 545 491 484 522
Avoid reading/hashing the inner stream(s) if the leader stream is empty
40
bugs gh 8223 
 tracker
 CS 626 624 638 642 622 614 633 629 612 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SubQueryConversion = true: error "no current record for fetch operation" with complex joins
41
bugs gh 8223 
 tracker
 SS 430 423 426 418 460 434 435 427 573 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SubQueryConversion = true: error "no current record for fetch operation" with complex joins
42
bugs gh 8391 
 tracker
 SS 2479 2495 2369 2513 3113 2435 2394 2810 2483 2346 2541 2406 2427 2568 3064 2574 2596 2428 2483 2573 2475 2417 2528 2848 2366 2352 2442 2461 2390 2611 2409
gbak: Incorrect total statistics for restore
43
functional basic isql 07 
 SS 302 288 301 286 289 314 295 299 303 314 302 281 398 341 344 301 324 302 313 296 309 295 294 2084 306 312 320 306 294 297 302
Add REPLICA MODE to the output of the isql SHOW DATABASE command
44
functional basic isql 08 
 SS 157 143 140 155 142 157 157 157 158 157 157 141 158 155 156 157 159 158 155 158 156 158 159 2076 157 188 156 155 157 156 158
ISQL showing publication status
45
functional gtcs cast datatypes 
 CS 1202 1181 1197 1186 1183 1236 1198 1182 1239 1203 1192 1172 1197 1189 1210 1202 1207 1202 1269 1194 1194 1205 1222 1241 1275 1278 1254 1257 1229 1244 798
Check result or CAST() for misc agruments // from GTCS.
46
functional gtcs cast datatypes 
 SS 938 914 914 921 944 1207 915 990 940 926 936 890 937 914 905 909 926 940 915 942 959 908 940 2469 948 992 973 1221 965 1157 575
Check result or CAST() for misc agruments // from GTCS.
47
functional gtcs gtcs proc cast isql 
 CS 1 1 1 1 1 2 2 1 1 1 1 0 2 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 575
PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
48
functional gtcs gtcs proc cast isql 
 SS 1 1 1 1 1 2 2 1 1 2 1 0 2 2 2 1 2 1 1 2 2 1 1 1 1 1 1 1 2 1 660
PROC_CAST1_ISQL.script ... PROC_CAST10_ISQL.script
49
functional replication blob characters garbled when conn charset differs 
 SS 8988 9507 9503 8642 8591 8730 9625 9517 8660 9671 9534 8545 8685 9662 8672 8641 8656 8723 9486 8656 9672 9651 8688 2418 9595 9247 9635 9748 8636 8666 9526
Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different
50
functional replication blob not found in rw replica if target row exists 
 SS 9736 9912 9876 10071 9994 9296 9032 9075 9995 10084 9163 9568 10088 8973 10093 10117 10139 10097 9037 9985 9051 8890 10086 2211 9610 9863 9241 8994 10134 9113 9115
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
51
functional replication blob segments longer 32kb are not replicated 
 SS 6413 6382 6417 6430 6353 6728 5785 6640 6350 6569 7417 6293 6348 6662 6372 6309 5485 6409 6623 6500 6458 6581 6574 2406 6466 5573 6437 6545 6335 6375 6369
Problem with replication of BLOB segments longer than 32KB
52
functional replication bugcheck in rw replica after conflicting insert 
 SS 5977 5949 5933 5965 5930 6019 6957 6041 5968 5968 5956 5921 5994 5975 6028 5967 6970 5966 5969 6010 5979 5957 5960 2210 6040 6034 6043 6122 5997 6974 6971
Bugcheck 183 (wrong record length) could happen on replica database after UK violation on insert
53
functional replication dblevel triggers must not fire on replica 
 SS 6110 6091 6094 6065 6085 6085 6087 6119 6110 6116 6099 6041 6136 6107 6131 6107 6117 6094 6101 6118 6115 6108 6174 2400 6183 6153 6143 6168 6113 6121 6111
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
54
functional replication ddl triggers must not fire on replica 
 SS 6315 6282 7244 6300 6271 6288 6290 7289 6290 6329 6287 7255 7296 6302 6385 6324 6294 6312 7315 6304 7413 6295 6298 2434 6355 7364 7544 6351 7325 6308 6319
DDL-triggers must fire only on master DB
55
functional replication disallow rdb backup history replication 
 SS 6119 6182 5161 6010 6060 6093 6209 6096 6067 6179 6083 6141 6175 6191 6118 6101 6217 6208 6226 6218 6135 6128 6104 2212 6121 5113 6295 6092 5217 6194 6091
Disallow replication of RDB$BACKUP_HISTORY
56
functional replication duplicates in rw replica after conflicting insert 
 SS 9502 8663 9503 9478 9514 9501 9640 8507 9517 9665 9491 8543 8665 9489 9513 9512 8646 9666 8653 9654 8714 9527 9694 2409 9730 9607 10286 8739 9536 8669 8684
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
57
functional replication failed ddl commands can be replicated 
 SS 6097 6074 6090 6045 6069 6335 6069 6099 6076 6082 6101 6048 6092 6107 6130 6073 6103 6131 6095 6089 6108 6111 6109 2217 6290 6155 5544 6578 6105 6101 6074
Failed DDL commands can be replicated
58
functional replication generator could not be transferred to replica 
 SS 6039 6020 6040 5980 6008 5527 6006 6025 6000 6012 6051 5970 6039 6047 6032 6049 6049 6039 6048 6059 6048 6051 6052 2403 6083 7064 6087 5530 6044 6011 6009
Generator values may not replicate after commit
59
functional replication invalid msg if target db has no replica flag 
 SS 13050 12122 13095 14085 13063 12161 13090 12072 13098 13074 13106 13038 12102 13127 13100 13095 12105 12107 13122 12104 12110 13100 13134 2419 13156 13169 12157 12135 12107 12095 12105
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
60
functional replication make async reinit reliable 
 SS 99224 99085 98092 99099 99345 99707 99122 101137 101165 102237 98375 99915 102311 99511 103297 99271 98128 99061 101059 101491 99378 98066 98046 2406 99178 98792 98337 103166 101489 99172 99099
Make asynchronous replica re-initialization reliable #8324
61
functional replication oltp emul ddl 
 CS 7 8 8 7 7 7 7 8 7 8 8 0 7 7 7 7 8 7 8 8 7 7 7 7 8 7 8 7 7 7 7702
Applying full DDL from OLTP-EMUL test on master with further check replica
62
functional replication oltp emul ddl 
 SS 7 8 7 7 8 7 8 8 7 7 7 0 7 8 7 7 7 7 8 8 7 7 7 7 7 7 8 8 7 7 7689
Applying full DDL from OLTP-EMUL test on master with further check replica
63
functional replication shutdown during applying segments leads to crash 
 SS 13829 13821 14030 13587 14022 13507 13452 13837 13017 13411 14036 12981 13846 13861 13277 13279 13847 13072 14187 14011 13888 13867 13567 2399 13383 14139 14032 13192 14310 14287 13266
Crash or hang while shutting down the replica database if segments are being applied
64
functional replication some updates crash server on replica side 
 SS 6046 6087 7023 6001 6027 6087 6030 6042 7016 6043 6047 6970 6018 6044 6022 6018 7040 6040 6283 6046 7052 6041 6042 2210 6095 6069 6089 7097 6040 7066 6053
Some updates can crash Firebird server on replica side
65
functional replication updating blob with empty string stops replication 
 SS 6053 6356 5990 6970 6997 6073 6027 6026 6030 6062 6012 5971 7039 6041 6061 6045 6043 7041 6002 6033 6038 7036 6066 2391 6079 6063 6079 6328 7035 5998 6034
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
66
functional services role in service attachment 
 CS 3405 3406 3415 3366 3359 3387 3641 3402 3371 3439 3398 3835 3385 3398 3404 3398 3420 3402 3443 3426 3389 3411 3397 3648 3534 4034 3518 3468 3413 3385 3395
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
67
functional services role in service attachment 
 SS 2851 3058 2815 2808 3000 2938 2843 2822 2823 2845 2842 2804 2846 2851 2852 2855 2861 2847 2839 2865 2843 2863 2851 2254 2925 2923 2914 2863 2865 2857 2848
Check that trace plugin shows ROLE used in service attachment. Format: USER[:ROLE]
68
functional tabloid dbp 2146 distinct not in 
 CS 934 895 921 919 888 927 909 908 930 909 943 859 970 949 997 903 966 938 941 908 944 984 949 928 957 984 956 952 911 947 906
Common SQL. Check correctness of the results
69
functional tabloid dbp 2146 distinct not in 
 SS 627 657 602 594 598 610 630 614 603 933 644 594 614 656 653 629 615 613 630 622 625 623 645 4139 657 667 663 645 626 605 678
Common SQL. Check correctness of the results

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1263
http://tracker.firebirdsql.org/browse/CORE-1361
http://tracker.firebirdsql.org/browse/CORE-214
http://tracker.firebirdsql.org/browse/CORE-2484
http://tracker.firebirdsql.org/browse/CORE-3168
http://tracker.firebirdsql.org/browse/CORE-3658
http://tracker.firebirdsql.org/browse/CORE-4236
http://tracker.firebirdsql.org/browse/CORE-4977
http://tracker.firebirdsql.org/browse/CORE-5236
http://tracker.firebirdsql.org/browse/CORE-5488
http://tracker.firebirdsql.org/browse/CORE-5833
http://tracker.firebirdsql.org/browse/CORE-6248
http://tracker.firebirdsql.org/browse/CORE-6329
http://tracker.firebirdsql.org/browse/CORE-6438
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/basic/isql/test_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/basic/isql/test_08.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_cast_datatypes.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_gtcs_proc_cast_isql.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_blob_characters_garbled_when_conn_charset_differs.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_blob_not_found_in_rw_replica_if_target_row_exists.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_blob_segments_longer_32kb_are_not_replicated.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_bugcheck_in_rw_replica_after_conflicting_insert.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_dblevel_triggers_must_not_fire_on_replica.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_ddl_triggers_must_not_fire_on_replica.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_disallow_rdb_backup_history_replication.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_duplicates_in_rw_replica_after_conflicting_insert.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_failed_ddl_commands_can_be_replicated.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_generator_could_not_be_transferred_to_replica.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_invalid_msg_if_target_db_has_no_replica_flag.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_make_async_reinit_reliable.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_oltp_emul_ddl.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_shutdown_during_applying_segments_leads_to_crash.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_some_updates_crash_server_on_replica_side.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_updating_blob_with_empty_string_stops_replication.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/services/test_role_in_service_attachment.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_dbp_2146_distinct_not_in.py
https://github.com/FirebirdSQL/firebird/issues/2388
https://github.com/FirebirdSQL/firebird/issues/310
https://github.com/FirebirdSQL/firebird/issues/6802
https://github.com/FirebirdSQL/firebird/issues/6935
https://github.com/FirebirdSQL/firebird/issues/6941
https://github.com/FirebirdSQL/firebird/issues/7141
https://github.com/FirebirdSQL/firebird/issues/7200
https://github.com/FirebirdSQL/firebird/issues/8113
https://github.com/FirebirdSQL/firebird/issues/8115
https://github.com/FirebirdSQL/firebird/issues/8223
https://github.com/FirebirdSQL/firebird/issues/8391
=== end of list ===

Last commits information (all timestamps in UTC):