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

Generated 15.10.2021 12:37
Tested: FB40.   Build: 4.0.1.2631;   CS: 15.10.21 11:00:21 - 15.10.21 12:33:49;   SS: 15.10.21 09:24:10 - 15.10.21 10:57:20;
OS and hardware info:  Linux 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) ; logical CPUs: 2 ; total memory: 7.6 Gb 
Loading data. Please wait...

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

Jump to LIST of unique test names from this report

NN Test name mode 4.0.1.2631
2021-10-15
4.0.1.2628
2021-10-12
4.0.1.2625
2021-10-10
4.0.1.2624
2021-10-07
4.0.1.2623
2021-10-06
4.0.1.2622
2021-10-03
4.0.1.2621
2021-10-01
4.0.1.2619
2021-09-30
4.0.1.2618
2021-09-26
4.0.1.2613
2021-09-21
4.0.1.2606
2021-09-20
4.0.1.2605
2021-09-19
4.0.1.2604
2021-09-17
4.0.1.2602
2021-09-16
4.0.1.2592
2021-09-16
4.0.1.2588
2021-09-14
4.0.1.2587
2021-09-10
4.0.1.2586
2021-09-09
4.0.1.2585
2021-09-08
4.0.1.2584
2021-09-07
4.0.1.2580
2021-09-04
4.0.1.2579
2021-09-02
4.0.1.2578
2021-09-01
4.0.1.2577
2021-08-31
4.0.1.2574
2021-08-29
4.0.1.2573
2021-08-27
4.0.1.2571
2021-08-20
4.0.1.2570
2021-08-14
4.0.1.2569
2021-08-13
4.0.1.2568
2021-08-12
Test TITLE
1 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Navigation vs IS NULL vs compound index
2 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Join on diffrent datatypes
3 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Using where params in SUM return incorrect results
4 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Recreate and self-referencing indexes
5 SS P P P P P P P P P P P P P     E     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
6 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
bug with ALL keyword
7 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
numeric div in dialect 3 mangles data
8 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
SELECT '1' UNION SELECT '12'
9 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Left joining views with null fails
10 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
trigger with except-s on view with union
11 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ORDER BY works wrong with collate PT_PT
12 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
SELECT...HAVING...NOT IN crashes server
13 SS P P P P P P P P P P P P P     E     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
14 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
bug #910430 ISQL and database dialect
15 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
NULLS FIRST does not work with unions
16 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Inconsistent results using STARTING WITH and COALESCE
17 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Tricky role defeats basic SQL security
18 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
FIRST is applied before aggregation
19 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Blob Type 1 compatibility with VarChar
20 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Privileges of dynamic statements in SP
21 SS P P P P P P P P P P P P P     E     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
22 SS P P P P P P P P P P P P P     E     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
23 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Problems with explicit cursors in unwanted states
24 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Server crash on violation of NOT NULL constraint
25 SS P P P P P P P P P P P P P     E     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
26 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Bug in DSQL parameter
27 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Case insensitive collation for UTF-8
28 SS P P P P P P P P P P P P P     E     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
29 SS P P P P P P P P P P P P P     E     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
30 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
context already in use (BLR error)
31 SS P P P P P P P P P P P P P     E     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
32 SS P P P P P P P P P P P P P     E     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
33 SS P P P P P P P P P P P P P     E     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)
34 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Wrong parameter matching for self-referenced procedures
35 SS P P P P P P P P P P P P P     E     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
36 SS P P P P P P P P P P P P P     E     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
37 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
UNION vs UTF8 literals : arithmetic exception is thrown
38 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Symbols ignored for ES_ES_CI_AI collation
39 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Expression index based on computed fields
40 SS P P P P P P P P P P P P P     E     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
41 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Union returns inconsistent field names
42 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Long SQL statements break TCP/IP connection
43 SS P P P P P P P P P P P P P     E     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
44 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Incorrect column values with outer joins and views
45 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Problem with DISTINCT and insensitive collations
46 SS P P P P P P P P P P P P P     E     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
47 SS P P P P P P P P P P P P P     E     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
48 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Bad optimization of queries with DB_KEY
49 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Indices not used for views
50 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
NOT NULL constraint for procedure parameters and variables
51 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
size of alias name in a table
52 SS P P P P P P P P P P P P P     E     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
53 SS P P P P P P P P P P P P P     E     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
54 SS P P P P P P P P P P P P P     E     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
55 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
French insensitive collation FR_FR_CI_AI
56 SS P P P P P P P P P P P P P     E     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
57 SS P P P P P P P P P P P P P     E     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
58 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Wrong current timestamp evaluation for selectable procedures
59 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Greek characters in cp1251 vs uppercasing
60 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Execute statement 'select ....' into new....
61 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Allow usage of functions in LIST delimiter parameter
62 SS P P P P P P P P P P P P P     E     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
63 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
POSITION(string_exp1, string_exp2 [, start])
64 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Functions DATEDIFF does not work in dialect 1
65 SS P P P P P P P P P P P P P     E     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
66 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
RDB$procedures generator overflow
67 SS P P P P P P P P P P P P P     E     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
68 SS P P P P P P P P P P P P P     E     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
69 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
AV when all statements are cancelled
70 SS P P P P P P P P P P P P P     E     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
71 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ABS() rounds NUMERIC values
72 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Bugcheck 232 (invalid operation) for an aggregated query
73 SS P P P P P P P P P P P P P     E     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
74 SS P P P P P P P P P P P P P     E     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
75 CS P X P P P P P P P P P P P     E     P P P P P P P P P P X P P P P P
Non-privileged monitoring reports wrong attachment data
76 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Non-privileged monitoring reports wrong attachment data
77 SS P P P P P P P P P P P P P     E     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
78 SS P P P P P P P P P P P P P     E     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.
79 SS P P P P P P P P P P P P P     E     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
80 SS P P P P P P P P P P P P P     E     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
81 SS P P P P P P P P P P P P P     E     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)
82 SS P P P P P P P P P P P P P     E     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
83 SS P P P P P P P P P P P P P     E     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
84 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Problem with COLLATE ES_ES_CI_AI
85 SS P P P P P P P P P P P P P     E     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
86 SS P P P P P P P P P P P P P     E     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
87 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Maximum key size using PXW_CSY collation
88 SS P P P P P P P P P P P P P     E     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"
89 SS P P P P P P P P P P P P P     E     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
90 SS P P P P P P P P P P P P P     E     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
91 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Roles granting/revoking logic
92 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Error on script with current_date
93 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Circular dependencies between computed fields crashs the engine
94 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
GROUP BY RAND() returns infinite rows
95 SS P P P P P P P P P P P P P     E     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.
96 SS P P P P P P P P P P P P P     E     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
97 SS P P P P P P P P P P P P P     E     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
98 SS P P P P P P P P P P P P P     E     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
99 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
SUBSTRING with regular expression (SIMILAR TO) capability
100 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
NOT NULL procedure parameters
101 SS P P P P P P P P P P P P P     E     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
102 SS P P P P P P P P P P P P P     E     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
103 SS P P P P P P P P P P P P P     E     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
104 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Domain-level CHECK constraints wrongly process NULL values
105 SS P P P P P P P P P P P P P     E     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
106 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
don't work subquery in COALESCE
107 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ALTER VIEW WITH CHECK OPTION crashes the engin
108 SS P P P P P P P P P P P P P     E     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
109 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
View over global temporary table
110 SS P P P P P P P P P P P P P     E     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
111 SS P P P P P P P P P P P P P     E     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"
112 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Unexpected (wrong) results with COALESCE and GROUP BY
113 SS P P P P P P P P P P P P P     E     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
114 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Problem with column names with Accents and triggers
115 CS P X P P P P P P P P P P P     E     P P P P P P P P P P X P P P P P
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
116 SS P P P P P P P P P P P P P     E     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
117 SS P P P P P P P P P P P P P     E     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.
118 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
gbak doesn't return error code
119 SS P P P P P P P P P P P P P     E     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
120 SS P P P P P P P P P P P P P     E     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 ...)
121 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Incomplete API information values
122 SS P P P P P P P P P P P P P     E     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
123 SS P P P P P P P P P P P P P     E     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
124 SS P P P P P P P P P P P P P     E     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
125 SS P P P P P P P P P P P P P     E     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
126 SS P P P P P P P P P P P P P     E     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
127 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Server crashes on UPDATE OR INSERT statement
128 SS P P P P P P P P P P P P P     E     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
129 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
UNICODE_CI internal gds software consistency check
130 SS P P P P P P P P P P P P P     E     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
131 SS P P P P P P P P P P P P P     E     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
132 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Wrong processing a SP parameters with arrays
133 SS P P P P P P P P P P P P P     E     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
134 SS P P P P P P P P P P P P P     E     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
135 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Infinity should not escape from the engine
136 SS P P P P P P P P P P P P P     E     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
137 SS P P P P P P P P P P P P P     E     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
138 SS P P P P P P P P P P P P P     E     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
139 SS P P P P P P P P P P P P P     E     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
140 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
141 SS P P P P P P P P P P P P P     E     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
142 SS P P P P P P P P P P P P P     E     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
143 SS P P P P P P P P P P P P P     E     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
144 SS P P P P P P P P P P P P P     E     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
145 SS P P P P P P P P P P P P P     E     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
146 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Make rdb$system_flag not null
147 SS P P P P P P P P P P P P P     E     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
148 SS P P P P P P P P P P P P P     E     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
149 SS P P P P P P P P P P P P P     E     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
150 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Query with "NOT IN <subselect from view>" fails
151 SS P P P P P P P P P P P P P     E     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
152 SS P P P P P P P P P P P P P     E     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
153 SS P P P P P P P P P P P P P     E     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.
154 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
PK index is not used for derived tables
155 SS P P P P P P P P P P P P P     E     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 )
156 SS P P P P P P P P P P P P P     E     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
157 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
"Invalid ESCAPE sequence" when connecting to the database
158 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Wrong field position after ALTER POSITION
159 SS P P P P P P P P P P P P P     E     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
160 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
count(*) from big table returns negative result
161 SS P P P P P P P P P P P P P     E     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
162 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Error on delete user "ADMIN"
163 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Procedure suspend check may cause restore to fail
164 SS P P P P P P P P P P P P P     E     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
165 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Wrong resultset
166 SS P P P P P P P P P P P P P     E     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
167 SS P P P P P P P P P P P P P     E     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
168 SS P P P P P P P P P P P P P     E     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
169 SS P P P P P P P P P P P P P     E     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
170 SS P P P P P P P P P P P P P     E     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
171 SS P P P P P P P P P P P P P     E     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
172 SS P P P P P P P P P P P P P     E     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
173 SS P P P P P P P P P P P P P     E     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
174 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Preserve comments for parameters after altering procedures
175 SS P P P P P P P P P P P P P     E     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
176 SS P P P P P P P P P P P P P     E     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
177 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ATAN2 returns incorrect value for (0, 0)
178 SS P P P P P P P P P P P P P     E     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
179 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
RIGHT() fails with multibyte text blobs > 1024 chars
180 SS P P P P P P P P P P P P P     E     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
181 SS P P P P P P P P P P P P P     E     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
182 SS P P P P P P P P P P P P P     E     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
183 SS P P P P P P P P P P P P P     E     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
184 SS P P P P P P P P P P P P P     E     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
185 SS P P P P P P P P P P P P P     E     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
186 SS P P P P P P P P P P P P P     E     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
187 SS P P P P P P P P P P P P P     E     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
188 SS P P P P P P P P P P P P P     E     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
189 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Extend syntax for ALTER USER CURRENT_USER
190 SS P P P P P P P P P P P P P     E     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
191 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
GRANT ADMIN ROLE not accepted
192 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Regression in joins on procedures
193 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Blob transliteration may not happen inside the union
194 SS P P P P P P P P P P P P P     E     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
195 SS P P P P P P P P P P P P P     E     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
196 SS P P P P P P P P P P P P P     E     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
197 SS P P P P P P P P P P P P P     E     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"
198 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Aliases for the RETURNING clause
199 SS P P P P P P P P P P P P P     E     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
200 SS P P P P P P P P P P P P P     E     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
201 SS P P P P P P P P P P P P P     E     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
202 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
AV in engine when preparing query against dropping table
203 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CHAR(32767) present in XSQLVAR with length 32765
204 SS P P P P P P P P P P P P P     E     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
205 SS P P P P P P P P P P P P P     E     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
206 SS P P P P P P P P P P P P P     E     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
207 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Can insert DUPLICATE keys in UNIQUE index
208 SS P P P P P P P P P P P P P     E     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
209 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Window Function: cume_dist()
210 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Window Function: ntile(num_buckets integer)
211 SS P P P P P P P P P P P P P     E     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
212 SS P P P P P P P P P P P P P     E     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
213 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
String truncation error when selecting from a VIEW with UNION inside
214 SS P P P P P P P P P P P P P     E     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
215 SS P P P P P P P P P P P P P     E     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
216 SS P P P P P P P P P P P P P     E     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
217 SS P P P P P P P P P P P P P     E     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
218 SS P P P P P P P P P P P P P     E     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
219 SS P P P P P P P P P P P P P     E     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
220 SS P P P P P P P P P P P P P     E     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 *)
221 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Bad alias table choice joining CTE
222 SS P P P P P P P P P P P P P     E     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
223 SS P P P P P P P P P P P P P     E     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
224 SS P P P P P P P P P P P P P     E     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
225 SS P P P P P P P P P P P P P     E     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)
226 SS P P P P P P P P P P P P P     E     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.
227 SS P P P P P P P P P P P P P     E     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
228 SS P P P P P P P P P P P P P     E     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
229 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Creating a procedure containing "case when" expression leads to a server crash
230 SS P P P P P P P P P P P P P     E     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
231 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Parametrized execute statement fails
232 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
wrong error message with recursive CTE
233 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
role not passed on external execute stmt
234 SS P P P P P P P P P P P P P     E     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
235 SS P P P P P P P P P P P P P     E     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
236 SS P P P P P P P P P P P P P     E     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)
237 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Bad optimization of OR predicates applied to unions
238 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
In SS sweep blocks establishment of concurrent attachments
239 SS P P P P P P P P P P P P P     E     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
240 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Regression: LIKE with escape does not work
241 SS P P P P P P P P P P P P P     E     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
242 SS P P P P P P P P P P P P P     E     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
243 SS P P P P P P P P P P P P P     E     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
244 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Add optional START WITH clause to identity columns
245 CS P X P P P P P P P P P P P     E     P P P P P P P P P P X P P P P P
An uncommitted select of the pseudo table sec$users blocks new database connections
246 SS P P P P P P P P P P P P P     E     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
247 SS P P P P P P P P P P P P P     E     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
248 SS P P P P P P P P P P P P P     E     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
249 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Dropping FK on GTT crashes server
250 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
GTT should not reference permanent relation
251 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Add database owner to mon$database
252 SS P P P P P P P P P P P P P     E     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
253 SS P P P P P P P P P P P P P     E     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
254 SS P P P P P P P P P P P P P     E     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
255 SS P P P P P P P P P P P P P     E     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
256 SS P P P P P P P P P P P P P     E     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)
257 SS P P P P P P P P P P P P P     E     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
258 SS P P P P P P P P P P P P P     E     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 ...)
259 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Choose the best matching index for navigation
260 SS P P P P P P P P P P P P P     E     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
261 SS P P P P P P P P P P P P P     E     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
262 SS P P P P P P P P P P P P P     E     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
263 SS P P P P P P P P P P P P P     E     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
264 SS P P P P P P P P P P P P P     E     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
265 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Ability to trace stored functions execution
266 SS P P P P P P P P P P P P P     E     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
267 SS P P P P P P P P P P P P P     E     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 ...)
268 SS P P P P P P P P P P P P P     E     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 <...>
269 SS P P P P P P P P P P P P P     E     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
270 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Poor performance of explicit cursors containing correlated subqueries in the select list
271 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ISQL truncates blob when reading an empty segment
272 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Enhancement in precision of calculations with NUMERIC/DECIMAL
273 SS P P P P P P P P P P P P P     E     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
274 SS P P P P P P P P P P P P P     E     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
275 SS P P P P P P P P P P P P P     E     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
276 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
nbackup prints error messages to stdout instead stderr
277 SS P P P P P P P P P P P P P     E     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
278 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Add DROP NOT NULL to ALTER COLUMN
279 SS P P P P P P P P P P P P P     E     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
280 SS P P P P P P P P P P P P P     E     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
281 SS P P P P P P P P P P P P P     E     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
282 SS P P P P P P P P P P P P P     E     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
283 SS P P P P P P P P P P P P P     E     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
284 SS P P P P P P P P P P P P P     E     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
285 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Index not found for RECREATE TRIGGER
286 SS P P P P P P P P P P P P P     E     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
287 SS P P P P P P P P P P P P P     E     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
288 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Server does not accept the right plan
289 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
EXECUTE STATEMENT rise varchar char_length() size
290 SS P P P P P P P P P P P P P     E     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
291 SS P P P P P P P P P P P P P     E     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)
292 SS P P P P P P P P P P P P P     E     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)
293 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Conditions like WHERE <field> = <cursor>.<field> do not use existing index
294 SS P P P P P P P P P P P P P     E     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")
295 SS P P P P P P P P P P P P P     E     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
296 SS P P P P P P P P P P P P P     E     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)
297 SS P P P P P P P P P P P P P     E     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
298 SS P P P P P P P P P P P P P     E     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
299 SS P P P P P P P P P P P P P     E     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
300 SS P P P P P P P P P P P P P     E     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
301 SS P P P P P P P P P P P P P     E     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"
302 SS P P P P P P P P P P P P P     E     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
303 SS P P P P P P P P P P P P P     E     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
304 SS P P P P P P P P P P P P P     E     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
305 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
306 SS P P P P P P P P P P P P P     E     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
307 SS P P P P P P P P P P P P P     E     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
308 SS P P P P P P P P P P P P P     E     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
309 SS P P P P P P P P P P P P P     E     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
310 SS P P P P P P P P P P P P P     E     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
311 SS P P P P P P P P P P P P P     E     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"
312 SS P P P P P P P P P P P P P     E     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
313 SS P P P P P P P P P P P P P     E     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
314 SS P P P P P P P P P P P P P     E     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
315 SS P P P P P P P P P P P P P     E     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
316 SS P P P P P P P P P P P P P     E     P P P P P P P P P P 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
317 SS P P P P P P P P P P P P P     E     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
318 SS P P P P P P P P P P P P P     E     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.
319 SS P P P P P P P P P P P P P     E     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
320 SS P P P P P P P P P P P P P     E     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
321 SS P P P P P P P P P P P P P     E     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
322 SS P P P P P P P P P P P P P     E     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
323 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Regression: Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
324 SS P P P P P P P P P P P P P     E     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
325 SS P P P P P P P P P P P P P     E     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
326 SS P P P P P P P P P P P P P     E     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
327 SS P P P P P P P P P P P P P     E     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
328 SS P P P P P P P P P P P P P     E     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
329 SS P P P P P P P P P P P P P     E     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
330 SS P P P P P P P P P P P P P     E     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
331 SS P P P P P P P P P P P P P     E     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
332 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ISQL extract command looses COMPUTED BY field types
333 SS P P P P P P P P P P P P P     E     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
334 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Support autocommit mode in SET TRANSACTION statement
335 SS P P P P P P P P P P P P P     E     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
336 SS P P P P P P P P P P P P P     E     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
337 SS P P P P P P P P P P P P P     E     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)
338 SS P P P P P P P P P P P P P     E     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
339 SS P P P P P P P P P P P P P     E     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
340 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
SEC$ tables and tag/attributes
341 SS P P P P P P P P P P P P P     E     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)
342 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Allow implicit conversion between boolean and string
343 SS P P P P P P P P P P P P P     E     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
344 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Invalid computed by definition generated by isql -x
345 SS P P P P P P P P P P P P P     E     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
346 SS P P P P P P P P P P P P P     E     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
347 SS P P P P P P P P P P P P P     E     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
348 SS P P P P P P P P P P P P P     E     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
349 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Nested OR conditions may lead to incorrest results
350 SS P P P P P P P P P P P P P     E     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)
351 SS P P P P P P P P P P P P P     E     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
352 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CASCADE UPDATE fails for self-referencing FK
353 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Data type unknown error with LIST
354 SS P P P P P P P P P P P P P     E     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
355 SS P P P P P P P P P P P P P     E     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.
356 SS P P P P P P P P P P P P P     E     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.
357 SS P P P P P P P P P P P P P     E     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
358 SS P P P P P P P P P P P P P     E     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
359 SS P P P P P P P P P P P P P     E     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
360 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Invalid data type for negation (minus operator)
361 SS P P P P P P P P P P P P P     E     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
362 SS P P P P P P P P P P P P P     E     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
363 SS P P P P P P P P P P P P P     E     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
364 SS P P P P P P P P P P P P P     E     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
365 SS P P P P P P P P P P P P P     E     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
366 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Support GENERATED ALWAYS identity columns and OVERRIDE clause
367 SS P P P P P P P P P P P P P     E     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
368 SS P P P P P P P P P P P P P     E     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
369 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
SUBSTRING startposition smaller than 1 should be allowed
370 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Timeout for IDLE connection (SET SESSION IDLE TIMEOUT <N>)
371 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Bad performance for NULLs filtering inside a navigational index scan
372 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
373 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Unclear gstat's diagnostic when damaged page in DB file appears encrypted
374 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Crash on 3.0 and 4.0 when DB contains database-level trigger
375 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Connections compressed and encrypted in MON$ATTACHMENTS table
376 SS P P P P P P P P P P P P P     E     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
377 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Database-level triggers related to TRANSACTION events (i.e. start, commit and rollback) do not take in account their POSITION index (when more than one trigger for the same event type is defined)
378 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Direct system table modifications are not completely prohibited
379 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ISQL incorrectly pads UNICODE_FSS/UTF8 columns when they use a collation
380 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Bugcheck on queries containing WITH LOCK clause
381 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
382 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Invalid blob id when add a new blob column of type text and update another field
383 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Gradual slowdown compilation (create, recreate or drop) of views
384 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
385 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Store precision of DECFLOAT in RDB$FIELDS
386 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Field alias disapears in complex query
387 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Reject non-constant date/time/timestamp literals
388 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
When requesting the subtype of a NUMERIC or DECIMAL column with precision in [19, 34] using isc_info_sql_sub_type, it always returns 0, instead of 1 for NUMERIC and 2 for DECIMAL.
389 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Incorrect error message in iSQL when trying to create database with wrong password
390 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
User can grant usage privilege by himself
391 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
No error if the GRANT target object does not exist
392 SS P P P P P P P P P P P P P P P P P P P P P P P P P     E     P P P P
Error returned from DbCryptPlugin::setKey() is not shown
393 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
gstat may produce faulty report about presence of some none-encrypted pages in database
394 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ALTER CURRENT USER fails with "no permission for <...> TABLE PLG$SRP" if current user: 1) has NO admin role and 2) wants to modify his own TAGS list
395 SS P P P P P P P P P P P P P     E     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
396 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Ignor of reference privilege
397 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Very poor "similar to" performance
398 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Incorrect caching of the subquery result (procedure call) in independent queries
399 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
400 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Initial global mapping from srp plugin does not work
401 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
SQL SECURITY DEFINER context is not properly evaluated for monitoring tables
402 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL
403 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Enhance dynamic libraries loading related error messages
404 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Bugcheck 165 (cannot find tip page) // Classic and SuperClassic only
405 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Firebird crashes, related to Bugcheck 165 (cannot find tip page)
406 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Bugcheck could happen when read-only database with non-zero linger is set to read-write mode
407 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Handling FP overflow in double precision value when converting from decfloat.
408 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
error read permission for BLOB field, when it is input/output procedure`s parametr
409 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Trace could not work correctly with quoted file names in trace configurations
410 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
RDB$GET_TRANSACTION_CN works different in Super and Classic
411 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
FB4 unable to overwrite older ods database
412 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
SUBSTRING(CURRENT_TIMESTAMP) does not work
413 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
The original time zone should be set to the current time zone at routine invocation
414 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Srp user manager sporadically creates users which can not attach
415 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field
416 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Builtin functions converting binary string to hexadecimal representation and vice versa
417 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Random crash 64bit fb_inet_server. Possible collation issue
418 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Server hangs when compiling big package with error
419 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
USING PLUGIN clause does not work in RECREATE USER
420 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CREATE SEQUENCE START WITH has wrong initial value
421 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Problem with casting within UNION
422 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
423 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
The Metadata script extracted using ISQL of a database restored from a Firebird 2.5.9 Backup is invalid/incorrect when table has COMPUTED BY field
424 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Win_Sspi in the list of auth plugins leads message about failed login to be changed (from 'Your user name and password are not defined...' to 'Missing security context ...')
425 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Inconsistent behavior regarding visibility of master record on detail inserts
426 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
substring similar - extra characters in the result for non latin characters
427 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
"No current record for fetch operation" with queries with aggregated subselect
428 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Operations when using "SET DECFLOAT BIND BIGINT,n" with result of 11+ digits, fail with "Decimal float invalid operation"
429 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Some (wrong ?) parameters of ENCRYPT() leads FB to crash
430 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Original content of column which is involved into ENCRYPT() is displayed as distorted view after this call
431 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
VARCHAR of insufficient length used for set bind of decfloat to varchar
432 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
request size limit exceeded when selecting from a table with large number of indicies
433 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
isc_info_svc_user_dbpath always returns alias of main security database
434 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
DECFLOAT: subtraction Num1 - Num2 leads to "Decimal float overflow" if Num2 is specified in scientific notation and less than max double ( 1.7976931348623157e308 )
435 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Problem with too many number of columns in resultset.
436 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
UNIQUE / PRIMARY KEY constraint can be violated when AUTODDL = OFF and mixing commands for DDL and DML
437 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction
438 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
SHOW DOMAIN/TABLE does not display character set of system objects
439 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Hex number used at end of statement (e.g. CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions
440 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
FB4 Beta 2 may still be using the current date for TIME WITH TIME ZONE and extended wire protocol.
441 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Make explicit basic type for high precision numerics - INT128
442 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ROUND() does not allow second argument >=1 when its first argument is more than MAX_BIGINT / 10
443 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Adding NOT NULL column with DEFAULT value may cause default values to update when selecting or have the wrong charset
444 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Error message "expected length N, actual M" contains wrong value of M when charset UTF8 is used in the field declaration of a table
445 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ISQL: bad headers when text columns has >= 80 characters
446 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Provide ability to see in the trace log actions related to session management (e.g. ALTER SESSION RESET)
447 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Regression: can not get statistics for selected table(s) via services, get "found unknown switch" error
448 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Provide same results for date arithmetics when date is changed by values near +/-max(bigint)
449 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Regression: inline comment of SP parameter with closing parenthesis leads to incorrect SQL when trying to extract metadata
450 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Error "no current record for fetch operation" when sorting by a international string
451 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
452 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Hash join cannot match records using some TIME ZONE / DECFLOAT keys
453 SS P P P     F     P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Implementation of SUBSTRING for UTF8 character set is inefficient
454 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
String truncation exception on UPPER/LOWER functions, UTF8 database and some multibyte characters [CORE5255]
455 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
DECRYPT() must return BLOB if its first argument is blob, otherwise returnted datatype must be VARCHAR with charset NONE
456 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
assertion in tomcrypt when key length for rc4 too small
457 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
assertion in tomcrypt when key length for rc4 too small
458 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Integer hex-literals: support for INT128
459 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Correct error message for DROP VIEW
460 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Segfault using "commit retaining" with GTT
461 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Deleting multiple rows from a view with triggers may cause triggers to fire just once
462 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
463 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Indexed STARTING WITH execution is very slow with UNICODE collation
464 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)
465 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
error no permision occurred while ALTER USER SET TAGS on snapshot build WI-V3.0.8.33482
466 SS P P P P P P P P P P P P P     E     P P P P P X X X X X X X X X X X
SQL SECURITY DEFINER does not affect the ownership of created DDL objects
467 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ALTER DOMAIN - DROP DEFAULT
468 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ALTER DOMAIN - Alter domain that doesn't exists
469 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CREATE DOMAIN - FLOAT
470 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CREATE DOMAIN - TIME
471 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CREATE DOMAIN - DECIMAL ARRAY
472 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CREATE DOMAIN - NUMERIC
473 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CREATE DOMAIN - CHARACTER
474 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CREATE DOMAIN - NATIONAL CHARACTER
475 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CREATE DOMAIN - BLOB (seglen,subtype)
476 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CREATE DOMAIN - CHECK
477 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
computed-fields-02
478 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
computed-fields-04
479 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
computed-fields-06
480 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
computed-fields-07
481 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
GTCS/tests/external-file-04-d-int128. Test for external table with field of INT128 datatype
482 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
gtcs-proc-isql-01
483 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
gtcs-proc-isql-05
484 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
gtcs-proc-isql-06
485 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
gtcs-proc-isql-07
486 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
gtcs-proc-isql-14
487 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
gtcs-proc-isql-17
488 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
GTCS/tests/SELECT_DELETE_ISQL. Test for select from SP that deletes record after its output.
489 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
GTCS/tests/CF_ISQL_34. minimum-grant-test
490 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
GTCS/tests/REF_INT.7.ISQL ; ref-integ-inactive-pk-index. Index that is used for PRIMARY KEY should not be avail for INACTIVE.
491 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
GTCS/tests/FB_SQL_WINDOW_FUNC_02 - set of miscelaneous tests for verification of windowed functions.
492 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
GTCS/tests/FB_SQL_WINDOW_FUNC_05 - set of miscelaneous tests for verification of windowed functions.
493 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ALTER TABLE - ADD column (test2)
494 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
ALTER TABLE - ALTER - TO
495 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
Verify ability to create exactly 254 changes of format (increasing it by 1) after initial creating table
496 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CREATE TABLE - constraints
497 SS P P P P P P P P P P P P P     E     P P P P P P P P P P P P P P P P
CREATE TABLE - unknown datatype (domain)

Elapsed time, milliseconds:
NN Test name mode median_ms 4.0.1.2631
2021-10-15
4.0.1.2628
2021-10-12
4.0.1.2625
2021-10-10
4.0.1.2624
2021-10-07
4.0.1.2623
2021-10-06
4.0.1.2622
2021-10-03
4.0.1.2621
2021-10-01
4.0.1.2619
2021-09-30
4.0.1.2618
2021-09-26
4.0.1.2613
2021-09-21
4.0.1.2606
2021-09-20
4.0.1.2605
2021-09-19
4.0.1.2604
2021-09-17
4.0.1.2602
2021-09-16
4.0.1.2592
2021-09-16
4.0.1.2588
2021-09-14
4.0.1.2587
2021-09-10
4.0.1.2586
2021-09-09
4.0.1.2585
2021-09-08
4.0.1.2584
2021-09-07
4.0.1.2580
2021-09-04
4.0.1.2579
2021-09-02
4.0.1.2578
2021-09-01
4.0.1.2577
2021-08-31
4.0.1.2574
2021-08-29
4.0.1.2573
2021-08-27
4.0.1.2571
2021-08-20
4.0.1.2570
2021-08-14
4.0.1.2569
2021-08-13
4.0.1.2568
2021-08-12
Test TITLE
1 SS 2000 2210 1940 2490 2080 2130 2190 2000 1990 2140 2400 2090 2080 1950 10 1960 2000 1870 1940 1940 2040 2040 1910 2110 2020 1890 2130 1870 1970 2000 2000
Navigation vs IS NULL vs compound index
2 SS 1655 1710 1640 1600 1740 1770 1680 1710 1660 1720 1650 1630 1720 1660 10 1900 1690 1630 1650 1680 1660 1620 1540 1640 1640 2010 1560 1800 1630 1520 1580
Join on diffrent datatypes
3 SS 1470 1600 1710 1380 1550 1460 1400 1570 1570 1470 1610 1380 1530 1400 10 1510 1550 1470 1370 1470 1000 1520 1480 1460 1410 1450 1530 1390 1600 1390 1430
Using where params in SUM return incorrect results
4 SS 2040 2170 2030 2090 1900 2050 2080 2050 2060 2200 2900 1980 2230 2110 10 2020 2060 2100 1920 2050 1990 1980 1930 2290 1970 1900 1980 1900 2020 2070 1890
Recreate and self-referencing indexes
5 SS 1760 1730 1980 1590 1850 2070 1940 1960 1940 1850 1650 1760 1660 1660 10 1840 1760 1670 1970 1880 1710 1630 1980 1720 1000 1580 1720 2050 1900 1640 1820
Dropping and recreating a table in the same txn disables PK
6 SS 1170 1230 1280 1400 1220 1000 1310 1170 1400 1230 1230 1000 1130 1160 10 1260 1190 1090 1190 1290 1150 1130 1210 1240 1080 1080 1170 1050 1090 1140 1130
bug with ALL keyword
7 SS 660 680 670 640 650 640 660 630 700 670 740 690 660 700 0 630 680 630 590 630 650 630 660 670 640 670 640 600 680 700 630
numeric div in dialect 3 mangles data
8 SS 1090 1220 1140 1240 1180 1340 1170 1130 1170 1120 1110 1130 1090 1230 10 1020 1090 1020 1020 1090 1010 1050 1040 990 1060 1060 1090 990 1090 1090 1090
SELECT '1' UNION SELECT '12'
9 SS 1830 1840 2140 1900 2000 1830 1920 1850 1870 1860 1780 1760 1830 1790 10 2190 2240 1770 1760 1720 1000 1760 1830 2230 1910 1860 1790 1730 1760 1820 1880
Left joining views with null fails
10 SS 1325 1300 1390 1410 1340 1330 1510 1350 1380 1410 1310 1340 1280 1420 10 1240 1540 1280 1320 1360 1370 1220 1510 1210 1320 1240 1350 1270 1240 1240 1320
trigger with except-s on view with union
11 SS 1515 1480 1560 1550 1550 1590 1660 1440 1830 1560 1580 1510 1530 1710 10 1520 1570 1540 1450 1760 1470 1460 1640 1000 1380 1440 1430 1390 1510 1390 1510
ORDER BY works wrong with collate PT_PT
12 SS 650 710 700 710 710 690 680 720 650 680 670 710 680 730 0 840 590 620 630 630 610 620 640 650 640 580 610 550 640 590 630
SELECT...HAVING...NOT IN crashes server
13 SS 1375 1000 1610 1530 1000 1660 1470 1480 1000 1370 1440 1000 1450 1460 10 1490 1610 1350 1450 1000 1350 1530 1320 1340 1340 1370 1520 1410 1360 1380 1340
DOMAINs don't register their dependency on other objects
14 SS 1180 1350 1330 1420 1000 1270 1230 1190 1170 1170 1180 1180 1180 1150 10 1210 1240 1130 1150 1170 1140 1090 1070 1140 1070 1170 1310 1180 1190 1290 1210
bug #910430 ISQL and database dialect
15 SS 1150 1220 1210 1110 1240 1230 1000 1110 1580 1140 1170 1170 1150 1160 10 1100 1200 1300 1360 1100 1120 1170 1150 1000 1110 1050 1140 1100 1180 1100 1170
NULLS FIRST does not work with unions
16 SS 1030 1030 1070 980 1160 1060 1120 1020 1160 1030 1060 1010 1000 1030 0 960 1090 1030 990 1030 1040 990 950 900 930 1110 1040 970 950 970 960
Inconsistent results using STARTING WITH and COALESCE
17 SS 1575 1510 1490 1680 1630 1570 1590 1580 1830 1550 1610 1520 1630 1610 10 1520 1650 1530 1580 1610 1440 1550 1470 1580 1590 1430 1520 1580 1520 1520 1770
Tricky role defeats basic SQL security
18 SS 1370 1550 1490 1360 1380 1490 1370 1420 1390 1580 1390 1400 1350 1290 0 1480 1590 1560 1320 1310 1340 1350 1320 1360 1310 1270 1510 1300 1300 1350 1380
FIRST is applied before aggregation
19 SS 1165 1300 1220 1320 1330 1200 1260 1270 1000 1210 1180 1110 1000 1160 10 1210 1000 1180 1160 1170 1190 1160 1190 1160 1110 1130 1170 1090 1150 1120 1150
Blob Type 1 compatibility with VarChar
20 SS 1870 1740 1890 1840 1890 1760 1900 1970 2120 1880 2000 1990 1800 1880 0 1910 1800 1740 1870 2000 1860 1870 1730 1800 1000 1970 1740 1770 1720 1900 1720
Privileges of dynamic statements in SP
21 SS 660 0 720 720 950 740 690 690 770 720 760 660 0 660 10 660 680 570 580 620 630 610 590 740 630 640 630 660 610 600 630
Engine crashes while trying to backup a logically corrupt db
22 SS 1120 1150 1180 1180 1110 1210 1000 1100 1200 1160 1140 1340 1090 1390 10 1070 1000 1070 1090 1130 1120 1180 1120 1120 1120 1080 1610 1070 1100 1150 1330
Dependencies are not cleared when creation of expression index fails
23 SS 1600 1000 1590 1730 1730 1650 1770 1630 1650 1660 1740 1680 1600 1670 10 1630 1700 1480 1690 1590 1560 1530 1640 1600 1600 1540 1000 1000 1580 1550 1590
Problems with explicit cursors in unwanted states
24 SS 1855 1770 1900 1930 2030 2040 1820 2050 1720 1800 1980 1900 1830 1950 10 2010 1830 1820 1890 1840 2020 1870 1980 1820 1720 1830 1800 1930 1870 1770 1680
Server crash on violation of NOT NULL constraint
25 SS 1840 2120 1890 2510 2010 2020 1840 1930 1870 1720 1920 1730 1890 1820 0 1880 2040 1940 1780 1860 1820 1840 1700 1650 1730 1740 1000 1770 1580 1730 1690
Grants don't work for procedures used inside views
26 SS 1340 1360 1550 1300 1380 1380 1410 1580 1340 1370 1280 1290 1340 1370 0 1270 1370 1340 1440 1320 1480 1270 1270 1210 1520 1220 1260 1360 1300 1260 1270
Bug in DSQL parameter
27 SS 1190 1210 1180 1420 1280 1550 1280 1180 1310 1220 1410 1220 1160 1190 0 1200 1190 1170 1280 1370 1190 1140 1190 1280 1090 1130 1170 1170 1160 1120 1260
Case insensitive collation for UTF-8
28 SS 4120 4520 4080 4100 4350 4150 4430 4350 4430 4270 3970 4130 4100 4230 0 3900 4110 4270 4800 4120 4040 4120 4460 3910 3960 4030 4370 4120 4190 3950 4080
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset
29 SS 1830 1960 1710 1820 1830 1880 1820 1790 1850 1880 2000 1810 1770 1900 10 1790 2030 1720 1830 1830 1850 1760 1900 1780 1830 1800 1720 1870 1840 1760 1880
select with FIRST and LEFT JOIN needs excess SORT in plan
30 SS 1160 1360 1240 1180 1150 1210 1160 1130 1200 1160 1150 1200 1200 1190 0 1120 1180 1280 1200 1140 1000 1070 1050 1110 1130 1040 1130 1050 1100 1160 1270
context already in use (BLR error)
31 SS 630 650 700 680 740 700 670 720 770 620 0 770 630 630 0 790 590 630 610 630 620 640 630 680 590 570 620 580 650 630 630
Provide mechanism to get engine version without needing to call API function
32 SS 1300 1390 1380 1290 1300 1440 1400 1370 1400 1220 1380 1460 1350 1260 10 1410 1300 1000 1270 1000 1290 1220 1270 1280 1300 1230 1310 1260 1350 1270 1320
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
33 SS 1305 1510 1270 1300 1370 1400 1460 1340 1280 1340 1440 1230 1350 1320 10 1320 1330 1310 1170 1270 1240 1280 1220 1370 1310 1390 1200 1190 1270 1230 1220
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)
34 SS 1135 1190 1000 1200 1230 1140 1260 1330 1170 1230 1220 1160 1130 1110 10 1000 1090 1230 1170 1120 1130 1120 1130 1180 1010 990 1080 1150 1120 1080 1140
Wrong parameter matching for self-referenced procedures
35 SS 990 1040 1000 1070 1090 1110 1040 1040 1140 1050 1040 940 1030 990 0 990 1060 890 930 900 940 930 950 980 950 970 980 940 910 870 1000
ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation
36 SS 1320 1650 1320 1480 1270 1420 1460 1350 1290 1330 1390 1400 1330 1380 0 1430 1340 1300 1310 1260 1160 1300 1270 1320 1460 1320 1320 1230 1350 1290 1320
Error msg "Could not find UNIQUE INDEX" when in fact one is present
37 SS 660 760 740 650 760 0 720 760 700 660 660 660 680 680 0 670 690 590 630 620 650 610 660 620 590 630 630 600 700 660 590
UNION vs UTF8 literals : arithmetic exception is thrown
38 SS 1570 1670 2120 1680 1830 1590 1530 1550 1610 1670 1590 1530 1700 1570 0 1650 1870 1530 1670 1490 1470 1460 1520 1000 1540 1450 1510 1490 1530 1590 1870
Symbols ignored for ES_ES_CI_AI collation
39 SS 1780 1900 1910 1820 1760 1920 1810 1720 1890 1720 2570 1820 1890 1930 10 2080 1870 1700 1610 1790 1720 1610 1770 1740 2000 1620 1720 1650 1820 1700 1720
Expression index based on computed fields
40 SS 1040 1160 1070 1180 1220 1120 1190 1040 1120 1140 1130 1070 1030 1000 0 1030 1040 1100 1050 1040 1030 980 1010 1040 1020 960 1120 1010 1110 1040 960
Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference
41 SS 1360 1770 1370 1450 1370 1470 1360 1410 1710 1410 1290 1360 1350 1330 10 1570 1000 1260 1390 1230 1000 1380 1000 1280 1280 1380 1340 1200 1360 1000 1410
Union returns inconsistent field names
42 SS 700 0 700 760 740 940 730 730 730 810 0 710 730 650 10 720 660 640 710 690 820 700 700 710 700 630 700 650 670 670 680
Long SQL statements break TCP/IP connection
43 SS 2980 3000 2850 2940 2860 2900 3200 3060 3000 2890 2950 3070 2830 2980 10 3360 3190 2770 2950 2980 3070 3140 2920 3020 2900 2820 3160 3010 2930 3140 3160
Wrong SELECT query results using index to evaluate >= condition
44 SS 1475 1480 1490 1460 1530 1590 1470 1690 1600 1490 1000 1430 1510 1510 10 1480 1450 1000 1580 1390 1330 1460 1660 2430 1490 1510 1470 1330 1360 1430 1000
Incorrect column values with outer joins and views
45 SS 1150 1180 1300 1140 1000 1220 1090 1240 1000 1120 1180 1100 1360 1180 0 1170 1330 1080 1040 1030 1290 1100 1150 1160 1150 1080 1110 1090 1070 1200 1150
Problem with DISTINCT and insensitive collations
46 SS 1230 1290 1410 1260 1360 1290 1000 1620 1460 1200 1290 1360 1270 1230 10 1220 1220 1230 1220 1180 1230 1180 1350 1380 1230 1300 1000 1760 1210 1190 1230
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
47 SS 1365 1400 1410 1350 1350 1000 1800 1450 1600 1380 1460 1380 1390 1350 660 1490 1420 1440 1460 1360 1340 1370 1360 1510 1330 1340 1310 1240 1360 1330 1000
Can't create table using long username and UTF8 as attachment charset
48 SS 640 720 700 720 660 730 760 700 0 640 710 630 620 700 10 650 690 590 600 670 620 600 600 690 580 610 640 610 570 630 680
Bad optimization of queries with DB_KEY
49 SS 1480 1000 1880 1530 1600 1470 1730 1000 1480 1530 1450 1470 1420 1490 10 1660 1520 1480 1520 1460 1560 1480 1470 1530 1360 1420 1420 1480 1410 1400 1520
Indices not used for views
50 SS 930 920 980 980 1270 1080 1030 970 990 1110 980 920 920 920 0 1010 910 920 880 930 910 920 920 920 1030 920 930 850 1000 960 970
NOT NULL constraint for procedure parameters and variables
51 SS 1180 1260 1350 1310 1310 1180 1240 1150 1290 1240 1230 1140 1140 1100 0 1100 1120 1030 1180 1150 1180 1100 1210 1110 1120 1190 1190 1200 1160 1130 1150
size of alias name in a table
52 SS 2030 1990 2040 2360 2120 2080 2140 2230 2130 1940 1960 2280 2060 1940 0 2070 2030 1970 1920 2160 2160 2100 1950 1950 1950 1970 1850 2110 2000 2000 1970
Index operations for global temporary tables are not visible for the active connection
53 SS 1165 1170 1220 1230 1270 1210 1180 1410 1200 1170 1310 1130 1090 1300 10 1140 1170 1100 1110 1180 1170 1080 1140 1210 1110 1160 1110 1160 1120 1100 1130
Too large numbers cause positive infinity to be inserted into database
54 SS 635 680 730 670 710 700 620 710 690 700 680 620 630 640 10 640 790 660 640 590 630 610 600 630 600 630 640 580 630 580 630
ISQL crash when converted-from-double string longer than 23 bytes
55 SS 1555 1640 1640 1640 1560 1630 1920 1790 1590 1530 1540 1000 1730 1580 10 1740 1650 1360 1550 1400 1590 1590 1480 1510 1430 1670 1480 1530 1460 1400 1430
French insensitive collation FR_FR_CI_AI
56 SS 650 650 780 760 950 730 760 680 630 650 730 630 630 630 0 630 770 580 700 600 620 650 640 630 610 630 680 560 720 670 660
Invalid parameter type when using it in CHAR_LENGTH function
57 SS 1330 1390 1430 1360 1820 1340 1300 1360 1240 1240 1330 1410 1480 1280 10 1350 1450 1300 1330 1290 1330 1340 1340 1150 1170 1420 1260 1330 1180 1270 1240
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
58 SS 1460 1630 1650 1490 1760 1580 1790 2000 1590 1620 1400 1430 1430 1510 10 1450 1580 1390 1460 1440 1460 1440 1470 1400 1520 1450 1380 1410 1370 1350 1540
Wrong current timestamp evaluation for selectable procedures
59 SS 1420 1400 1480 1600 1450 1660 1620 1480 1450 1520 1480 1400 1460 1480 0 1680 1290 1460 1320 1330 1420 1410 1410 1420 1000 1390 1360 1310 1450 1370 1380
Greek characters in cp1251 vs uppercasing
60 SS 1370 1550 1330 1570 1590 1450 1510 1420 1630 1280 1370 1490 1290 1410 10 1350 1240 1400 1370 1320 1320 1300 1350 1420 1270 1390 1600 1340 1340 1350 1420
Execute statement 'select ....' into new....
61 SS 1230 1340 1300 1310 1320 1380 1300 1360 1240 1000 1230 1320 1400 1270 0 1000 1220 1270 1290 1340 1000 1150 1160 1130 1180 1190 1170 1160 1140 1200 1150
Allow usage of functions in LIST delimiter parameter
62 SS 5430 5510 5380 5630 5470 5460 5000 5220 5730 5340 5510 5650 5400 5360 10 5860 6680 5200 5330 5320 5810 5570 5290 5460 5360 5330 5580 5000 5490 5340 5710
Make optimizer to consider ORDER BY optimization when making decision about join order
63 SS 650 650 720 650 680 720 700 620 810 630 720 670 710 700 0 660 780 610 630 570 580 650 610 600 720 590 630 690 610 610 620
POSITION(string_exp1, string_exp2 [, start])
64 SS 690 740 780 820 790 770 790 730 760 710 680 720 710 690 0 0 650 630 650 660 620 650 650 610 720 590 660 620 690 640 690
Functions DATEDIFF does not work in dialect 1
65 SS 1270 1270 1270 1350 1620 1330 1430 1220 1390 1000 1230 1290 1270 1430 0 1240 1410 1290 1150 1210 1280 1190 1140 1240 1270 1240 1200 1000 1190 1280 1390
JOIN on first record of ordered derived table returns wrong record
66 SS 120575 132910 140220 139570 137470 140330 137490 138560 138290 129240 125340 120160 120990 124970 10 120030 138780 115590 122900 114570 114540 112650 115070 116990 116760 111390 115140 109580 113120 115890 122340
RDB$procedures generator overflow
67 SS 1210 1150 1440 1230 1000 1270 1210 1360 1230 1230 1270 1240 1270 1000 10 1200 1290 1230 1260 1180 1130 1160 1210 1160 1290 1170 1150 1140 1440 1150 1160
Subquery-based predicates are not evaluated early in the join order
68 SS 1095 1180 1230 1100 1160 1000 1030 1260 1160 1120 1180 1080 1120 1090 10 1070 1330 1050 1090 1000 1140 1120 1030 1100 1070 1240 1040 1060 1050 1160 1060
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
69 SS 2790 1880 2120 2600 2310 2260 1800 2300 2330 2790 2240 2060 3040 2420 10 2890 2810 2850 2720 3560 3030 3440 2790 2770 3300 3120 2860 3020 3420 3530 3240
AV when all statements are cancelled
70 SS 1575 1600 1770 1700 1580 1660 1660 1930 1740 1000 1680 1530 1570 1660 10 1530 1680 1460 1570 1460 1440 1800 1560 1000 1590 1440 1530 1510 1640 1560 1660
Multiple Rows in Singleton Select not reported in a View
71 SS 650 660 660 700 670 740 650 0 730 690 670 650 650 640 0 690 730 680 620 610 620 610 650 650 620 590 590 590 600 600 670
ABS() rounds NUMERIC values
72 SS 1300 1330 1300 1360 1430 1430 1370 1450 1390 1260 1350 1270 1340 1260 10 1290 1380 1290 1330 1290 1350 1270 1260 1260 1300 1350 1290 1300 1360 1240 1240
Bugcheck 232 (invalid operation) for an aggregated query
73 SS 1850 1910 1850 2350 1910 2220 1940 2030 2030 1710 1970 1790 1780 1840 0 1910 2320 1700 1850 1920 1870 1840 1760 2020 1760 1820 1790 1800 1720 1730 1680
Ability to insert child record if parent record is locked but foreign key target unchanged
74 SS 940 1000 1080 930 940 980 920 1060 1040 960 1040 990 910 960 10 1020 960 880 900 900 870 940 1070 880 980 960 910 870 930 890 930
Incorrect error message (column number) if the empty SQL string is prepared
75 CS 2095 2480 2340 2270 2230 2270 2030 2160 2030 2020 2100 1950 2080 820 2210 2110 2030 2220 2260 2010 1990 2100 1980 2080 1890 1930 2230 2090 2140
Non-privileged monitoring reports wrong attachment data
76 SS 1540 1600 1650 1560 1580 1800 1570 1580 1440 1480 1670 1480 1550 1480 630 1590 1520 1460 1540 1710 1540 1490 1440 1590 1470 1420 1490 1420 1580 1580 1490
Non-privileged monitoring reports wrong attachment data
77 SS 1340 1330 1450 1330 1490 1320 1350 1530 1390 1380 1380 1370 1310 1370 10 1420 1310 1660 1490 1320 1390 1260 1280 1290 1290 1260 1320 1280 1350 1300 1370
AV when recursive query used MERGE JOIN in execution plan
78 SS 1845 2190 2020 1830 1900 2020 1770 2080 1930 2240 1920 1820 1830 2040 10 1740 1830 1850 2220 1850 1950 1810 1830 1740 1860 1670 1840 1960 1800 1760 1690
'There are <n> dependencies' error message shows the wrong count of dependent objects.
79 SS 1260 1270 1370 1320 1410 1260 1470 1430 1220 1280 1370 1210 1270 1400 0 1220 1260 1000 1200 1140 1220 1210 1160 1220 1200 1280 1210 1190 1270 1170 1320
arithmetic exception, numeric overflow, or string truncation in utf8 tables
80 SS 900 910 930 980 940 930 910 900 1060 900 1000 920 940 900 0 910 910 820 920 840 900 790 880 900 810 840 870 850 860 840 820
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
81 SS 1180 1240 1260 1190 1200 1170 1150 1240 1210 1120 1240 1220 1000 1270 10 1120 1380 1070 1080 1100 1130 1180 1180 1170 1050 1270 1220 1160 1230 1180 1330
Bug in create/alter Database trigger (with Russian comment)
82 SS 36700 35930 39000 36400 36310 36770 36060 36800 36450 37510 37930 37860 37410 36780 10 36820 36490 35810 36990 36010 35930 36840 35840 35850 35930 37030 36710 36820 36400 36840 36690
Expression index can be created while doing inserts into table
83 SS 660 710 760 730 780 830 720 0 770 730 770 680 690 700 10 700 630 650 610 660 650 620 610 660 650 660 640 620 640 640 680
Include information about context variables into the monitoring tables
84 SS 1140 1330 1180 1120 1530 1290 1260 1260 1140 1060 1160 1000 1240 1270 0 1050 1200 1120 1150 1010 1140 1090 1110 1030 1130 1010 1020 1290 1100 1090 1220
Problem with COLLATE ES_ES_CI_AI
85 SS 820 840 900 930 940 950 820 790 840 820 860 850 800 800 10 860 910 770 0 870 790 0 810 730 790 790 800 0 830 840 820
ISQL crashes when fetching data for a column having alias longer than 30 characters
86 SS 975 1000 1090 1060 1110 970 1010 1010 1040 970 1020 970 1000 990 10 910 1080 890 870 910 990 940 1120 940 910 980 1030 870 950 950 920
AV at prepare of query with unused parametrized CTE
87 SS 1090 1280 1020 1080 1150 1200 1130 1080 990 1100 1100 1050 1070 1050 0 1020 1050 1270 1060 1060 1100 1090 1130 1120 1090 1120 1090 1000 1130 1150 1060
Maximum key size using PXW_CSY collation
88 SS 1180 1180 1170 1200 1290 1240 1410 1220 1310 1240 1400 1180 1090 1590 0 1190 1080 1070 1160 1180 1140 1070 1160 1090 1080 1100 1090 1110 1240 1060 1240
Incorrect parser's reaction to the unquoted usage of the keyword "VALUE"
89 SS 4660 4920 4550 4530 4480 4660 4000 5460 4880 4000 4550 4740 5340 5210 0 4970 17340 4410 4730 4610 4590 4700 4470 4740 4670 4380 4410 4640 4480 4770 4710
Index is not used for some date/time expressions in dialect 1
90 SS 3290 3350 3350 3490 3410 3240 3260 3400 3570 3440 3480 3290 3290 3360 0 3330 3440 3210 3310 3170 3600 3210 3190 3260 3000 3150 3240 3190 3340 3170 3230
BLR error on restore database with computed by Field
91 SS 2150 2320 2140 2320 2220 2000 2170 2370 2350 2340 2420 2150 2100 2160 10 2540 2200 2320 2030 2140 2080 2270 2110 2100 2090 2090 2150 2110 2020 2120 2190
Roles granting/revoking logic
92 SS 1130 1240 1130 1340 1300 1220 1220 1180 1130 1000 1130 1200 1050 1150 10 1120 1080 1160 1130 1100 1040 1170 1170 1070 1120 1070 1080 1120 1090 1080 1160
Error on script with current_date
93 SS 1460 1460 1430 1570 1530 1570 1000 1540 1680 1510 1460 1430 1690 1510 10 1450 1510 1360 1450 1000 1700 1420 1400 1460 1510 1440 1550 1430 1460 1470 1650
Circular dependencies between computed fields crashs the engine
94 SS 630 680 640 710 690 670 650 700 0 600 670 630 620 600 0 630 650 610 630 620 630 630 630 610 610 600 680 580 620 640 620
GROUP BY RAND() returns infinite rows
95 SS 980 980 1030 1010 1010 1060 1090 1150 1060 1030 1020 1090 940 970 10 1120 940 960 910 980 950 970 930 1010 930 980 980 940 980 920 930
Non-SYSDBA user can change FW mode of database.
96 SS 1560 1490 1600 1000 1570 2030 1560 1690 1590 1550 1560 1560 1520 1560 10 1550 1510 1610 1560 1600 1840 1610 1570 1700 1430 1480 1650 1440 1520 1530 1580
Broken foreign key handling for multi-segmented index using multi-level collations
97 SS 2520 2590 2740 2540 2600 2710 2670 2630 2000 2580 2630 2790 2630 2520 0 2000 2680 2410 2510 2480 2460 2400 2430 2460 2470 2540 2460 2410 2570 2490 2480
TimeStamp in the every line output gbak.exe utility
98 SS 640 630 920 780 680 730 860 650 780 680 630 640 620 660 0 650 720 630 660 640 640 640 640 620 600 580 660 590 600 620 620
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user
99 SS 850 910 890 980 930 900 910 880 1000 870 890 820 860 880 10 910 790 850 870 790 810 810 810 810 800 790 850 810 850 760 840
SUBSTRING with regular expression (SIMILAR TO) capability
100 SS 1060 1320 1060 1080 1170 1340 980 1150 1020 1080 1120 990 1080 1060 0 1060 1100 1090 950 1000 1030 950 1020 1100 1020 1070 970 990 1020 1010 970
NOT NULL procedure parameters
101 SS 6200 6430 6000 6560 6210 6270 6010 6080 5700 6600 6440 6530 6020 6000 0 6140 6530 7200 6060 5620 6450 7220 5930 6050 7140 5600 6480 6340 6200 6020 5860
I/O statistics for stored procedures are not accounted in monitoring tables
102 SS 855 910 990 920 910 850 920 940 950 920 940 890 910 880 0 860 850 770 870 830 0 760 840 740 800 740 850 740 790 810 760
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT
103 SS 650 760 650 660 700 760 770 620 710 730 680 760 650 740 0 610 700 630 700 590 770 610 620 630 620 620 580 600 630 590 670
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining
104 SS 1100 1180 1230 1240 1330 1100 1190 1150 1110 1080 1160 1100 1110 1040 10 1100 1240 1130 1190 1150 1100 1050 1130 1090 1050 1050 1070 1060 1100 1040 1030
Domain-level CHECK constraints wrongly process NULL values
105 SS 1570 1730 1580 1720 1610 1570 1690 1510 1590 1600 1900 1530 1570 1640 0 1720 1610 1420 1590 1480 1480 1610 1540 1480 1520 1560 1550 1480 1700 1520 1540
update or insert with gen_id() with wrong generator value
106 SS 1570 1650 1000 1580 1580 1000 1600 1630 1660 1550 1610 1600 1530 1620 10 1700 1730 1000 1760 1490 1510 1000 1490 1440 1590 1530 1430 1600 1590 1400 1560
don't work subquery in COALESCE
107 SS 1120 1290 1100 1190 1370 1200 1120 1110 1240 1100 1130 1120 1130 1160 0 1120 1180 1050 1370 1180 1060 1090 1050 1100 1070 1040 1160 1070 1110 1130 1060
ALTER VIEW WITH CHECK OPTION crashes the engin
108 SS 1470 1450 1440 1440 1740 1870 1520 1580 1670 1470 1580 1450 1630 1530 0 1580 1330 1400 1410 1430 1630 1480 1490 1430 1360 1470 1380 1430 1470 1450 1410
Parts of RDB$DB_KEY of views may be inverted when using outer joins
109 SS 1480 1790 1430 1550 1530 1410 1840 1850 1540 1470 1440 1480 1430 1600 0 1730 1490 1370 1530 1520 1390 1440 1360 1370 1670 1410 1510 1340 1360 1590 1350
View over global temporary table
110 SS 1290 1320 1520 1290 1360 1290 1330 1320 1370 1290 1360 1280 1450 1360 0 1000 1400 1160 1370 1000 1000 1230 1370 1240 1000 1210 1280 1240 1630 1210 1310
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor
111 SS 1425 1470 1400 1650 1450 1380 1000 1490 1520 1450 1700 1350 1380 1370 10 1460 1310 1470 1370 1360 1370 1520 1440 1370 1580 1330 1410 1280 1510 1490 1480
Join of SP with view or table may fail with "No current record for fetch operation"
112 SS 995 1060 1070 1020 1030 1080 1000 1040 1010 1150 1000 960 960 960 10 1060 1040 970 950 970 1070 940 960 900 950 950 1020 970 990 1190 960
Unexpected (wrong) results with COALESCE and GROUP BY
113 SS 3790 4110 3790 4330 4140 4120 3920 4110 4070 3710 4020 3810 3740 3830 0 4170 3650 3680 3630 4120 3670 3820 3670 3990 3610 3560 3780 3420 3610 3780 3790
New gbak option to ignore specific tables data during the backup
114 SS 1165 1350 1160 1280 1190 1190 1340 1240 1190 1000 1210 1150 1160 1300 10 1180 1210 1140 1240 1080 1150 1090 1130 1150 1170 1050 1190 1060 1210 1090 1120
Problem with column names with Accents and triggers
115 CS 1970 2090 2320 1890 2030 1970 2020 1930 1880 2080 1930 1980 1920 860 1920 2010 1970 1890 1760 2130 2100 2310 1970 1950 2000 1900 2220 1880 1880
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
116 SS 1260 1360 1240 1370 1360 1190 1260 1270 1420 1260 1430 1370 1210 1260 10 1360 1380 1210 1290 1270 1350 1240 1300 1200 1240 1170 1210 1160 1180 1210 1210
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
117 SS 1025 1110 1240 1050 1160 1130 1020 1050 1030 980 1140 1080 1030 1070 10 1020 1050 900 1010 1010 1010 980 1000 1020 990 1070 1000 1010 1030 1080 1020
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.
118 SS 1550 1620 1000 1630 1810 1590 1580 1630 1620 1660 1790 1590 1600 1600 0 1700 1490 1490 1540 1460 1570 1520 1540 1550 1520 1490 1470 1480 1540 1540 1530
gbak doesn't return error code
119 SS 1580 1570 1710 1650 1610 1670 1550 1540 1660 1730 1630 1550 1810 1830 0 1560 1650 1450 1600 1000 1580 1480 1480 1650 1710 1440 1520 1550 1000 1580 1520
Wrong (primary) constraint name is reported for the foreign key violation during FK creation
120 SS 1235 1290 1340 1310 1370 1350 1260 1260 1450 1270 1420 1400 1240 1310 10 1290 1220 1200 1260 1200 1200 1000 1220 1220 1210 1210 1230 1150 1170 1200 1190
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
121 SS 2570 2980 3050 2730 2900 2850 2560 2760 2810 2580 2770 2600 2590 2620 0 2580 2740 2410 2450 2530 2490 2550 2560 2570 2560 2450 2440 2450 2510 2440 2430
Incomplete API information values
122 SS 1025 1100 1010 980 1000 1040 1120 1160