0. Total results for each kind of outcome and server mode
1. ERRORS MAP: distribution of Firebird errors which occured during runs (0 rows)
2. FRESH FAILS: tests which failed for LAST execution only (0 rows)
3. FRESH ERRORS: tests which raised run-time error for LAST execution only (0 rows)
4. STILL FAILS: tests which fail for at least two last runs (0 rows)
5. Has fails: tests with at least one fail for previous runs (50 rows)
6. Has runtime errors: tests with at least one runtime error for previous runs (789 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (0 rows)
[CURRENT] 8. All tests: outcomes (3025 rows)
9. All tests: durations (4476 rows)
A. Skipped: tests which was intentionally excluded from execution (3 rows)

Generated 21.01.2022 09:43
Tested: FB40.   Build: 4.0.1.2707;   SS: 21.01.22 06:32:00 - 21.01.22 08:03:12;   CS: 21.01.22 08:06:17 - 21.01.22 09:39:20;
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 
Loading data. Please wait...

Outcomes for the whole set of tests in the last 30 runs:
NN Test name mode 4.0.1.2707
2022-01-21
4.0.1.2704
2022-01-07
4.0.1.2701
2022-01-04
4.0.1.2700
2022-01-02
4.0.1.2699
2022-01-01
4.0.1.2697
2021-12-29
4.0.1.2696
2021-12-23
4.0.1.2694
2021-12-22
4.0.1.2693
2021-12-21
4.0.1.2692
2021-12-20
4.0.1.2691
2021-12-17
4.0.1.2690
2021-12-16
4.0.1.2689
2021-12-15
4.0.1.2687
2021-12-14
4.0.1.2685
2021-12-13
4.0.1.2682
2021-12-12
4.0.1.2680
2021-12-10
4.0.1.2676
2021-12-07
4.0.1.2675
2021-12-04
4.0.1.2672
2021-12-01
4.0.1.2669
2021-11-26
4.0.1.2668
2021-11-22
4.0.1.2667
2021-11-17
4.0.1.2666
2021-11-16
4.0.1.2660
2021-11-15
4.0.1.2658
2021-11-11
4.0.1.2656
2021-11-10
4.0.1.2654
2021-11-09
4.0.1.2653
2021-11-06
4.0.1.2650
2021-11-03
Test TITLE
1 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
FBserver shutsdown when a user password is attempted to be modified to a empty string
2 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect value returned with execute statement calculation
3 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Navigation vs IS NULL vs compound index
4 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Navigation vs IS NULL vs compound index
5 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Trigger do it wrong
6 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Navigation vs IS NULL vs compound index
7 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Navigation vs IS NULL vs compound index
8 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
cannot create procedure with long chain of else-if clauses
9 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
cannot create procedure with long chain of else-if clauses
10 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
FIRST 1 vs ORDER DESC vs explicit plan (ODS11)
11 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
FIRST 1 vs ORDER DESC vs explicit plan (ODS11)
12 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
WHERE CURRENT OF doesn't work
13 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
WHERE CURRENT OF doesn't work
14 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Automatic not null in PK columns incomplete
15 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sequence of commands crash FB server
16 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression index regression since 2.0a3
17 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Expression index regression since 2.0a3
18 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Invalid ROW_COUNT variable value after DELETE
19 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Invalid ROW_COUNT variable value after DELETE
20 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Query with not in (select) returns wrong result
21 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Query with not in (select) returns wrong result
22 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Index bug
23 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Index bug
24 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Join on diffrent datatypes
25 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Using where params in SUM return incorrect results
26 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Recreate and self-referencing indexes
27 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Recreate and self-referencing indexes
28 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Strange/Inconsistent query results
29 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Strange/Inconsistent query results
30 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
JOIN the same table - problem with alias names
31 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Dropping and recreating a table in the same txn disables PK
32 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
bug with ALL keyword
33 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE TABLE - no blob for external
34 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression evaluation not supported on LEFT JOIN
35 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
numeric div in dialect 3 mangles data
36 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
numeric div in dialect 3 mangles data
37 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
index breaks = ANY result
38 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
index breaks = ANY result
39 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Using where params in SUM return incorrect results
40 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SELECT '1' UNION SELECT '12'
41 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
SELECT '1' UNION SELECT '12'
42 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Left joining views with null fails
43 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sqlsubtype incorrect on timestamp math, constant arithmetic
44 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Query using VIEW with UNION causes crash
45 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
cannot specify PLAN in UPDATE statement
46 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
cannot specify PLAN in UPDATE statement
47 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DB crashes if trigger BU deletes own row
48 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
trigger on view with union receive nulls
49 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
trigger on view with union receive nulls
50 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
trigger with except-s on view with union
51 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
trigger with except-s on view with union
52 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 291
53 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Bugcheck 291
54 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SYSDBA can grant non existent roles
55 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
wrong order by in table join storedproc
56 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Empty column names with aggregate funcs
57 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ORDER BY works wrong with collate PT_PT
58 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW ignores PLAN
59 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
CREATE VIEW ignores PLAN
60 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CHECK constraints fire twice
61 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CS server crash altering SP in 2 connect
62 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
CS server crash altering SP in 2 connect
63 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SELECT...HAVING...NOT IN crashes server
64 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Count ( DISTINCT ... ) is too slow
65 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Too many grants lose privileges
66 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Too many grants lose privileges
67 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER TABLE altering to VARCHAR
68 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DOMAINs don't register their dependency on other objects
69 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
DOMAINs don't register their dependency on other objects
70 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Blob Comparison with constant
71 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Blob Comparison with constant
72 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
bug #585624 IB server stalled by simple script
73 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ANY user can drop procedures, generators, exceptions.
74 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unsuccessful execution caused by system error <...> bad BLR -- invalid stream
75 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Unsuccessful execution caused by system error <...> bad BLR -- invalid stream
76 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DateTime math imprecision
77 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
bug #910430 ISQL and database dialect
78 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Complex view crashes server
79 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Complex view crashes server
80 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
NULLS FIRST does not work with unions
81 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
NULLS FIRST does not work with unions
82 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Garbage vs indices/constraints
83 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong sort order when using es_ES collate
84 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong sort order when using es_ES collate
85 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
JOIN including a complex view kills the server
86 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
JOIN including a complex view kills the server
87 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Redundant evaluations in COALESCE
88 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Redundant evaluations in COALESCE
89 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ORDER BY has no effect
90 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grants overwrite previous rdb$security_classes entries
91 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Grants overwrite previous rdb$security_classes entries
92 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Foreign key relation VARCHAR <-> INT
93 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Foreign key relation VARCHAR <-> INT
94 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Lot of syntax tests for COALESCE()
95 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ambiguous statements return unpredictable results
96 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Permissions are checked case-insensitively
97 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Inconsistent results using STARTING WITH and COALESCE
98 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
before triggers are firing after checks
99 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
before triggers are firing after checks
100 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Tricky role defeats basic SQL security
101 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Tricky role defeats basic SQL security
102 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
FIRST is applied before aggregation
103 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
FIRST is applied before aggregation
104 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SKIP is off by one
105 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ORDER BY on a VIEW turns values in fields into NULL
106 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ORDER BY on a VIEW turns values in fields into NULL
107 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Token unknown in simple SELECT with GROUP BY and ORDER BY
108 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grouping on derived fields processing NULL data kills IB
109 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Blob Type 1 compatibility with VarChar
110 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
User Account maintanance in SQL
111 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
User Account maintanance in SQL
112 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Compress Data over the Network
113 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wildcards/Regular Expressions in WHERE clause - SIMILAR TO predicate
114 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Alter view
115 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Alter view
116 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Easy metadata extract improvements
117 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Easy metadata extract improvements
118 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Privileges of dynamic statements in SP
119 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Privileges of dynamic statements in SP
120 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
accent ignoring collation for unicode
121 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Specific query crashing server
122 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Specific query crashing server
123 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
computed field can't be changed to non-computed using 'alter table alter column type xy'
124 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DYN allows to set defaults for computed fields when altering a field
125 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
DYN allows to set defaults for computed fields when altering a field
126 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Field can be used multiple times in multi-segment index definition
127 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
substring(current_user from 4) fails
128 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Aggregates in the WHERE clause vs derived tables
129 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unable to set FName, MName, LName fields in security to blank
130 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Containing not working correctly
131 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Containing not working correctly
132 ALL S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S
Server crash when using UDF
133 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Removing a NOT NULL constraint is not visible until reconnect
134 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Engine crashes while trying to backup a logically corrupt db
135 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Engine crashes while trying to backup a logically corrupt db
136 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect handling of null within view - returns 0
137 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
problem when dropping column that is a primary key
138 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Dependencies are not cleared when creation of expression index fails
139 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Singleton isn't respected in COMPUTED BY expressions
140 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Singleton isn't respected in COMPUTED BY expressions
141 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The built-in BLR printer doesn't support all FB2 features
142 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
The built-in BLR printer doesn't support all FB2 features
143 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
It is impossible to take away rights on update of a column
144 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SPs in views
145 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DDL - object in use
146 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
DDL - object in use
147 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SUBSTRING with NULL offset or length don't return NULL
148 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problems with explicit cursors in unwanted states
149 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New value of column is accessable before update
150 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crash on violation of NOT NULL constraint
151 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Garbage in plan output of complex statement
152 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
An attempt to select DB_KEY from a procedure crashes the server
153 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALL predicate works incorrectly for some subqueries
154 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ALL predicate works incorrectly for some subqueries
155 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grants don't work for procedures used inside views
156 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bug in DSQL parameter
157 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Comment in create database
158 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Comment in create database
159 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad error message when tring to create FK to non-existent table
160 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Bad error message when tring to create FK to non-existent table
161 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV when blob is used in expression index
162 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
AV when blob is used in expression index
163 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GSTAT does not work using the localhost connection string
164 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Many aggregate functions within a single select list may cause a server crash
165 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SQL with incorrect characters (outside the ASCII range) may be processed wrongly
166 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Case insensitive collation for UTF-8
167 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make RDB$DB_KEY in outer joins return NULL when appropriate
168 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Make RDB$DB_KEY in outer joins return NULL when appropriate
169 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset
170 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset
171 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
select with FIRST and LEFT JOIN needs excess SORT in plan
172 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Keyword AS not recognized in clause FROM
173 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Keyword AS not recognized in clause FROM
174 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect results when left join on subquery with constant column
175 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Incorrect results when left join on subquery with constant column
176 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
bad handling of /*/ comments in ISQL
177 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
bad handling of /*/ comments in ISQL
178 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
context already in use (BLR error)
179 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
context already in use (BLR error)
180 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DISTINCT vs NULLS LAST clause: wrong order of NULLs
181 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
DISTINCT vs NULLS LAST clause: wrong order of NULLs
182 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
183 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Restoring RDB$BASE_FIELD for expression
184 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Restoring RDB$BASE_FIELD for expression
185 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Local buffer overrun in DYN_error() that takes down the server
186 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Local buffer overrun in DYN_error() that takes down the server
187 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Provide mechanism to get engine version without needing to call API function
188 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Provide mechanism to get engine version without needing to call API function
189 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make information available regading ODS Version and Dialect via SQL
190 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
191 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
192 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Estonian collation in UTF8 charset
193 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)
194 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)
195 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
like doesn't work for computed values (at least in a view)
196 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
like doesn't work for computed values (at least in a view)
197 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
extend retutnning support added in ver 2 in update record of table and in updateble view
198 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong single-segment ascending index on character field with NULL and empty string values
199 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong parameter matching for self-referenced procedures
200 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong parameter matching for self-referenced procedures
201 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
A query could produce different results, depending on the presence of an index
202 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation
203 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation
204 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server hangs eating CPU and performs huge I/O copying different codepage fields
205 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SINGULAR buggy when nulls present
206 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
207 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View with equally named source fields not faisible
208 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
User (not SYSDBA) what have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA
209 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong ordering with views, distinct, left join and order by
210 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error msg "Could not find UNIQUE INDEX" when in fact one is present
211 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Error msg "Could not find UNIQUE INDEX" when in fact one is present
212 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support BETWEEN predicate for select expressions
213 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results with GROUP BY on constants
214 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong results with GROUP BY on constants
215 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Crash when dealing with a string literal longer than 32K
216 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Remove or extend limit of command text length (64K)
217 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Conversion from string to number is not standard compliant
218 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Recursive Query bug in FB2.1
219 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Recursive Query bug in FB2.1
220 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UNION vs UTF8 literals : arithmetic exception is thrown
221 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad optimization -- <procedure> left join <subquery> (or <view>)
222 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cannot alter generator's comment to the same value
223 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server locks up while attempting to commit a deletion of an expression index
224 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Server locks up while attempting to commit a deletion of an expression index
225 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV in rse\invalidate_child_rpbs for recursive queies
226 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
AV in rse\invalidate_child_rpbs for recursive queies
227 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Every user can view server log using services API
228 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Every user can view server log using services API
229 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error conversion error from string " " using outer join on int64 and int fields
230 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
cannot erase a table with check constraints referencing more than a single columns
231 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Activating index change "STARTING" working as "LIKE" in join condition
232 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Prepare fails when having a parameter in a DSQL statement before a sub query
233 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem altering numeric field type
234 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Problem altering numeric field type
235 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL
236 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL
237 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CHARACTER SET GBK is not installed
238 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
CHARACTER SET GBK is not installed
239 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql exponential format of numbers has zero pad on windows
240 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Symbols ignored for ES_ES_CI_AI collation
241 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Symbols ignored for ES_ES_CI_AI collation
242 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression index based on computed fields
243 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Expression index based on computed fields
244 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference
245 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"CH" and "LL" are not separate spanish alphabet letters since 1994
246 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
"CH" and "LL" are not separate spanish alphabet letters since 1994
247 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Union returns inconsistent field names
248 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Union returns inconsistent field names
249 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference
250 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference
251 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Select Starting with :Param (Empty string) doesn't work if using index with many fields
252 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Long SQL statements break TCP/IP connection
253 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CURRENT OF support views
254 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong SELECT query results using index to evaluate >= condition
255 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong SELECT query results using index to evaluate >= condition
256 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIST() function seems not work if used twice or more in a query
257 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crash on select * from <recursive CTE>
258 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect column values with outer joins and views
259 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Incorrect column values with outer joins and views
260 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect column values with outer joins and derived tables
261 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect timestamp arithmetic when one of operands is negative number
262 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Full shutdown mode doesn't work on Classic if there are other connections to the database
263 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIST(DISTINCT) concatenate VARCHAR values as CHAR
264 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
LIST(DISTINCT) concatenate VARCHAR values as CHAR
265 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with DISTINCT and insensitive collations
266 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
String truncation error when concatenating _UTF8 string onto extract(year result
267 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
String truncation error when concatenating _UTF8 string onto extract(year result
268 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Table columns hide destination variables of RETURNING INTO
269 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GSec incorrectly processes some switches
270 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
GSec incorrectly processes some switches
271 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Small bug with default value for domains in PSQL
272 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Small bug with default value for domains in PSQL
273 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Ceation of invalid procedures/triggers allowed
274 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
275 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
276 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bug with COMPUTED BY fields
277 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Bug with COMPUTED BY fields
278 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
279 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Can't create table using long username and UTF8 as attachment charset
280 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad optimization of queries with DB_KEY
281 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Indices not used for views
282 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Indices not used for views
283 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
A remote attacker can check, if a file is present in the system, running firebird server
284 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$DB_KEY not supported in derived tables and merge command
285 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Data type unknown
286 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
NOT NULL constraint for procedure parameters and variables
287 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
NOT NULL constraint for procedure parameters and variables
288 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "Identifier ... is too long using multiple (nested) derived tables
289 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
size of alias name in a table
290 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Charset transliterations don't work with EXECUTE STATEMENT
291 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Charset transliterations don't work with EXECUTE STATEMENT
292 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Joins with NULL RDB$DB_KEY crash the server
293 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Joins with NULL RDB$DB_KEY crash the server
294 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with view , computed field and functions
295 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bug with a simple case and a subquery
296 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Bug with a simple case and a subquery
297 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
lpad and rpad with two columns not working
298 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unexpected "cannot transliterate" error
299 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Unexpected "cannot transliterate" error
300 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
TYPE OF COLUMN in PSQL
301 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Index operations for global temporary tables are not visible for the active connection
302 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Index operations for global temporary tables are not visible for the active connection
303 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Too large numbers cause positive infinity to be inserted into database
304 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ISQL crash when converted-from-double string longer than 23 bytes
305 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ISQL crash when converted-from-double string longer than 23 bytes
306 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
French insensitive collation FR_FR_CI_AI
307 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Execute block fails within execute statement
308 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Execute block fails within execute statement
309 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields
310 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Add an ability to change role without reconnecting to database.
311 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Add an ability to change role without reconnecting to database.
312 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Domain names and charset issues
313 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Domain names and charset issues
314 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Invalid parameter type when using it in CHAR_LENGTH function
315 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
316 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Generated columns
317 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Indexed MIN/MAX aggregates produce three index reads instead of the expected one indexed read
318 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Few problems with domains's check constraints
319 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Global temporary table instance may pick up not all indices
320 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Global temporary table instance may pick up not all indices
321 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW without column list when UNION is used
322 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
CREATE VIEW without column list when UNION is used
323 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support for autonomous transactions
324 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Support for autonomous transactions
325 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong current timestamp evaluation for selectable procedures
326 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect timestamp substraction in 3 dialect when result is negative number
327 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Incorrect timestamp substraction in 3 dialect when result is negative number
328 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Greek characters in cp1251 vs uppercasing
329 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Greek characters in cp1251 vs uppercasing
330 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Collation not propagated between record formats
331 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result with EXECUTE STATEMENT and VARCHAR columns
332 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer joins don't work properly with the MON$ tables
333 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Execute statement 'select ....' into new....
334 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Execute statement 'select ....' into new....
335 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Using RDB$DB_KEY in where section while selecting from a procedure crashes the server
336 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow usage of functions in LIST delimiter parameter
337 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER mechanism for computed fields
338 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ALTER mechanism for computed fields
339 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crash caused by a buffer overrun in the optimizer when more than 255 relation references exist in the query
340 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make optimizer to consider ORDER BY optimization when making decision about join order
341 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DATEADD wrong work with NULL arguments
342 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
BLOB isn't compatible with [VAR]CHAR in COALESCE
343 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
BLOB isn't compatible with [VAR]CHAR in COALESCE
344 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax
345 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax
346 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crash with isc_dsql_execute_immediate and zero length string
347 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Conversion from double to varchar insert trailing spaces
348 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad XSQLVAR [NULL flags] for (2*COALESCE(NULL,NULL))
349 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
POSITION(string_exp1, string_exp2 [, start])
350 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Connection lost running script
351 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Connection lost running script
352 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Many new 2.1 built in functions have incorrect NULL semantics
353 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Many new 2.1 built in functions have incorrect NULL semantics
354 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Adding a non-null restricted column to a populated table renders the table inconsistent
355 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Inconsistent DATEDIFF behaviour
356 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Computed field + index not working in WHERE
357 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Functions DATEDIFF does not work in dialect 1
358 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
JOIN on first record of ordered derived table returns wrong record
359 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
JOIN on first record of ordered derived table returns wrong record
360 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
361 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$procedures generator overflow
362 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     F    
Subquery-based predicates are not evaluated early in the join order
363 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Subquery-based predicates are not evaluated early in the join order
364 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
365 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
366 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV when all statements are cancelled
367 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
select ... where ... <> ALL (select ... join ...) bug
368 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
'select ...from...where...not in (select...from...)' no results
369 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
'select ...from...where...not in (select...from...)' no results
370 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Dropping NOT NULL contranint doesn'have the desired effect
371 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
NULLIF crashes when first parameter is constant empty string
372 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Multiple Rows in Singleton Select not reported in a View
373 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Multiple Rows in Singleton Select not reported in a View
374 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ABS() rounds NUMERIC values
375 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashed or bugcheck when inserting in monitoring tables.
376 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Altering procedure parameters can lead to unrestorable database
377 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Altering procedure parameters can lead to unrestorable database
378 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 232 (invalid operation) for an aggregated query
379 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Ability to insert child record if parent record is locked but foreign key target unchanged
380 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Correlated subquery is optimized badly if it depends on the union stream
381 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
PSQL output parameter size limited
382 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Some aggregate functions does NOT support NULL-constant in 3-d dialect
383 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect error message (column number) if the empty SQL string is prepared
384 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Incorrect error message (column number) if the empty SQL string is prepared
385 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
MERGE not correctly worked with parameters in MATCHING clause
386 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
MERGE not correctly worked with parameters in MATCHING clause
387 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Create or Alter view
388 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Non-privileged monitoring reports wrong attachment data
389 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Non-privileged monitoring reports wrong attachment data
390 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV when recursive query used MERGE JOIN in execution plan
391 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
AV when recursive query used MERGE JOIN in execution plan
392 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Infinite row generation in "select gen_id(..) from rdb$database" with "group by"
393 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Ability to format UUID from char(16) OCTETS to human readable form and vice versa
394 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Floor & ceiling functions give wrong results with exact numeric arguments
395 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
'There are <n> dependencies' error message shows the wrong count of dependent objects.
396 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
arithmetic exception, numeric overflow, or string truncation in utf8 tables
397 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
arithmetic exception, numeric overflow, or string truncation in utf8 tables
398 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
399 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
400 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bug in create/alter Database trigger (with Russian comment)
401 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Buffer overflow in conversion
402 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect "key size exceeds implementation restriction for index" error
403 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong variable initialization in recursive procedures
404 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Common table expressions cannot be used in computed columns and quantified predicates (IN / ANY / ALL)
405 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     F    
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
406 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     F    
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
407 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bug in SET DEFAULT statement
408 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Bug in SET DEFAULT statement
409 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression index can be created while doing inserts into table
410 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Expression index can be created while doing inserts into table
411 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DDL statement with AUTODDL ON won't show statistics
412 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Include information about context variables into the monitoring tables
413 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Include information about context variables into the monitoring tables
414 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Results of a join with different collations depend on the execution plan
415 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Results of a join with different collations depend on the execution plan
416 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support hex numeric and string literals
417 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with COLLATE ES_ES_CI_AI
418 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Problem with COLLATE ES_ES_CI_AI
419 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ISQL crashes when fetching data for a column having alias longer than 30 characters
420 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ISQL crashes when fetching data for a column having alias longer than 30 characters
421 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT
422 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Consistency check when subquery is ordered by aggregate function from other context
423 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Consistency check when subquery is ordered by aggregate function from other context
424 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV at prepare of query with unused parametrized CTE
425 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes on SQL script
426 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Server crashes on SQL script
427 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
OLD/NEW.RDB$DB_KEY returns incorrect result in triggers
428 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
OLD/NEW.RDB$DB_KEY returns incorrect result in triggers
429 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$DB_KEY evaluates to NULL in INSERT ... RETURNING
430 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Maximum key size using PXW_CSY collation
431 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Maximum key size using PXW_CSY collation
432 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Usernames with '.' character
433 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect parser's reaction to the unquoted usage of the keyword "VALUE"
434 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Index is not used for some date/time expressions in dialect 1
435 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Index is not used for some date/time expressions in dialect 1
436 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Ability to grant role to another role
437 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error with ABS in dialect 1
438 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Possible index corruption with multiply updates of the same record in the same transaction and using of savepoints
439 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Procedure text is stored truncated in system tables if any variable have default value
440 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Procedure text is stored truncated in system tables if any variable have default value
441 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV when sorting by field, calculated using recursive CTE
442 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
AV when sorting by field, calculated using recursive CTE
443 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
If some VIEW used derived tables and long table namesliases, It is possible to overflow RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME
444 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DEFAULT values are unnecessary evaluated
445 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Some standard calls show server installation directory to regular users
446 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow index walk (ORDER plan) when there is a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B
447 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Arithmetic overflow or division by zero has occurred. in MAX function
448 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
BLR error on restore database with computed by Field
449 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
BLR error on restore database with computed by Field
450 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Roles granting/revoking logic
451 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Roles granting/revoking logic
452 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error on script with current_date
453 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE COLLATION connection lost under Posix
454 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SHOW VIEW shows non-sense information for view fields with expressions
455 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Circular dependencies between computed fields crashs the engine
456 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Dropping and adding a domain constraint in the same transaction leaves incorrect dependencies
457 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Not valid fields in MERGE's insert clause are allowed
458 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
MON$DATABASE returns outdated transaction counters
459 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled
460 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO character classes are incorrectly recognized
461 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The log(base, number) built-in function doesn't check parameters and delivers NAN values instead.
462 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GROUP BY RAND() returns infinite rows
463 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
GROUP BY RAND() returns infinite rows
464 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Custom attribute for collation to sort numbers in numeric order
465 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Custom attribute for collation to sort numbers in numeric order
466 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 291
467 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Bugcheck 291
468 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect extraction of MILLISECONDs
469 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Incorrect extraction of MILLISECONDs
470 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Set the fixed and documented check order for WHERE clause and other conditional sentences
471 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Set the fixed and documented check order for WHERE clause and other conditional sentences
472 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Non-SYSDBA user can change FW mode of database.
473 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Non-SYSDBA user can change FW mode of database.
474 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Altering domains name drops dependencies using the domain
475 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Altering domains name drops dependencies using the domain
476 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UTF8 UNICODE_CI collate can?t be used in foreing key constraint
477 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
bad BLR -- invalid stream for union select
478 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Broken foreign key handling for multi-segmented index using multi-level collations
479 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Broken foreign key handling for multi-segmented index using multi-level collations
480 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
TimeStamp in the every line output gbak.exe utility
481 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
TimeStamp in the every line output gbak.exe utility
482 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user
483 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user
484 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER USER XXX INACTIVE
485 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support SQL 2008 syntax for MERGE statement with DELETE extension
486 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SUBSTRING with regular expression (SIMILAR TO) capability
487 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
NOT NULL procedure parameters
488 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
I/O statistics for stored procedures are not accounted in monitoring tables
489 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
I/O statistics for stored procedures are not accounted in monitoring tables
490 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Only one client can access a readonly database
491 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UTF-8 conversion error (string truncation)
492 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
UTF-8 conversion error (string truncation)
493 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"EXECUTE BLOCK" statement does not support "CREATE USER"
494 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
"EXECUTE BLOCK" statement does not support "CREATE USER"
495 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with a read-only marked database
496 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect buffer size for ORDER BY expression with system fields
497 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Incorrect buffer size for ORDER BY expression with system fields
498 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Null in the first record in a condition on rdb$db_key
499 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Stored procedure recursively called by calculated field fails after reconnect
500 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Stored procedure recursively called by calculated field fails after reconnect
501 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT
502 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining
503 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining
504 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Domain-level CHECK constraints wrongly process NULL values
505 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Domain-level CHECK constraints wrongly process NULL values
506 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
update or insert with gen_id() with wrong generator value
507 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
update or insert with gen_id() with wrong generator value
508 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
connection lost to database when used AUTONOMOUS TRANSACTION
509 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
connection lost to database when used AUTONOMOUS TRANSACTION
510 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
511 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
512 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
don't work subquery in COALESCE
513 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Computed expressions may be optimized badly if used inside the RETURNING clause of the INSERT statement
514 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER VIEW WITH CHECK OPTION crashes the engin
515 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ALTER VIEW WITH CHECK OPTION crashes the engin
516 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GROUP by and RDB$DB_KEY problems
517 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
GROUP by and RDB$DB_KEY problems
518 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Comparision with IN and subquery with RDB$DB_KEY returns wrong result
519 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect VIEW expansion when RDB$DB_KEY is used in view body
520 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression indexes bug: incorrect result for the inverted boolean
521 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parts of RDB$DB_KEY of views may be inverted when using outer joins
522 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Parts of RDB$DB_KEY of views may be inverted when using outer joins
523 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Suboptimal join plan if there are selective non-indexed predicates involved
524 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Suboptimal join plan if there are selective non-indexed predicates involved
525 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$DB_KEY in subselect expression incorrectly returns NULL
526 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View over global temporary table
527 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
View over global temporary table
528 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor
529 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Query plan is missing for the long query
530 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect ROW_COUNT value with indexed retrieval and subquery
531 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
532 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate
533 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error messages after parameters substitution contains '8' characters instead of line break
534 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Error messages after parameters substitution contains '8' characters instead of line break
535 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO predicate hangs with "|" option
536 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
SIMILAR TO predicate hangs with "|" option
537 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Join of SP with view or table may fail with "No current record for fetch operation"
538 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Join of SP with view or table may fail with "No current record for fetch operation"
539 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
error in operator "and" in as clausule where
540 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
error in operator "and" in as clausule where
541 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unexpected (wrong) results with COALESCE and GROUP BY
542 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Extend maximum database page size to 32KB
543 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Add support for -nodbtriggers switch in gbak into services API
544 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Extremely slow executing a cross join of 3 tables in Firebird 2.X
545 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Extremely slow executing a cross join of 3 tables in Firebird 2.X
546 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$VIEW_RELATIONS is not cleaned when altering a view
547 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
RDB$VIEW_RELATIONS is not cleaned when altering a view
548 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
constraints on sp output parameters are checked even when the sp returns zero rows
549 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New gbak option to ignore specific tables data during the backup
550 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
New gbak option to ignore specific tables data during the backup
551 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Offset value for SUBSTRING from BLOB more than 32767 makes exception
552 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GROUP BY concatenation with empty string
553 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Nbackup as online dump
554 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with column names with Accents and triggers
555 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Problem with column names with Accents and triggers
556 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Implement domain check of input parameters of execute block
557 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Implement domain check of input parameters of execute block
558 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
559 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
560 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.
561 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.
562 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
gbak doesn't return error code
563 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
gbak doesn't return error code
564 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EXECUTE STATEMENT on EXTERNAL SOURCE does not check the status of the transaction
565 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
'...exception...string right truncation' when alter view with join
566 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
'...exception...string right truncation' when alter view with join
567 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
internal Firebird consistency check when alter dependent procedures
568 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
internal Firebird consistency check when alter dependent procedures
569 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
internal error when select upper(<blob>) from union
570 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
internal error when select upper(<blob>) from union
571 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER DOMAIN with dependencies may leave a transaction handle in inconsistent state causing segmentation faults
572 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ALTER DOMAIN with dependencies may leave a transaction handle in inconsistent state causing segmentation faults
573 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grouping by function doesn't work properly
574 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GFIX causes BUGCHECK errors with non valid transaction numbers
575 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
MERGE non-standard behaviour, accepts multiple matches
576 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Records left in RDB$PAGES after rollback of CREATE TABLE statement
577 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Records left in RDB$PAGES after rollback of CREATE TABLE statement
578 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong (primary) constraint name is reported for the foreign key violation during FK creation
579 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
580 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong dependent object type (RELATION) in RDB$DEPEDENCIES for VIEW's
581 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unexpected error "arithmetic exception, numeric overflow, or string truncation" while evaluating SUBSTRING the second time
582 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Unexpected error "arithmetic exception, numeric overflow, or string truncation" while evaluating SUBSTRING the second time
583 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Include PLAN in mon$statements
584 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make mon$statement_id value constant among monitoring snapshots
585 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incomplete API information values
586 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO produces random results with [x-y] expressions
587 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
SIMILAR TO produces random results with [x-y] expressions
588 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Firebird float support does not conform to Interbase spec
589 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
select * from (select cast(.... returns null
590 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER DOMAIN invalid RDB$FIELD_SUB_TYPE
591 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result for the derived expression based on aggregate and computation
592 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Incorrect result for the derived expression based on aggregate and computation
593 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Hidden variables conflict with output parameters, causing assertions, unexpected errors or possibly incorrect results
594 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Too long column name for select alias should be rejected
595 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect handling of LOWER/UPPER when result string shrinks in terms of byte length
596 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Logical multibyte maximum string length is not respected when assigning numbers
597 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
String truncation reading 8859-1 Spanish column using isc_dsql_fetch with UTF-8 connection..
598 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
String truncation reading 8859-1 Spanish column using isc_dsql_fetch with UTF-8 connection..
599 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER TRIGGER / PROCEDURE wrong error message
600 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ALTER TRIGGER / PROCEDURE wrong error message
601 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER VIEW could remove column used in stored procedure or trigger
602 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ALTER VIEW could remove column used in stored procedure or trigger
603 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong matching of SIMILAR TO expression with brackets
604 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
If you drop two different indexes within the same transaction, you get database corruption
605 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
If you drop two different indexes within the same transaction, you get database corruption
606 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
607 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV preparing a query with aggregate over derived table
608 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parsing error in EXECUTE STATEMENT with named parameters
609 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Parsing error in EXECUTE STATEMENT with named parameters
610 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make CREATE VIEW infer column names for views involving a GROUP BY clause or derived table
611 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Alter table not respecting collation
612 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Alter table not respecting collation
613 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER VIEW doesn't clear dependencies on old views
614 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server adds "NOT" at the end of default value for the TIMESTAMP field
615 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
String values in error messages are not converted to connection charset
616 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE USER command: Invalid error message
617 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes on UPDATE OR INSERT statement
618 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Query SELECT ... WHERE ... IN (SELECT DISTINCT ... ) returns a wrong result set.
619 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server fails when doing DROP DATABASE right after error in statistical fnction
620 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Server fails when doing DROP DATABASE right after error in statistical fnction
621 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UNICODE_CI internal gds software consistency check
622 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
External table data not visible to other sessions in Classic
623 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
mon$memory_usage: Sorting memory should be reported as owned by the statement
624 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Success message when connecting to tiny trash database file
625 ALL 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 X
Append the IP address of the remote host to error messages in firebird.log for TCP connections
626 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Implementation limit of DISTINCT items are not enforced, causing generation of incorrect BLR
627 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Implementation limit of DISTINCT items are not enforced, causing generation of incorrect BLR
628 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Binary shift functions give wrong results with negative shift values
629 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Built-in trigonometric functions can produce NaN and Infinity
630 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Built-in trigonometric functions can produce NaN and Infinity
631 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Tricky index names can defeat the parsing logic when generating a human readable plan
632 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong processing a SP parameters with arrays
633 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
634 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
PSQL doesnt allow to use singleton query result as input parameter of stored procedure when procedure accessed using 'execute procedure'
635 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
PSQL doesnt allow to use singleton query result as input parameter of stored procedure when procedure accessed using 'execute procedure'
636 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CI column does not group correctly with a second column
637 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
CI column does not group correctly with a second column
638 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Maximum and minimum identifier length should be enforced by DSQL
639 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Maximum and minimum identifier length should be enforced by DSQL
640 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
internal error [335544384]
641 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
internal error [335544384]
642 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The server crashes when selecting from the MON$ tables in the ON DISCONNECT trigger
643 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
The server crashes when selecting from the MON$ tables in the ON DISCONNECT trigger
644 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
select rdb$db_key from a view with a more than 1 table joined, results in conversion error
645 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
select rdb$db_key from a view with a more than 1 table joined, results in conversion error
646 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parameters and variables cannot be used as expressions in EXECUTE PROCEDURE parameters without a colon prefix
647 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Infinity should not escape from the engine
648 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Infinity should not escape from the engine
649 ALL S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S
Infinity from UDF should be trapped by the engine
650 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results for CASE used together with GROUP BY
651 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Attachments using NONE charset may cause reads from MON$ tables to fail
652 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Multibyte CHAR value requested as VARCHAR is returned with padded spaces
653 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Introducer (_charset) problems with monitoring and persistent modules
654 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Connection lost immediatelly after compiling procedure with RPAD system function
655 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Connection lost immediatelly after compiling procedure with RPAD system function
656 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Silent truncation when using utf8 parameters and utf8 client character set encoding
657 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Invalid BLOB ID when working with monitoring tables
658 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Invalid BLOB ID when working with monitoring tables
659 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SELECT WITH LOCK with no fields are accessed clears the data
660 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
SELECT WITH LOCK with no fields are accessed clears the data
661 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unique index with a lot of NULL keys can be corrupted at level 1
662 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Improve sorting performance when long VARCHARs are involved
663 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Improve sorting performance when long VARCHARs are involved
664 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect "string right truncation" error with NONE column and multibyte connection charset
665 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
COUNT(*) incorrectly returns 0 when a condition of an outer join doesn't match
666 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Write note into log when automatic sweep is started
667 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Write note into log when automatic sweep is started
668 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Full outer join cannot use available indices (very slow execution)
669 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
System triggers on view with check option are not removed
670 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support the "? in (SELECT some_col FROM some_table)" subqueries
671 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Common table expression context could be used with parameters
672 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Do not print "invalid request BLR" for par.cpp errors with valid BLR
673 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong evaluation result with divide and unary plus\minus operations
674 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong evaluation result with divide and unary plus\minus operations
675 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
676 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Storage of malformed blob is allowed when copying from a blob with NONE/OCTETS charset
677 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Storage of malformed blob is allowed when copying from a blob with NONE/OCTETS charset
678 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
679 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
680 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
681 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Recursive EXECUTE STATEMENT works wrong
682 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Recursive EXECUTE STATEMENT works wrong
683 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql hangs when trying to show a view based on a procedure
684 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Naive metadata extraction code in isql is defeated by "check" keyword typed in mixed case
685 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO works wrongly
686 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
SIMILAR TO works wrongly
687 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
substring from timestamp - unexpected result
688 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
substring from timestamp - unexpected result
689 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Use of RDB$ADMIN role does not provide SYSDBA rights in GRANT/REVOKE
690 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Use of RDB$ADMIN role does not provide SYSDBA rights in GRANT/REVOKE
691 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "page 0 is of wrong type (expected 6, found 1)" is thrown while accessing a non-corrupted table
692 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTERING OR DROPPING PROCEDURE which has type of domain parameter leads to attempt to delete that domain
693 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ALTERING OR DROPPING PROCEDURE which has type of domain parameter leads to attempt to delete that domain
694 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Include client library version and protocol version in mon$attachments
695 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV using recursive query as subquery in SELECT list and ORDER'ing by them
696 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
AV using recursive query as subquery in SELECT list and ORDER'ing by them
697 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make rdb$system_flag not null
698 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Make rdb$system_flag not null
699 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql extracts the array dimensions after the character set name
700 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
isql extracts the array dimensions after the character set name
701 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DB_KEY is always zero for external tables
702 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with default value of SP parameter
703 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incomplete plan output (lack of view names) when selecting from views containing procedures inside
704 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Incomplete plan output (lack of view names) when selecting from views containing procedures inside
705 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Changing sort directon in delete statement cause deletion of all records in table
706 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Changing sort directon in delete statement cause deletion of all records in table
707 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problems with COMMENT ON and strings using introducer (charset)
708 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Views based on procedures can't be created if the proc's output fields participate in an expression
709 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Views based on procedures can't be created if the proc's output fields participate in an expression
710 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unsuccessful execution' error when updating a record
711 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Prohibit any improper mixture of explicit and implicit joins
712 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure rigger executed first time
713 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure rigger executed first time
714 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "no current row for fetch operation" when subquery includes a non-trivial derived table
715 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Join condition fails for UTF-8 databases.
716 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Join condition fails for UTF-8 databases.
717 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql shouldn't display db and user name when extracting a script
718 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
isql shouldn't display db and user name when extracting a script
719 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Changing data that affects an expression index that contains references to null date fields fails
720 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Changing data that affects an expression index that contains references to null date fields fails
721 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Natural is used to select instead of primary key index
722 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cannot remove user with dot in login
723 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Cannot remove user with dot in login
724 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View created from JOIN and LEFT JOIN doesnt order
725 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer ORDER BY clause has no effect
726 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EVL_expr: invalid operation (232)
727 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
String right truncation error when char column longer than 4096 bytes compared with string constant
728 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
729 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql should show packaged procedures and functions categorized per package
730 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
isql should show packaged procedures and functions categorized per package
731 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Query with "NOT IN <subselect from view>" fails
732 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Query with "NOT IN <subselect from view>" fails
733 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
A memory corruption cause incorrect query evaluation and may crash the server
734 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
735 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression in a subquery may be treated as invariant and produce incorrect results
736 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Expression in a subquery may be treated as invariant and produce incorrect results
737 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Don't send full length of field over the wire when field is null
738 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unable to catch exceptions that are thrown inside a dynamic builded execute block.
739 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
PK index is not used for derived tables
740 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
PK index is not used for derived tables
741 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
742 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
COLLATE expressions are applied incorrectly
743 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
COLLATE expressions are applied incorrectly
744 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Broken error handling in the case of a conversion error happened during index creation
745 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect execution of volatile SQL statements inside EXECUTE STATEMENT
746 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Incorrect execution of volatile SQL statements inside EXECUTE STATEMENT
747 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Character set used in constants is not registered as dependency
748 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Character set used in constants is not registered as dependency
749 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with dependencies between a procedure and a view using that procedure
750 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"Invalid ESCAPE sequence" when connecting to the database
751 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
"Invalid ESCAPE sequence" when connecting to the database
752 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DROP VIEW drops output parameters of used stored procedures
753 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong field position after ALTER POSITION
754 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong field position after ALTER POSITION
755 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Trace output could contain garbage data left from filtered out statements
756 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
parsing error recursive query with two recursive parts
757 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
parsing error recursive query with two recursive parts
758 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Case-sensitive character class names in SIMILAR TO
759 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Case-sensitive character class names in SIMILAR TO
760 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
count(*) from big table returns negative result
761 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect ROW_COUNT value after SINGULAR condition
762 ALL S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S
Wrong results or unexpected errors while sorting a large data set
763 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them
764 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them
765 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" error
766 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unexpected "Invalid SIMILAR TO pattern" error
767 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
768 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error in Trace plugin (use local symbols in query)
769 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
770 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Concurrent transaction number not reported if lock timeout occurs
771 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Concurrent transaction number not reported if lock timeout occurs
772 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error on delete user "ADMIN"
773 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Error on delete user "ADMIN"
774 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Procedure suspend check may cause restore to fail
775 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Add attachment's CHARACTER SET name into corresponding trace records
776 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Add attachment's CHARACTER SET name into corresponding trace records
777 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Check ability to use RECREATE, ALTER and CREATE OR ALTER SEQUENCE/GENERATOR statements
778 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Check ability to use RECREATE, ALTER and CREATE OR ALTER SEQUENCE/GENERATOR statements
779 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "no current record for fetch operation" after ALTER VIEW
780 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
781 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
782 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong resultset
783 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong resultset
784 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)
785 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)
786 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong logic is used to resolve EXECUTE BLOCK parameters collations
787 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong resultset
788 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong resultset
789 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
790 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
791 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
792 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
793 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow the usage of blobs in COMPUTED BY expressions
794 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Allow the usage of blobs in COMPUTED BY expressions
795 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New generators are created with wrong value when more than 32K generators was previously created
796 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
New generators are created with wrong value when more than 32K generators was previously created
797 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Using both the procedure name and alias inside an explicit plan crashes the server
798 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Using both the procedure name and alias inside an explicit plan crashes the server
799 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Foreign key cascade with SET DEFAULT uses the default value of the moment of the FK creation
800 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Better performance for (table.field = :param or :param = -1) in where clause
801 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Better performance for (table.field = :param or :param = -1) in where clause
802 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
803 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect LEFT JOIN result using table and derived constant subquery
804 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral
805 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ROW_COUNT is not cleared before the singleton INSERT statement
806 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parameters doesn't work with NOT IN from a selectable procedure
807 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
808 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
809 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Updating blob field cause server crash with ACCESS_VIOLATION exception
810 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction
811 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction
812 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cannot alter the domain after migrating from older versions
813 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT. See also: CORE-3283
814 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
815 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Partial rollback is possible for a selectable procedure modifying data
816 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Partial rollback is possible for a selectable procedure modifying data
817 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Preserve comments for parameters after altering procedures
818 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Preserve comments for parameters after altering procedures
819 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The last column in a view is returning as a null value even when it's not
820 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
The last column in a view is returning as a null value even when it's not
821 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parameterized requests involving blob fields fails when connected using charset UTF8
822 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Parameterized requests involving blob fields fails when connected using charset UTF8
823 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
exclude_filter doesn't work for <services></section> section of the Trace facility
824 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Empty result when select from SP that contains two CTE (second of them with GROUP BY clause) and INNER join
825 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Empty result when select from SP that contains two CTE (second of them with GROUP BY clause) and INNER join
826 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression index with TRIM may lead to incorrect indexed lookup
827 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Expression index with TRIM may lead to incorrect indexed lookup
828 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View with "subselect" column join table and not use index
829 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER VIEW with not matched columns in declaration and selection crashs the server
830 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ALTER VIEW with not matched columns in declaration and selection crashs the server
831 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
page 0 is of wrong type (expected 6, found 1)
832 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
page 0 is of wrong type (expected 6, found 1)
833 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ATAN2 returns incorrect value for (0, 0)
834 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Constraint violation error of CAST is not raised inside views
835 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query
836 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query
837 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
String truncation occurs when selecting from a view containing NOT IN inside
838 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
839 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
840 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ASCII_VAL() fails if argument contains multi-byte character anywhere
841 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ASCII_VAL() fails if argument contains multi-byte character anywhere
842 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RIGHT() fails with multibyte text blobs > 1024 chars
843 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
RIGHT() fails with multibyte text blobs > 1024 chars
844 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
OVERLAY() fails when used with text BLOBs containing multi-byte chars
845 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
OVERLAY() fails when used with text BLOBs containing multi-byte chars
846 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIKE, STARTING and CONTAINING fail if second operand >= 32K
847 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
LIKE, STARTING and CONTAINING fail if second operand >= 32K
848 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support for text BLOBs >= 32K as first argument for TRIM()
849 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Makes GEN_UUID return a compliant RFC-4122 UUID
850 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Makes GEN_UUID return a compliant RFC-4122 UUID
851 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UTF8 UNICODE_CI collate can not be used in compound index
852 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Recursive stored procedure shouldnt require execute right to call itself
853 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
POSITION: Wrong result with '' if third argument present
854 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SUBSTRING on long blobs truncates result to 32767 if third argument not present
855 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
SUBSTRING on long blobs truncates result to 32767 if third argument not present
856 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The server could crash using views with GROUP BY
857 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
The server could crash using views with GROUP BY
858 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "request depth exceeded" may appear while preparing a select query against a view with explicit plan
859 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIST() may overwrite last part of output with zero characters
860 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong result for RIGHT(UTF8 varchar)
861 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong result for RIGHT(UTF8 varchar)
862 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EXECUTE STATEMENT parses the SQL text using wrong charset
863 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
EXECUTE STATEMENT parses the SQL text using wrong charset
864 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
865 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
866 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction that created a record version
867 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction that created a record version
868 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "context already in use" for the simple case function with a sub-select operand
869 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Distinct aggregates return wrong (duplicated) data
870 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Distinct aggregates return wrong (duplicated) data
871 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"BLOB not found" error after creation/altering of the invalid trigger
872 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
"BLOB not found" error after creation/altering of the invalid trigger
873 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure
874 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure
875 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$GET_CONTEXT and between in view
876 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
RDB$GET_CONTEXT and between in view
877 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
878 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
879 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sub-optimal join plan when the slave table depends on the master one via the OR predicate
880 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
881 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
882 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Ability to cancel waiting in lock manager
883 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Ability to cancel waiting in lock manager
884 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Client writes error messages into firebird.log when database is shutted down
885 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Client writes error messages into firebird.log when database is shutted down
886 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes while recreating the table with a NULL -> NOT NULL change
887 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments
888 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments
889 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
890 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error in autonomous transaction with empty exception handler: can insert duplicate values into PK/UK column (leads to unrestorable backup)
891 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Error in autonomous transaction with empty exception handler: can insert duplicate values into PK/UK column (leads to unrestorable backup)
892 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements
893 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements
894 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Predicate (blob_field LIKE ?) describes the parameter as VARCHAR(30) rather than as BLOB
895 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong comparsion of DATE and TIMESTAMP if index is used
896 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong comparsion of DATE and TIMESTAMP if index is used
897 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Generators are set to 0 after restore
898 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
899 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
900 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     F    
Cursors should ignore changes made by the same statement
901 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Cursors should ignore changes made by the same statement
902 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cursors should ignore changes made by the same statement
903 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Cursors should ignore changes made by the same statement
904 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Blob filter to translate internal debug info into text representation
905 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Blob filter to translate internal debug info into text representation
906 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Extend syntax for ALTER USER CURRENT_USER
907 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Extend syntax for ALTER USER CURRENT_USER
908 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
It is possible to store string with lenght 31 chars into column varchar(25)
909 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
It is possible to store string with lenght 31 chars into column varchar(25)
910 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format
911 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format
912 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
913 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GRANT ADMIN ROLE not accepted
914 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow write operations to temporary tables in read only transactions
915 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Allow write operations to temporary tables in read only transactions
916 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Collation errors with [type of] <domain>, type of column
917 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Collation errors with [type of] <domain>, type of column
918 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Improve diagnostics of internal trace errors
919 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Improve diagnostics of internal trace errors
920 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Inserting K?se into a CHARACTER SET ASCII column succeeds
921 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Database trigger created as INACTIVE is active
922 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Database trigger created as INACTIVE is active
923 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Recurse leads to hangs/crash server
924 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Recurse leads to hangs/crash server
925 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
BOOLEAN not present in system table RDB$TYPES
926 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
BOOLEAN not present in system table RDB$TYPES
927 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
[FB3] AV with "UPDATE OR INSERT"
928 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
[FB3] AV with "UPDATE OR INSERT"
929 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
[FB3] Wrong RDB$PARAMETER_MECHANISM
930 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashing with UTF8 blobs
931 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Server crashing with UTF8 blobs
932 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ISQL pads UTF-8 data incorrectly
933 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
ISQL pads UTF-8 data incorrectly
934 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Lateral derived tables
935 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Lateral derived tables
936 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow conversion from/to BLOBs and others types in the API functions (XSQLVAR or blr messages)
937 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Collation is not installed with icu > 4.2
938 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Inefficient optimization (regression)
939 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Added not null timestamp col with default causes error on select of old null records
940 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DDL operations fail after backup/restore
941 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression in joins on procedures
942 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parameters inside the CAST function are described as not nullable
943 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIST function wrongly concatenates binary blobs
944 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
LIST function wrongly concatenates binary blobs
945 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ASCII_VAL raises error instead of return 0 for empty strings
946 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Blob transliteration may not happen inside the union
947 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Blob transliteration may not happen inside the union
948 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Concurrency problem when using named cursors
949 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Concurrency problem when using named cursors
950 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Altering of a TYPE OF COLUMN parameter affects the original column
951 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Altering of a TYPE OF COLUMN parameter affects the original column
952 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Adding a value to a timestamp below '16.11.1858 00:00:01' throws 'value exceeds the range for valid timestamp'
953 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Adding a value to a timestamp below '16.11.1858 00:00:01' throws 'value exceeds the range for valid timestamp'
954 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DROP VIEW ignores the existing non-column dependencies
955 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
DROP VIEW ignores the existing non-column dependencies
956 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER VIEW crashes the server if the new version has an artificial (aggregate or union) stream at the position of a regular context in the older version
957 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Alter procedure allows to add the parameter with the same name
958 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Alter procedure allows to add the parameter with the same name
959 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unquoted role names with non-ASCII characters passed in DPB are upper-cased wrongly
960 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crash with built in function LPAD with string as second parameter
961 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO: False matches on descending ranges
962 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support for WHEN SQLSTATE
963 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
964 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
965 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Inconsistent domain's constraint validation in PSQL
966 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Aliases for the RETURNING clause
967 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Aliases for the RETURNING clause
968 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Floating-point negative zero doesn't match positive zero in the index
969 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Floating-point negative zero doesn't match positive zero in the index
970 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GFIX returns an error after correctly shutting down a database
971 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Database corruption after end of session : page xxx is of wrong type expected 4 found 7
972 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
973 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
974 CS P P P P P P P P P P P P P P P P P P P P P P P P P     F         F     P     F     P
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
975 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
976 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV in engine when preparing query against dropping table
977 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CHAR(32767) present in XSQLVAR with length 32765
978 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
CHAR(32767) present in XSQLVAR with length 32765
979 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Can not drop table when computed field depends on later created another field
980 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Can not drop table when computed field depends on later created another field
981 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Include expected and actual string lenght into error message for sqlcode -802
982 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
TRACE: add statistics of actions that were after transaction finished
983 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
TRACE: add statistics of actions that were after transaction finished
984 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Possible drop role RDB$ADMIN
985 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect TEXT BLOB charset transliteration on VIEW with trigger
986 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Can insert DUPLICATE keys in UNIQUE index
987 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Can insert DUPLICATE keys in UNIQUE index
988 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong data while retrieving from CTEs (or derived tables) with same column names
989 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong data while retrieving from CTEs (or derived tables) with same column names
990 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Plan returned for query with recursive CTE return wrong count of parenthesis
991 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Plan returned for query with recursive CTE return wrong count of parenthesis
992 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Window Function: cume_dist()
993 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Window Function: ntile(num_buckets integer)
994 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level)
995 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level)
996 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes with access violation when inserting row into table with unique index
997 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
998 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
999 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Window Function: frame (rows / range) clause
1000 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
recreation of collation for utf8 from unicode with option NUMERIC-SORT=1 leads to FB death
1001 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
1002 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
computed index by substring function for long columns
1003 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
computed index by substring function for long columns
1004 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE INDEX considers NULL and empty string being the same in compound indices
1005 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
CREATE INDEX considers NULL and empty string being the same in compound indices
1006 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results if the recursive query contains an embedded GROUP BY clause
1007 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong results if the recursive query contains an embedded GROUP BY clause
1008 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong warning message for ambiguous query
1009 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong warning message for ambiguous query
1010 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Missing constraint name in foreign key error message in FB 2.1.4
1011 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
1012 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
internal Firebird consistency check in query with grouping by subquery+stored procedure+aggregate
1013 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
String truncation error when selecting from a VIEW with UNION inside
1014 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
String truncation error when selecting from a VIEW with UNION inside
1015 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
IS NOT DISTINCT FROM NULL doesn't use index
1016 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
IS NOT DISTINCT FROM NULL doesn't use index
1017 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Segfault when closing attachment to database
1018 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GBAK fails to fix system generators while restoring
1019 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
GBAK fails to fix system generators while restoring
1020 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
1021 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table
1022 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table
1023 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets
1024 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets
1025 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SELECT using IN list with 153 or more elements causes crash
1026 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The trigger together with the operator MERGE if in a condition of connection ON contains new is not compiled
1027 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
The trigger together with the operator MERGE if in a condition of connection ON contains new is not compiled
1028 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO works wrongly
1029 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
SIMILAR TO works wrongly
1030 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Conversion error when using a blob as an argument for the EXCEPTION statement
1031 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Conversion error from string when using GROUP BY
1032 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Report OS user name in MON$ATTACHMENTS
1033 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
fb server die when carry out the LEFT + INNER JOIN
1034 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
with caller privileges option do not work with autonomous transaction option
1035 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Warnings could be put twice in status-vector
1036 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause
1037 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "Invalid expression in the select list" can be unexpectedly raised if a string literal is used inside a GROUP BY clause in a multi-byte connection
1038 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Provide ability to return all columns using RETURNING (eg RETURNING *)
1039 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql: zero divide + coredump when use "-pag 0" command switch & set heading on inside .sql script
1040 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$TYPES contain duplicate character sets
1041 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad alias table choice joining CTE
1042 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Usage of a NATURAL JOIN with a derived table crashes the server
1043 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Very poor performance of SIMILAR TO on some arguments + unable to disconnect via DELETE FROM MON$ATTACHMENTS
1044 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Very poor performance of SIMILAR TO on some arguments + unable to disconnect via DELETE FROM MON$ATTACHMENTS
1045 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Trace API: Faulty database filter crashes server
1046 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Trace API: Faulty database filter crashes server
1047 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Computed column appears in non-existant rows of left join
1048 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Extend the error reported for index/constraint violations to include the problematic key value
1049 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Extend the error reported for index/constraint violations to include the problematic key value
1050 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Ambiguous field name in the trigger when it does a select from the table
1051 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes on preparing empty query when trace is enabled
1052 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Server crashes on preparing empty query when trace is enabled
1053 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong numbers in error message for decreasing char/varchar columns
1054 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong numbers in error message for decreasing char/varchar columns
1055 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
High memory usage when PSQL code SELECT's from stored procedure which modified some data
1056 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
High memory usage when PSQL code SELECT's from stored procedure which modified some data
1057 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
row_number(), rank() and dense_rank() return BIGINT datatype in dialect 1
1058 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
row_number(), rank() and dense_rank() return BIGINT datatype in dialect 1
1059 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Derived fields may not be optimized via an index
1060 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Derived fields may not be optimized via an index
1061 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Improve SIMILAR TO performance
1062 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 291 (cannot find record back version) if GTT is modified concurrently using at least one read-committed read-only transaction
1063 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Bugcheck 291 (cannot find record back version) if GTT is modified concurrently using at least one read-committed read-only transaction
1064 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Creating self-referential FK crashes database (bug-check) whether constraint violation had place
1065 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Invalid "attempted update of read-only column" error when trying select minvalue from list with more than 255 elements
1066 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Invalid "attempted update of read-only column" error when trying select minvalue from list with more than 255 elements
1067 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Value of log_sweep parameter in trace configuration is ignored by trace plugin (assumed always true)
1068 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DeActivate/Activate INDEX or RESTORE not possible with NULL in unique index.
1069 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Restore from gbak backup using service doesn't report an error
1070 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Restore from gbak backup using service doesn't report an error
1071 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause
1072 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Repeat Temporary Table access from ReadOnly Transaction and ReadWrite transaction causes Internal Firebird consistency check (cannot find record back version (291), file: vio.cpp line: 4905)
1073 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql doesn't know the difference between UDF's and psql-functions
1074 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
isql doesn't know the difference between UDF's and psql-functions
1075 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
It is not possible to create a ddl-trigger with "any DDL statement" clause
1076 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Creating a procedure containing "case when" expression leads to a server crash
1077 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Creating a stored procedure with an "update or insert" statement with MATCHING fails
1078 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
subselect with reference to outer select fails
1079 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow the selection of SQL_INT64, SQL_DATE and SQL_TIME in dialect 1
1080 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Original table name and column name and owner missing from SQLDA for aliased column in grouped query
1081 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
1082 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
1083 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"attempted update of read-only column" when trying update editable view without triggers
1084 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
No records in the table rdb$dependencies for ddl trigger
1085 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
No records in the table rdb$dependencies for ddl trigger
1086 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Join using RDB$DB_KEY produce NATURAL plan
1087 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Join using RDB$DB_KEY produce NATURAL plan
1088 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parametrized execute statement fails
1089 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Parametrized execute statement fails
1090 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bug in unique constraints and / or NUMERIC-SORT collation
1091 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error message "index unexpectedly deleted" in database trigger on commit transaction
1092 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
wrong error message with recursive CTE
1093 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
using a result from a procedure in a substring expression leads to server crash
1094 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Using system domain in procedures arguments/returns cause the proc to be unchangeable
1095 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Creating table with computed fields containing "SELECT FIRST" produces corrupted result
1096 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Creating table with computed fields containing "SELECT FIRST" produces corrupted result
1097 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck or database corruption when attempting to store long incompressible data into a table
1098 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Bugcheck or database corruption when attempting to store long incompressible data into a table
1099 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Broken optimization for the stored dbkeys
1100 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
role not passed on external execute stmt
1101 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
role not passed on external execute stmt
1102 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Remote Stack Buffer Overflow in Firebird SQL Server (when specially crafted packet is sent via socket API)
1103 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql does not insert boolean values correctly, always shown as False
1104 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
isql does not insert boolean values correctly, always shown as False
1105 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Creating external function (udf) to not existing dll - and then procedure with it - crash server
1106 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
create package fails on creating header as soon as there is at least 1 procedure name
1107 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
NOT-NULL-column can be used as primary key and filled with NULL-values
1108 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
NOT-NULL-column can be used as primary key and filled with NULL-values
1109 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Constant columns getting empty value with subselect from procedure
1110 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Constant columns getting empty value with subselect from procedure
1111 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Computed by columns and position function
1112 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Computed by columns and position function
1113 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server bugchecks or crashes on exception in calculated index
1114 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Built-in functions and subselect no longer supported in "update or insert" value list
1115 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Regression: Built-in functions and subselect no longer supported in "update or insert" value list
1116 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong value of expected length in the sring right truncation error
1117 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Wrong value of expected length in the sring right truncation error
1118 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Full outer join in derived table with coalesce (iif)
1119 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Full outer join in derived table with coalesce (iif)
1120 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Group by fails if subselect-column is involved
1121 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Regression: Group by fails if subselect-column is involved
1122 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect full join result with ROW_NUMBER() Function in CTE
1123 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes while converting an overscaled numeric to a string
1124 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong parameters order in trace output
1125 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad optimization of OR predicates applied to unions
1126 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
wrong resultset (subquery + derived table + union)
1127 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Server crashes when executing sql query "delete from mytable order by id desc rows 2"
1128 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EXECUTE BLOCK prepare fails
1129 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO does not work with x-prefixed literals
1130 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
SIMILAR TO does not work with x-prefixed literals
1131 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EXECUTE BLOCK execution cause server crash
1132 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
COMPUTED BY field is evaluated as NULL if used as an exception parameter directly
1133 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression index may be not used for derived fields or view fields
1134 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Metadata source becomes wrong after twice transliteration to the metadata charset
1135 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Metadata source becomes wrong after twice transliteration to the metadata charset
1136 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Metadata export with isql (option -ex) does not export functions properly
1137 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
Metadata export with isql (option -ex) does not export functions properly
1138 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
1139 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Using COLLATE UNICODE_CI_AI in WHERE clause (not indexed) is extremely slow
1140 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
gbak -r fails in restoring all stored procedures/functions in packages
1141 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P     E    
gbak -r fails in restoring all stored procedures/functions in packages
1142 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes instead of reporting the error "key size exceeds implementation restriction"
1143 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error when processing an empty data set by window function, if reading indexed
1144 CS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
In SS sweep blocks establishment of concurrent attachments
1145 SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P