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 (4 rows)
04. NEW ERRORS: tests which raised runtime error for LAST run (0 rows)
05. STILL FAILS: tests which fail for at least TWO LAST runs (1 rows)
[CURRENT] 06. Has fails: tests with at least one fail for previous 30 runs (68 rows)
07. Has runtime errors: tests with at least one runtime error for previous 30 runs (0 rows)
08. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (0 rows)
09. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (4 rows)
10. All tests: outcomes for previous 30 runs (2445 rows)
11. All tests: durations for previous 30 runs (4681 rows)
12. Skipped: tests which was intentionally excluded from execution (65 rows)

Generated 03.10.2023 05:23
Tested: FB50.   Build: 5.0.0.1236;   SS: 03.10.23 03:41:42 - 03.10.23 04:25:23;   CS: 03.10.23 04:27:13 - 03.10.23 05:20:53;
OS and hardware info:  Linux 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) ; logical CPUs: 2 ; total memory: 7.6 Gb 
QA-software: Python 3.10.9, virtual env; pytest: 7.2.1; firebird.driver: 1.8.0; Firebird.Qa: 0.17.2

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

Jump to LIST of unique test names from this report

NN Test name mode 5.0.0.1236
2023-10-03		 5.0.0.1235
2023-10-01		 5.0.0.1233
2023-09-29		 5.0.0.1229
2023-09-27		 5.0.0.1227
2023-09-26		 5.0.0.1225
2023-09-25		 5.0.0.1216
2023-09-16		 5.0.0.1215
2023-09-15		 5.0.0.1211
2023-09-14		 5.0.0.1209
2023-09-13		 5.0.0.1204
2023-09-12		 5.0.0.1202
2023-09-11		 5.0.0.1201
2023-09-09		 5.0.0.1200
2023-09-08		 5.0.0.1194
2023-09-07		 5.0.0.1190
2023-09-06		 5.0.0.1184
2023-09-05		 5.0.0.1182
2023-09-02		 5.0.0.1181
2023-08-31		 5.0.0.1180
2023-08-30		 5.0.0.1177
2023-08-29		 5.0.0.1176
2023-08-27		 5.0.0.1170
2023-08-25		 5.0.0.1169
2023-08-24		 5.0.0.1167
2023-08-21		 5.0.0.1164
2023-08-16		 5.0.0.1163
2023-08-14		 5.0.0.1161
2023-08-11		 5.0.0.1160
2023-08-10		 5.0.0.1159
2023-08-09
Test TITLE
1
bugs core 0214 
 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
Count ( DISTINCT ... ) is too slow
2
bugs core 0733 
 tracker
 SS 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 P
Compress Data over the Network
3
bugs core 2115 
 tracker
 CS P P P P P P P P P P P P P P F F F P P P P P P P P P P P P P
Query plan is missing for the long query
4
bugs core 2115 
 tracker
 SS P P P P P P P P P P P P P P F F F P P P P P P P P P P P P P
Query plan is missing for the long query
5
bugs core 2508 
 tracker
 CS P P P P P P P P P P P P P P P F F P P P P P P P P P P P P P
Tricky index names can defeat the parsing logic when generating a human readable plan
6
bugs core 2508 
 tracker
 SS P P P P P P P P P P P P P P P F F P P P P P P P P P P P P P
Tricky index names can defeat the parsing logic when generating a human readable plan
7
bugs core 3095 
 tracker
 SS P P P P P P F F F F F F F F F F F F F F F F F P F P F F F F
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
8
bugs core 5087 
 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 P P P P P P
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
9
bugs core 5167 
 tracker
 CS P P P P P P P P P P P P P P P F F P P P P P P P P P P P P P
Allow implicit conversion between boolean and string
10
bugs core 5167 
 tracker
 SS P P P P P P P P P P P P P P P F F P P P P P P P P P P P P P
Allow implicit conversion between boolean and string
11
bugs core 5210 
 tracker
 SS P P P P P P P P P P F P P F P P P P P P P P P P P P P P P P
Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work
12
bugs core 5236 
 tracker
 CS P P P P P P P P P P P F F F F F F F F F F F F F F P P P P P
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
13
bugs core 5236 
 tracker
 SS P P P P P P P P P P P F F F F F F F F F F F F F F P P P P P
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
14
bugs core 5481 
 tracker
 CS P P P P P P F F F P P P P P P P P P P P P P P P P P P P P P
