0. Total results for each kind of outcome and server mode
1. ERRORS MAP: distribution of Firebird errors which occured during runs (12 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 (41 rows)
6. Has runtime errors: tests with at least one runtime error for previous runs (152 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (0 rows)
[CURRENT] 8. All tests: outcomes (2369 rows)
9. All tests: durations (4532 rows)
A. Skipped: tests which was intentionally excluded from execution (5 rows)

Generated 19.10.2021 11:36
Tested: FB50.   Build: 5.0.0.259;   SS: 19.10.21 07:02:16 - 19.10.21 09:29:34;   CS: 19.10.21 09:31:59 - 19.10.21 11:34:07;
OS and hardware info:  Windows 2008ServerR2 6.1.7601 ; logical CPUs: 4 ; total memory: 8.0 Gb 
Loading data. Please wait...

Outcomes for the whole set of tests in the last 30 runs: <
NN Test name mode 5.0.0.259
2021-10-19
5.0.0.257
2021-10-15
5.0.0.253
2021-10-13
5.0.0.249
2021-10-12
5.0.0.245
2021-10-10
5.0.0.244
2021-10-08
5.0.0.243
2021-10-06
5.0.0.242
2021-10-05
5.0.0.241
2021-10-03
5.0.0.240
2021-10-01
5.0.0.236
2021-09-30
5.0.0.232
2021-09-29
5.0.0.231
2021-09-28
5.0.0.229
2021-09-26
5.0.0.228
2021-09-23
5.0.0.220
2021-09-22
5.0.0.219
2021-09-20
5.0.0.218
2021-09-19
5.0.0.215
2021-09-17
5.0.0.212
2021-09-16
5.0.0.208
2021-09-15
5.0.0.202
2021-09-14
5.0.0.198
2021-09-12
5.0.0.197
2021-09-11
5.0.0.196
2021-09-10
5.0.0.193
2021-09-09
5.0.0.192
2021-09-08
5.0.0.187
2021-09-07
5.0.0.186
2021-09-04
5.0.0.181
2021-09-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 ALL P P P P P P 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 ALL P P P P P P 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
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
Navigation vs IS NULL vs compound index
6 ALL P P P P P P 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
7 ALL P P P P P P 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)
8 ALL P P P P P P 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
9 ALL P P P P P P 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
10 ALL P P P P P P 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
11 ALL P P P P P P 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
12 ALL P P P P P P 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
13 ALL P P P P P P 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
14 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Index bug
15 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Index bug
16 ALL P P P P P P 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
17 ALL P P P P P P 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
18 ALL P P P P P P 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
19 ALL P P P P P P 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
20 ALL P P P P P P 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
21 ALL P P P P P P 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
22 ALL P P P P P P 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
23 ALL P P P P P P 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
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
Expression evaluation not supported on LEFT JOIN
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
numeric div in dialect 3 mangles data
26 ALL P P P P P P 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
27 ALL P P P P P P 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
28 ALL P P P P P P 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'
29 ALL P P P P P P 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
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
Sqlsubtype incorrect on timestamp math, constant arithmetic
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
Query using VIEW with UNION causes crash
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
cannot specify PLAN in UPDATE statement
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
DB crashes if trigger BU deletes own row
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
trigger on view with union receive nulls
35 ALL P P P P P P 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
36 ALL P P P P P P 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
37 ALL P P P P P P 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
38 ALL P P P P P P 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
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
Empty column names with aggregate funcs
40 ALL P P P P P P 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
41 ALL P P P P P P 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
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
CHECK constraints fire twice
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
CS server crash altering SP in 2 connect
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
SELECT...HAVING...NOT IN crashes server
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
Count ( DISTINCT ... ) is too slow
46 SS P P P P P P P P P P P     F     P P P P P P P P P P P P P P P P P P
Count ( DISTINCT ... ) is too slow
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
Too many grants lose privileges
48 ALL P P P P P P 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
49 ALL P P P P P P 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
50 ALL P P P P P P 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
51 ALL P P P P P P 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
52 ALL P P P P P P 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.
53 ALL P P P P P P 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
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
DateTime math imprecision
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
bug #910430 ISQL and database dialect
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
Complex view crashes server
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
NULLS FIRST does not work with unions
58 ALL P P P P P P 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
59 ALL P P P P P P 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
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
JOIN including a complex view kills the server
61 ALL P P P P P P 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
62 ALL P P P P P P 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
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
Grants overwrite previous rdb$security_classes entries
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
Foreign key relation VARCHAR <-> INT
65 ALL P P P P P P 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()
66 ALL P P P P P P 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
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
Permissions are checked case-insensitively
68 ALL P P P P P P 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
69 ALL P P P P P P 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
70 ALL P P P P P P 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
71 ALL P P P P P P 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
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
SKIP is off by one
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
ORDER BY on a VIEW turns values in fields into NULL
74 ALL P P P P P P 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
75 ALL P P P P P P 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
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
Blob Type 1 compatibility with VarChar
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
User Account maintanance in SQL
78 ALL P P P P P P 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
79 ALL P P P P P P 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
80 ALL P P P P P P 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
81 ALL P P P P P P 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
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
Privileges of dynamic statements in SP
83 ALL P P P P P P 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
84 ALL P P P P P P 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
85 ALL P P P P P P 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'
86 ALL P P P P P P 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
87 ALL P P P P P P 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
88 ALL P P P P P P 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
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
Aggregates in the WHERE clause vs derived tables
90 ALL P P P P P P 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
91 ALL P P P P P P 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
92 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
93 ALL P P P P P P 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
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
Engine crashes while trying to backup a logically corrupt db
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
Incorrect handling of null within view - returns 0
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
problem when dropping column that is a primary key
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
Dependencies are not cleared when creation of expression index fails
98 ALL P P P P P P 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
99 ALL P P P P P P 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
100 ALL P P P P P P 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
101 ALL P P P P P P 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
102 ALL P P P P P P 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
103 ALL P P P P P P 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
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
Problems with explicit cursors in unwanted states
105 ALL P P P P P P 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
106 ALL P P P P P P 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
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
Garbage in plan output of complex statement
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
An attempt to select DB_KEY from a procedure crashes the server
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
ALL predicate works incorrectly for some subqueries
110 ALL P P P P P P 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
111 ALL P P P P P P 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
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
Comment in create database
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
Bad error message when tring to create FK to non-existent table
114 ALL P P P P P P 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
115 ALL P P P P P P 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
116 ALL P P P P P P 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
117 ALL P P P P P P 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
118 ALL P P P P P P 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
119 ALL P P P P P P 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
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
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset
121 ALL P P P P P P 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
122 ALL P P P P P P 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
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
Incorrect results when left join on subquery with constant column
124 ALL P P P P P P 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
125 ALL P P P P P P 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)
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
DISTINCT vs NULLS LAST clause: wrong order of NULLs
127 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
128 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
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
Restoring RDB$BASE_FIELD for expression
130 ALL P P P P P P 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
131 ALL P P P P P P 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
132 ALL P P P P P P 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
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
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
134 ALL P P P P P P 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
135 ALL P P P P P P 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)
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
like doesn't work for computed values (at least in a view)
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
extend retutnning support added in ver 2 in update record of table and in updateble view
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
Wrong single-segment ascending index on character field with NULL and empty string values
139 ALL P P P P P P 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
140 ALL P P P P P P 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
141 ALL P P P P P P 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
142 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Server hangs eating CPU and performs huge I/O copying different codepage fields
143 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Server hangs eating CPU and performs huge I/O copying different codepage fields
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
SINGULAR buggy when nulls present
145 ALL P P P P P P 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
146 ALL P P P P P P 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
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
User (not SYSDBA) what have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA
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
Wrong ordering with views, distinct, left join and order by
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
Error msg "Could not find UNIQUE INDEX" when in fact one is present
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
Support BETWEEN predicate for select expressions
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
Wrong results with GROUP BY on constants
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
Crash when dealing with a string literal longer than 32K
153 ALL P P P P P P 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)
154 ALL P P P P P P 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
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
Recursive Query bug in FB2.1
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
UNION vs UTF8 literals : arithmetic exception is thrown
157 ALL P P P P P P 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>)
158 ALL P P P P P P 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
159 ALL P P P P P P 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
160 ALL P P P P P P 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
161 ALL P P P P P P 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
162 ALL P P P P P P 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
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
cannot erase a table with check constraints referencing more than a single columns
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
Activating index change "STARTING" working as "LIKE" in join condition
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
Prepare fails when having a parameter in a DSQL statement before a sub query
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
Problem altering numeric field type
167 ALL P P P P P P 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
168 ALL P P P P P P 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
169 ALL P P P P P P 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
170 ALL P P P P P P 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
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
Expression index based on computed fields
172 ALL P P P P P P 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
173 ALL P P P P P P 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
174 ALL P P P P P P 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
175 ALL P P P P P P 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
176 ALL P P P P P P 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
177 ALL P P P P P P 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
178 ALL P P P P P P 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
179 ALL P P P P P P 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
180 ALL P P P P P P 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
181 ALL P P P P P P 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>
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
Incorrect column values with outer joins and views
183 ALL P P P P P P 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
184 ALL P P P P P P 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
185 ALL P P P P P P 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
186 ALL P P P P P P 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
187 ALL P P P P P P 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
188 ALL P P P P P P 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
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
Table columns hide destination variables of RETURNING INTO
190 ALL P P P P P P 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
191 ALL P P P P P P 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
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
Ceation of invalid procedures/triggers allowed
193 ALL P P P P P P 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
194 ALL P P P P P P 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
195 ALL P P P P P P 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)
196 ALL P P P P P P 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
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
Bad optimization of queries with DB_KEY
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
Indices not used for views
199 ALL P P P P P P 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
200 ALL P P P P P P 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
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
Data type unknown
202 ALL P P P P P P 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
203 ALL P P P P P P 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
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
size of alias name in a table
205 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Charset transliterations don't work with EXECUTE STATEMENT
206 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Charset transliterations don't work with EXECUTE STATEMENT
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
Joins with NULL RDB$DB_KEY crash the server
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
Problem with view , computed field and functions
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
Bug with a simple case and a subquery
210 ALL P P P P P P 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
211 ALL P P P P P P 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
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
TYPE OF COLUMN in PSQL
213 ALL P P P P P P 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
214 ALL P P P P P P 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
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
ISQL crash when converted-from-double string longer than 23 bytes
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
French insensitive collation FR_FR_CI_AI
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
Execute block fails within execute statement
218 ALL P P P P P P 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
219 ALL P P P P P P 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.
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
Domain names and charset issues
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
Invalid parameter type when using it in CHAR_LENGTH function
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
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
223 ALL P P P P P P 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
224 ALL P P P P P P 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
225 ALL P P P P P P 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
226 ALL P P P P P P 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
227 ALL P P P P P P 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
228 ALL P P P P P P 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
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
Wrong current timestamp evaluation for selectable procedures
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
Incorrect timestamp substraction in 3 dialect when result is negative number
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
Greek characters in cp1251 vs uppercasing
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
Collation not propagated between record formats
233 ALL P P P P P P 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
234 ALL P P P P P P 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
235 ALL P P P P P P 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....
236 ALL P P P P P P 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
237 ALL P P P P P P 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
238 ALL P P P P P P 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
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
Server crash caused by a buffer overrun in the optimizer when more than 255 relation references exist in the query
240 ALL P P P P P P 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
241 ALL P P P P P P 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
242 ALL P P P P P P 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
243 ALL P P P P P P 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
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
Server crash with isc_dsql_execute_immediate and zero length string
245 ALL P P P P P P 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
246 ALL P P P P P P 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))
247 ALL P P P P P P 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])
248 ALL P P P P P P 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
249 ALL P P P P P P 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
250 ALL P P P P P P 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
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
Inconsistent DATEDIFF behaviour
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
Computed field + index not working in WHERE
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
Functions DATEDIFF does not work in dialect 1
254 ALL P P P P P P 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
255 ALL P P P P P P 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%'
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
RDB$procedures generator overflow
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
Subquery-based predicates are not evaluated early in the join order
258 ALL P P P P P P 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
259 ALL P P P P P P 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
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
AV when all statements are cancelled
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
select ... where ... <> ALL (select ... join ...) bug
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
'select ...from...where...not in (select...from...)' no results
263 ALL P P P P P P 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
264 ALL P P P P P P 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
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
Multiple Rows in Singleton Select not reported in a View
266 ALL P P P P P P 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
267 ALL P P P P P P 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.
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
Altering procedure parameters can lead to unrestorable database
269 ALL P P P P P P 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
270 ALL P P P P P P 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
271 ALL P P P P P P 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
272 ALL P P P P P P 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
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
Some aggregate functions does NOT support NULL-constant in 3-d dialect
274 ALL P P P P P P 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
275 ALL P P P P P P 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
276 ALL P P P P P P 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
277 ALL P P P P P P 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
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
AV when recursive query used MERGE JOIN in execution plan
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
Infinite row generation in "select gen_id(..) from rdb$database" with "group by"
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
Ability to format UUID from char(16) OCTETS to human readable form and vice versa
281 ALL P P P P P P 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
282 ALL P P P P P P 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.
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
arithmetic exception, numeric overflow, or string truncation in utf8 tables
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
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
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
Bug in create/alter Database trigger (with Russian comment)
286 ALL P P P P P P 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
287 ALL P P P P P P 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
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
Wrong variable initialization in recursive procedures
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
Common table expressions cannot be used in computed columns and quantified predicates (IN / ANY / ALL)
290 ALL P P P P P P 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 restore a database with inactive indices if any SP/trigger contains an explicit plan
291 ALL P P P P P P 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
292 ALL P P P P P P 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
293 ALL P P P P P P 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
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
Include information about context variables into the monitoring tables
295 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Results of a join with different collations depend on the execution plan
296 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Results of a join with different collations depend on the execution plan
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
Support hex numeric and string literals
298 ALL P P P P P P 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
299 ALL P P P P P P 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
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
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT
301 ALL P P P P P P 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
302 ALL P P P P P P 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
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
Server crashes on SQL script
304 ALL P P P P P P 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
305 ALL P P P P P P 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
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
Maximum key size using PXW_CSY collation
307 ALL P P P P P P 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
308 ALL P P P P P P 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"
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
Index is not used for some date/time expressions in dialect 1
310 ALL P P P P P P 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
311 ALL P P P P P P 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
312 ALL P P P P P P 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
313 ALL P P P P P P 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
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
AV when sorting by field, calculated using recursive CTE
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
If some VIEW used derived tables and long table namesliases, It is possible to overflow RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME
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
DEFAULT values are unnecessary evaluated
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
Some standard calls show server installation directory to regular users
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
Allow index walk (ORDER plan) when there is a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B
319 ALL P P P P P P 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
320 ALL P P P P P P 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
321 ALL P P P P P P 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
322 ALL P P P P P P 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
323 ALL P P P P P P 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
324 ALL P P P P P P 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
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
Circular dependencies between computed fields crashs the engine
326 ALL P P P P P P 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
327 ALL P P P P P P 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
328 ALL P P P P P P 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
329 ALL P P P P P P 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
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
SIMILAR TO character classes are incorrectly recognized
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
The log(base, number) built-in function doesn't check parameters and delivers NAN values instead.
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
GROUP BY RAND() returns infinite rows
333 ALL P P P P P P 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
334 ALL P P P P P P 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
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
Incorrect extraction of MILLISECONDs
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
Set the fixed and documented check order for WHERE clause and other conditional sentences
337 ALL P P P P P P 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.
338 ALL P P P P P P 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
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
UTF8 UNICODE_CI collate can?t be used in foreing key constraint
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
bad BLR -- invalid stream for union select
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
Broken foreign key handling for multi-segmented index using multi-level collations
342 ALL P P P P P P 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
343 ALL P P P P P P 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
344 ALL P P P P P P 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
345 ALL P P P P P P 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
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
SUBSTRING with regular expression (SIMILAR TO) capability
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
NOT NULL procedure parameters
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
I/O statistics for stored procedures are not accounted in monitoring tables
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
Only one client can access a readonly database
350 ALL P P P P P P 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)
351 ALL P P P P P P 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"
352 ALL P P P P P P 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
353 ALL P P P P P P 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
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
Null in the first record in a condition on rdb$db_key
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
Stored procedure recursively called by calculated field fails after reconnect
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
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT
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
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining
358 ALL P P P P P P 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
359 ALL P P P P P P 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
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
connection lost to database when used AUTONOMOUS TRANSACTION
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
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
362 ALL P P P P P P 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
363 ALL P P P P P P 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
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
ALTER VIEW WITH CHECK OPTION crashes the engin
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
GROUP by and RDB$DB_KEY problems
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
Comparision with IN and subquery with RDB$DB_KEY returns wrong result
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
Incorrect VIEW expansion when RDB$DB_KEY is used in view body
368 ALL P P P P P P 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
369 ALL P P P P P P 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
370 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Suboptimal join plan if there are selective non-indexed predicates involved
371 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Suboptimal join plan if there are selective non-indexed predicates involved
372 ALL P P P P P P 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
373 ALL P P P P P P 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
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
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor
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
Query plan is missing for the long query
376 ALL P P P P P P 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
377 ALL P P P P P P 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
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
Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate
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
Error messages after parameters substitution contains '8' characters instead of line break
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
SIMILAR TO predicate hangs with "|" option
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
Join of SP with view or table may fail with "No current record for fetch operation"
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
error in operator "and" in as clausule where
383 ALL P P P P P P 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
384 ALL P P P P P P 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
385 ALL P P P P P P 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
386 ALL P P P P P P 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
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
RDB$VIEW_RELATIONS is not cleaned when altering a view
388 ALL P P P P P P 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
389 ALL P P P P P P 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
390 ALL P P P P P P 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
391 ALL P P P P P P 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
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
Nbackup as online dump
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
Problem with column names with Accents and triggers
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
Implement domain check of input parameters of execute block
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
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
396 ALL P P P P P P 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.
397 ALL P P P P P P 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
398 ALL P P P P P P 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
399 ALL P P P P P P 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
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
internal Firebird consistency check when alter dependent procedures
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
internal error when select upper(<blob>) from union
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
ALTER DOMAIN with dependencies may leave a transaction handle in inconsistent state causing segmentation faults
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
Grouping by function doesn't work properly
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
GFIX causes BUGCHECK errors with non valid transaction numbers
405 ALL P P P P P P 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
406 ALL P P P P P P 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
407 ALL P P P P P P 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
408 ALL P P P P P P 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 ...)
409 ALL P P P P P P 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
410 ALL P P P P P P 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
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
Include PLAN in mon$statements
412 ALL P P P P P P 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
413 ALL P P P P P P 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
414 ALL P P P P P P 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
415 ALL P P P P P P 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
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
select * from (select cast(.... returns null
417 ALL P P P P P P 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
418 ALL P P P P P P 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
419 ALL P P P P P P 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
420 ALL P P P P P P 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
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
Incorrect handling of LOWER/UPPER when result string shrinks in terms of byte length
422 ALL P P P P P P 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
423 ALL P P P P P P 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..
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
ALTER TRIGGER / PROCEDURE wrong error message
425 ALL P P P P P P 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
426 ALL P P P P P P 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
427 ALL P P P P P P 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
428 ALL P P P P P P 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
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
AV preparing a query with aggregate over derived table
430 ALL P P P P P P 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
431 ALL P P P P P P 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
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
Alter table not respecting collation
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
ALTER VIEW doesn't clear dependencies on old views
434 ALL P P P P P P 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
435 ALL P P P P P P 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
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
CREATE USER command: Invalid error message
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
Server crashes on UPDATE OR INSERT statement
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
Query SELECT ... WHERE ... IN (SELECT DISTINCT ... ) returns a wrong result set.
439 ALL P P P P P P 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
440 ALL P P P P P P 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
441 ALL P P P P P P 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
442 ALL P P P P P P 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
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
Success message when connecting to tiny trash database file
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
Append the IP address of the remote host to error messages in firebird.log for TCP connections
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
Implementation limit of DISTINCT items are not enforced, causing generation of incorrect BLR
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
Binary shift functions give wrong results with negative shift values
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
Built-in trigonometric functions can produce NaN and Infinity
448 ALL P P P P P P 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
449 ALL P P P P P P 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
450 ALL P P P P P P 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
451 ALL P P P P P P 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'
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
CI column does not group correctly with a second column
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
Maximum and minimum identifier length should be enforced by DSQL
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
internal error [335544384]
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
The server crashes when selecting from the MON$ tables in the ON DISCONNECT trigger
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
select rdb$db_key from a view with a more than 1 table joined, results in conversion error
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
Parameters and variables cannot be used as expressions in EXECUTE PROCEDURE parameters without a colon prefix
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
Infinity should not escape from the engine
459 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
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
Wrong results for CASE used together with GROUP BY
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
Attachments using NONE charset may cause reads from MON$ tables to fail
462 ALL P P P P P P 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
463 ALL P P P P P P 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
464 ALL P P P P P P 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
465 ALL P P P P P P 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
466 ALL P P P P P P 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
467 ALL P P P P P P 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
468 ALL P P P P P P 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
469 ALL P P P P P P 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
470 ALL P P P P P P 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
471 ALL P P P P P P 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
472 ALL P P P P P P 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
473 ALL P P P P P P 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)
474 ALL P P P P P P 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
475 ALL P P P P P P 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
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
Common table expression context could be used with parameters
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
Do not print "invalid request BLR" for par.cpp errors with valid BLR
478 ALL P P P P P P 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
479 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
480 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
481 ALL P P P P P P 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
482 ALL P P P P P P 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
483 ALL P P P P P P 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
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
Recursive EXECUTE STATEMENT works wrong
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
isql hangs when trying to show a view based on a procedure
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
Naive metadata extraction code in isql is defeated by "check" keyword typed in mixed case
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
SIMILAR TO works wrongly
488 ALL P P P P P P 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
489 ALL P P P P P P 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
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
Error "page 0 is of wrong type (expected 6, found 1)" is thrown while accessing a non-corrupted table
491 ALL P P P P P P 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
492 ALL P P P P P P 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
493 ALL P P P P P P 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
494 ALL P P P P P P 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
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
isql extracts the array dimensions after the character set name
496 ALL P P P P P P 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
497 ALL P P P P P P 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
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
Incomplete plan output (lack of view names) when selecting from views containing procedures inside
499 ALL P P P P P P 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
500 ALL P P P P P P 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)
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
Views based on procedures can't be created if the proc's output fields participate in an expression
502 ALL P P P P P P 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
503 ALL P P P P P P 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
504 ALL P P P P P P 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
505 ALL P P P P P P 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
506 ALL P P P P P P 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.
507 ALL P P P P P P 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
508 ALL P P P P P P 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
509 ALL P P P P P P 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
510 ALL P P P P P P 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
511 ALL P P P P P P 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
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
Outer ORDER BY clause has no effect
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
EVL_expr: invalid operation (232)
514 ALL P P P P P P 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
515 ALL P P P P P P 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)
516 ALL P P P P P P 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
517 ALL P P P P P P 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
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
A memory corruption cause incorrect query evaluation and may crash the server
519 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
520 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
521 ALL P P P P P P 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
522 ALL P P P P P P 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
523 ALL P P P P P P 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.
524 ALL P P P P P P 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
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
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
526 ALL P P P P P P 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
527 ALL P P P P P P 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
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
Incorrect execution of volatile SQL statements inside EXECUTE STATEMENT
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
Character set used in constants is not registered as dependency
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
Problem with dependencies between a procedure and a view using that procedure
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
"Invalid ESCAPE sequence" when connecting to the database
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
DROP VIEW drops output parameters of used stored procedures
533 ALL P P P P P P 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
534 ALL P P P P P P 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
535 ALL P P P P P P 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
536 ALL P P P P P P 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
537 ALL P P P P P P 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
538 ALL P P P P P P 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
539 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
540 ALL P P P P P P 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
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
Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" error
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
Unexpected "Invalid SIMILAR TO pattern" error
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
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
544 ALL P P P P P P 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)
545 ALL P P P P P P 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
546 ALL P P P P P P 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
547 ALL P P P P P P 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"
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
Procedure suspend check may cause restore to fail
549 ALL P P P P P P 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
550 ALL P P P P P P 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
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
Error "no current record for fetch operation" after ALTER VIEW
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
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
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
Wrong resultset
554 ALL P P P P P P 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)
555 ALL P P P P P P 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
556 ALL P P P P P P 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
557 ALL P P P P P P 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
558 ALL P P P P P P 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
559 ALL P P P P P P 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
560 ALL P P P P P P 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
561 ALL P P P P P P 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
562 ALL P P P P P P 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
563 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Better performance for (table.field = :param or :param = -1) in where clause
564 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Better performance for (table.field = :param or :param = -1) in where clause
565 ALL P P P P P P 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
566 ALL P P P P P P 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
567 ALL P P P P P P 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
568 ALL P P P P P P 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
569 ALL P P P P P P 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
570 ALL P P P P P P 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
571 ALL P P P P P P 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
572 ALL P P P P P P 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
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
Cannot alter the domain after migrating from older versions
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
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT. See also: CORE-3283
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
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
576 ALL P P P P P P 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
577 ALL P P P P P P 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
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
The last column in a view is returning as a null value even when it's not
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
Parameterized requests involving blob fields fails when connected using charset UTF8
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
exclude_filter doesn't work for <services></section> section of the Trace facility
581 ALL P P P P P P 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
582 ALL P P P P P P 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
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
View with "subselect" column join table and not use index
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
ALTER VIEW with not matched columns in declaration and selection crashs the server
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
page 0 is of wrong type (expected 6, found 1)
586 ALL P P P P P P 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)
587 ALL P P P P P P 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
588 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     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
589 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     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
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
String truncation occurs when selecting from a view containing NOT IN inside
591 ALL P P P P P P 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
592 ALL P P P P P P 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
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
RIGHT() fails with multibyte text blobs > 1024 chars
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
OVERLAY() fails when used with text BLOBs containing multi-byte chars
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
LIKE, STARTING and CONTAINING fail if second operand >= 32K
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
Support for text BLOBs >= 32K as first argument for TRIM()
597 ALL P P P P P P 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
598 ALL P P P P P P 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
599 ALL P P P P P P 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
600 ALL P P P P P P 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
601 ALL P P P P P P 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
602 ALL P P P P P P 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
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
Error "request depth exceeded" may appear while preparing a select query against a view with explicit plan
604 ALL P P P P P P 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
605 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Wrong result for RIGHT(UTF8 varchar)
606 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Wrong result for RIGHT(UTF8 varchar)
607 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
EXECUTE STATEMENT parses the SQL text using wrong charset
608 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
EXECUTE STATEMENT parses the SQL text using wrong charset
609 ALL P P P P P P 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
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
New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction that created a record version
611 ALL P P P P P P 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
612 ALL P P P P P P 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
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
"BLOB not found" error after creation/altering of the invalid trigger
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
Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure
615 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
RDB$GET_CONTEXT and between in view
616 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
RDB$GET_CONTEXT and between in view
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
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
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
Sub-optimal join plan when the slave table depends on the master one via the OR predicate
619 ALL P P P P P P 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
620 ALL P P P P P P 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
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
Client writes error messages into firebird.log when database is shutted down
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
Server crashes while recreating the table with a NULL -> NOT NULL change
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
Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments
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
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
625 ALL P P P P P P 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)
626 ALL P P P P P P 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
627 ALL P P P P P P 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
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
Wrong comparsion of DATE and TIMESTAMP if index is used
629 ALL P P P P P P 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
630 ALL P P P P P P 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
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
Cursors should ignore changes made by the same statement
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
Cursors should ignore changes made by the same statement
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
Blob filter to translate internal debug info into text representation
634 ALL P P P P P P 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
635 ALL P P P P P P 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)
636 ALL P P P P P P 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
637 ALL P P P P P P 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
638 ALL P P P P P P 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
639 ALL P P P P P P 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
640 ALL P P P P P P 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
641 ALL P P P P P P 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
642 ALL P P P P P P 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
643 ALL P P P P P P 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
644 ALL P P P P P P 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
645 ALL P P P P P P 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
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
[FB3] AV with "UPDATE OR INSERT"
647 ALL P P P P P P 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
648 ALL P P P P P P 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
649 ALL P P P P P P 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
650 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Lateral derived tables
651 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Lateral derived tables
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
Allow conversion from/to BLOBs and others types in the API functions (XSQLVAR or blr messages)
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
Collation is not installed with icu > 4.2
654 ALL P P P P P P 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)
655 ALL P P P P P P 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
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
DDL operations fail after backup/restore
657 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Regression in joins on procedures
658 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Regression in joins on procedures
659 ALL P P P P P P 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
660 ALL P P P P P P 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
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
ASCII_VAL raises error instead of return 0 for empty strings
662 ALL P P P P P P 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
663 ALL P P P P P P 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
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
Altering of a TYPE OF COLUMN parameter affects the original column
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
Adding a value to a timestamp below '16.11.1858 00:00:01' throws 'value exceeds the range for valid timestamp'
666 ALL P P P P P P 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
667 ALL P P P P P P 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
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
Alter procedure allows to add the parameter with the same name
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
Unquoted role names with non-ASCII characters passed in DPB are upper-cased wrongly
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
Server crash with built in function LPAD with string as second parameter
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
SIMILAR TO: False matches on descending ranges
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
Support for WHEN SQLSTATE
673 ALL P P P P P P 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"
674 ALL P P P P P P 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
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
Inconsistent domain's constraint validation in PSQL
676 ALL P P P P P P 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
677 ALL P P P P P P 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
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
GFIX returns an error after correctly shutting down a database
679 ALL P P P P P P 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
680 ALL P P P P P P 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
681 ALL P P P P P P 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 during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
682 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
AV in engine when preparing query against dropping table
683 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
AV in engine when preparing query against dropping table
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
CHAR(32767) present in XSQLVAR with length 32765
685 ALL P P P P P P 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
686 ALL P P P P P P 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
687 ALL P P P P P P 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
688 ALL P P P P P P 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
689 ALL P P P P P P 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
690 ALL P P P P P P 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
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
Wrong data while retrieving from CTEs (or derived tables) with same column names
692 ALL P P P P P P 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
693 ALL P P P P P P 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()
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
Window Function: ntile(num_buckets integer)
695 ALL P P P P P P 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)
696 ALL P P P P P P 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
697 ALL P P P P P P 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 use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
698 ALL P P P P P P 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
699 ALL P P P P P P 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
700 ALL P P P P P P 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
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
computed index by substring function for long columns
702 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
CREATE INDEX considers NULL and empty string being the same in compound indices
703 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
CREATE INDEX considers NULL and empty string being the same in compound indices
704 ALL P P P P P P 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
705 ALL P P P P P P 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
706 ALL P P P P P P 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
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
Missing constraint name in foreign key error message in FB 2.1.4
708 ALL P P P P P P 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
709 ALL P P P P P P 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
710 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
String truncation error when selecting from a VIEW with UNION inside
711 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
String truncation error when selecting from a VIEW with UNION inside
712 ALL P P P P P P 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
713 ALL P P P P P P 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
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
GBAK fails to fix system generators while restoring
715 ALL P P P P P P 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
716 ALL P P P P P P 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
717 ALL P P P P P P 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
718 ALL P P P P P P 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
719 ALL P P P P P P 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
720 ALL P P P P P P 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
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
Conversion error when using a blob as an argument for the EXCEPTION statement
722 ALL P P P P P P 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
723 ALL P P P P P P 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
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
fb server die when carry out the LEFT + INNER JOIN
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
with caller privileges option do not work with autonomous transaction option
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
Warnings could be put twice in status-vector
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
Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause
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
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
729 ALL P P P P P P 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 *)
730 ALL P P P P P P 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
731 ALL P P P P P P 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
732 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Bad alias table choice joining CTE
733 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Bad alias table choice joining CTE
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
Usage of a NATURAL JOIN with a derived table crashes the server
735 ALL P P P P P P 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
736 ALL P P P P P P 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
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
Trace API: Faulty database filter crashes server
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
Computed column appears in non-existant rows of left join
739 ALL P P P P P P 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
740 ALL P P P P P P 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
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
Server crashes on preparing empty query when trace is enabled
742 ALL P P P P P P 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
743 ALL P P P P P P 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
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
row_number(), rank() and dense_rank() return BIGINT datatype in dialect 1
745 ALL P P P P P P 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
746 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Improve SIMILAR TO performance
747 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Improve SIMILAR TO performance
748 ALL P P P P P P 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
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
Creating self-referential FK crashes database (bug-check) whether constraint violation had place
750 ALL P P P P P P 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
751 ALL P P P P P P 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)
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
DeActivate/Activate INDEX or RESTORE not possible with NULL in unique index.
753 ALL P P P P P P 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
754 ALL P P P P P P 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
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
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)
756 ALL P P P P P P 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
757 ALL P P P P P P 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
758 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Creating a procedure containing "case when" expression leads to a server crash
759 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Creating a procedure containing "case when" expression leads to a server crash
760 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Creating a stored procedure with an "update or insert" statement with MATCHING fails
761 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Creating a stored procedure with an "update or insert" statement with MATCHING fails
762 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
subselect with reference to outer select fails
763 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
subselect with reference to outer select fails
764 ALL P P P P P P 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
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
Original table name and column name and owner missing from SQLDA for aliased column in grouped query
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
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
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
"attempted update of read-only column" when trying update editable view without triggers
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
No records in the table rdb$dependencies for ddl trigger
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
Join using RDB$DB_KEY produce NATURAL plan
770 ALL P P P P P P 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
771 ALL P P P P P P 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
772 ALL P P P P P P 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
773 ALL P P P P P P 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
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
using a result from a procedure in a substring expression leads to server crash
775 ALL P P P P P P 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
776 ALL P P P P P P 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
777 ALL P P P P P P 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
778 ALL P P P P P P 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
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
role not passed on external execute stmt
780 ALL P P P P P P 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)
781 ALL P P P P P P 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
782 ALL P P P P P P 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
783 ALL P P P P P P 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
784 ALL P P P P P P 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
785 ALL P P P P P P 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
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
Computed by columns and position function
787 ALL P P P P P P 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
788 ALL P P P P P P 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
789 ALL P P P P P P 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
790 ALL P P P P P P 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)
791 ALL P P P P P P 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
792 ALL P P P P P P 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
793 ALL P P P P P P 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
794 ALL P P P P P P 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
795 ALL P P P P P P 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
796 ALL P P P P P P 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)
797 ALL P P P P P P 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"
798 ALL P P P P P P 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
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
SIMILAR TO does not work with x-prefixed literals
800 ALL P P P P P P 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
801 ALL P P P P P P 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
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
Expression index may be not used for derived fields or view fields
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
Metadata source becomes wrong after twice transliteration to the metadata charset
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
Metadata export with isql (option -ex) does not export functions properly
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
Firebird crash when executing an stored procedure called by a trigger that converts string to upper
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
Using COLLATE UNICODE_CI_AI in WHERE clause (not indexed) is extremely slow
807 ALL P P P P P P 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
808 ALL P P P P P P 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"
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
Error when processing an empty data set by window function, if reading indexed
810 ALL P P P P P P 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
811 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sharp-S character treated incorrectly in UNICODE_CI_AI collation
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
Wrong metadata output script generate by isql / CHARACTER SETISO8859_1 sintax error
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
Error "invalid stream" can be raised in some cases while matching a computed index
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
EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset
815 ALL P P P P P P 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 while preparing a query with DISTINCT and ORDER BY
816 ALL P P P P P P 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 (BLR error)" when preparing a query with UNION
817 ALL P P P P P P 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 permission types are not displayed by ISQL
818 ALL P P P P P P 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 routines DDL in Packages wrongly report error for termination with semi-colon
819 ALL P P P P P P 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/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE
820 ALL P P P P P P 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: LIKE with escape does not work
821 ALL P P P P P P 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 exception does not accept not ASCII characters as parameter
822 ALL P P P P P P 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 can not insert records into table with column "generated by default as identity" in its DDL
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
Owner name is missing for generators/exceptions restored from a backup
824 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Replace the hierarchical union execution with the plain one
825 ALL P P P P P P 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
826 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Setting generator value twice in single transaction will set it to zero
827 ALL P P P P P P 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 some boolean expressions not being allowed
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
CREATE COLLATION does not verify base collation charset
829 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Executing empty EXECUTE BLOCK with NotNull output parameter raised error
830 ALL P P P P P P 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 "token unknown" error when the SQL string ends with a hex number literal
831 ALL P P P P P P 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 optional START WITH clause to identity columns
832 ALL P P P P P P 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 uncommitted select of the pseudo table sec$users blocks new database connections
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
Regression: Computed field returns null value inside BI trigger
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
Cannot create packaged routines with [VAR]CHAR parameters
835 ALL P P P P P P 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 compiling the procedure containing the statement if (x = (select ...))
836 ALL P P P P P P 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 -x does not output the START WITH clause of generators/sequences
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
Add RESTART [WITH] clause for alter identity columns
838 ALL P P P P P P 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 output parameters after altering procedures
839 ALL P P P P P P 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 FK on GTT crashes server
840 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GTT should not reference permanent relation
841 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Memory leak with TRIGGER ON TRANSACTION COMMIT
842 ALL P P P P P P 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 database owner to mon$database
843 ALL P P P P P P 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 replace through services API fails
844 ALL P P P P P P 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: Wrong evaluation of BETWEEN and boolean expressions due to parser conflict
845 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bidirectional cursor is not positioned by the first call of FETCH LAST
846 ALL P P P P P P 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 PSQL modules with declared cursors engine could assign value to the wrong variable
847 ALL P P P P P P 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 IF (subfunc()) when subfunc returns a boolean
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
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
849 ALL P P P P P P 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: recursive query in SQL query returns incorrect results if more than one branch bypass
850 ALL P P P P P P 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 creation procedure which contain adding text in DOS864 charset
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
Delete "where current of" cursor fails for tables with newly added fields
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
Add table name to text of validation contraint error message, to help identify error context
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
Parametrized queries using RDB$DB_KEY do not work
854 ALL P P P P P P 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: Wrong boundary for minimum value for BIGINT/DECIMAL(18)
855 ALL P P P P P P 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 result when joined fields are created via row_number() function
856 ALL P P P P P P 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 parsing error with derived tables and CASE functions
857 ALL P P P P P P 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 output when field with result of windowed function is used in query with useless WHERE 0=0 and GROUP BY clause
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 in case of subquery with windowed function + where <field> IN(select ...)
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
Engine crashs in case of re-creation of an erratic package body
860 ALL P P P P P P 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 create table with "CHARACTER SET DOS775" field
861 ALL P P P P P P 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: Stored function accepts duplicate input arguments
862 ALL P P P P P P 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 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed
863 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Choose the best matching index for navigation
864 ALL P P P P P P 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: NOT-null field from derived table became NULL when is referred outside DT
865 ALL P P P P P P 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 ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
866 ALL P P P P P P 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 doesn't recognise sts_record_versions and other sts switches
867 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Inappropriate self-reference of column when using "with check option" with extract(...)
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
Non-ASCII data in SEC$USERS is not read correctly
869 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Lookup (or scan) in descending index could be very inefficient for some keys
870 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
### ADDITIONAL TEST ### Lookup (or scan) in descending index could be very inefficient for some keys
871 ALL P P P P P P 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 when attempt to REcreate table with FK after syntax error before such recreating
872 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Fields present only in WHERE clause of views WITH CHECK OPTION causes invalid CHECK CONSTRAINT violation
873 ALL P P P P P P 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(): change input <amount> argument from INT to BIGINT
874 ALL P P P P P P 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 field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers
875 ALL P P P P P P 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: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
876 ALL P P P P P P 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 when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
877 ALL P P P P P P 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: ISQL does not destroy the SQL statement
878 ALL P P P P P P 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 when use aggregate or window functions in recursive query (instead of producing compiling error)
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
Keyword SET should not be required in ALTER USER statement
880 ALL P P P P P P 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 correct result function LAG, if OFFSET value are assigned from a table
881 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LAG, LEAD and NTH_VALUE raise error when the second argument is NULL
882 ALL P P P P P P 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 -sweep makes "reconnect" when it is removed from mon$attachments by delete command (issued in another window)
883 ALL P P P P P P 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 user can delete records from RDB$SECURITY_CLASSES table
884 ALL P P P P P P 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" when table inner join procedure inner join table
885 ALL P P P P P P 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 trace stored functions execution
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
Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause)
887 ALL P P P P P P 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 default value when adding a new column
888 ALL P P P P P P 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 of recursive query returns error "Column does not belong to referenced table" for source that HAS such column
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
non-priviledged user can insert and update rdb$database
890 ALL P P P P P P 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 derived table which contains GROUP BY on field with literal value returns wrong result
891 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Equality predicate distribution does not work for some complex queries
892 ALL P P P P P P 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 of WHERE predicate when it contains NULL IS NOT DISTINCT FROM (select min(NULL) from ...)
893 ALL P P P P P P 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(177) for MERGE with multiple matches
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
Create function/sp which references to non-existent exception <...>
895 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Duplicate names in package are not checked
896 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Truncation error when using EXECUTE STATEMENT with a blob
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
Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
898 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Preparation of erroneous DDL statement does not show the main command failed
899 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
900 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
901 ALL P P P P P P 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 truncates blob when reading an empty segment
902 ALL P P P P P P 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 line/column information in runtime errors
903 ALL P P P P P P 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 savepoints are not released on commit
904 ALL P P P P P P 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 more details for "object in use" errors
905 ALL P P P P P P 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 may enter an infinite loop for a single record
906 ALL P P P P P P 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 query if it is execute through "execute statement"
907 ALL P P P P P P 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 specify extra-long name of log when doing gbak to avoid "attempt to store 256 bytes in a clumplet" message
908 ALL P P P P P P 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 referencing cursors as record variables in PSQL
909 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Enhancement in precision of calculations with NUMERIC/DECIMAL
910 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Useless extraction of generic DDL trigger
911 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
gbak: cannot commit index ; primary key with german umlaut
912 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
gbak: cannot commit index ; primary key with german umlaut
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
Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn
914 ALL P P P P P P 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 sorting records longer than 128KB
915 ALL P P P P P P 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 crashes when using row_number()over( PARTITION BY x) in ORDER by clause
916 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Rollback to wrong savepoint if several exception handlers on the same level are executed
917 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
User-collations based on UNICODE are not upgrade to newer ICU version on restore
918 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
User-collations based on UNICODE are not upgrade to newer ICU version on restore
919 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Properties of user created in Legacy_UserManager padded with space up to 10 character
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
Extend the use of colon prefix for read/assignment OLD/NEW fields and assignment to variables
921 ALL P P P P P P 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 different hash algorithms in HASH system function
922 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Raise the 1024 connections limit (FD_SETSIZE) on Windows SS/SC
923 ALL P P P P P P 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 without connect when execute command "show version"
924 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
925 ALL P P P P P P 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 output to trace explain plan form.
926 ALL P P P P P P 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 two collations with different names if autoddl OFF in FB 2.5.3
927 ALL P P P P P P 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: NOT NULL constraint, declared in domain, does not work
928 ALL P P P P P P 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 should support fractional value for MILLISECOND
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
Expressions containing some built-in functions may be badly optimized
930 ALL P P P P P P 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 prints error messages to stdout instead stderr
931 ALL P P P P P P 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 it possible to restore compressed .nbk files without explicitly decompressing them
932 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Duplicate tags for CREATE/ALTER USER not handled correctly
933 ALL P P P P P P 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 DROP NOT NULL to ALTER COLUMN
934 ALL P P P P P P 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: CREATE USER GRANT ADMIN ROLE does not work
935 ALL P P P P P P 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 field in SEC$USERS reflecting whether a user has RDB$ADMIN role in security database
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
gbak fails to restore database containing dependency between views and packaged functions
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
Message "Modifying function <F> which is currently in use" when running script with AUTODDL=OFF and <F> is called from INTERNAL function declared in other unit
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
Restore of pre ODS 11.1 database can leave RDB$RELATION_TYPE null
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
Field RDB$MAP_TO_TYPE is not present in RDB$TYPES
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
ISQL issues warning: "Bad debug info format" when connect to database with stored function after it`s restoring
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
Changed data not visible in WHEN-section if exception occured inside SP that has been called from this code
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
Description (COMMENT ON) for package procedures and functions, and its parameters
943 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Maintain package body after ALTER/RECREATE PACKAGE
944 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cursor references must always represent the CURRENT state of the record, without caching when this record is read
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
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
946 ALL P P P P P P 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 not found for RECREATE TRIGGER
947 ALL P P P P P P 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 3.0.x: wrong handling in FOR-cursor when NOT EXISTS( select from <VIEW> ) statement is used to check results obtained from SP
948 ALL P P P P P P 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 3.0 crashes when getting an explained plan for a DBKEY based retrieval
949 ALL P P P P P P 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 command SHOW USERS display only me
950 ALL P P P P P P 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 delete procedure source on Firebird 3.0 Alpha 2.0
951 ALL P P P P P P 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 enable encryption during restore
952 ALL P P P P P P 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 hash/merge joins for non-field (dbkey or derived expression) equalities
953 ALL P P P P P P 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 to use index when GROUP BY on field which has DESCENDING index
954 ALL P P P P P P 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 based join of two tables may be ineffective
955 ALL P P P P P P 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 does not accept the right plan
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
Allow hiding source code of procedures and triggers in FB 3
957 ALL P P P P P P 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 trigger remains active after dropped
958 ALL P P P P P P 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 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN
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
BUGCHECK(183) when use cursor with "order by ID+0" and "for update with lock"
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
Incorrect size of the output parameter/argument when execute block, procedure or function use system field in metadata charset
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
BIN_SHL and BIN_SHR does not work in Dialect 1
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
Wrong error at ALTER PACKAGE
963 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
Can't select from table with ICU column when database (.FDB) is created on LINUX with icu 4.2.1 and then copied to WINDOWS
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
Regression: Incorrect result in subquery with aggregate
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
Regression: Incorrect result in subquery with aggregate
966 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
INPUT file not properly closed
967 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Within linger period one can not change some database properties
968 ALL P P P P P P 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 column check constraint when the column is domain based
969 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Change type of returning value of CHAR_LENGTH, BIT_LENGTH and OCTET_LENGTH of BLOBs to bigint
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
REPLACE function works incorrectly with multibyte charsets
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
EXECUTE STATEMENT rise varchar char_length() size
972 ALL P P P P P P 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 having more than one UserManager in firebird.conf and use them from SQL
973 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Rollback doesn`t undo changes when MERGE statement updates the same target rows multiple times and PLAN MERGE is used
974 ALL P P P P P P 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: Trigger with UPDATE OR INSERT statement and IIF() not working as expected
975 ALL P P P P P P 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: SP "Domain" and "Type Of" based variables referring BLOB with sub_type < 0 no longer work
976 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Regression: ORDER BY via an index + WHERE clause: error "no current record for fetch operation"
977 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Regression: ORDER BY via an index + WHERE clause: error "no current record for fetch operation"
978 ALL P P P P P P 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 (cannot find tip page (165), file: tra.cpp line: 2375)
979 ALL P P P P P P 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 permission for CREATE access to DATABASE (for RDB$ADMIN)
980 ALL P P P P P P 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 on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
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
Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N }
982 ALL P P P P P P 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 mon$table_stats doesn`t work on SC and CS
983 ALL P P P P P P 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 based on a computed column stores NULL for all its keys
984 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
985 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
986 ALL P P P P P P 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: incorrect calculation of byte-length for view columns
987 ALL P P P P P P 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 while preparing a complex query ("Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256")
988 ALL P P P P P P 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 non-DISTINCT affects the result of IN subquery
989 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CTE Aliases ('Column unknown' when recursive CTE contain join with *alias* rather than table name)
990 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
991 ALL P P P P P P 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: Join order in v3 is less optimal than in v2.x
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
ISQL pads blob columns wrongly when the column alias has more than 17 characters
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
Implement ability to validate tables and indices online (without exclusive access to database)
994 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Content of MON$EXPLAINED_PLAN in MON$STATEMENTS is truncated if exceeds the 32KB limit
995 ALL P P P P P P 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 request BLR at offset 361 context already in use (BLR error)
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
"BLOB not found" error at rollback after insert into table with expression index
997 ALL P P P P P P 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 of shadowed database fails using -k ("restore without shadow") switch
998 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Message "Statement failed, SQLSTATE = 00000 + unknown ISC error 0" appears when issuing REVOKE ALL ON ALL FROM <existing_user>
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
Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
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
Provide ability to do: REcreate user <user_name> password <user_pwd>
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
Add a flag to mon$database helping to decide what type of security database is used - default, self or other
1002 ALL P P P P P P 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 an ability to issue DML or DDL statements on RDB$ tables
1003 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Command "Alter table <T> alter TYPE <C> <DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR
1004 ALL P P P P P P 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 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
1005 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code at offset 15, encountered 255"
1006 ALL P P P P P P 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 insensitive comparison: diacritical letters with DIAGONAL crossing stroke pass only test on EQUALITY to their non-accented forms
1007 ALL P P P P P P 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 with quantifier {n,} in the pattern: 1) fails on 2.5 ("Invalid pattern"), 2) strange result in 3.0
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
Granted role does not work with non-ascii username
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
ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used
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
Error "invalid BLOB ID" can occur when retrieving MON$STATEMENTS.MON$SQL_TEXT using ES/EDS and db_connect argument is not specified
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
Can not restore in FB 3.0 SuperServer from .fbk which source .fdb was created on 2.5.4 and moved to READ-ONLY before backed up
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
EXECUTE STATEMENT using BLOB parameters results in "Invalid BLOB ID" error
1013 ALL P P P P P P 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 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles)
1014 ALL P P P P P P 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 exception: wrong output when number of arguments greater than 7
1015 ALL P P P P P P 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 create user with non-ascii (multi-byte) characters in it's name
1016 ALL P P P P P P 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 trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
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
CREATE USER ... TAGS ( attr = 'prefix #suffix' ): suffix will be removed from storage because of character '#' in the value of attribute
1018 ALL P P P P P P 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 ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
1019 CS P P P P P P P P P P P P P P P P P P P P P P P P     F         F         F         F         F         F    
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
1020 SS P P P P P P P P P P P P P P P P P P P P P P P P     F         F         F         F         F         F    
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
1021 ALL P P P P P P 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 string length (32765 bytes) is not validated
1022 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Command `SHOW TABLE` fails when the table contains field with unicode collationin its DDL
1023 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
1024 CS P P P P P P P P P P     F     P P P P P P P P P P P P P P P P P P P
Prohibit ability to cast timestamps that out of valid range to varchar
1025 SS P P P P P P P P P P     F     P P P P P P P P P P P P P P P P P P P
Prohibit ability to cast timestamps that out of valid range to varchar
1026 ALL P P P P P P 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 INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions
1027 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Regression: MIN/MAX with a join ignores possible index navigation
1028 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Regression: MIN/MAX with a join ignores possible index navigation
1029 ALL P P P P P P 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: GRANT UPDATE(<some_column>) on <T> acts like grant update on ALL columns of <T>
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
Regression: generators can be seen/modified by unprivileged users
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
Regression: List of aggregation is not checked properly
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
HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations
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
Make user names behave according to SQL identifiers rules
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
ISQL doesn`t show number of affected rows for "MERGE ... WHEN MATCHING" in case when this number surely > 0
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
EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
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
grant create database to ROLE does not work: "no permission for CREATE access to DATABASE ..."
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
MERGE JOIN cannot be used for DBKEY based expressions
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
Make ISQL display character set when sqlda_display is on
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
Revoke all on all from role <R> -- failed with "SQL role <R> does not exist in security database"
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
Grant update(c) on t to U01 with grant option: user U01 will not be able to `revoke update(c) on t from <user | role>` if this `U01` do some DML before revoke
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
SHOW GRANTS does not display info about exceptions which were granted to user
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
Transactions with isc_tpb_autocommit can hang 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
Make message about missing password being always displayed as reply on attempt to issue CREATE new login without PASSWORD clause
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
Altering a trigger indicating other table than the original does not reflect the change
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     F         F         F         F    
MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
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     F         F         F         F    
MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
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
Online validation during DML activity in other connection leads to message "Error while trying to read from file" and "page in use during flush (210), file: cch.cpp line: 2672"
1048 ALL P P P P P P 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 DATABASE fail with ISQL
1049 ALL P P P P P P 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 when preparing a query with PLAN clause at some CTE
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
Incorrect number of affected rows for UPDATE against VIEW created WITH CHECK OPTION
1051 ALL P P P P P P 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 "similar to" matching
1052 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Minor inconvenience in user management via services API
1053 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Increase speed of creating package when number of its functions more than several hundreds
1054 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Increase maximum string literal length to 64K (bytes) while setting a lower limit (of characters) for multibyte charsets based on their max char. length (UTF-8 literals will be limited to 16383 characters)
1055 ALL P P P P P P 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 input command (or -i option) reads large (> 64K) lines incorrectly
1056 ALL P P P P P P 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 on pasring of script containing `execute block` with lot of nested begin..end statements
1057 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AFTER CREATE/ALTER PACKAGE DDL triggers runs in incorrectly moment
1058 ALL P P P P P P 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 with `action_trace_start` prevents in 3.0 SuperServer from connecting using local protocol
1059 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Speed up function creation and loading when there are many functions in the database
1060 ALL P P P P P P 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 -online: message "IProvider::attachDatabase failed when loading mapping cache" appears in Classic (only) if access uses remote protocol
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
Index corruption when add data in long-key-indexed field
1062 ALL P P P P P P 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 internal BLR filter conversion
1063 ALL P P P P P P 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 / HASH JOINs produce incorrect results when VARCHAR join keys differ only by trailing spaces
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
ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
1065 ALL P P P P P P 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 IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
1066 ALL P P P P P P 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 ability to track domains rename in DDL triggers
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
IIF function prevents the condition from being pushed into the union for better optimization
1068 CS 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 P P P P P
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
1069 SS 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 P P P P P
It is not possible to save the connection information in the ON CONNECT trigger, if the connection is created by the gbak
1070 ALL P P P P P P 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 compile source with "ELSE IF ( <expr> ) THEN" statement and commands to manupulate explicit cursor inside
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
Add better transaction control to isql
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
Different collation ID for altered computed column
1073 ALL P P P P P P 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/subselect with "union" does not use computed index
1074 ALL P P P P P P 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 label about deterministic flag for stored function in SHOW and extract commands
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
Dialect 1 casting date to string breaks when in the presence a domain with a check constraint
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
Compound ALTER TABLE statement with ADD and DROP the same check constraint fails
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
Statistics for any system index can not be updated/recalculated
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
The package procedure with value by default isn't called if this parameter isn't specified.
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
Real errors during connect to security database are hidden by Srp user manager. Errors should be logged no matter what AuthServer is used.
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
Table trigger does not see its mode: inserting or updating or deleting
1081 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Detach using Linux client takes much longer than from Windows
1082 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Operator REVOKE can modify rights granted to system tables at DB creation time
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
Ordering by compound index together with a range condition gives wrong results
1084 ALL P P P P P P 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 user can implicitly count records in a restricted table
1085 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Both client and server could not close connection after failed authentification
1086 ALL P P P P P P 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 during GC when DELETE is executed after adding new referencing column
1087 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
1088 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
1089 ALL P P P P P P 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: ORDER BY clause on compound index may disable usage of other indices
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
Report the remote port number in MON$ATTACHMENTS
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
At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
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
Connecting to service with invalid servicename yields incorrect error message
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
Regression: incorrect calculation of byte-length for view columns
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
Cannot CREATE VIEW that selects from a system table, despite having all grants
1095 ALL P P P P P P 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 plan output is unexpectedly truncated after a query is simplified to become shorter
1096 ALL P P P P P P 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_TO_UUID on column with index throws expression evaluation not supported Human readable UUID argument for CHAR_TO_UUID must be of exact length 36
1097 ALL P P P P P P 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 datatypes (VAR)BINARY(n) and BINARY VARYING(n) as alias for (VAR)CHAR(n) CHARACTER SET OCTETS
1098 ALL P P P P P P 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 with invalid parameter crashes FB
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
Compound index cannot be used for filtering in some ORDER/GROUP BY queries
1100 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Lost the charset ID in selection of array element
1101 ALL P P P P P P 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. Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0; 2) leads FB to crash when it is recreated
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
ISQL 'SHOW DATABASE' command does not show encryption status of database
1103 ALL P P P P P P 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" error
1104 ALL P P P P P P 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 does not validate correctness of user/password pair provided in EXECUTE STATEMENT operator
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
Allow to fixup (nbackup) database via Services API
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
Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
1107 ALL P P P P P P 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 extration (ISQL -X): "CREATE PROCEDURE/FUNCTION" statement contains reference to column of table(s) that not yet exists if this procedure had parameter of such type when it was created
1108 ALL P P P P P P 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 extract command looses COMPUTED BY field types
1109 ALL P P P P P P 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 extract command lose COMPUTED BY field types
1110 ALL P P P P P P 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 expressions are not converted to their field type inside the engine
1111 ALL P P P P P P 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 autoddl off and sequence of: ( create view V as select * from T; alter view V as select 1 x from rdb$database; drop view V; ) leads to server crash
1112 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
False PK\FK violation could be reported when attachment used isc_dpb_no_garbage_collect flag
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
Indices on computed fields are broken after restore (all keys are NULL)
1114 ALL P P P P P P 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 autocommit mode in SET TRANSACTION statement
1115 ALL P P P P P P 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 not be used by the optimizer if created and used in different connection charsets
1116 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Compiler issues message about "invalid request BLR" when attempt to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL
1117 ALL P P P P P P 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 SEQUENCE RESTART WITH does not change the initial value
1118 ALL P P P P P P 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 when user tries to set number of page buffers into not supported value
1119 ALL P P P P P P 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 definition allows several NOT NULL clauses
1120 ALL P P P P P P 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 to fetch" if some record is to be deleted both by the statement itself and by some trigger fired during statement execution
1121 ALL P P P P P P 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 (cannot find tip page (165), file: tra.cpp line: 2375)
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
Suboptimal join order if one table has a selective predicate and MIN is calculated for the other one
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
create trigger fails with ambiguous field name between table B and table A error
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
Regression: LEFT JOIN incorrectly pushes COALESCE into the inner stream causing wrong results
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
Regression: Server crashes when aggregate functions are used together with NOT IN predicate
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
[CREATE OR] ALTER USER statement: clause PASSWORD (if present) must be always specified just after USER
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
Unique index could be created on non-unique data
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
SEC$ tables and tag/attributes
1129 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
HAVING COUNT(*) NOT IN ( <Q> ) prevent record from appearing in outer resultset when it should be there (<Q> = resultset without nulls)
1130 ALL P P P P P P 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 UNIQUE BOOLEAN field
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
Allow implicit conversion between boolean and string
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
Wrong sequence of savepoints may be produced by selectable procedure
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
Regression: line/column numbering may be twisted if alias.name syntax is used
1134 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Precedence problem with operator IS
1135 ALL P P P P P P 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 computed by definition generated by isql -x
1136 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Return nonzero result code when restore fails on activating and creating deferred user index
1137 ALL P P P P P P 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 -X may generate invalid GRANT USAGE statements for domains
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 3.0 + fbclient 3.0 - POST_EVENT won't work
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
Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK
1140 ALL P P P P P P 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 -x may crash while exporting an exception with message text length > 127 bytes
1141 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
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
ISQL -X: double quotes are missed for COLLATE <C> of CREATE DOMAIN statement when <C> is from any non-ascii charset
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
SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load
1144 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Authentication end with first plugin that has the user but auth fails; should continue with next plugin
1145 ALL P P P P P P 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 to enforce IPv4 or IPv6 in URL-like connection strings
1146 ALL P P P P P P 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: BLR error if more than 256 output parameters exist
1147 ALL P P P P P P 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/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
1148 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Affected rows are not counted for some update operations with views
1149 ALL P P P P P P 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 while selecting from MON$ tables if some user-defined context variable exceeds 255 bytes in length
1150 ALL P P P P P P 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 consistency in GRANT syntax between roles and privileges according to SQL standard
1151 ALL P P P P P P 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 OR conditions may lead to incorrest results
1152 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
FBTRACEMGR should understand 'role <name>' command switch (needed to explicitly connect with role with 'TRACE_ANY_ATTACHMENT' privilege)
1153 ALL P P P P P P 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 does not produce error while attempting to shutdown a database without specified timeout (prp_force_shutdown N)
1154 ALL P P P P P P 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: Can not create large index
1155 ALL P P P P P P 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 attempt to create database with running trace ( internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2233) )
1156 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CORE-5275: Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
1157 ALL P P P P P P 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 with multibyte character sets allow to bypass the character limit of varchar fields
1158 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Granting access rights to view is broken
1159 ALL P P P P P P 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 differ when regular user tries to RESTORE database, depending on his default role and (perhaps) system privilege USE_GBAK_UTILITY
1160 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Validation could read after the end-of-file when handle multifile database
1161 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Validation could read after the end-of-file when handle multifile database
1162 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Performance regression when bulk inserting into table with indices
1163 ALL P P P P P P 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: Can not restore database with table contains field CHAR(n) and UTF8 character set
1164 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CASCADE UPDATE fails for self-referencing FK
1165 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Backup created under FB2.5 can be restored in FB3.0.0.32419 but not under current snapshot (FB3.0.1.32556)
1166 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Backup created under FB2.5 can be restored in FB3.0.0.32419 but not under current snapshot (FB3.0.1.32556)
1167 ALL P P P P P P 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 error with LIST
1168 ALL P P P P P P 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 to fetch" if some record is to be deleted both by the statement itself and by some trigger fired during statement execution
1169 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Malformed string error when using cyrilic symbols and x'0d0a' in exception
1170 CS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Database gets partially corrupted in the "no-reserve" mode
1171 SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Database gets partially corrupted in the "no-reserve" mode
1172 ALL P P P P P P 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 session leads FB 4.0 to hang after 2nd launch of trivial .sql script. Neither attach to any database nor regular restart of FB service can be done.
1173 ALL P P P P P P 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: The subquery in the insert list expressions ignore the changes made earlier in the same executable block.
1174 ALL P P P P P P 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 collate doesn't work with blobs
1175 ALL P P P P P P 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: named window
1176 ALL P P P P P P 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 JOIN incorrectly pushes UDF into the inner stream causing wrong results
1177 ALL P P P P P P 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 -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2
1178 ALL P P P P P P 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: could not use CASE expression with more than 255 conditions.
1179 ALL P P P P P P 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: (boolean) parameters as search condition no longer allowed
1180 ALL P P P P P P 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 subroutines to call others subroutines and themself recursively
1181 ALL P P P P P P 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: could not execute query (select from view with nested view)
1182 ALL P P P P P P 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 in Package not recognised
1183 ALL P P P P P P 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 cannot be executed if win1251 characters used in field aliases
1184 ALL P P P P P P 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 179 (decompression overran buffer) or unexpected lock conflict may happen during record versions backout
1185 ALL P P P P P P 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 some operations with views containing subqueries
1186 ALL P P P P P P 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 data type for negation (minus operator)
1187 ALL P P P P P P 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 column/line references when PSQL definitions return errors
1188 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Result of boolean expression can not be concatenated with string literal
1189 ALL P P P P P P 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 stored when using some type of contructions in subroutines
1190 ALL P P P P P P 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 restoring on FB 3.0 from FB 2.5: bugcheck 221 (cannot remap)
1191 ALL P P P P P P 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 output when retrieving the server log via Services API
1192 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Performance degradation in FB 3.0.2 compared to FB 2.5.7
1193 ALL P P P P P P 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: "Invalid usage of boolean expression" when use "BETWEEN" and "IS" operators
1194 ALL P P P P P P 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 field concatenation of System tables
1195 ALL P P P P P P 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 INCREMENT option in identity columns
1196 ALL P P P P P P 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 DROP IDENTITY clause
1197 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Minor performance optimization - avoid additional database attachment from security objects mapping code
1198 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Read-only transactions in SuperServer could avoid immediate write of Header and TIP pages after change
1199 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Badly selective index could be used for extra filtering even if selective index is used for sorting
1200 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
1201 ALL P P P P P P 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 <e> when <e> starts with '--' issues -Unexpected ... column <NNN>, value <NNN> is invalid and can change randomly
1202 ALL P P P P P P 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 DEFAULT context value in INSERT, UPDATE, MERGE and UPDATE OR INSERT statements
1203 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
INSERT into updatable view without explicit field list failed
1204 ALL P P P P P P 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 167 (invalid SEND request)
1205 ALL P P P P P P 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 GENERATED ALWAYS identity columns and OVERRIDE clause
1206 ALL P P P P P P 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 fbclient when reading blob stored in incompatible encoding
1207 ALL P P P P P P 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 INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
1208 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Additional check for trace log when user issues statement with character that can not be transliterated
1209 ALL P P P P P P 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 filter out info and warnings from trace log
1210 ALL P P P P P P 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 duplicates asci_char(13) in its output (Windows only)
1211 ALL P P P P P P 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 startposition smaller than 1 should be allowed
1212 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Available indices are not used in some cases if ORDER BY expression is a filtered one
1213 ALL P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Timeout for running SQL statement (SET STATEMENT TIMEOUT <N>)
1214 ALL P