01. Total results for each kind of outcome and server mode, for previous 35 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 (6 rows)
[CURRENT] 05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (37 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 35 runs (24 rows)
08. Has runtime errors: tests with at least one runtime error for previous 35 runs (1 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 35 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 35 runs (2933 rows)
12. Skipped: tests which was intentionally excluded from execution (169 rows)

Generated UTC 14.09.2025 01:10
Tested: FB60.   Build / date: 6.0.0.1274-85ea9459 / 2025.09.12;
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 performance slowdown for LAST 5 runs - moving medians

LAST moving median (window = 5) greater than previous for at least 1.5x. No more than 50 rows are shown, pre-filtered in descending order of ratio between latest and previous medians:
NN Test name mode Test last update Moving medians chart
6.0.0.1274
2025.09.12
85ea9
6.0.0.1273
2025.09.08
f9194
6.0.0.1267
2025.09.07
6441f
6.0.0.1266
2025.09.05
1a0af
6.0.0.1265
2025.09.04
ba248
6.0.0.1264
2025.09.02
6a321
6.0.0.1262
2025.09.01
984aa
6.0.0.1261
2025.08.31
8d5bb
6.0.0.1259
2025.08.30
66b1c
6.0.0.1255
2025.08.29
037e1
6.0.0.1247
2025.08.28
6ad59
6.0.0.1246
2025.08.26
5cad6
6.0.0.1245
2025.08.25
382cf
6.0.0.1244
2025.08.21
ab7da
6.0.0.1232
2025.08.20
f69e8
6.0.0.1227
2025.08.19
2e9f0
6.0.0.1226
2025.08.18
58d28
6.0.0.1224
2025.08.17
b2381
6.0.0.1214
2025.08.16
99bbb
6.0.0.1212
2025.08.15
c96d5
6.0.0.1210
2025.08.14
6ab0c
6.0.0.1204
2025.08.11
d69d1
6.0.0.1203
2025.08.10
ec2be
6.0.0.1194
2025.08.08
c157a
6.0.0.1189
2025.08.07
7863e
6.0.0.1164
2025.08.06
c3e5d
6.0.0.1157
2025.08.05
c8def
6.0.0.1152
2025.08.04
ffb6d
6.0.0.1131
2025.08.03
87afd
6.0.0.1124
2025.08.02
1ccdf
6.0.0.1115
2025.08.01
ab0bd
Test TITLE
1
bugs core 1428 
 tracker
 CS 2022.02.02 14:46
974 575 575 575 572 572 561 561 586 596 596 659 659 659 659 932 1016 1016 1016 789 721 721 735 735 981 991 981 989 989 1014 989
Incorrect timestamp substraction in 3 dialect when result is negative number
2
bugs core 3937 
 tracker
 CS 2022.02.02 14:46
1073 712 652 712 652 652 652 970 614 970 662 724 662 662 662 724 1103 1103 1103 1089 659 659 659 720 1017 1017 720 720 1011 1011 1011
eActivate/Activate INDEX or RESTORE not possible with NULL in unique index.
3
bugs core 3942 
 tracker
 CS 2022.02.02 14:46
968 566 564 566 564 566 564 936 552 936 603 652 603 603 603 652 945 953 953 953 906 906 906 602 950 950 782 782 950 904 904
Restore from gbak backup using service doesn't report an error
4
bugs core 5831 
 tracker
 CS 2023.03.11 07:58
1092 643 841 841 667 667 669 667 669 683 669 683 683 709 709 827 827 827 727 727 727 735 1105 1105 1105 1112 1082 777 703 667 667
Not user friendly output of gstat at encrypted database
5
bugs core 5837 
 tracker
 CS 2022.02.02 14:46
1236 784 1330 1330 875 875 875 740 845 740 740 819 819 819 912 957 912 912 913 833 833 833 913 1323 1355 1386 1418 1386 1386 739 739
Inconsistent results when working with GLOBAL TEMPORARY TABLE ON COMMIT PRESERVE ROWS
6
bugs core 5840 
 tracker
 CS 2025.07.02 12:23
1437 797 797 812 812 812 816 816 816 812 812 812 812 917 965 1036 965 965 875 875 875 875 926 1465 1465 1528 1535 1528 1455 785 785
Ignor of reference privilege
7
bugs core 5845 
 tracker
 CS 2025.06.25 15:39
1211 720 720 756 720 690 690 690 661 644 644 644 767 769 843 890 843 843 872 752 752 752 872 1239 1239 1239 1296 1296 1218 1189 736
ORDER BY on index can cause suboptimal index choices
8
bugs core 5846 
 tracker
 CS 2022.02.02 14:46
1013 602 602 602 597 597 597 597 606 636 645 645 676 680 721 731 1026 1026 1026 710 710 653 710 1052 1084 1128 1163 1163 1128 1012 758
CREATE VIEW issues "Implementation of text subtype 512 not located"
9
bugs core 5939 
 tracker
 CS 2022.02.02 14:46
709 425 423 423 423 423 698 757 757 698 496 490 490 490 490 490 483 483 528 528 528 528 453 453 577 577 577 852 743 743 738
Crash for "gbak -se -b database nul"
10
bugs core 5953 
 tracker
 CS 2022.02.02 14:46
1053 655 655 663 663 663 989 1049 1049 1049 803 739 739 739 697 739 692 692 718 729 729 729 718 729 661 661 661 1039 1039 1039 1039
Statement level read consistency in read-committed transactions
11
bugs core 6254 
 tracker
 CS 2022.02.02 14:46
1020 668 1023 1042 1042 668 639 639 615 639 668 694 694 694 668 694 632 632 658 711 711 711 671 711 671 635 671 607 607 607 590
AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction
12
bugs gh 6874 
 tracker
 SS 2023.12.14 16:29
501 332 318 332 332 332 316 537 447 520 447 447 379 370 353 342 342 353 442 442 442 382 382 382 418 418 420 420 483 420 420
Literal 65536 (interpreted as int) can not be multiplied by itself w/o cast if result more than 2^63-1
13
bugs gh 6934 
 tracker
 SS 2022.02.02 14:46
843 552 508 466 466 465 463 463 481 826 826 826 616 609 609 609 773 773 845 773 684 465 684 684 896 896 896 859 859 856 764
SQL SECURITY DEFINER does not affect the ownership of created DDL objects
14
bugs gh 6935 
 tracker
 SS 2023.12.01 20:09
1201 787 698 698 686 686 681 686 837 1233 1233 1233 939 939 939 1008 1203 1203 1203 1202 945 835 945 945 1274 1295 1295 1274 1274 1230 1087
SQL SECURITY DEFINER has inconsistent behaviour if the object owner is non-privileged
15
bugs gh 7220 
 tracker
 CS 2025.07.04 20:45
1340 852 854 854 854 854 914 1320 1320 1320 1280 752 752 749 749 749 689 689 652 652 652 652 652 708 1029 1029 1029 1042 1042 677 709
Dependencies of subroutines are not preserved after backup restore
16
bugs gh 7493 
 tracker
 CS 2023.03.03 22:02
1258 828 828 844 794 794 844 844 1236 1289 1289 1236 1059 684 661 684 641 612 612 694 612 694 701 989 989 989 757 757 757 897 897
Firebird 5.0 snapshot blob not found error after first commit / rollback
17
bugs gh 8265 
 tracker
 SS 2025.07.06 16:20
780 435 435 436 436 436 436 436 416 511 485 510 485 510 510 510 440 440 415 415 440 456 509 509 456 436 436 409 436 567 567
Nested IN/EXISTS subqueries should not be converted into semi-joins if the outer context is a sub-query which wasn't unnested
18
bugs gh 8278 
 tracker
 SS 2025.02.24 16:02
836 500 500 521 521 521 554 554 554 596 596 633 556 616 616 616 568 616 568 568 595 641 641 641 595 477 477 477 513 548 649
Avoid index lookup for a NULL key if the condition is known to always be FALSE in this case
19
bugs gh 8290 
 tracker
 SS 2025.07.06 16:24
671 422 422 485 485 439 485 485 439 514 514 481 472 472 472 454 454 480 480 480 480 480 480 480 480 441 667 398 683 616 616
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
20
functional datatypes int128 math functions 
 SS 2022.02.04 18:05
630 394 394 394 483 616 616 616 483 616 459 459 459 459 449 424 449 424 424 438 480 438 438 438 415 415 516 558 516 558 516
Basic test for math functions against INT128 datatype
21
functional fkey cascade master uk on update cascade 
 SS 2025.06.18 12:03
703 407 407 624 407 600 624 600 414 600 438 438 479 479 479 479 460 460 628 549 628 628 549 479 479 407 383 407 496 496 497
Updating PK column(s) in master must cause changes in appropriate detail column(s) if 'ON UPDATE CASCADE' option is used
22
functional gtcs computed fields 17 
 SS 2022.02.04 18:05
616 365 365 365 365 352 344 344 352 515 515 515 515 423 412 388 412 412 512 512 568 603 568 407 568 381 381 560 560 460 460
Computed fields
23
functional gtcs conversion error from string 
 SS 2022.02.04 18:05
751 448 447 447 447 445 445 445 489 666 666 666 548 544 532 488 532 476 532 527 749 595 595 527 595 455 455 548 580 548 548
Script issues conversion error from string
24
functional gtcs crash of group by varchar 4000 
 SS 2023.12.16 10:29
580 366 353 350 353 353 402 407 487 568 568 568 459 443 440 440 443 408 408 401 512 512 512 479 512 479 479 557 564 564 564
Crash on attempt to GROUP BY on table with varchar(4000) field
25
functional gtcs division by zero corrupts db 
 SS 2025.07.11 09:03
617 400 395 395 386 386 386 391 391 594 594 594 601 446 441 441 441 434 441 436 492 567 567 538 567 538 538 588 632 588 588
Zero divide in SP can crash database when call this SP several times
26
functional gtcs dsql domain 01 
 SS 2023.12.16 10:31
597 363 351 358 363 363 364 367 370 425 457 457 523 464 457 364 464 357 357 397 414 414 452 452 482 482 513 430 491 430 430
Test the level 0 syntax for SQL create domain defining only the datatype
27
functional gtcs dsql domain 07 
 SS 2025.07.11 09:10
822 539 506 490 490 490 470 441 441 629 555 582 635 582 564 564 564 430 430 514 514 514 514 500 500 496 475 475 598 475 589
Test CREATE / ALTER domain statement with ADD/DROP CONSTRAINT clauses, together and separately.
28
functional gtcs gtcs proc isql 10 
 SS 2022.02.04 18:05
891 560 623 623 561 554 554 554 561 732 732 732 721 696 669 537 537 519 519 671 671 531 568 534 534 534 568 534 619 619 731
gtcs-proc-isql-10
29
functional gtcs time zone 
 SS 2025.07.11 09:45
838 516 516 516 516 515 530 530 774 808 808 808 752 656 554 656 492 482 482 500 482 483 500 627 816 816 816 816 863 837 837
Miscelaneous time zone tests
30
functional gtcs transactions autocommit 3 
 SS 2022.04.29 17:46
710 410 395 395 395 393 393 393 393 668 668 520 520 482 471 482 388 388 388 396 388 396 415 500 500 500 500 500 440 440 486
Changes within AUTO COMMIT must be cancelled when exception raises in some PROCEDURE
31
functional gtcs trigger variable assignment 
 SS 2022.02.04 18:05
557 329 329 329 329 329 340 394 394 534 534 435 435 431 387 387 329 320 320 323 320 323 369 409 496 496 496 496 316 316 377
Variable in the AFTER-trigger must be allowed for assignment OLD value in it
32
functional gtcs window func 02 
 SS 2022.05.07 13:53
633 410 394 394 394 391 391 428 447 669 669 669 573 482 468 482 385 385 385 391 385 375 391 487 591 591 591 584 438 438 554
Set of miscelaneous tests for verification of windowed functions
33
functional sqlite 6c1d3febc0 
 SS 2025.08.18 13:37
527 346 346 346 346 343 357 358 348 526 526 462 462 X X X X X X X X X X X X X X X X X X
PRIMARY KEY for REAL column datatype leads to a missing entry in the index.
34
functional sqlite fc7bd6358f 
 SS 2025.08.22 08:25
589 381 381 374 359 355 355 355 355 456 X X X X X X X X X X X X X X X X X X X X X
Incorrect query result in a 3-way join due to affinity issues
35
functional syspriv access any object 
 SS 2025.07.11 18:04
1108 649 649 649 647 642 638 638 638 699 737 795 915 808 808 824 908 824 908 908 907 900 907 900 900 900 632 632 829 1024 829
Check ability to query, modify and deleting data plus add/drop constraints on any table
36
functional syspriv access shutdown database 
 SS 2024.06.09 15:53
1948 1104 1106 1106 1104 1074 1106 1074 1074 1121 1250 1260 1331 1260 1260 1331 1734 1734 1815 1734 1734 1728 1756 1728 1728 1720 1181 1181 1720 1720 1576
Check ability to access to database in shutdown single mode as non-sysdba
37
functional syspriv read raw pages 
 SS 2022.05.20 19:05
1959 1226 1226 1374 1374 1086 1374 1167 1125 1167 1421 1421 1488 1488 1421 1410 1410 1410 1729 1729 1777 1729 1570 1152 1150 1068 1150 1150 1812 1866 1866
Check ability to get binary content of DB page by non-sysdba user who is granted with necessary system privilege

Elapsed time, milliseconds:

NN Test name mode
6.0.0.1274
2025.09.12
85ea9
6.0.0.1273
2025.09.08
f9194
6.0.0.1267
2025.09.07
6441f
6.0.0.1266
2025.09.05
1a0af
6.0.0.1265
2025.09.04
ba248
6.0.0.1264
2025.09.02
6a321
6.0.0.1262
2025.09.01
984aa
6.0.0.1261
2025.08.31
8d5bb
6.0.0.1259
2025.08.30
66b1c
6.0.0.1255
2025.08.29
037e1
6.0.0.1247
2025.08.28
6ad59
6.0.0.1246
2025.08.26
5cad6
6.0.0.1245
2025.08.25
382cf
6.0.0.1244
2025.08.21
ab7da
6.0.0.1232
2025.08.20
f69e8
6.0.0.1227
2025.08.19
2e9f0
6.0.0.1226
2025.08.18
58d28
6.0.0.1224
2025.08.17
b2381
6.0.0.1214
2025.08.16
99bbb
6.0.0.1212
2025.08.15
c96d5
6.0.0.1210
2025.08.14
6ab0c
6.0.0.1204
2025.08.11
d69d1
6.0.0.1203
2025.08.10
ec2be
6.0.0.1194
2025.08.08
c157a
6.0.0.1189
2025.08.07
7863e
6.0.0.1164
2025.08.06
c3e5d
6.0.0.1157
2025.08.05
c8def
6.0.0.1152
2025.08.04
ffb6d
6.0.0.1131
2025.08.03
87afd
6.0.0.1124
2025.08.02
1ccdf
6.0.0.1115
2025.08.01
ab0bd
6.0.0.1113
2025.07.30
8f46c
6.0.0.1103
2025.07.29
9f972
6.0.0.1093
2025.07.28
9a5e0
6.0.0.1092
2025.07.27
daed3
Test TITLE
1
bugs core 1428 
 tracker
 CS 1064 1000 569 575 974 572 590 540 561 586 526 1061 596 1010 596 659 932 629 1077 1072 1016 721 789 582 562 991 735 1001 981 1189 581 989 1055 1014 564
Incorrect timestamp substraction in 3 dialect when result is negative number
2
bugs core 3937 
 tracker
 CS 1073 1193 645 1135 712 625 652 1033 614 994 596 970 607 1111 662 724 644 650 1128 1103 1186 1089 586 631 659 1017 1060 720 1117 618 611 1011 1047 1085 657
eActivate/Activate INDEX or RESTORE not possible with NULL in unique index.
3
bugs core 3942 
 tracker
 CS 968 1220 503 972 553 566 564 979 510 1081 552 936 492 964 603 652 543 595 945 1019 1093 953 906 602 527 968 1165 551 950 782 559 1041 1045 904 634
Restore from gbak backup using service doesn't report an error
4
bugs core 5831 
 tracker
 CS 1092 621 643 1179 1104 601 841 667 629 1218 669 659 683 1098 645 709 644 827 1194 1176 672 599 727 735 1105 1133 1112 1082 777 1141 703 667 624 606 743
Not user friendly output of gstat at encrypted database
5
bugs core 5837 
 tracker
 CS 1236 703 784 1330 1344 687 1380 723 875 1116 709 740 845 719 819 957 783 912 1392 1400 807 742 913 833 1323 758 1458 1355 1418 1386 1549 726 739 725 791
Inconsistent results when working with GLOBAL TEMPORARY TABLE ON COMMIT PRESERVE ROWS
6
bugs core 5840 
 tracker
 CS 1437 754 797 1483 1459 765 789 812 816 853 818 761 812 711 917 1036 792 965 1589 1530 804 776 875 926 1465 817 1535 1528 1455 1538 1665 763 765 785 905
Ignor of reference privilege
7
bugs core 5845 
 tracker
 CS 1220 635 631 1211 1284 720 641 756 661 690 1244 640 644 622 769 890 767 843 1255 1194 749 616 872 752 1266 696 1239 1296 1218 1317 1455 693 673 1189 736
ORDER BY on index can cause suboptimal index choices
8
bugs core 5846 
 tracker
 CS 1048 570 564 1113 1013 602 584 597 586 606 1148 570 645 636 721 731 676 680 1153 1098 1026 544 710 653 1052 627 1084 1163 1172 1128 1188 587 572 1012 758
CREATE VIEW issues "Implementation of text subtype 512 not located"
9
bugs core 5939 
 tracker
 CS 709 425 416 757 789 423 422 418 757 808 698 762 412 379 496 490 816 483 426 664 466 782 528 453 768 381 407 870 577 852 547 862 743 738 481
Crash for "gbak -se -b database nul"
10
bugs core 5953 
 tracker
 CS 1053 600 655 1168 1068 636 642 663 989 1112 1049 1068 565 803 697 739 1197 639 666 1123 692 1043 718 729 1028 602 661 1115 596 1173 643 1039 1172 1039 740
Statement level read consistency in read-committed transactions
11
bugs core 6254 
 tracker
 CS 1020 571 643 1023 1042 668 1061 1192 615 577 639 1033 597 968 668 694 949 609 632 711 614 1014 658 711 968 635 671 1120 572 607 1041 530 948 548 590
AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction
12
bugs gh 6874 
 tracker
 SS 501 560 285 318 581 332 313 540 306 577 316 537 447 520 370 379 280 353 293 342 583 442 539 382 284 298 546 418 536 305 420 483 513 336 399
Literal 65536 (interpreted as int) can not be multiplied by itself w/o cast if result more than 2^63-1
13
bugs gh 6934 
 tracker
 SS 843 868 869 508 552 465 466 460 481 463 432 826 903 901 616 609 489 573 909 773 845 465 854 684 443 447 896 972 920 859 856 623 960 764 597
SQL SECURITY DEFINER does not affect the ownership of created DDL objects
14
bugs gh 6935 
 tracker
 SS 1285 1201 1356 698 787 698 648 652 686 837 681 1233 1305 1285 939 918 646 1008 1203 1232 1213 661 1202 945 621 835 1383 1295 1274 1328 1087 839 1323 1230 965
SQL SECURITY DEFINER has inconsistent behaviour if the object owner is non-privileged
15
bugs gh 7220 
 tracker
 CS 1343 776 1340 745 1446 852 854 914 775 1339 1320 1359 752 1280 618 749 1062 689 1043 582 632 1007 652 708 577 582 1029 1165 1064 593 677 1042 1173 585 709
Dependencies of subroutines are not preserved after backup restore
16
bugs gh 7493 
 tracker
 CS 1264 1258 828 1337 752 794 863 844 761 750 1292 1236 1300 1289 661 684 1059 641 606 707 612 600 701 694 566 1018 1036 989 641 608 757 1057 1024 897 782
Firebird 5.0 snapshot blob not found error after first commit / rollback
17
bugs gh 8265 
 tracker
 SS 780 819 400 435 801 428 532 436 416 511 416 725 408 796 485 510 366 528 738 409 440 415 400 509 456 518 743 409 389 436 612 377 669 567 514
Nested IN/EXISTS subqueries should not be converted into semi-joins if the outer context is a sub-query which wasn't unnested
18
bugs gh 8278 
 tracker
 SS 864 940 489 500 836 498 711 521 468 554 596 875 506 743 534 633 556 616 632 495 568 645 460 677 595 641 785 426 477 477 548 513 660 816 649
Avoid index lookup for a NULL key if the condition is known to always be FALSE in this case
19
bugs gh 8290 
 tracker
 SS 671 772 393 359 706 422 500 485 424 439 514 689 410 671 472 481 360 454 514 375 480 500 351 533 480 441 667 367 683 398 701 350 693 616 550
"Unique scan" is incorrectly reported in the explained plan for unique index and IS NULL predicate
20
functional datatypes int128 math functions 
 SS 630 630 635 394 381 342 627 651 483 616 392 660 385 627 459 413 507 449 349 424 499 420 480 438 523 415 344 629 323 558 516 632 426 573 398
Basic test for math functions against INT128 datatype
21
functional fkey cascade master uk on update cascade 
 SS 706 703 404 737 407 406 762 624 369 600 713 414 387 732 438 479 652 460 663 399 429 676 628 549 678 479 328 355 665 407 383 496 640 620 497
Updating PK column(s) in master must cause changes in appropriate detail column(s) if 'ON UPDATE CASCADE' option is used
22
functional gtcs computed fields 17 
 SS 623 645 359 361 616 365 420 338 344 352 334 582 515 569 423 388 584 375 412 335 512 603 664 407 568 619 327 315 613 381 599 560 460 323 400
Computed fields
23
functional gtcs conversion error from string 
 SS 789 751 435 427 796 448 447 440 388 445 489 666 676 769 548 488 544 476 532 406 784 445 768 527 749 595 454 376 737 455 736 548 580 397 547
Script issues conversion error from string
24
functional gtcs crash of group by varchar 4000 
 SS 614 601 366 327 580 325 353 350 487 402 407 568 594 595 372 440 459 443 408 313 572 355 541 401 512 625 479 303 557 347 564 610 637 287 429
Crash on attempt to GROUP BY on table with varchar(4000) field
25
functional gtcs division by zero corrupts db 
 SS 617 634 400 395 624 363 386 399 378 391 375 594 601 611 434 446 674 434 441 387 492 433 671 436 567 588 538 345 672 371 632 588 716 334 444
Zero divide in SP can crash database when call this SP several times
26
functional gtcs dsql domain 01 
 SS 633 597 351 338 636 363 342 358 364 367 425 370 553 523 457 364 551 464 357 351 621 346 397 414 452 482 513 317 599 378 612 430 491 328 424
Test the level 0 syntax for SQL create domain defining only the datatype
27
functional gtcs dsql domain 07 
 SS 828 822 893 452 539 490 506 470 414 629 429 441 648 853 555 582 635 564 413 425 899 430 850 514 500 976 496 409 630 440 475 598 665 388 589
Test CREATE / ALTER domain statement with ADD/DROP CONSTRAINT clauses, together and separately.
28
functional gtcs gtcs proc isql 10 
 SS 892 534 560 921 891 531 623 541 561 554 511 949 732 905 669 721 537 696 506 519 671 495 818 756 521 531 568 534 959 506 756 527 619 743 731
gtcs-proc-isql-10
29
functional gtcs time zone 
 SS 881 1032 838 515 516 472 571 530 500 515 774 984 808 989 554 752 492 656 446 863 482 435 500 627 459 483 862 816 863 638 465 869 925 837 606
Miscelaneous time zone tests
30
functional gtcs transactions autocommit 3 
 SS 710 757 712 373 410 395 378 397 393 380 751 370 673 668 471 520 378 482 372 567 388 378 396 500 355 415 697 500 684 368 369 643 440 624 486
Changes within AUTO COMMIT must be cancelled when exception raises in some PROCEDURE
31
functional gtcs trigger variable assignment 
 SS 557 638 603 309 314 329 340 400 306 319 534 394 564 580 435 431 329 387 297 594 320 317 323 369 292 409 559 588 496 316 311 567 281 392 377
Variable in the AFTER-trigger must be allowed for assignment OLD value in it
32
functional gtcs window func 02 
 SS 633 793 664 371 394 410 385 428 368 391 447 780 715 669 468 573 363 482 375 576 385 357 391 487 372 375 591 655 649 438 403 584 377 639 554
Set of miscelaneous tests for verification of windowed functions
33
functional sqlite 6c1d3febc0 
 SS 586 527 587 331 346 343 357 358 322 339 597 526 348 599 378 462 497 X X X X X X X X X X X X X X X X X X
PRIMARY KEY for REAL column datatype leads to a missing entry in the index.
34
functional sqlite fc7bd6358f 
 SS 589 364 612 619 381 333 374 359 355 354 329 456 560 547 X X X X X X X X X X X X X X X X X X X X X
Incorrect query result in a 3-way join due to affinity issues
35
functional syspriv access any object 
 SS 1194 604 1182 1108 649 642 647 652 630 638 608 699 956 1028 737 795 915 808 824 1188 908 560 1075 838 907 900 1050 586 606 1024 632 1210 829 1039 721
Check ability to query, modify and deleting data plus add/drop constraints on any table
36
functional syspriv access shutdown database 
 SS 2022 1031 2022 1948 1104 1039 1106 1228 998 1074 1121 1063 1424 1880 1250 1260 1331 1259 1815 1851 1734 1314 1899 1467 1756 1728 1939 1181 1007 1720 1166 1767 2032 1576 1411
Check ability to access to database in shutdown single mode as non-sysdba
37
functional syspriv read raw pages 
 SS 2012 2001 1226 1088 1959 1086 1509 1374 1051 1077 1447 1167 1125 2080 1421 1488 1983 1410 1245 1145 2054 1984 1729 1570 1777 1068 1152 1048 1150 1066 1866 1812 1929 1952 1545
Check ability to get binary content of DB page by non-sysdba user who is granted with necessary system privilege

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1428
http://tracker.firebirdsql.org/browse/CORE-3937
http://tracker.firebirdsql.org/browse/CORE-3942
http://tracker.firebirdsql.org/browse/CORE-5831
http://tracker.firebirdsql.org/browse/CORE-5837
http://tracker.firebirdsql.org/browse/CORE-5840
http://tracker.firebirdsql.org/browse/CORE-5845
http://tracker.firebirdsql.org/browse/CORE-5846
http://tracker.firebirdsql.org/browse/CORE-5939
http://tracker.firebirdsql.org/browse/CORE-5953
http://tracker.firebirdsql.org/browse/CORE-6254
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/datatypes/test_int128_math_functions.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/fkey/cascade/test_master_uk_on_update_cascade.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_computed_fields_17.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_conversion_error_from_string.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_crash_of_group_by_varchar_4000.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_division_by_zero_corrupts_db.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_dsql_domain_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_dsql_domain_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_gtcs_proc_isql_10.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_time_zone.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_transactions_autocommit_3.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_trigger_variable_assignment.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_window_func_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_6c1d3febc0.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/sqlite/test_fc7bd6358f.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/syspriv/test_access_any_object.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/syspriv/test_access_shutdown_database.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/syspriv/test_read_raw_pages.py
https://github.com/FirebirdSQL/firebird/issues/6874
https://github.com/FirebirdSQL/firebird/issues/6934
https://github.com/FirebirdSQL/firebird/issues/6935
https://github.com/FirebirdSQL/firebird/issues/7220
https://github.com/FirebirdSQL/firebird/issues/7493
https://github.com/FirebirdSQL/firebird/issues/8265
https://github.com/FirebirdSQL/firebird/issues/8278
https://github.com/FirebirdSQL/firebird/issues/8290
=== end of list ===

Last commits information (all timestamps in UTC):