Available indices are not used in some cases if ORDER BY expression is a filtered one
15
bugs core 5481 
 tracker
 SS P P P P P P F F F P P P P P P P P P P P P P P P P P P P P P
Available indices are not used in some cases if ORDER BY expression is a filtered one
16
bugs core 5501 
 tracker
 CS 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 P P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
17
bugs core 5646 
 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 P P P P P
Parse error when compiling a statement causes memory leak until attachment is disconnected
18
bugs core 5845 
 tracker
 CS P P P P P P P P P P P F F F F F F P P P P P P P P P P P P P
ORDER BY on index can cause suboptimal index choices
19
bugs core 5845 
 tracker
 SS P P P P P P P P P P P F F F F F F P P P P P P P P P P P P P
ORDER BY on index can cause suboptimal index choices
20
bugs core 6248 
 tracker
 SS P P P P P P F P P F P P P P P P P P P P P P P P P P P P P P
A number of errors when database name is longer than 255 symbols
21
bugs core 6348 
 tracker
 SS P P P P P P F P P P P P P P P P P P P P P F P P P P P P P P
Wire compression causes freezes
22
bugs core 6444 
 tracker
 CS 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 P P
Ability to query Firebird configuration using SQL
23
bugs core 6444 
 tracker
 SS 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 P P
Ability to query Firebird configuration using SQL
24
bugs gh 0310 
 tracker
 CS 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 P P
System table with keywords
25
bugs gh 0310 
 tracker
 SS 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 P P
System table with keywords
26
bugs gh 6875 
 tracker
 CS P P P P P P P P P P P P P P F F P P P P P P P P P P F P P P
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
27
bugs gh 6875 
 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 P P P P P P
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
28
bugs gh 6934 
 tracker
 CS P P P P P P P P P P P P P P P F F P P P P P P P P P P P P P
SQL SECURITY DEFINER does not affect the ownership of created DDL objects
29
bugs gh 6934 
 tracker
 SS P P P P P P P P P P P P P P P F F P P P P P P P P P P P P P
SQL SECURITY DEFINER does not affect the ownership of created DDL objects
30
bugs gh 7086 
 tracker
 CS P P F F F F P P P P P P P P P P P P P P P P P P F F F F F F
PSQL and SQL profiler
31
bugs gh 7086 
 tracker
 SS P P F F F F P P P P P P P P P P P P P P P P P P F F F F F F
PSQL and SQL profiler
32
bugs gh 7200 
 tracker
 CS 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 P P P
DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress
33
bugs gh 7331 
 tracker
 CS P P P P P P P P P P F F F F F F F F F F F F F F F P P P P P
Cost-based choice between nested loop join and hash join
34
bugs gh 7331 
 tracker
 SS P P P P P P P P P P F F F F F F F F F F F F F F F P P P P P
Cost-based choice between nested loop join and hash join
35
bugs gh 7466 plans tracking 
 tracker
 CS P P P P P P P P P P P P P F F F F P P P P P P P P X X X X X
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
36
bugs gh 7466 plans tracking 
 tracker
 SS P P P P P P P P P P P P F F F F F P P P P P P P P X X X X X
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
37
bugs gh 7466 
 tracker
 CS P P P P P P P P P P P P P P P F F P P P P P P P P X X X X X
Add COMPILE trace events for procedures/functions/triggers
38
bugs gh 7466 
 tracker
 SS P P P P P P P P P P P P P P P F F P P P P P P P P X X X X X
Add COMPILE trace events for procedures/functions/triggers
39
bugs gh 7476 
 tracker
 CS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Improvement on procedures/triggers to recognize changes in a domain used in COALESCE
40
bugs gh 7476 
 tracker
 SS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
Improvement on procedures/triggers to recognize changes in a domain used in COALESCE
41
bugs gh 7548 
 tracker
 CS P P P P P P P P P P P P P P P P P P F F P P P P P P P P P P
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
42
bugs gh 7548 
 tracker
 SS P P P P P P P P P P P P P P P P P P F F P P P P P P P P P P
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
43
bugs gh 7553 
 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 F F F
