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

Generated 12.05.2024 19:14
Tested: HQ30.   Build: 3.0.12.33744;   SS: 12.05.24 17:42:19 - 12.05.24 18:16:50;   CS: 12.05.24 18:17:31 - 12.05.24 19:11:55;
OS and hardware info:  Linux 6.5.0-5-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.5.13-1 (2023-11-29) ; logical CPUs: 2 ; total memory: 7.6 Gb 
QA-software: Python 3.11.7, virtual env; pytest: 7.4.4; firebird.driver: 1.10.4; Firebird.Qa: 0.19.3

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 3.0.12.33744
2024-05-12
3.0.12.33740
2024-04-20
3.0.12.33726
2024-04-04
3.0.12.33725
2023-12-29
3.0.12.33722
2023-11-28
3.0.12.33712
2023-11-07
3.0.12.33706
2023-09-20
3.0.11.33689
2023-08-09
3.0.11.33687
2023-06-22
3.0.11.33685
2023-06-04
3.0.11.33683
2023-05-02
3.0.11.33666
2023-04-17
3.0.11.33664
2023-03-14
3.0.11.33657
2023-02-08
3.0.11.33648
2023-01-18
X X X X X X X X X X X X X X X
Test TITLE
1 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Tricky role defeats basic SQL security
2 CS P P P P P P P P P P F P P F F X X X X X X X X X X X X X X X
Compress Data over the Network
3 SS P P P P P P P P P P F P P F F X X X X X X X X X X X X X X X
Compress Data over the Network
4 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
It is impossible to take away rights on update of a column
5 CS P F F F F F F F F F F F F F F X X X X X X X X X X X X X X X
Can't create table using long username and UTF8 as attachment charset
6 SS F F F F F F F F F F F F F F F X X X X X X X X X X X X X X X
Can't create table using long username and UTF8 as attachment charset
7 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
8 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Trace output could contain garbage data left from filtered out statements
9 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Add attachment's CHARACTER SET name into corresponding trace records
10 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
exclude_filter doesn't work for <services></section> section of the Trace facility
11 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Improve diagnostics of internal trace errors
12 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
13 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
TRACE: add statistics of actions that were after transaction finished
14 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Wrong parameters order in trace output
15 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
fbsvcmgr doesn't recognise sts_record_versions and other sts switches
16 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Keyword SET should not be required in ALTER USER statement
17 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
18 SS P P P P P P P P P P P F P P P X X X X X X X X X X X X X X X
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
19 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
non-priviledged user can insert and update rdb$database
20 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Allow output to trace explain plan form.
21 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
FB3: CREATE USER GRANT ADMIN ROLE does not work
22 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Make user names behave according to SQL identifiers rules
23 SS F F F P F F P P P F F F F F F X X X X X X X X X X X X X X X
Better performance of creating packages containing many functions
24 CS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
ISQL does not show encryption status of database
25 SS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
ISQL does not show encryption status of database
26 CS P P P P P P P P P P P P P F P X X X X X X X X X X X X X X X
Return nonzero result code when restore fails on activating and creating deferred user index
27 SS P P P P P P P P P P P P P F P X X X X X X X X X X X X X X X
Return nonzero result code when restore fails on activating and creating deferred user index
28 SS S S S S S S S S S S S S F F P X X X X X X X X X X X X X X X
Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
29 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Badly selective index could be used for extra filtering even if selective index is used for sorting
30 CS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
31 SS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
32 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Bad performance for NULLs filtering inside a navigational index scan
33 CS F F P P P P P P P P P P P X X X X X X X X X X X X X X X X X
Slow changes on domain
34 SS F F P P P P P P P P P P P X X X X X X X X X X X X X X X X X
Slow changes on domain
35 CS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Unique constraint not working in encrypted database on first command
36 SS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Unique constraint not working in encrypted database on first command
37 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
ALTER TRIGGER check privilege for alter database instead of table
38 CS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Error returned from DbCryptPlugin::setKey() is not shown
39 SS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Error returned from DbCryptPlugin::setKey() is not shown
40 CS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
gstat may produce faulty report about presence of some none-encrypted pages in database
41 SS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
gstat may produce faulty report about presence of some none-encrypted pages in database
42 CS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Not user friendly output of gstat at encrypted database
43 SS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Not user friendly output of gstat at encrypted database
44 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Regression: ROLE does not passed in ES/EDS (specifying it in the statement is ignored)
45 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Creator user name is empty in user trace sessions
46 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
Srp user manager sporadically creates users which can not attach Explanation of bug nature was provided by Alex, see letter 05-jun-19 13:51. Some iteration failed with probability equal to occurence of 0 (zero) in the highest BYTE of some number. Byte is 8 bit ==> this probability is 1/256. Given 'N_LIMIT' is number of iterations, probability of success for ALL of them is 7.5%, and when N_LIMIT is 1000 then p = 0.004%. Because of time (speed) it was decided to run only 256 iterations. If bug will be 'raised' somewhere then this number is enough to catch it after 2-3 times of test run. Reproduced on WI-V3.0.5.33118, date: 11-apr-19 (got fails not late than on 250th iteration). Works fine on WI-V3.0.5.33139, date: 04-apr-19.
47 CS F F F F F F F F F F F F F F F X X X X X X X X X X X X X X X
Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
48 SS F F F F F F F F F F F F F F F X X X X X X X X X X X X X X X
Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
49 CS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Generator pages are not encrypted
50 SS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Generator pages are not encrypted
51 CS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Wire compression causes freezes
52 SS P P P P P P P P P P P P P F F X X X X X X X X X X X X X X X
Wire compression causes freezes
53 CS 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 X
Wrong or missing IS NULL optimization (regression) [CORE3449]
54 SS 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 X
Wrong or missing IS NULL optimization (regression) [CORE3449]
55 CS P 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
56 SS P 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
57 CS 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 X
Firebird performance issue - non necessary index reads
58 SS 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 X
Firebird performance issue - non necessary index reads
59 CS 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 X
Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
60 SS 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 X
Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
61 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
Precision of standalone unit may differ from packaged one in SQL dialect 1
62 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
Precision of standalone unit may differ from packaged one in SQL dialect 1
63 CS 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 X
Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
64 SS 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 X
Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
65 CS 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 X
Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT()
66 SS 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 X
Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT()
67 CS 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 X
Server crash on some LockMemSize values
68 SS 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 X
Server crash on some LockMemSize values
69 CS X X X X X X X X X X F X X X X X X X X X X X X X X X X X X X
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
70 SS X X X X X X X X X X F X X X X X X X X X X X X X X X X X X X
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
71 CS 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 X X X X X
DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
72 SS 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 X X X X X
DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
73 CS 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 X X X X X
Wrong result ordering in LEFT JOIN query
74 SS 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 X X X X X
Wrong result ordering in LEFT JOIN query
75 CS X X X X X X X F X X X X X X X X X X X X X X X X X X X X X X
Cursor name can duplicate parameter and variable names in procedures and functions
76 SS X X X X X X X F X X X X X X X X X X X X X X X X X X X X X X
Cursor name can duplicate parameter and variable names in procedures and functions
77 CS P P P P P P F X X X X X X X X X X X X X X X X X X X X X X X
Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field.
78 SS P P P P P P F X X X X X X X X X X X X X X X X X X X X X X X
Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field.
79 CS P P P P P P F X X X X X X X X X X X X X X X X X X X X X X X
garbage collection in indexes and blobs is not performed in VIO_backout
80 SS P P P P P P F X X X X X X X X X X X X X X X X X X X X X X X
garbage collection in indexes and blobs is not performed in VIO_backout
81 CS P P P P 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
Potential bug in BETWEEN Operator
82 SS P P P P 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
Potential bug in BETWEEN Operator
83 CS P P P P 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
Removing first column with SET WIDTH crashes ISQL
84 SS P P P P 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
Removing first column with SET WIDTH crashes ISQL
85 CS P P P P 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
Crash potentially caused by BETWEEN Operator
86 CS P P F P P P P P P P P P P P P X X X X X X X X X X X X X X X
INNER JOIN join order
87 SS P P F P P P P P P P P P P P P X X X X X X X X X X X X X X X
INNER JOIN join order
88 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
MIN() and DESC index (non-unique)
89 CS F P P P P P P P P P P P P P P X X X X X X X X X X X X X X X
gtcs-proc-isql-16
90 SS P P P P P P P F P P P P P P P X X X X X X X X X X X X X X X
All DB objects types must allow name COMMENT. Also, COMMENT ON ... must allow occurence of "comment" in it.
91 CS 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 X X X X X
crash on assert or memory corruption when too long username is used for authentication
92 CS S S S S S S S S S S S S S F F X X X X X X X X X X X X X X X
Verify ability to make REMOTE connect to security.db
93 SS S S S S S S S S S S S S S F F X X X X X X X X X X X X X X X
Verify ability to make REMOTE connect to security.db