Firebird 5 profiler error with subselects
44
bugs gh 7553 
 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 F F F
Firebird 5 profiler error with subselects
45
bugs gh 7600 
 tracker
 CS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
CASE statement different result compared to FB 2.5.9
46
bugs gh 7600 
 tracker
 SS F X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
CASE statement different result compared to FB 2.5.9
47
bugs gh 7687 
 tracker
 CS P P F F F F P P P P P P P P P P P P P P P P X X X X X X X X
Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW
48
bugs gh 7687 
 tracker
 SS P P F F F F P P P P P P P P P P P P P P P P X X X X X X X X
Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW
49
functional replication oltp emul ddl 
 CS P P P P P P P P P P P P P P P P F F F F F F F F F F F F F F
Applying full DDL from OLTP-EMUL test on master with further check replica
50
functional replication shutdown during applying segments leads to crash 
 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 P F P P F
Crash or hang while shutting down the replica database if segments are being applied
51
functional replication some updates crash server on replica side 
 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 P F P P F
Some updates can crash Firebird server on replica side
52
functional replication updating blob with empty string stops replication 
 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 P F P P F
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
53
functional tabloid e260ced8 
 CS P P P P P P P P P P P P F X X X X X X X X X X X X X X X X X
Allow computable but non-invariant lists to be used for index lookup
54
functional tabloid e260ced8 
 SS P P P P P P P P P P P P F X X X X X X X X X X X X X X X X X
Allow computable but non-invariant lists to be used for index lookup
55
functional transactions read consist statement delete undone 01 
 CS 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 P P P P P
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
56
functional transactions read consist sttm restart max limit 
 CS P P P S S S F P F F F F F F F F F F F F F F F F F F F P F F
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
57
functional transactions read consist sttm restart max limit 
 SS P P P S S S P P P F P P P P P P F P P P P P P P P F P P P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
58
functional transactions read consist sttm restart on delete 04 
 CS P P P P P P P F F F F F P F P P P P F P P F F F F P F P F P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
59
functional transactions read consist sttm restart on delete 04 
 SS 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 P F F
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
60
functional transactions read consist sttm restart on merge 04 
 CS P P P P P F F P F P P F F F P F F P F P F F F P F P F F F P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
61
functional transactions read consist sttm restart on merge 04 
 SS P P P P P F P P P F P P P P P F P F P P P F P P P F P P F P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
62
functional transactions read consist sttm restart on update 02 
 CS P P P P P F P P P P P P P F P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
63
functional transactions read consist sttm restart on update 04 
 CS P P P P P P F F F P P F F P P F F F P P F P P P P P F P F P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
64
functional transactions read consist sttm restart on update 04 
 SS P P P P P P P P P P P F P P P P P P P P F P P F P P F P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
65
functional trigger database disconnect 05 
 CS P P P P P P P P P P F F F F F F F F F F F F F F F F F F F F
ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration
66
functional trigger database disconnect 05 
 SS P P P P P P P P P P F F F F F F F F F F F F F F F F F F F F
ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration
67
functional trigger database disconnect 06 
 CS P P P P P P P P P P F F F F F F F F F F F F F F F F F F F F
ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true
68
functional trigger database disconnect 06 
 SS P P P P P P P P P P F F F F F F F F F F F F F F F F F F F F
ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true

Elapsed time, milliseconds:

NN Test name mode median_ms 5.0.0.1236
2023-10-03		 5.0.0.1235
2023-10-01		 5.0.0.1233
2023-09-29		 5.0.0.1229
2023-09-27		 5.0.0.1227
2023-09-26		 5.0.0.1225
2023-09-25		 5.0.0.1216
2023-09-16		 5.0.0.1215
2023-09-15		 5.0.0.1211
2023-09-14		 5.0.0.1209
2023-09-13		 5.0.0.1204
2023-09-12		 5.0.0.1202
2023-09-11		 5.0.0.1201
2023-09-09		 5.0.0.1200
2023-09-08		 5.0.0.1194
2023-09-07		 5.0.0.1190
2023-09-06		 5.0.0.1184
2023-09-05		 5.0.0.1182
2023-09-02		 5.0.0.1181
2023-08-31		 5.0.0.1180
2023-08-30		 5.0.0.1177
2023-08-29		 5.0.0.1176
2023-08-27		 5.0.0.1170
2023-08-25		 5.0.0.1169
2023-08-24		 5.0.0.1167
2023-08-21		 5.0.0.1164
2023-08-16		 5.0.0.1163
2023-08-14		 5.0.0.1161
2023-08-11		 5.0.0.1160
2023-08-10		 5.0.0.1159
2023-08-09
Test TITLE
1
bugs core 0214 
 tracker
 SS 3109 2393 2325 2369 2379 2383 2330 4141 2976 2830 2711 4925 4054 4316 4089 4295 2915 4852 2860 4903 2835 3108 2773 4875 3045 3124 4323 3140 3110 3371 4701
Count ( DISTINCT ... ) is too slow
2
bugs core 0733 
 tracker
 SS 51726 31767 31851 32187 31090 31404 31124 59874 55128 58207 42827 49191 47672 57041 58712 57349 51899 59322 54517 48159 57059 48174 59590 50246 51554 56720 53903 46696 60717 48790 64797
Compress Data over the Network
3
bugs core 2115 
 tracker
 CS 1023 465 465 437 456 476 453 609 637 571 553 526 602 632 537 1032 1095 1015 2267 2163 2312 2408 2431 2405 2507 2324 2261 2253 1984 2362 2409
Query plan is missing for the long query
4
bugs core 2115 
 tracker
 SS 851 279 286 267 291 292 271 433 436 525 458 543 448 480 467 840 862 915 2431 2583 2439 2797 3184 2902 2829 3156 1719 2859 2560 3079 2785
Query plan is missing for the long query
5
bugs core 2508 
 tracker
 CS 445 385 356 367 388 372 378 422 446 508 460 435 446 437 457 454 433 460 459 447 445 427 468 455 484 418 410 494 461 443 445
Tricky index names can defeat the parsing logic when generating a human readable plan
6
bugs core 2508 
 tracker
 SS 371 212 224 235 229 227 234 394 387 347 432 359 359 373 410 356 386 358 409 379 359 356 340 414 427 408 454 369 381 379 427
Tricky index names can defeat the parsing logic when generating a human readable plan
7
bugs core 3095 
 tracker
 SS 10447 252 253 251 260 251 265 10481 10467 10457 10470 10470 10436 10298 10381 10496 10494 10395 10473 10496 10466 10531 10430 10468 254 10441 235 10461 10526 10443 10451
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
8
bugs core 5087 
 tracker
 CS 18637 18401 18126 18317 18080 18578 18103 18710 18498 18812 18649 18693 18501 18653 18454 18538 18640 19001 18888 18851 18881 18765 18471 18986 18657 18463 18573 18634 19257 18609 18650
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
9
bugs core 5167 
 tracker
 CS 513 388 410 423 384 444 379 542 550 498 473 576 490 536 486 536 541 554 533 531 525 503 489 523 586 461 528 548 492 428 544
Allow implicit conversion between boolean and string
10
bugs core 5167 
 tracker
 SS 263 255 280 262 258 245 255 265 230 256 279 237 247 263 355 269 396 261 268 264 250 434 258 265 335 425 301 233 266 275 247
Allow implicit conversion between boolean and string
11
bugs core 5210 
 tracker
 SS 5465 5451 5440 5428 5450 5482 5438 5467 5461 5429 5652 5434 5461 5466 4525 5464 5748 5487 5492 5495 5570 5801 5724 5450 5528 5723 5443 5496 5457 5448 5472
Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work
12
bugs core 5236 
 tracker
 CS 636 533 518 560 548 542 532 629 691 545 611 673 638 673 604 594 583 655 676 697 636 750 592 637 653 607 677 658 684 654 643
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
13
bugs core 5236 
 tracker
 SS 352 355 350 371 340 349 336 382 356 354 335 550 411 337 576 319 550 376 306 564 325 567 346 343 429 539 347 348 416 328 334
IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
14
bugs core 5481 
 tracker
 CS 510 386 424 411 387 428 403 595 432 528 484 546 535 515 521 519 488 526 515 486 560 473 523 508 492 493 537 530 513 499 526