Elapsed time, milliseconds:

NN Test name mode median_ms 3.0.12.33744
2024-05-12
3.0.12.33740
2024-04-20
3.0.12.33726
2024-04-04
3.0.12.33725
2023-12-29
3.0.12.33722
2023-11-28
3.0.12.33712
2023-11-07
3.0.12.33706
2023-09-20
3.0.11.33689
2023-08-09
3.0.11.33687
2023-06-22
3.0.11.33685
2023-06-04
3.0.11.33683
2023-05-02
3.0.11.33666
2023-04-17
3.0.11.33664
2023-03-14
3.0.11.33657
2023-02-08
3.0.11.33648
2023-01-18
X X X X X X X X X X X X X X X
Test TITLE
1 CS 2329 3234 2958 2329 2820 2350 2201 2409 2227 2246 2108 2259 2375 2109 2464 1979 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Tricky role defeats basic SQL security
2 CS 44007 48376 34893 37460 45798 40510 39825 48996 48222 48594 39929 44320 47343 44007 2150 1936 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Compress Data over the Network
3 SS 42945 45485 32201 36082 44686 39476 38616 46651 46572 45110 39318 43665 45925 42945 1831 1546 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Compress Data over the Network
4 CS 2990 3952 3645 2994 3585 2972 2914 3010 2991 2876 2643 2946 2990 2678 3115 2451 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
It is impossible to take away rights on update of a column
5 CS 850 1167 992 828 1126 861 878 850 844 808 738 822 875 727 999 839 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Can't create table using long username and UTF8 as attachment charset
6 SS 432 464 432 395 470 398 436 453 408 406 377 360 441 437 536 405 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Can't create table using long username and UTF8 as attachment charset
7 CS 3441 4313 4105 3494 4042 3441 3462 3667 3317 3461 3055 3302 3364 3069 3420 2847 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
8 CS 2955 3131 3077 2959 3113 2947 2912 2976 2955 2956 2890 2911 2922 2919 3109 2750 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Trace output could contain garbage data left from filtered out statements
9 CS 2959 3413 3097 2956 3292 2959 2968 2925 2967 2949 2903 2880 2936 2950 3099 3032 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Add attachment's CHARACTER SET name into corresponding trace records
10 CS 2951 3136 3121 2983 3150 3037 2951 2976 2952 2730 2647 2687 2923 2613 2874 2757 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
exclude_filter doesn't work for <services></section> section of the Trace facility
11 CS 2955 3098 3093 2960 3046 2915 2935 2973 2955 2905 2637 2895 2917 2905 3120 3049 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Improve diagnostics of internal trace errors
12 CS 5149 5636 5444 5222 6065 5325 5325 5149 5121 5293 4837 4840 4908 4844 5025 4502 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
13 CS 3170 3429 3375 3208 3256 3168 3196 3157 3187 3163 3118 3149 3170 3133 3280 2968 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TRACE: add statistics of actions that were after transaction finished
14 CS 3169 3393 3299 3175 3264 3165 3198 3169 3138 3198 3078 3123 3115 3153 3301 2952 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong parameters order in trace output
15 CS 894 1260 1107 894 1017 926 931 904 862 875 750 799 820 743 1025 848 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
fbsvcmgr doesn't recognise sts_record_versions and other sts switches
16 CS 1655 1893 1754 1655 1984 1619 1718 1718 1712 1534 1478 1565 1592 1461 1831 1538 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Keyword SET should not be required in ALTER USER statement
17 CS 13529 14588 13386 13361 16151 14023 13997 13529 13436 13760 13593 13476 13736 13283 13403 12060 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
18 SS 12209 12515 11905 12085 14190 12724 12710 12209 12372 12423 12309 12125 5845 11986 12029 10979 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
gfix -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
19 CS 1381 1750 1710 1381 1711 1362 1410 1443 1382 1373 1244 1345 1338 1215 1544 1264 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
non-priviledged user can insert and update rdb$database
20 CS 3187 3419 3290 3196 3334 3187 3193 3215 3164 3175 3068 3108 3116 3061 3240 2929 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Allow output to trace explain plan form.
21 CS 1985 2814 2215 1914 2412 1914 1963 2032 1985 2111 1671 1925 2097 1840 2301 1854 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FB3: CREATE USER GRANT ADMIN ROLE does not work
22 CS 3111 4101 4078 3376 3848 3012 3158 3263 3111 3070 2699 2944 3013 2773 3189 2491 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Make user names behave according to SQL identifiers rules
23 SS 178724 155713 141009 155680 199542 176102 181437 193014 192599 187706 166446 178724 185588 179258 175770 114084 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Better performance of creating packages containing many functions
24 CS 943 1144 1121 943 1107 955 916 967 948 967 835 892 914 814 650 530 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ISQL does not show encryption status of database
25 SS 421 449 433 326 461 421 431 402 425 427 372 405 446 350 300 237 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ISQL does not show encryption status of database
26 CS 1132 1493 1424 1114 1241 1231 1103 1196 1132 1128 1006 1025 1161 1038 1240 1011 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Return nonzero result code when restore fails on activating and creating deferred user index
27 SS 733 1052 883 808 827 699 741 659 755 709 707 642 733 714 787 658 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Return nonzero result code when restore fails on activating and creating deferred user index
28 SS 400 434 428 358 2 400 5 389 4 1 392 415 411 16531 16743 16719 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
29 CS 4440 4547 4382 4591 4810 4418 4382 4668 4681 4754 4440 4294 4331 4313 4446 4121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Badly selective index could be used for extra filtering even if selective index is used for sorting
30 CS 1315 3 5 1 5 2 0 2947 2995 4 2626 4 2925 2635 2865 2771 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
31 SS 2414 4 4 2406 5 2477 1 2450 0 2448 2437 3 3 2422 2527 2508 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
32 CS 4472 4633 4376 4356 4691 4630 4472 4597 4622 4717 4301 4213 4294 4376 4541 3780 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Bad performance for NULLs filtering inside a navigational index scan
33 CS 11418 20231 18523 10874 12354 11079 10842 13294 12403 13403 10797 10076 11418 10927 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Slow changes on domain
34 SS 9807 16905 16190 9418 11730 9700 9534 11309 11221 12011 9807 9138 9426 9778 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Slow changes on domain
35 CS 1164 1345 1387 1170 1284 1204 1164 1202 1144 1141 1059 1127 1169 1026 832 681 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unique constraint not working in encrypted database on first command
36 SS 567 553 567 508 654 577 591 595 554 610 501 611 577 508 441 358 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unique constraint not working in encrypted database on first command
37 CS 859 859 1032 859 929 843 864 963 799 863 747 828 816 704 1024 828 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ALTER TRIGGER check privilege for alter database instead of table
38 CS 465 574 672 531 523 465 460 479 440 451 388 433 419 407 608 533 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Error returned from DbCryptPlugin::setKey() is not shown
39 SS 202 243 228 165 256 199 187 202 160 198 160 202 218 169 364 250 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Error returned from DbCryptPlugin::setKey() is not shown
40 CS 9463 9878 8494 8408 10825 8235 8933 11111 11075 11446 9463 8619 10727 9575 8887 6298 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
gstat may produce faulty report about presence of some none-encrypted pages in database
41 SS 9003 9134 7546 8953 10279 9450 8847 9579 11588 10756 8557 8618 9003 9460 7770 6035 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
gstat may produce faulty report about presence of some none-encrypted pages in database
42 CS 653 868 781 669 680 708 675 693 653 644 575 621 636 584 631 495 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not user friendly output of gstat at encrypted database
43 SS 298 318 313 269 355 298 285 286 312 289 271 301 320 270 335 265 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not user friendly output of gstat at encrypted database
44 CS 2349 3016 2795 2433 2909 2386 2312 2349 2484 2295 2040 2212 2267 2131 2512 1942 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Regression: ROLE does not passed in ES/EDS (specifying it in the statement is ignored)
45 CS 2728 2872 2803 2696 3052 2930 2762 2669 2963 2642 2647 2663 2671 2651 2912 2728 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Creator user name is empty in user trace sessions
46 CS 169699 830 214958 174617 200810 171768 170264 178116 174672 169699 152160 164337 169250 156625 168600 130997 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Srp user manager sporadically creates users which can not attach Explanation of bug nature was provided by Alex, see letter 05-jun-19 13:51. Some iteration failed with probability equal to occurence of 0 (zero) in the highest BYTE of some number. Byte is 8 bit ==> this probability is 1/256. Given 'N_LIMIT' is number of iterations, probability of success for ALL of them is 7.5%, and when N_LIMIT is 1000 then p = 0.004%. Because of time (speed) it was decided to run only 256 iterations. If bug will be 'raised' somewhere then this number is enough to catch it after 2-3 times of test run. Reproduced on WI-V3.0.5.33118, date: 11-apr-19 (got fails not late than on 250th iteration). Works fine on WI-V3.0.5.33139, date: 04-apr-19.
47 CS 500 691 653 483 542 474 508 500 500 461 443 435 455 483 656 529 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
48 SS 222 259 222 203 292 199 236 213 222 255 175 227 219 217 299 271 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
49 CS 853 1094 988 847 937 909 906 865 844 853 765 780 878 752 816 727 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Generator pages are not encrypted
50 SS 419 443 419 389 469 439 390 427 456 414 368 378 446 403 442 348 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Generator pages are not encrypted
51 CS 71818 47423 46709 53185 72168 72053 80661 75000 74036 71818 63936 77673 77623 64789 908 773 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wire compression causes freezes
52 SS 72742 45070 49055 54833 77401 73094 78179 77025 77277 72742 63416 75657 75401 65691 520 486 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wire compression causes freezes
53 CS 653 925 698 636 725 604 599 758 663 634 607 643 694 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong or missing IS NULL optimization (regression) [CORE3449]
54 SS 388 349 376 322 389 400 382 440 476 388 360 388 423 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong or missing IS NULL optimization (regression) [CORE3449]
55 CS 568 692 733 553 652 504 590 570 581 528 482 546 567 523 681 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
56 SS 277 296 280 241 376 277 300 243 256 331 213 241 277 253 404 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
57 CS 733 834 813 745 795 725 769 737 710 673 656 652 730 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Firebird performance issue - non necessary index reads
58 SS 448 453 421 455 506 444 495 443 427 490 392 443 483 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Firebird performance issue - non necessary index reads
59 CS 674 1060 913 741 818 617 637 677 725 660 607 671 663 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
60 SS 491 597 558 428 437 502 464 493 500 560 437 416 490 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Problem with restore when backup has procedure which contains explicit PLAN clause with inappropriate indices.
61 CS 820 942 906 774 953 841 822 820 836 756 702 771 764 750 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Precision of standalone unit may differ from packaged one in SQL dialect 1
62 SS 348 353 354 318 410 338 413 348 302 345 347 357 387 328 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Precision of standalone unit may differ from packaged one in SQL dialect 1
63 CS 551 737 721 559 623 544 572 492 544 561 532 527 536 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
64 SS 315 336 314 241 281 318 354 267 316 283 230 324 318 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
65 CS 575 756 652 551 671 605 597 607 554 537 484 482 495 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT()
66 SS 295 293 297 220 339 304 307 297 278 224 216 221 314 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT()
67 CS 326 478 388 375 339 272 287 341 314 306 288 306 405 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Server crash on some LockMemSize values
68 SS 226 363 257 175 228 214 204 248 248 221 181 224 371 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Server crash on some LockMemSize values
69 CS 8765 0 0 0 0 0 0 0 0 0 0 8765 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
70 SS 5412 0 0 0 0 0 0 0 0 0 0 5412 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
SET BIND OF TIMESTAMP WITH TIME ZONE TO CHAR is not working with UTF8 connection charset
71 CS 653 879 753 590 664 695 642 638 591 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
72 SS 340 345 321 276 359 354 402 326 336 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
73 CS 600 648 715 571 665 593 598 603 540 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong result ordering in LEFT JOIN query
74 SS 328 295 331 273 325 364 373 334 304 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wrong result ordering in LEFT JOIN query
75 CS 583 0 0 0 0 0 0 0 583 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Cursor name can duplicate parameter and variable names in procedures and functions
76 SS 338 0 0 0 0 0 0 0 338 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Cursor name can duplicate parameter and variable names in procedures and functions
77 CS 599 649 712 590 758 597 553 599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field.
78 SS 348 366 344 270 376 378 331 348 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Stability of implicit cursor could be broken, if cursor's select expression is based on view with sub-query in select list, or on table with sub-query in computed field.
79 CS 1046 1208 1267 1041 1176 1046 997 1013 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
garbage collection in indexes and blobs is not performed in VIO_backout
80 SS 489 516 535 424 489 470 523 402 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
garbage collection in indexes and blobs is not performed in VIO_backout
81 CS 669 669 679 592 676 553 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
Potential bug in BETWEEN Operator
82 SS 266 266 255 243 320 332 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
Potential bug in BETWEEN Operator
83 CS 644 730 667 591 644 548 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
Removing first column with SET WIDTH crashes ISQL
84 SS 292 286 292 259 340 1277 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
Removing first column with SET WIDTH crashes ISQL
85 CS 673 727 673 581 668 826 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
Crash potentially caused by BETWEEN Operator
86 CS 1024 1136 1132 1024 1124 964 1093 1066 1037 1021 885 951 962 876 1121 916 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
INNER JOIN join order
87 SS 618 583 581 535 680 596 593 687 716 674 539 618 667 654 722 589 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
INNER JOIN join order
88 CS 781 870 906 807 927 786 852 739 766 767 643 689 781 690 878 765 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MIN() and DESC index (non-unique)
89 CS 1338 1717 1620 1339 1545 1342 1419 1335 1352 1338 1161 1217 1181 1143 1164 992 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
gtcs-proc-isql-16
90 SS 454 464 448 350 454 481 437 447 1439 460 378 483 499 390 570 446 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
All DB objects types must allow name COMMENT. Also, COMMENT ON ... must allow occurence of "comment" in it.
91 CS 400 602 435 378 387 388 405 413 396 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
crash on assert or memory corruption when too long username is used for authentication
92 CS 306 1871 2 1542 7 1573 0 -1 8 1598 0 8 2 1 751 605 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Verify ability to make REMOTE connect to security.db
93 SS 325 3 6 -1 1048 4 1000 1048 926 0 2 9 888 894 325 278 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Verify ability to make REMOTE connect to security.db

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-1292
http://tracker.firebirdsql.org/browse/core-2233
http://tracker.firebirdsql.org/browse/core-2940
http://tracker.firebirdsql.org/browse/core-3008
http://tracker.firebirdsql.org/browse/core-3168
http://tracker.firebirdsql.org/browse/core-3413
http://tracker.firebirdsql.org/browse/core-3537
http://tracker.firebirdsql.org/browse/core-3598
http://tracker.firebirdsql.org/browse/core-4094
http://tracker.firebirdsql.org/browse/core-4298
http://tracker.firebirdsql.org/browse/core-4326
http://tracker.firebirdsql.org/browse/core-4337
http://tracker.firebirdsql.org/browse/core-4359
http://tracker.firebirdsql.org/browse/core-4451
http://tracker.firebirdsql.org/browse/core-4468
http://tracker.firebirdsql.org/browse/core-4811
http://tracker.firebirdsql.org/browse/core-4880
http://tracker.firebirdsql.org/browse/core-5077
http://tracker.firebirdsql.org/browse/core-5201
http://tracker.firebirdsql.org/browse/core-5275
http://tracker.firebirdsql.org/browse/core-5435
http://tracker.firebirdsql.org/browse/core-5470
http://tracker.firebirdsql.org/browse/core-5489
http://tracker.firebirdsql.org/browse/core-5602
http://tracker.firebirdsql.org/browse/core-5673
http://tracker.firebirdsql.org/browse/core-5754
http://tracker.firebirdsql.org/browse/core-5793
http://tracker.firebirdsql.org/browse/core-5796
http://tracker.firebirdsql.org/browse/core-5831
http://tracker.firebirdsql.org/browse/core-5985
http://tracker.firebirdsql.org/browse/core-5995
http://tracker.firebirdsql.org/browse/core-6038
http://tracker.firebirdsql.org/browse/core-606
http://tracker.firebirdsql.org/browse/core-6108
http://tracker.firebirdsql.org/browse/core-6163
http://tracker.firebirdsql.org/browse/core-6348
http://tracker.firebirdsql.org/browse/core-733
http://tracker.firebirdsql.org/browse/core-885
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_inner_join_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/optimizer/test_opt_sort_by_index_08.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_gtcs_proc_isql_16.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_comment_in_object_names.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_crash_when_too_long_username_for_auth.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_remote_access_to_security_db.py
https://github.com/FirebirdSQL/firebird/issues/3810
https://github.com/FirebirdSQL/firebird/issues/7446
https://github.com/FirebirdSQL/firebird/issues/7494
https://github.com/FirebirdSQL/firebird/issues/7499
https://github.com/FirebirdSQL/firebird/issues/7501
https://github.com/FirebirdSQL/firebird/issues/7517
https://github.com/FirebirdSQL/firebird/issues/7537
https://github.com/FirebirdSQL/firebird/issues/7545
https://github.com/FirebirdSQL/firebird/issues/7548
https://github.com/FirebirdSQL/firebird/issues/7664
https://github.com/FirebirdSQL/firebird/issues/7665
https://github.com/FirebirdSQL/firebird/issues/7670
https://github.com/FirebirdSQL/firebird/issues/7713
https://github.com/FirebirdSQL/firebird/issues/7747
https://github.com/FirebirdSQL/firebird/issues/7839
https://github.com/FirebirdSQL/firebird/issues/7844
https://github.com/FirebirdSQL/firebird/issues/7860

=== end of list ===