Available indices are not used in some cases if ORDER BY expression is a filtered one
15
bugs core 5481 
 tracker
 SS 278 276 265 289 269 271 260 390 303 264 448 236 451 465 233 422 259 247 244 246 247 502 284 281 299 387 245 503 289 458 271
Available indices are not used in some cases if ORDER BY expression is a filtered one
16
bugs core 5501 
 tracker
 CS 689 503 547 559 590 564 522 743 710 642 689 702 759 696 717 690 729 763 705 698 730 676 673 695 683 670 655 679 633 698 743
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
17
bugs core 5646 
 tracker
 SS 481 467 480 521 482 463 484 450 724 446 893 467 505 394 394 492 483 815 394 595 813 473 460 402 592 440 481 723 757 815 418
Parse error when compiling a statement causes memory leak until attachment is disconnected
18
bugs core 5845 
 tracker
 CS 470 457 461 475 420 474 470 550 633 583 591 482 535 549 471 412 467 499 464 480 414 470 474 475 441 415 442 401 458 494 453
ORDER BY on index can cause suboptimal index choices
19
bugs core 5845 
 tracker
 SS 288 286 266 276 250 263 267 283 288 262 450 304 236 327 369 288 242 433 298 444 352 386 413 242 272 230 278 385 398 362 362
ORDER BY on index can cause suboptimal index choices
20
bugs core 6248 
 tracker
 SS 6276 5879 5898 5866 5821 5932 5876 7550 6044 6344 7763 10215 6078 6757 6044 10244 6122 6586 6156 6148 10495 6358 6022 6300 6881 8165 6847 6124 6298 6320 6255
A number of errors when database name is longer than 255 symbols
21
bugs core 6348 
 tracker
 SS 54192 46010 46671 47066 44084 45605 44235 46504 54437 63960 58607 53947 49681 74093 53414 46727 73416 68807 56512 44539 53186 58024 13019 65666 70806 65349 70835 56967 43871 66935 68452
Wire compression causes freezes
22
bugs core 6444 
 tracker
 CS 441 387 388 371 369 352 358 459 421 443 494 451 446 440 462 478 512 465 440 424 435 473 474 479 489 417 463 398 436 466 414
Ability to query Firebird configuration using SQL
23
bugs core 6444 
 tracker
 SS 267 224 238 203 230 209 204 269 365 214 277 305 236 258 265 262 288 299 244 265 273 373 322 214 318 272 276 395 242 366 366
Ability to query Firebird configuration using SQL
24
bugs gh 0310 
 tracker
 CS 447 379 354 377 362 368 367 518 486 509 482 512 445 436 472 422 527 476 424 463 414 520 482 477 433 459 446 440 416 449 462
System table with keywords
25
bugs gh 0310 
 tracker
 SS 260 216 250 217 231 232 233 267 371 210 272 344 217 269 266 254 289 311 222 350 334 228 389 203 300 294 262 223 252 370 259
System table with keywords
26
bugs gh 6875 
 tracker
 CS 5468 4365 4189 4357 4156 4213 4253 5117 5640 5317 6031 5947 5938 4872 5168 5683 6341 5665 6112 6186 6428 5691 6276 5121 5440 5337 5756 5382 5497 5995 5167
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
27
bugs gh 6875 
 tracker
 SS 5175 4229 3953 4034 4039 3947 4039 5159 6679 5086 4683 5816 5472 4780 6567 4804 6767 5295 5534 5719 5347 5593 4928 5997 4987 5192 4678 5666 5436 5581 5103
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
28
bugs gh 6934 
 tracker
 CS 816 672 654 631 635 635 634 782 727 910 892 831 723 797 827 819 896 780 848 855 867 828 843 824 907 804 780 798 880 874 814
SQL SECURITY DEFINER does not affect the ownership of created DDL objects
29
bugs gh 6934 
 tracker
 SS 482 394 388 389 342 372 370 459 475 496 447 512 480 517 498 478 516 513 481 508 488 551 484 587 533 462 481 511 589 471 519
SQL SECURITY DEFINER does not affect the ownership of created DDL objects
30
bugs gh 7086 
 tracker
 CS 773 561 675 636 644 655 659 698 824 732 949 957 747 659 810 744 794 743 786 721 744 864 760 786 801 1104 969 1042 1039 1145 1031
PSQL and SQL profiler
31
bugs gh 7086 
 tracker
 SS 590 473 594 514 475 523 491 646 601 571 689 650 619 573 587 519 583 597 538 530 572 515 550 615 599 817 993 918 916 869 850
PSQL and SQL profiler
32
bugs gh 7200 
 tracker
 CS 3700 3455 3360 3315 3355 2557 3338 3879 3739 3759 2673 3818 2673 3592 3604 3829 3085 3704 3704 3813 3774 3765 3792 2909 3697 3804 3704 3791 3624 3823 2864
DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress
33
bugs gh 7331 
 tracker
 CS 1880 1618 1529 1541 1561 1532 1513 1806 1778 1872 1857 1906 1901 1688 1830 1810 1937 1945 2014 2005 2063 2011 1944 1674 1999 1837 1888 1998 1973 2086 1904
Cost-based choice between nested loop join and hash join
34
bugs gh 7331 
 tracker
 SS 1227 1078 1044 996 978 1201 984 1202 1235 1220 1263 1100 1361 1181 1155 1147 1220 1163 1352 1408 1368 1497 1355 1466 1399 1180 1292 1301 1431 1461 1456
Cost-based choice between nested loop join and hash join
35
bugs gh 7466 plans tracking 
 tracker
 CS 2878 2532 2552 2574 2526 2539 2551 2888 2914 2942 2874 2861 2891 2899 2874 2892 2910 2925 2878 2648 2610 2913 2883 2679 2899 2882 0 0 0 0 0
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
36
bugs gh 7466 plans tracking 
 tracker
 SS 2433 2413 2404 2410 2422 2433 2410 2491 2452 2447 2487 2444 2448 2429 2394 2418 2456 2419 2451 2444 2457 2410 2432 2434 2433 2456 0 0 0 0 0
Add COMPILE trace events - ability to see execution plan of every PSQL statement.
37
bugs gh 7466 
 tracker
 CS 2877 2809 2802 2785 2776 2787 2792 2908 2904 2876 2854 3169 2885 2886 2913 2932 2841 2916 2856 2883 2888 2892 2935 2858 2845 2877 0 0 0 0 0
Add COMPILE trace events for procedures/functions/triggers
38
bugs gh 7466 
 tracker
 SS 2687 2399 2391 2417 2384 2388 2384 2709 2709 2717 2671 2715 2653 2687 2693 2701 2677 2682 2710 2670 2701 2710 2694 2697 2679 2711 0 0 0 0 0
Add COMPILE trace events for procedures/functions/triggers
39
bugs gh 7476 
 tracker
 CS 408 408 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Improvement on procedures/triggers to recognize changes in a domain used in COALESCE
40
bugs gh 7476 
 tracker
 SS 229 229 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Improvement on procedures/triggers to recognize changes in a domain used in COALESCE
41
bugs gh 7548 
 tracker
 CS 7855 6752 6671 6705 6654 7158 6923 7651 7870 7914 7685 7864 7662 7847 7571 7654 7801 7747 7784 8436 8492 8605 8877 8309 8637 8445 8558 8527 8582 8416 8516
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
42
bugs gh 7548 
 tracker
 SS 5966 5098 5103 5041 5111 5228 5075 5951 6033 5981 5925 5621 5938 5944 5617 5873 5755 6010 5705 6434 6189 6244 6366 6546 6327 6178 6348 6359 6660 6428 6531
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
43
bugs gh 7553 
 tracker
 CS 757 643 648 652 670 661 646 826 790 852 962 1006 771 760 718 769 773 765 783 750 735 762 754 798 771 723 728 726 743 724 766
Firebird 5 profiler error with subselects
44
bugs gh 7553 
 tracker
 SS 492 423 458 430 416 472 433 561 534 525 563 607 531 527 478 491 493 467 466 473 544 492 468 531 544 406 523 537 497 531 461
Firebird 5 profiler error with subselects
45
bugs gh 7600 
 tracker
 CS 359 359 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CASE statement different result compared to FB 2.5.9
46
bugs gh 7600 
 tracker
 SS 237 237 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CASE statement different result compared to FB 2.5.9
47
bugs gh 7687 
 tracker
 CS 720 672 614 649 602 566 596 829 824 836 829 1035 712 713 746 718 786 735 722 749 700 725 661 0 0 0 0 0 0 0 0
Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW
48
bugs gh 7687 
 tracker
 SS 544 482 491 485 461 469 480 635 611 660 604 729 526 547 578 591 542 567 538 573 559 538 525 0 0 0 0 0 0 0 0
Add LEVEL column to PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW
49
functional replication oltp emul ddl 
 CS 47291 33191 33790 35692 33062 33888 32934 37459 37322 44759 49120 45463 36059 30609 30851 35949 33214 159464 157078 157589 156920 158003 157806 156695 157491 155633 158522 158270 160632 158861 160645
Applying full DDL from OLTP-EMUL test on master with further check replica
50
functional replication shutdown during applying segments leads to crash 
 CS 13395 13995 13778 13970 13269 13521 13996 14265 13759 14139 14414 13917 16634 14104 16516 14067 14189 4915 4679 4700 4722 5008 4966 4653 4764 2309 4500 2461 4914 4680 2388
Crash or hang while shutting down the replica database if segments are being applied
51
functional replication some updates crash server on replica side 
 CS 6163 6465 6540 6521 6526 6530 6533 6773 6854 6844 6723 6884 6779 6900 5862 6838 6863 1723 2730 2660 2741 1804 1743 1670 2714 624 1781 682 3815 1656 730
Some updates can crash Firebird server on replica side
52
functional replication updating blob with empty string stops replication 
 CS 5584 6463 5453 6433 6475 6536 6486 5757 5788 5727 5769 5716 5825 5815 6931 5727 5778 1756 1771 1753 1724 1842 1731 1777 1690 177 1795 228 1676 1710 226
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
53
functional tabloid e260ced8 
 CS 552 447 491 471 437 438 425 585 604 578 552 591 569 633 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Allow computable but non-invariant lists to be used for index lookup
54
functional tabloid e260ced8 
 SS 289 281 285 280 249 244 277 330 289 317 389 312 323 334 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Allow computable but non-invariant lists to be used for index lookup
55
functional transactions read consist statement delete undone 01 
 CS 4347 6744 6756 6777 6531 6760 3415 4369 4480 4337 4370 4366 4362 4313 4349 4334 4338 4292 4255 4332 4261 4334 4346 4320 4357 4357 4282 4343 4246 4359 4395
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
56
functional transactions read consist sttm restart max limit 
 CS 28887 47440 47607 46827 0 1910 -1 29128 28943 29078 29065 29143 28874 28869 28885 28776 28832 28863 28910 28885 29010 29258 28867 29081 28576 28781 28093 28362 28890 28847 29232
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
57
functional transactions read consist sttm restart max limit 
 SS 26513 42938 42914 43464 5922 1482 2 26539 26549 26893 26117 26488 26299 26652 26603 26579 26244 26626 26389 26077 26453 26716 26616 26983 26476 26034 26607 26266 26566 26010 26242
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
58
functional transactions read consist sttm restart on delete 04 
 CS 3763 6762 6725 6670 6676 6706 1892 3855 3684 3669 3859 3769 3695 3844 3818 3748 3820 3836 3650 3643 3677 3798 3758 3592 3709 3698 3602 3681 3796 3736 3816
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
59
functional transactions read consist sttm restart on delete 04 
 SS 3299 5935 5924 5945 5912 5952 1417 3266 3245 3368 3253 3353 3376 3259 3317 3282 3334 3164 3210 3312 3272 3239 3312 3290 3242 3162 3309 3244 3313 3266 3340
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
60
functional transactions read consist sttm restart on merge 04 
 CS 3723 6785 6645 6687 6647 6731 1859 3608 3740 3778 3528 3738 3696 3772 3784 3919 3630 3715 3666 3675 3725 3752 3722 3639 3629 3795 3642 3667 3692 3617 3782
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
61
functional transactions read consist sttm restart on merge 04 
 SS 3310 5948 5973 5944 5959 5929 1481 3424 3283 3318 3323 3357 3328 3312 3173 3313 3308 3259 3305 3290 3326 3291 3261 3291 3259 3239 3228 3288 3253 3362 3313
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
62
functional transactions read consist sttm restart on update 02 
 CS 3699 6682 6741 6754 6697 6734 7201237 2 3884 2 3763 3 7 0 7203016 3794 3672 3801 0 3727 0 8 3726 6 3609 5 1 3631 3669 0 2
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
63
functional transactions read consist sttm restart on update 04 
 CS 3724 6725 6695 6639 6702 6700 6846 3778 3743 3676 3676 3704 3704 3722 3655 3717 3807 3774 3667 3689 3699 3726 3675 3767 3652 3684 3740 3778 3687 3738 3717
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
64
functional transactions read consist sttm restart on update 04 
 SS 3294 5892 5946 5872 5907 5900 5927 3273 3291 3384 3383 3250 3272 3294 3294 3309 3386 3248 3174 3262 3348 3382 3262 3309 3265 3241 3419 3272 3274 3267 3259
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
65
functional trigger database disconnect 05 
 CS 5643 5599 5555 5603 5612 5579 5584 5948 5905 5841 5836 5642 5645 5627 5761 5959 5624 5767 5681 5575 5622 5640 5664 5588 5652 5621 5615 5726 5683 5683 5848
ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration
66
functional trigger database disconnect 05 
 SS 5103 5034 5087 5069 5056 5066 5084 5237 5311 5141 5321 5160 5183 5138 5067 5078 5101 5065 5143 5125 5063 5089 4970 5127 5156 5078 5150 5109 5067 5105 5165
ON DISCONNECT trigger and OnDisconnectTriggerTimeout expiration
67
functional trigger database disconnect 06 
 CS 3472 3339 3418 3372 3318 3341 3400 3754 3554 3695 3613 3498 3474 3494 3470 3510 3471 3501 3460 3403 3520 3484 3474 3483 3444 3419 3485 3458 3471 3432 3519
ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true
68
functional trigger database disconnect 06 
 SS 2944 2876 2892 2902 2851 2925 2881 3022 3061 3061 3042 2975 3035 2960 2992 2933 2943 2877 2946 2986 2896 2973 2931 2908 2953 2917 2904 2874 2964 2979 2972
ON DISCONNECT trigger: print exceptions (including cancelling) to trace if log_errors = true

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-2115
http://tracker.firebirdsql.org/browse/core-214
http://tracker.firebirdsql.org/browse/core-2508
http://tracker.firebirdsql.org/browse/core-3095
http://tracker.firebirdsql.org/browse/core-5087
http://tracker.firebirdsql.org/browse/core-5167
http://tracker.firebirdsql.org/browse/core-5210
http://tracker.firebirdsql.org/browse/core-5236
http://tracker.firebirdsql.org/browse/core-5481
http://tracker.firebirdsql.org/browse/core-5501
http://tracker.firebirdsql.org/browse/core-5646
http://tracker.firebirdsql.org/browse/core-5845
http://tracker.firebirdsql.org/browse/core-6248
http://tracker.firebirdsql.org/browse/core-6348
http://tracker.firebirdsql.org/browse/core-6444
http://tracker.firebirdsql.org/browse/core-733
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/tabloid/test_e260ced8.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_statement_delete_undone_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_max_limit.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_delete_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_merge_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/trigger/database/test_disconnect_05.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/trigger/database/test_disconnect_06.py
https://github.com/FirebirdSQL/firebird/issues/310
https://github.com/FirebirdSQL/firebird/issues/6875
https://github.com/FirebirdSQL/firebird/issues/6934
https://github.com/FirebirdSQL/firebird/issues/7086
https://github.com/FirebirdSQL/firebird/issues/7200
https://github.com/FirebirdSQL/firebird/issues/7331
https://github.com/FirebirdSQL/firebird/issues/7466
https://github.com/FirebirdSQL/firebird/issues/7476
https://github.com/FirebirdSQL/firebird/issues/7548
https://github.com/FirebirdSQL/firebird/issues/7553
https://github.com/FirebirdSQL/firebird/issues/7600
https://github.com/FirebirdSQL/firebird/issues/7687

=== end of list ===