01. Total results for each kind of outcome and server mode, for previous 30 runs
02. NEW CRASHES/BUGCHECKS: tests that caused FB abnormal termination for LAST run (0 rows)
03. NEW FAILS: tests which failed for LAST run (0 rows)
04. NEW ERRORS: tests which raised runtime error for LAST run (0 rows)
04. STILL FAILS: tests which fail for at least TWO LAST runs (964 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (1 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (26 rows)
07. Has fails: tests with at least one fail for previous 30 runs (1618 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (5 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (24 rows)
[CURRENT] 10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (319 rows)
11. All tests: outcomes for previous 30 runs (3520 rows)
12. Skipped: tests which was intentionally excluded from execution (78 rows)

Generated UTC 01.07.2025 03:47
Tested: FB60.   Build / date: 6.0.0.881-7035d6ee / 2025.06.27;
Test machine: Windows 10 10.0.19045; logical CPUs: 8; RAM: 31 Gb 
QA software: Python: 3.11.2; pytest: 7.4.4; firebird.driver: 1.10.9; firebird.Qa: 0.19.3 
Loading data. Please wait...

Jump to the list of unique test names from this report
Jump to the list with last developing commits information

Tests with result = "PASSED" after previous outcome = FAIL/ERROR/SKIPPED or absent:

NN Test name mode
6.0.0.881
2025.06.27
6.0.0.877
2025.06.26
6.0.0.876
2025.06.25
6.0.0.863
2025.06.24
6.0.0.858
2025.06.24
6.0.0.858
2025.06.23
6.0.0.854
2025.06.23
6.0.0.849
2025.06.20
6.0.0.848
2025.06.19
6.0.0.845
2025.06.18
6.0.0.843
2025.06.16
6.0.0.840
2025.06.14
6.0.0.838
2025.06.13
6.0.0.834
2025.06.11
6.0.0.800
2025.06.10
6.0.0.799
2025.06.07
6.0.0.797
2025.06.06
6.0.0.795
2025.05.29
6.0.0.792
2025.05.28
6.0.0.791
2025.05.27
6.0.0.789
2025.05.21
6.0.0.787
2025.05.20
6.0.0.783
2025.05.12
6.0.0.779
2025.05.11
6.0.0.778
2025.05.07
6.0.0.776
2025.05.06
6.0.0.770
2025.05.05
6.0.0.767
2025.05.01
6.0.0.762
2025.04.30
6.0.0.755
2025.04.29
Test TITLE
1 SS P F P P P P P P P P P P P P P P P P P P P P P P P P P P F P
Count (DISTINCT ...) is too slow
2 CS P F F E E E E E E E E E E E P P P P P P P P P P P P P P P P
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
3 SS P F F E E E E E E E E E E E P P P P P P P P P P P P P P P P
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
4 CS P F F F F F F F F F F F F F 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
5 SS P F F F F F F F F F F F F F 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
6 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Prohibit any improper mixture of explicit and implicit joins
7 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Prohibit any improper mixture of explicit and implicit joins
8 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Join condition fails for UTF-8 databases
9 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Join condition fails for UTF-8 databases
10 CS P F F F F F F F F F F F F F 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
11 SS P F F F F F F F F F F F F F 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
12 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
isql should show packaged procedures and functions categorized per package
13 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
isql should show packaged procedures and functions categorized per package
14 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
PK index is not used for derived tables
15 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
PK index is not used for derived tables
16 CS P F F F F F F F F F F F F F 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)
17 SS P F F F F F F F F F F F F F 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)
18 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Broken error handling in the case of a conversion error happened during index creation
19 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Broken error handling in the case of a conversion error happened during index creation
20 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
DROP VIEW drops output parameters of used stored procedures
21 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
DROP VIEW drops output parameters of used stored procedures
22 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
23 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
24 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
25 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
26 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
27 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
28 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
29 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
30 CS P F F F F F F F F F F F F F 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
31 SS P F F F F F F F F F F F F F 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
32 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
33 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
34 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Cannot alter the domain after migrating from older versions
35 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Cannot alter the domain after migrating from older versions
36 CS P F F F F F F F F F F F F F 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
37 SS P F F F F F F F F F F F F F 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
38 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Expression index with TRIM may lead to incorrect indexed lookup
39 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Expression index with TRIM may lead to incorrect indexed lookup
40 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Index is not used when view has "subselect" column
41 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Index is not used when view has "subselect" column
42 CS P F F F F F F F F F F F F F 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 crashes the server
43 SS P F F F F F F F F F F F F F 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 crashes the server
44 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
45 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
46 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
UTF8 UNICODE_CI collate can not be used in compound index
47 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
UTF8 UNICODE_CI collate can not be used in compound index
48 CS P F F F F F F F F F F F F F 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
49 SS P F F F F F F F F F F F F F 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
50 CS P F F F F F F F F F F F F F 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
51 SS P F F F F F F F F F F F F F 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
52 CS P F F F F F F F F F F F F F 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
53 SS P F F F F F F F F F F F F F 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
54 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Sub-optimal join plan when the slave table depends on the master via the "OR" predicate
55 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Sub-optimal join plan when the slave table depends on the master via the "OR" predicate
56 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
57 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
58 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB
59 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB
60 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Generators are set to 0 after restore
61 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Generators are set to 0 after restore
62 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Blob filter to translate internal debug info into text representation
63 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Blob filter to translate internal debug info into text representation
64 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
65 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
66 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Recurse leads to hangs/crash server
67 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Recurse leads to hangs/crash server
68 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
[FB3] AV with "UPDATE OR INSERT"
69 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
[FB3] AV with "UPDATE OR INSERT"
70 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Inefficient optimization (regression)
71 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Inefficient optimization (regression)
72 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression in joins on procedures
73 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression in joins on procedures
74 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Altering of a TYPE OF COLUMN parameter affects the original column
75 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Altering of a TYPE OF COLUMN parameter affects the original column
76 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
DROP VIEW ignores the existing non-column dependencies
77 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
DROP VIEW ignores the existing non-column dependencies
78 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Alter procedure allows to add the parameter with the same name
79 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Alter procedure allows to add the parameter with the same name
80 CS P F F F F F F F F F F F F F 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"
81 SS P F F F F F F F F F F F F F 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"
82 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Inconsistent domain's constraint validation in PSQL
83 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Inconsistent domain's constraint validation in PSQL
84 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Floating-point negative zero doesn't match positive zero in the index
85 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Floating-point negative zero doesn't match positive zero in the index
86 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
87 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
88 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
CHAR(32767) present in XSQLVAR with length 32765
89 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
CHAR(32767) present in XSQLVAR with length 32765
90 CS P F F F F F F F F F F F F F 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
91 SS P F F F F F F F F F F F F F 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
92 CS P F F F F F F F F F F F F F 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
93 SS P F F F F F F F F F F F F F 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
94 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Can insert DUPLICATE keys in UNIQUE index
95 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Can insert DUPLICATE keys in UNIQUE index
96 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Server crashes with access violation when inserting row into table with unique index
97 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Server crashes with access violation when inserting row into table with unique index
98 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
computed index by substring function for long columns
99 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
computed index by substring function for long columns
100 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Wrong warning message for ambiguous query
101 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Wrong warning message for ambiguous query
102 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Wrong warning message for ambiguous query
103 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Wrong warning message for ambiguous query
104 CS P F F F F F F F F F F F F F 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
105 SS P F F F F F F F F F F F F F 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
106 CS P F F F F F F F F F F F F F 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
107 SS P F F F F F F F F F F F F F 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
108 CS P F F F F F F F F F F F F F 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
109 SS P F F F F F F F F F F F F F 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
110 CS P F F F F F F F F F F F F F 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
111 SS P F F F F F F F F F F F F F 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
112 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Conversion error when using a blob as an argument for the EXCEPTION statement
113 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Conversion error when using a blob as an argument for the EXCEPTION statement
114 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Usage of a NATURAL JOIN with a derived table crashes the server
115 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Usage of a NATURAL JOIN with a derived table crashes the server
116 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Extend the error reported for index/constraint violations to include the problematic key value
117 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Extend the error reported for index/constraint violations to include the problematic key value
118 CS P F F F F F F F F F F F F F 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
119 SS P F F F F F F F F F F F F F 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
120 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Derived fields may not be optimized via an index
121 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Derived fields may not be optimized via an index
122 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Creating self-referential FK crashes database (bug-check) whether constraint violation had place
123 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Creating self-referential FK crashes database (bug-check) whether constraint violation had place
124 CS P F F F F F F F F F F F F F 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
125 SS P F F F F F F F F F F F F F 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
126 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
isql doesn't know the difference between UDF's and psql-functions
127 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
isql doesn't know the difference between UDF's and psql-functions
128 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Original table name and column name and owner missing from SQLDA for aliased column in grouped query
129 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Original table name and column name and owner missing from SQLDA for aliased column in grouped query
130 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Join using RDB$DB_KEY produce NATURAL plan
131 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Join using RDB$DB_KEY produce NATURAL plan
132 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Creating table with computed fields containing "SELECT FIRST" produces corrupted result
133 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Creating table with computed fields containing "SELECT FIRST" produces corrupted result
134 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Broken optimization for the stored dbkeys
135 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Broken optimization for the stored dbkeys
136 CS P F F F F F F F F F F F F F 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
137 SS P F F F F F F F F F F F F F 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
138 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Computed by columns and position function
139 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Computed by columns and position function
140 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Server bugchecks or crashes on exception in calculated index
141 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Server bugchecks or crashes on exception in calculated index
142 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: Group by fails if subselect-column is involved
143 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: Group by fails if subselect-column is involved
144 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Bad optimization of OR predicates applied to unions
145 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Bad optimization of OR predicates applied to unions
146 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
COMPUTED BY field is evaluated as NULL if used as an exception parameter directly
147 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
COMPUTED BY field is evaluated as NULL if used as an exception parameter directly
148 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Expression index may be not used for derived fields or view fields
149 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Expression index may be not used for derived fields or view fields
150 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Metadata source becomes wrong after twice transliteration to the metadata charset
151 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Metadata source becomes wrong after twice transliteration to the metadata charset
152 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Metadata export with isql (option -ex) does not export functions properly
153 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Metadata export with isql (option -ex) does not export functions properly
154 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error
155 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error
156 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
New permission types are not displayed by ISQL
157 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
New permission types are not displayed by ISQL
158 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE
159 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE
160 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
The parameterized exception does not accept not ASCII characters as parameter
161 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
The parameterized exception does not accept not ASCII characters as parameter
162 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Replace the hierarchical union execution with the plain one
163 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Replace the hierarchical union execution with the plain one
164 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Cannot create packaged routines with [VAR]CHAR parameters
165 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Cannot create packaged routines with [VAR]CHAR parameters
166 CS P F F F F F F F F F F F F F 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
167 SS P F F F F F F F F F F F F F 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
168 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Preserve comments for output parameters after altering procedures
169 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Preserve comments for output parameters after altering procedures
170 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
GTT should not reference permanent relation
171 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
GTT should not reference permanent relation
172 CS P F F F F F F F F F F F F F 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
173 SS P F F F F F F F F F F F F F 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
174 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Add table name to text of validation contraint error message, to help identify error context
175 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Add table name to text of validation contraint error message, to help identify error context
176 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Context parsing error with derived tables and CASE functions
177 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Context parsing error with derived tables and CASE functions
178 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Error on create table with "CHARACTER SET DOS775" field
179 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Error on create table with "CHARACTER SET DOS775" field
180 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
FB3: Stored function accepts duplicate input arguments
181 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
FB3: Stored function accepts duplicate input arguments
182 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed
183 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed
184 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Choose the best matching index for navigation
185 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Choose the best matching index for navigation
186 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Engine crashes when attempt to REcreate table with FK after syntax error before such recreating
187 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Engine crashes when attempt to REcreate table with FK after syntax error before such recreating
188 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers
189 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers
190 CS P F F F F F F F F F F F F F 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
191 SS P F F F F F F F F F F F F F 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
192 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Non-privileged user can delete records from RDB$SECURITY_CLASSES table
193 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Non-privileged user can delete records from RDB$SECURITY_CLASSES table
194 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause)
195 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause)
196 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
non-priviledged user can insert and update rdb$database
197 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
non-priviledged user can insert and update rdb$database
198 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Equality predicate distribution does not work for some complex queries
199 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Equality predicate distribution does not work for some complex queries
200 CS P F F F F F F F F F F F F F 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 <...>
201 SS P F F F F F F F F F F F F F 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 <...>
202 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Duplicate names in package are not checked
203 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Duplicate names in package are not checked
204 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Preparation of erroneous DDL statement does not show the main command failed
205 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Preparation of erroneous DDL statement does not show the main command failed
206 CS P F F F F F F F F F F F F F 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
207 SS P F F F F F F F F F F F F F 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
208 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Incorrect line/column information in runtime errors
209 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Incorrect line/column information in runtime errors
210 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Report more details for "object in use" errors
211 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Report more details for "object in use" errors
212 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Allow referencing cursors as record variables in PSQL
213 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Allow referencing cursors as record variables in PSQL
214 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Useless extraction of generic DDL trigger
215 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Useless extraction of generic DDL trigger
216 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
217 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
218 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Allow output to trace explain plan form.
219 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Allow output to trace explain plan form.
220 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: NOT NULL constraint, declared in domain, does not work
221 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: NOT NULL constraint, declared in domain, does not work
222 CS P F F F F F F F F F F F F F P P P P P P P P P F F P P P P P
FB3: CREATE USER GRANT ADMIN ROLE does not work
223 SS P F F F F F F F F F F F F F P P P P P P P P P F F P P P P P
FB3: CREATE USER GRANT ADMIN ROLE does not work
224 CS P F F F F F F F F F F F F F 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
225 SS P F F F F F F F F F F F F F 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
226 CS P F F F F F F F F F F F F F 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
227 SS P F F F F F F F F F F F F F 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
228 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval
229 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval
230 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
New gbak option to enable encryption during restore
231 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
New gbak option to enable encryption during restore
232 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
233 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
234 CS P F F F F F F F F F F F F F 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
235 SS P F F F F F F F F F F F F F 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
236 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
DB_KEY based join of two tables may be ineffective
237 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
DB_KEY based join of two tables may be ineffective
238 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Server does not accept the right plan
239 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Server does not accept the right plan
240 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
DDL trigger remains active after dropped
241 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
DDL trigger remains active after dropped
242 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN
243 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN
244 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments
245 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments
246 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Can't create column check constraint when the column is domain based
247 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Can't create column check constraint when the column is domain based
248 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
249 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
250 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N }
251 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N }
252 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: computed index based on a computed column stores NULL for all its keys
253 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: computed index based on a computed column stores NULL for all its keys
254 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
255 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
256 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: Join order in v3 is less optimal than in v2.x
257 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: Join order in v3 is less optimal than in v2.x
258 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Implement ability to validate tables and indices online (without exclusive access to database)
259 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Implement ability to validate tables and indices online (without exclusive access to database)
260 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
261 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
262 CS P F F F F F F F F F F F F F 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
263 SS P F F F F F F F F F F F F F 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
264 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
265 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
266 CS P F F F F F F F F F F F F F 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 ..."
267 SS P F F F F F F F F F F F F F 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 ..."
268 CS P F F F F F F F F F F F F F 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
269 SS P F F F F F F F F F F F F F 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
270 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles)
271 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles)
272 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Parameterized exception: wrong output when number of arguments greater than 7
273 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Parameterized exception: wrong output when number of arguments greater than 7
274 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
275 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
276 CS P F F F F F F F F F F F F F 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
277 SS P F F F F F F F F F F F F F 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
278 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL
279 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL
280 CS P F F F F F F F F F F F F F 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
281 SS P F F F F F F F F F F F F F 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
282 CS P F F F F F F F F F F F F F P P P P P P P P P F F P P P P P
Regression: generators can be seen/modified by unprivileged users
283 SS P F F F F F F F F F F F F F P P P P P P P P P F F P P P P P
Regression: generators can be seen/modified by unprivileged users
284 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: List of aggregation is not checked properly
285 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Regression: List of aggregation is not checked properly
286 CS P F F F F F F F F F F F F F 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
287 SS P F F F F F F F F F F F F F 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
288 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Make user names behave according to SQL identifiers rules
289 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Make user names behave according to SQL identifiers rules
290 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
291 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
292 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Make ISQL display character set when sqlda_display is on
293 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Make ISQL display character set when sqlda_display is on
294 CS P F F F F F F F F F F F F F 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
295 SS P F F F F F F F F F F F F F 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
296 CS P F F F F F F F F F F F F F P P P P P P P P P F F P P P P P
SHOW GRANTS does not display info about exceptions which were granted to user
297 SS P F F F F F F F F F F F F F P P P P P P P P P F F P P P P P
SHOW GRANTS does not display info about exceptions which were granted to user
298 CS P F F F F F F F F F F F F F 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
299 SS P F F F F F F F F F F F F F 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
300 CS P F F F F F F F F F F F F F 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"
301 SS P F F F F F F F F F F F F F 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"
302 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Crash on pasring of script containing `execute block` with lot of nested begin..end statements
303 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Crash on pasring of script containing `execute block` with lot of nested begin..end statements
304 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Invalid internal BLR filter conversion
305 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Invalid internal BLR filter conversion
306 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
307 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
308 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
309 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
310 CS P F F F F F F F F F F F F F 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
311 SS P F F F F F F F F F F F F F 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
312 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Add label about deterministic flag for stored function in SHOW and extract commands
313 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Add label about deterministic flag for stored function in SHOW and extract commands
314 CS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Operator REVOKE can modify rights granted to system tables at DB creation time
315 SS P F F F F F F F F F F F F F P P P P P P P P P P P P P P P P
Operator REVOKE can modify rights granted to system tables at DB creation time
316 CS P F F F F F F F F F F F F F 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
317 SS P F F F F F F F F F F F F F 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
318 CS P F F P P P P P P P P P P P P P P P P P P P P P P P P P P P
Restore of encrypted backup of database with SQL dialect 1 fails
319 SS P F F P P P P P P P P P P P P P P P P P P P P P P P P P P P
Restore of encrypted backup of database with SQL dialect 1 fails

Elapsed time, milliseconds:

NN Test name mode median_ms
6.0.0.881
2025.06.27
6.0.0.877
2025.06.26
6.0.0.876
2025.06.25
6.0.0.863
2025.06.24
6.0.0.858
2025.06.24
6.0.0.858
2025.06.23
6.0.0.854
2025.06.23
6.0.0.849
2025.06.20
6.0.0.848
2025.06.19
6.0.0.845
2025.06.18
6.0.0.843
2025.06.16
6.0.0.840
2025.06.14
6.0.0.838
2025.06.13
6.0.0.834
2025.06.11
6.0.0.800
2025.06.10
6.0.0.799
2025.06.07
6.0.0.797
2025.06.06
6.0.0.795
2025.05.29
6.0.0.792
2025.05.28
6.0.0.791
2025.05.27
6.0.0.789
2025.05.21
6.0.0.787
2025.05.20
6.0.0.783
2025.05.12
6.0.0.779
2025.05.11
6.0.0.778
2025.05.07
6.0.0.776
2025.05.06
6.0.0.770
2025.05.05
6.0.0.767
2025.05.01
6.0.0.762
2025.04.30
6.0.0.755
2025.04.29
Test TITLE
1 SS 17656 17334 18471 43018 17628 17353 17350 17966 17874 17656 17539 17454 17664 17824 17772 17658 18107 17539 17657 17626 17705 17683 17286 18185 17489 17382 17799 17343 17332 18053 17286
Count (DISTINCT ...) is too slow
2 CS 1304 1438 1476 1449 511 494 503 520 520 507 498 490 510 518 501 1310 1318 1316 1381 1312 1316 1305 1330 1295 1326 1303 1308 1297 1336 1315 1282
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
3 SS 981 1321 1152 1162 407 409 384 404 728 895 694 385 641 387 436 1009 1209 983 1025 1264 977 1358 993 971 1032 975 980 1020 1006 1007 1046
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
4 CS 586 619 642 585 654 615 595 596 595 597 594 588 598 588 626 580 567 542 566 582 572 574 599 592 544 548 572 539 548 554 570
Views based on procedures can't be created if the proc's output fields participate in an expression
5 SS 375 387 408 2713 420 404 409 397 411 400 402 408 416 405 406 372 373 357 362 373 364 359 377 369 367 362 366 362 364 359 361
Views based on procedures can't be created if the proc's output fields participate in an expression
6 CS 808 828 851 816 855 841 813 815 821 842 818 834 876 828 848 814 753 804 754 754 766 784 768 753 764 750 752 752 756 753 752
Prohibit any improper mixture of explicit and implicit joins
7 SS 539 540 564 3296 576 548 580 781 987 1066 1009 556 998 564 622 502 538 512 516 527 558 519 505 497 512 528 529 503 517 533 533
Prohibit any improper mixture of explicit and implicit joins
8 CS 598 635 604 603 683 613 614 639 649 617 602 635 636 602 597 571 580 558 559 575 554 586 599 590 578 556 569 569 565 561 618
Join condition fails for UTF-8 databases
9 SS 402 410 425 1700 419 420 416 425 421 435 425 424 442 421 711 403 374 376 391 374 377 376 382 379 391 401 377 378 384 373 374
Join condition fails for UTF-8 databases
10 CS 649 686 674 701 702 669 662 664 662 662 689 657 666 652 686 611 616 615 605 647 620 612 612 598 611 608 644 605 617 609 651
Natural is used to select instead of primary key index
11 SS 443 455 465 1201 462 475 485 482 934 474 465 468 883 486 501 422 428 418 420 422 431 426 427 423 428 458 423 425 429 431 430
Natural is used to select instead of primary key index
12 CS 592 590 607 625 641 599 611 601 630 599 606 630 653 677 641 604 561 557 591 562 553 552 594 581 588 560 563 584 586 557 551
isql should show packaged procedures and functions categorized per package
13 SS 384 409 443 1306 419 429 666 424 425 463 417 421 432 423 429 359 382 373 375 374 386 382 375 367 371 359 372 359 377 366 372
isql should show packaged procedures and functions categorized per package
14 CS 775 586 819 809 850 819 795 834 800 821 840 797 808 797 792 778 767 764 771 753 772 755 754 768 771 756 784 746 753 743 740
PK index is not used for derived tables
15 SS 525 391 581 1963 546 544 556 562 561 586 546 543 591 570 837 520 500 498 515 530 512 517 519 497 533 502 516 503 506 519 507
PK index is not used for derived tables
16 CS 589 592 633 598 625 592 594 622 597 630 598 585 641 603 602 638 608 585 585 585 547 556 586 569 583 587 560 549 562 545 548
Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1)
17 SS 386 394 417 1654 409 417 423 408 410 418 403 405 412 418 399 361 367 358 374 376 361 369 357 360 399 360 378 376 378 377 379
Exception when upper casing string with 'ÿ' (lowercase y trema, code 0xFF in ISO8859_1)
18 CS 586 633 640 585 620 635 594 607 625 592 588 591 600 603 592 547 598 539 546 547 553 541 545 532 548 545 561 550 550 590 549
Broken error handling in the case of a conversion error happened during index creation
19 SS 378 390 412 1689 403 407 418 409 406 404 404 400 400 402 411 363 359 361 362 360 375 377 362 359 370 367 356 362 372 375 379
Broken error handling in the case of a conversion error happened during index creation
20 CS 787 594 822 798 828 819 816 818 806 835 836 807 826 815 788 782 749 788 750 749 755 750 757 781 766 786 784 785 800 749 739
DROP VIEW drops output parameters of used stored procedures
21 SS 531 390 556 1373 566 558 563 548 563 611 559 563 555 577 560 545 503 518 512 517 531 518 501 501 518 505 524 512 521 532 516
DROP VIEW drops output parameters of used stored procedures
22 CS 805 631 809 835 918 815 810 827 812 814 815 819 864 809 810 771 787 764 803 797 807 765 776 768 789 793 765 775 1051 764 743
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
23 SS 524 393 565 559 604 567 591 855 569 727 850 550 773 569 1128 506 523 522 523 522 523 522 519 522 519 519 523 525 522 525 520
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
24 CS 801 603 874 816 855 821 828 823 825 821 822 808 883 818 807 804 773 765 811 760 754 749 780 758 776 798 783 784 757 748 783
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
25 SS 533 402 562 788 568 569 587 566 561 561 574 558 610 597 589 533 517 526 527 519 529 528 515 522 533 525 534 525 517 525 519
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
26 CS 609 612 621 642 653 628 607 615 647 645 632 613 630 611 620 587 569 603 663 573 605 596 563 560 578 616 591 558 570 566 576
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
27 SS 398 401 439 459 429 442 428 429 430 808 437 438 429 433 428 393 394 391 388 389 381 380 378 395 410 373 378 379 379 380 382
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
28 CS 717 830 758 717 763 718 749 756 748 749 710 718 749 744 759 727 708 675 734 666 655 667 662 682 674 670 680 679 779 657 669
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
29 SS 513 831 537 683 544 543 540 544 553 537 531 524 700 530 534 499 503 658 486 483 477 482 472 479 490 472 492 470 492 489 485
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
30 CS 791 646 802 793 829 833 826 812 839 833 847 789 857 833 823 770 748 752 801 750 758 761 748 753 756 762 749 800 745 813 749
Using both the procedure name and alias inside an explicit plan crashes the server
31 SS 524 396 547 600 539 552 568 540 550 552 544 552 539 566 544 522 507 506 521 495 545 497 506 508 526 520 509 508 508 490 491
Using both the procedure name and alias inside an explicit plan crashes the server
32 CS 594 608 639 600 641 615 610 633 635 607 608 605 656 671 609 575 566 560 614 586 567 554 589 549 555 569 546 579 555 545 552
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
33 SS 406 403 417 558 426 428 420 418 418 428 418 414 419 443 424 811 378 368 379 363 410 376 398 377 366 385 361 377 378 379 376
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
34 CS 932 960 966 984 1088 1009 979 963 946 980 949 967 958 1028 996 890 918 883 915 880 898 886 877 882 911 949 878 883 881 878 896
Cannot alter the domain after migrating from older versions
35 SS 623 642 639 701 641 653 647 626 663 650 652 647 649 652 651 621 602 594 597 582 639 590 592 577 598 585 593 576 587 584 583
Cannot alter the domain after migrating from older versions
36 CS 671 958 683 687 729 720 684 691 684 678 691 711 713 690 740 626 640 637 697 628 634 634 630 628 636 662 664 625 665 644 630
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
37 SS 464 517 493 572 491 497 492 495 536 504 486 515 497 486 479 466 456 449 449 455 463 443 442 441 442 440 439 444 440 445 452
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
38 CS 827 850 843 853 888 858 844 853 859 848 876 842 843 869 850 807 812 802 831 815 797 821 824 820 817 819 787 805 804 801 794
Expression index with TRIM may lead to incorrect indexed lookup
39 SS 571 594 593 608 591 591 593 598 595 620 608 596 669 792 592 548 561 543 553 548 582 543 547 549 554 560 560 553 550 543 548
Expression index with TRIM may lead to incorrect indexed lookup
40 CS 793 592 840 814 852 815 815 851 796 847 813 801 868 821 826 774 829 742 799 769 751 768 790 746 754 753 769 754 756 767 753
Index is not used when view has "subselect" column
41 SS 517 405 559 617 559 560 548 543 559 553 564 552 738 564 545 500 510 500 510 506 536 503 501 499 521 506 513 500 506 501 506
Index is not used when view has "subselect" column
42 CS 789 598 821 827 848 817 827 836 812 819 839 789 850 803 814 835 785 786 793 744 751 749 759 780 757 789 749 733 738 747 778
ALTER VIEW with not matched columns in declaration and selection crashes the server
43 SS 525 408 561 573 550 567 562 565 559 561 546 559 589 557 549 526 503 515 512 516 549 510 490 505 510 514 525 519 519 508 520
ALTER VIEW with not matched columns in declaration and selection crashes the server
44 CS 797 590 819 798 853 815 804 822 804 852 810 798 828 842 825 766 776 770 828 765 796 794 795 785 758 812 752 772 797 752 758
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
45 SS 534 403 551 568 576 564 555 556 563 569 734 539 774 556 743 517 520 536 515 518 533 516 508 512 508 519 522 515 522 535 516
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
46 CS 618 627 676 657 654 627 664 664 630 660 623 618 623 627 618 623 592 611 607 566 606 580 582 602 581 585 670 610 578 602 580
UTF8 UNICODE_CI collate can not be used in compound index
47 SS 425 438 438 451 455 430 450 440 426 437 824 425 435 424 722 738 392 399 388 393 427 393 388 392 393 392 394 393 396 427 388
UTF8 UNICODE_CI collate can not be used in compound index
48 CS 580 592 599 596 630 590 596 678 592 594 594 599 597 630 626 548 577 557 578 550 544 548 546 536 553 545 576 547 583 547 573
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
49 SS 383 386 404 1331 406 406 419 404 404 436 408 401 404 419 441 380 359 370 353 369 388 363 367 359 359 365 361 367 366 365 361
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
50 CS 582 592 586 590 619 590 599 611 627 595 596 593 592 628 606 556 585 546 553 576 541 546 543 567 552 576 556 541 580 549 548
"BLOB not found" error after creation/altering of the invalid trigger
51 SS 397 386 407 1363 401 410 408 401 401 408 400 404 436 414 410 358 361 438 825 355 394 358 356 359 357 365 367 362 358 362 366
"BLOB not found" error after creation/altering of the invalid trigger
52 CS 798 824 807 798 856 812 843 846 836 835 856 798 843 834 829 832 764 751 753 762 759 763 749 833 753 758 756 752 750 791 756
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
53 SS 544 565 558 913 574 572 571 568 563 576 585 559 556 1033 571 523 533 513 499 513 548 534 517 503 503 502 506 518 541 502 498
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
54 CS 576 583 580 579 618 600 602 596 583 588 589 621 628 595 578 543 544 540 568 550 537 543 545 576 544 542 537 576 550 542 530
Sub-optimal join plan when the slave table depends on the master via the "OR" predicate
55 SS 388 383 393 608 406 402 394 404 412 402 399 406 406 408 396 361 373 363 365 348 395 352 360 356 361 363 360 420 356 344 346
Sub-optimal join plan when the slave table depends on the master via the "OR" predicate
56 CS 589 597 636 592 634 606 594 618 601 627 594 592 597 607 616 574 549 586 541 556 585 618 562 548 553 554 547 552 545 546 543
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
57 SS 393 389 407 608 406 414 413 405 418 424 407 402 808 407 562 397 362 380 370 360 397 359 357 364 360 362 371 377 359 361 366
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
58 CS 572 580 585 623 616 641 596 616 616 578 589 618 639 593 591 575 562 570 552 564 540 534 537 526 553 565 549 565 546 538 539
Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB
59 SS 388 385 412 537 402 409 403 454 405 402 436 411 434 419 437 360 360 392 357 358 394 358 360 358 360 363 361 361 363 356 341
Predicate 'blob_field LIKE ?' describes the parameter as VARCHAR(30) rather than as BLOB
60 CS 1034 1034 1070 1120 1091 1052 1090 1080 1042 1078 1046 1034 1074 1107 1058 959 949 998 957 947 953 947 1034 962 1018 1048 940 941 965 964 935
Generators are set to 0 after restore
61 SS 755 772 793 1011 785 808 783 781 776 812 779 780 985 791 777 714 719 1003 690 692 739 683 678 693 692 704 706 715 708 692 692
Generators are set to 0 after restore
62 CS 782 815 826 796 813 883 839 797 786 822 793 787 831 788 821 743 750 771 747 779 746 744 815 734 753 766 744 775 750 741 749
Blob filter to translate internal debug info into text representation
63 SS 527 533 543 694 546 559 560 560 565 551 527 545 648 619 541 501 505 720 499 497 527 501 502 490 504 504 506 513 503 500 506
Blob filter to translate internal debug info into text representation
64 CS 577 591 595 619 615 597 627 601 622 600 584 619 626 621 610 537 571 551 547 619 549 548 541 540 544 553 553 544 548 559 538
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
65 SS 388 392 401 2516 406 412 403 564 581 416 586 405 416 585 605 366 365 358 370 362 385 355 362 359 359 360 413 380 363 367 364
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
66 CS 770 760 968 851 859 854 846 853 842 851 857 852 840 851 838 733 806 733 771 727 732 736 728 718 770 735 735 752 731 720 731
Recurse leads to hangs/crash server
67 SS 547 555 601 825 605 620 616 618 618 621 661 602 684 663 640 539 518 535 514 531 517 586 506 521 532 537 534 513 517 520 518
Recurse leads to hangs/crash server
68 CS 806 646 823 819 843 830 848 822 817 818 842 843 830 819 845 789 774 781 750 777 809 819 755 754 763 804 749 757 751 747 744
[FB3] AV with "UPDATE OR INSERT"
69 SS 536 408 567 626 582 583 567 583 579 585 568 565 583 569 565 516 530 501 519 552 525 543 526 504 521 513 504 502 525 513 503
[FB3] AV with "UPDATE OR INSERT"
70 CS 607 617 648 648 639 629 614 618 614 651 674 609 657 611 646 633 605 565 563 571 569 564 567 562 566 563 559 564 588 564 564
Inefficient optimization (regression)
71 SS 397 433 432 440 419 452 448 584 438 430 423 441 439 436 426 380 380 383 391 369 372 380 372 394 373 387 374 374 400 376 376
Inefficient optimization (regression)
72 CS 1128 1203 1170 1130 1193 1149 1175 1175 1146 1172 1199 1142 1143 1193 1166 1122 1116 1095 1084 1095 1153 1127 1099 1087 1118 1110 1085 1088 1096 1098 1072
Regression in joins on procedures
73 SS 812 1301 813 902 814 830 814 811 854 825 827 827 1339 817 825 766 816 765 769 788 765 763 754 844 771 790 753 756 801 776 765
Regression in joins on procedures
74 CS 799 598 808 815 837 819 807 805 828 811 803 826 831 805 855 788 814 758 805 778 769 795 747 745 767 771 760 754 794 744 759
Altering of a TYPE OF COLUMN parameter affects the original column
75 SS 543 408 558 583 558 551 557 560 556 558 569 557 560 559 564 515 517 515 517 518 526 549 516 532 517 515 538 524 549 521 511
Altering of a TYPE OF COLUMN parameter affects the original column
76 CS 778 617 811 836 838 830 820 821 814 793 820 828 832 828 834 818 761 744 746 743 751 756 763 743 815 755 758 747 754 755 752
DROP VIEW ignores the existing non-column dependencies
77 SS 528 414 561 596 560 564 635 547 563 571 561 555 572 558 549 500 506 533 577 514 515 511 500 519 497 518 516 522 524 524 500
DROP VIEW ignores the existing non-column dependencies
78 CS 785 1277 827 784 837 862 796 794 802 807 787 840 816 837 801 799 762 744 788 755 747 756 735 755 758 745 750 758 738 754 743
Alter procedure allows to add the parameter with the same name
79 SS 516 544 549 617 544 550 549 556 542 560 545 544 586 563 558 501 501 497 502 509 509 500 499 500 506 496 517 516 503 497 504
Alter procedure allows to add the parameter with the same name
80 CS 596 602 617 599 635 602 607 609 605 631 596 602 596 603 602 608 571 582 614 576 542 568 584 588 564 550 555 577 563 551 572
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
81 SS 406 410 404 414 410 410 403 732 406 405 411 479 453 406 409 98 359 431 376 544 559 381 365 364 373 367 407 500 378 358 363
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
82 CS 600 615 648 614 647 631 649 621 619 642 611 622 638 644 669 609 573 574 568 561 579 581 563 573 591 575 567 568 575 568 562
Inconsistent domain's constraint validation in PSQL
83 SS 404 423 429 463 437 433 434 435 435 447 441 447 436 438 437 386 389 385 390 389 395 376 404 374 386 395 387 404 393 388 390
Inconsistent domain's constraint validation in PSQL
84 CS 793 842 860 813 847 839 812 823 848 855 817 813 815 825 875 754 798 783 765 746 751 777 749 748 788 754 786 751 765 749 767
Floating-point negative zero doesn't match positive zero in the index
85 SS 538 552 554 594 569 548 561 567 583 558 563 591 561 580 574 518 522 518 522 534 533 523 540 509 510 536 514 507 501 519 527
Floating-point negative zero doesn't match positive zero in the index
86 CS 575 580 581 586 621 597 614 618 585 612 618 577 583 620 609 554 569 529 561 573 551 543 534 580 571 535 566 529 542 537 538
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
87 SS 395 387 409 396 391 402 401 406 422 406 408 420 410 408 396 545 395 357 360 362 417 358 375 362 359 409 364 357 362 365 347
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
88 CS 583 598 628 622 621 625 605 627 603 601 595 621 611 633 586 581 580 586 552 546 554 575 554 571 555 555 546 535 563 560 569
CHAR(32767) present in XSQLVAR with length 32765
89 SS 386 437 409 417 422 411 410 718 443 416 684 417 840 684 422 361 363 359 369 371 360 374 379 362 394 364 358 361 374 363 362
CHAR(32767) present in XSQLVAR with length 32765
90 CS 582 590 599 593 630 605 596 597 585 598 591 594 590 591 598 592 545 551 541 544 549 575 551 567 551 549 575 539 569 541 580
Include expected and actual string lenght into error message for sqlcode -802
91 SS 370 402 410 408 405 402 405 423 413 405 407 404 421 410 410 359 364 374 358 360 354 355 362 364 359 359 360 362 362 366 360
Include expected and actual string lenght into error message for sqlcode -802
92 CS 2932 2970 3243 2922 2938 2949 2983 3217 2943 2953 2944 2931 3395 2948 2935 2955 2933 2881 2911 2874 2879 2874 2934 2899 2907 2866 2856 2912 2893 2865 2906
TRACE: add statistics of actions that were after transaction finished
93 SS 2684 2911 2692 2738 2707 2703 2726 2708 2735 2782 2704 2715 2824 2862 2718 2669 2672 3007 2669 2666 2673 2653 2656 2660 2669 2660 2672 2677 2654 2662 2663
TRACE: add statistics of actions that were after transaction finished
94 CS 651 671 668 652 678 682 672 667 668 691 681 675 659 682 688 616 650 609 610 627 609 615 620 781 627 619 620 609 613 604 607
Can insert DUPLICATE keys in UNIQUE index
95 SS 392 360 427 438 436 438 440 437 441 440 440 446 424 442 570 380 392 397 391 390 388 390 375 378 392 391 393 392 387 378 388
Can insert DUPLICATE keys in UNIQUE index
96 CS 581 595 585 600 601 594 604 636 596 636 638 596 652 598 600 580 550 557 546 582 581 554 542 547 558 541 554 576 572 572 540
Server crashes with access violation when inserting row into table with unique index
97 SS 397 403 404 423 402 416 406 449 419 406 408 412 414 405 406 364 359 364 372 361 367 485 368 392 371 383 375 364 360 366 362
Server crashes with access violation when inserting row into table with unique index
98 CS 612 636 625 615 647 624 654 621 617 632 630 713 669 675 648 598 622 564 571 610 600 565 578 565 573 579 574 573 569 566 572
computed index by substring function for long columns
99 SS 393 413 416 688 432 419 423 464 435 600 418 433 419 430 437 378 378 387 399 379 376 387 380 368 380 372 382 387 382 388 373
computed index by substring function for long columns
100 CS 569 589 582 582 587 601 589 589 587 623 618 610 580 588 631 569 546 540 537 552 534 556 546 532 545 547 541 552 570 532 537
Wrong warning message for ambiguous query
101 SS 374 391 402 408 420 393 403 803 672 400 402 397 727 410 409 359 371 358 359 351 365 357 365 361 361 378 364 360 362 358 360
Wrong warning message for ambiguous query
102 CS 575 579 594 583 611 596 617 620 585 595 584 623 605 591 578 568 598 541 543 544 537 548 566 536 572 549 541 548 573 540 542
Wrong warning message for ambiguous query
103 SS 377 391 393 406 402 429 408 400 397 405 405 406 414 407 413 357 360 365 360 362 350 371 355 346 370 359 357 357 357 383 361
Wrong warning message for ambiguous query
104 CS 595 598 597 614 642 632 600 648 630 607 626 600 667 627 593 604 587 547 551 585 556 613 561 550 545 555 546 548 548 582 550
Missing constraint name in foreign key error message in FB 2.1.4
105 SS 380 411 409 415 415 420 440 416 434 421 407 428 413 407 422 360 379 369 374 371 381 367 357 364 377 377 377 356 375 372 372
Missing constraint name in foreign key error message in FB 2.1.4
106 CS 768 1012 844 878 842 862 828 834 829 827 795 832 784 838 799 766 745 770 745 745 751 754 755 767 755 749 744 749 743 752 746
IS NOT DISTINCT FROM NULL doesn't use index
107 SS 519 408 548 558 555 542 552 583 536 569 577 538 541 539 543 516 523 503 502 519 516 519 497 497 499 506 504 504 514 520 499
IS NOT DISTINCT FROM NULL doesn't use index
108 CS 1182 1133 1231 1221 1264 1229 1218 1259 1297 1252 1221 1247 1254 1276 1235 1175 1130 1190 1125 1139 1144 1118 1192 1136 1139 1164 1159 1121 1124 1109 1125
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
109 SS 725 696 760 931 782 1221 807 745 1140 771 748 770 760 759 784 863 693 667 689 666 667 666 670 684 671 695 686 685 706 871 671
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
110 CS 1748 1746 1808 1789 1783 1789 1798 1784 1850 1792 1784 1783 1810 1793 1783 1708 1719 1735 1675 1702 1657 1658 1751 1677 1658 1723 1686 1763 1682 1685 1696
WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table
111 SS 969 849 1021 1040 1047 1037 1108 1028 1033 1075 1030 1060 1041 1053 1037 956 953 941 982 936 940 943 941 915 939 946 954 952 1148 944 950
WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table
112 CS 771 614 795 831 839 783 793 795 796 955 939 958 1004 986 976 757 739 744 732 783 1059 760 741 757 754 748 751 749 754 733 747
Conversion error when using a blob as an argument for the EXCEPTION statement
113 SS 511 390 528 573 714 555 548 533 825 596 557 561 561 563 550 505 648 503 504 505 502 501 502 484 502 516 507 497 503 500 503
Conversion error when using a blob as an argument for the EXCEPTION statement
114 CS 572 582 583 588 615 580 581 591 578 591 633 593 586 578 580 555 555 563 574 538 545 541 550 530 561 552 571 569 540 552 533
Usage of a NATURAL JOIN with a derived table crashes the server
115 SS 368 380 426 407 395 401 407 388 400 403 405 388 397 414 394 364 359 356 359 359 360 366 356 359 362 371 362 363 361 357 349
Usage of a NATURAL JOIN with a derived table crashes the server
116 CS 593 602 599 633 649 611 640 617 620 625 612 634 596 609 603 564 546 560 563 545 549 590 609 547 573 560 554 590 551 551 562
Extend the error reported for index/constraint violations to include the problematic key value
117 SS 397 402 409 428 428 420 425 407 418 420 415 435 424 423 420 379 380 372 374 392 376 360 376 369 374 408 374 379 378 372 380
Extend the error reported for index/constraint violations to include the problematic key value
118 CS 589 590 604 604 627 605 652 637 634 627 604 598 665 631 643 555 573 555 561 546 589 585 559 570 563 573 571 553 552 592 555
Wrong numbers in error message for decreasing char/varchar columns
119 SS 381 407 408 449 407 419 417 411 415 424 404 407 422 413 425 365 363 363 375 362 375 376 365 359 382 366 363 377 381 366 367
Wrong numbers in error message for decreasing char/varchar columns
120 CS 576 610 640 591 619 627 618 595 615 582 595 592 620 579 615 547 568 539 550 546 591 567 573 538 544 540 534 549 543 535 520
Derived fields may not be optimized via an index
121 SS 373 397 390 405 402 410 395 856 583 402 391 405 607 418 404 367 359 355 358 363 360 358 363 342 349 363 358 359 379 358 360
Derived fields may not be optimized via an index
122 CS 579 593 588 624 603 635 606 623 597 630 624 590 616 662 608 598 553 553 560 548 550 570 552 539 555 551 546 555 555 547 549
Creating self-referential FK crashes database (bug-check) whether constraint violation had place
123 SS 382 407 417 413 547 416 416 408 416 432 416 412 416 413 428 355 382 374 382 369 375 371 360 363 371 359 366 373 372 368 375
Creating self-referential FK crashes database (bug-check) whether constraint violation had place
124 CS 806 864 831 828 865 823 828 836 836 909 818 827 860 829 841 784 790 802 804 784 798 791 788 771 765 788 792 809 775 790 763
Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause
125 SS 556 558 579 586 586 579 583 584 584 580 588 586 575 571 597 535 537 541 526 540 544 541 540 545 539 534 533 547 554 568 524
Wrong results when the column with collation using option (NUMERIC-SORT=1) is in where clause
126 CS 591 618 601 600 644 598 610 619 611 610 602 600 601 633 605 587 557 556 595 547 554 581 555 569 582 564 556 575 586 551 547
isql doesn't know the difference between UDF's and psql-functions
127 SS 382 390 416 450 422 440 432 424 432 467 419 424 428 437 460 371 365 361 356 356 371 361 370 374 372 375 374 371 389 371 374
isql doesn't know the difference between UDF's and psql-functions
128 CS 581 583 617 585 614 593 618 584 597 583 591 658 589 633 593 591 556 542 541 550 548 580 571 568 552 575 548 553 561 532 534
Original table name and column name and owner missing from SQLDA for aliased column in grouped query
129 SS 374 392 426 413 403 409 398 405 423 403 444 427 416 407 407 363 360 362 358 367 370 353 361 362 363 363 353 379 363 356 361
Original table name and column name and owner missing from SQLDA for aliased column in grouped query
130 CS 589 599 644 602 641 605 617 601 603 606 608 600 596 656 600 572 571 563 560 565 560 563 568 583 565 558 563 561 567 557 601
Join using RDB$DB_KEY produce NATURAL plan
131 SS 399 428 421 432 417 419 426 636 446 433 727 432 423 417 422 380 378 370 376 377 375 404 375 371 375 376 395 392 383 375 379
Join using RDB$DB_KEY produce NATURAL plan
132 CS 601 605 639 624 631 638 665 608 622 609 635 607 670 609 630 562 563 552 565 553 557 563 566 598 795 591 565 555 563 586 546
Creating table with computed fields containing "SELECT FIRST" produces corrupted result
133 SS 395 399 408 415 423 419 422 414 879 423 420 417 432 421 420 397 377 371 388 379 376 376 372 377 374 394 363 379 377 374 368
Creating table with computed fields containing "SELECT FIRST" produces corrupted result
134 CS 771 616 825 868 822 892 847 839 799 825 837 790 837 849 784 781 759 746 756 756 756 737 745 762 914 751 756 758 750 760 759
Broken optimization for the stored dbkeys
135 SS 525 391 553 543 543 554 549 544 978 559 590 539 581 546 579 522 506 492 527 505 538 499 498 491 498 523 518 516 518 492 500
Broken optimization for the stored dbkeys
136 CS 581 580 595 590 642 624 629 588 597 601 599 618 595 641 622 542 553 546 551 571 548 578 583 535 601 540 543 540 541 544 576
NOT-NULL column can be used as primary key and filled with NULL-values
137 SS 378 391 411 405 395 402 402 391 403 406 401 401 405 400 407 361 362 367 357 378 375 367 379 361 359 377 360 355 368 363 361
NOT-NULL column can be used as primary key and filled with NULL-values
138 CS 787 584 818 812 852 836 801 814 830 792 835 799 801 855 787 755 817 747 755 748 755 765 738 733 1321 762 747 788 773 736 743
Computed by columns and position function
139 SS 524 392 546 545 562 541 562 1001 993 549 567 567 551 1017 1002 519 520 500 497 505 526 516 523 509 519 503 528 499 517 503 503
Computed by columns and position function
140 CS 799 597 799 807 847 844 842 848 836 847 817 799 812 831 832 775 755 796 749 801 751 818 792 742 1368 757 769 760 756 754 753
Server bugchecks or crashes on exception in calculated index
141 SS 530 397 562 565 568 545 562 577 567 568 563 567 551 571 569 505 511 507 504 505 560 498 548 500 505 515 500 500 504 503 499
Server bugchecks or crashes on exception in calculated index
142 CS 583 584 622 588 594 584 597 588 636 575 585 623 584 598 606 553 569 542 544 548 567 573 536 525 940 595 570 541 569 583 526
Regression: Group by fails if subselect-column is involved
143 SS 366 375 408 410 416 405 411 810 415 405 408 391 405 405 440 365 363 364 360 358 358 358 360 356 353 359 358 363 361 366 366
Regression: Group by fails if subselect-column is involved
144 CS 580 581 806 584 636 592 582 600 593 582 580 589 681 632 590 533 543 577 549 595 547 534 556 550 928 544 574 571 567 575 536
Bad optimization of OR predicates applied to unions
145 SS 379 392 392 394 392 404 406 403 405 405 421 391 419 407 412 361 386 360 362 361 353 361 360 352 372 347 357 353 359 367 359
Bad optimization of OR predicates applied to unions
146 CS 798 796 801 803 856 804 801 802 838 800 859 797 803 816 872 793 816 760 758 785 764 773 753 752 1369 759 757 755 765 837 763
COMPUTED BY field is evaluated as NULL if used as an exception parameter directly
147 SS 532 530 592 573 580 552 553 569 564 569 578 549 580 560 672 533 532 532 883 522 513 530 501 505 509 514 508 518 511 511 503
COMPUTED BY field is evaluated as NULL if used as an exception parameter directly
148 CS 795 619 815 810 803 826 817 837 817 833 871 815 881 833 787 805 750 743 756 776 757 746 772 749 1324 805 754 753 758 765 761
Expression index may be not used for derived fields or view fields
149 SS 528 396 554 569 542 540 562 555 558 533 566 553 837 552 707 505 528 500 505 507 502 512 506 504 528 504 519 509 530 513 505
Expression index may be not used for derived fields or view fields
150 CS 584 588 582 614 602 588 588 615 592 604 626 606 592 621 620 587 574 543 542 544 550 552 546 537 924 543 548 537 553 578 546
Metadata source becomes wrong after twice transliteration to the metadata charset
151 SS 382 391 407 410 394 420 401 409 404 408 455 415 422 399 414 389 362 357 363 365 364 375 357 359 362 361 352 354 366 359 358
Metadata source becomes wrong after twice transliteration to the metadata charset
152 CS 843 833 849 842 883 870 862 857 844 865 876 871 846 885 860 780 851 814 789 780 787 792 788 799 1478 783 788 797 777 847 786
Metadata export with isql (option -ex) does not export functions properly
153 SS 573 565 572 587 574 578 807 589 585 591 596 578 583 586 592 540 537 691 531 535 545 576 529 546 543 532 536 540 583 535 517
Metadata export with isql (option -ex) does not export functions properly
154 CS 784 833 849 847 877 862 592 598 622 620 625 620 595 607 592 841 786 778 837 778 787 786 783 780 1183 782 799 812 798 780 800
Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error
155 SS 532 561 617 588 580 581 398 407 404 409 471 397 424 439 418 530 534 522 543 531 530 531 531 539 538 538 533 541 550 535 537
Wrong metadata output script generated by isql / CHARACTER SETISO8859_1 syntax error
156 CS 589 650 629 624 652 628 627 657 611 652 619 616 633 617 646 575 577 562 593 579 563 567 569 563 585 581 564 564 563 573 575
New permission types are not displayed by ISQL
157 SS 391 408 429 428 422 433 428 434 439 445 463 441 419 424 425 381 393 371 377 390 374 369 373 370 378 376 376 374 377 379 374
New permission types are not displayed by ISQL
158 CS 580 625 619 589 634 619 599 635 626 598 597 581 594 612 624 564 551 544 601 551 551 543 570 540 557 570 544 539 545 540 579
RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE
159 SS 379 388 416 439 412 408 407 406 409 407 415 396 421 410 424 370 360 363 359 357 364 362 355 358 359 362 368 357 359 412 366
RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE
160 CS 804 837 854 815 848 806 813 856 813 828 806 823 820 806 836 825 762 781 766 764 802 776 758 770 790 782 749 753 778 743 773
The parameterized exception does not accept not ASCII characters as parameter
161 SS 544 547 565 634 558 566 567 559 559 731 590 560 564 562 763 520 546 517 520 516 539 530 517 516 519 516 543 518 521 520 521
The parameterized exception does not accept not ASCII characters as parameter
162 CS 1051 677 1117 1086 1107 1115 1138 1062 1084 1120 1111 1107 1130 1102 1070 1110 1035 1014 1017 1036 1021 1050 1027 1052 1050 1038 1017 1026 1019 1022 1022
Replace the hierarchical union execution with the plain one
163 SS 800 444 806 940 837 826 820 834 840 817 836 818 846 813 849 800 801 783 786 776 801 778 762 783 792 782 782 768 774 774 776
Replace the hierarchical union execution with the plain one
164 CS 576 613 596 583 635 606 599 599 597 594 597 616 594 585 608 556 540 542 553 574 548 548 579 548 544 573 561 550 555 550 551
Cannot create packaged routines with [VAR]CHAR parameters
165 SS 377 413 411 420 411 421 404 408 403 424 439 409 409 444 434 364 353 364 358 360 371 371 362 375 364 359 356 358 380 361 357
Cannot create packaged routines with [VAR]CHAR parameters
166 CS 810 839 853 870 851 833 831 868 874 869 848 878 882 875 819 801 831 785 782 787 777 783 787 785 778 791 797 772 774 769 767
ISQL -x does not output the START WITH clause of generators/sequences
167 SS 551 558 814 582 575 563 579 561 572 559 562 582 575 576 582 535 544 524 523 537 532 534 533 577 527 532 535 539 536 520 536
ISQL -x does not output the START WITH clause of generators/sequences
168 CS 621 632 644 632 678 649 683 668 649 635 633 709 630 638 684 581 613 610 617 587 579 582 580 584 588 615 626 581 589 584 576
Preserve comments for output parameters after altering procedures
169 SS 402 427 446 454 453 444 450 441 444 435 452 443 437 453 455 384 406 393 393 398 388 392 389 395 389 392 395 378 389 393 391
Preserve comments for output parameters after altering procedures
170 CS 593 621 600 600 626 595 632 607 600 594 594 641 669 644 602 568 551 553 574 551 600 582 580 582 556 561 552 542 592 570 550
GTT should not reference permanent relation
171 SS 386 392 406 405 403 420 411 404 410 414 409 406 412 403 428 374 370 374 358 361 359 373 380 358 379 361 371 414 356 374 358
GTT should not reference permanent relation
172 CS 584 597 644 581 645 636 621 600 603 600 584 588 684 636 584 546 550 547 571 552 551 597 571 591 565 583 563 550 589 548 552
Problem with creation procedure which contain adding text in DOS864 charset
173 SS 377 390 410 417 401 400 400 410 422 397 408 416 416 399 407 363 375 358 360 373 355 365 358 368 364 379 364 356 361 361 361
Problem with creation procedure which contain adding text in DOS864 charset
174 CS 808 834 822 821 840 857 823 849 815 826 810 837 831 824 837 807 752 757 761 770 790 758 819 760 797 770 752 755 755 748 744
Add table name to text of validation contraint error message, to help identify error context
175 SS 542 534 556 583 564 568 583 556 590 576 559 581 561 571 594 520 522 499 517 499 525 522 519 544 532 583 515 529 541 515 518
Add table name to text of validation contraint error message, to help identify error context
176 CS 575 610 616 582 589 585 592 615 593 612 612 580 612 615 579 546 537 571 533 592 552 544 562 567 564 548 572 535 531 531 564
Context parsing error with derived tables and CASE functions
177 SS 378 391 398 407 404 410 421 408 398 404 405 404 407 399 415 359 365 356 357 361 357 345 356 362 347 396 359 360 364 364 361
Context parsing error with derived tables and CASE functions
178 CS 592 596 623 594 617 618 599 596 612 618 611 595 591 635 597 554 559 611 565 615 583 582 574 545 554 552 547 571 546 546 576
Error on create table with "CHARACTER SET DOS775" field
179 SS 389 407 417 430 419 414 407 407 421 406 408 419 497 420 410 361 370 362 360 364 362 378 360 362 372 401 364 374 362 362 367
Error on create table with "CHARACTER SET DOS775" field
180 CS 578 579 578 616 673 588 596 618 590 589 590 611 590 593 583 591 539 543 539 578 538 537 612 534 548 551 534 543 533 533 542
FB3: Stored function accepts duplicate input arguments
181 SS 375 415 415 414 406 408 408 407 398 395 417 388 418 406 394 357 363 353 358 360 346 355 362 359 374 377 363 365 361 363 357
FB3: Stored function accepts duplicate input arguments
182 CS 585 617 596 585 604 628 627 601 626 593 612 588 640 650 578 558 597 546 546 571 564 583 587 534 555 586 539 578 572 548 568
FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed
183 SS 389 407 400 407 417 418 406 400 400 402 429 403 428 418 420 356 370 360 359 381 358 356 356 362 364 386 381 379 360 364 393
FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed
184 CS 808 707 825 814 859 840 828 863 851 820 922 827 869 848 881 772 854 778 763 773 766 776 844 753 771 777 803 785 766 776 779
Choose the best matching index for navigation
185 SS 552 466 569 586 586 589 583 581 583 571 597 554 583 587 599 550 539 560 521 515 536 539 522 522 519 555 523 538 530 516 515
Choose the best matching index for navigation
186 CS 588 627 595 599 628 636 606 604 600 638 609 606 622 619 620 587 581 558 589 582 552 570 562 554 554 565 581 548 559 552 547
Engine crashes when attempt to REcreate table with FK after syntax error before such recreating
187 SS 403 412 416 428 429 452 447 687 432 434 433 412 431 419 492 372 374 370 371 374 408 372 374 377 377 399 381 376 371 362 358
Engine crashes when attempt to REcreate table with FK after syntax error before such recreating
188 CS 777 598 873 827 869 820 857 848 819 819 812 833 800 841 892 772 776 764 781 768 763 767 759 778 774 768 770 769 767 767 765
Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers
189 SS 541 411 565 560 592 573 591 557 577 574 590 567 604 593 612 520 534 544 513 516 539 530 532 514 516 559 510 514 530 518 514
Usage of field(s) alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers
190 CS 788 684 830 817 864 829 856 864 809 854 811 805 839 849 850 790 769 766 771 767 763 766 771 764 765 789 772 767 755 788 765
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
191 SS 532 456 566 573 551 564 583 564 568 564 586 564 593 579 580 516 518 514 528 522 531 509 534 503 520 557 513 520 517 517 521
Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
192 CS 1668 1734 1759 1760 1769 1770 1735 1762 1784 1742 1731 1791 1850 1792 1747 1675 1622 1621 1624 1610 1629 1635 1606 1609 1654 1623 1661 1612 1621 1603 1608
Non-privileged user can delete records from RDB$SECURITY_CLASSES table
193 SS 1014 1042 1026 1049 1043 1031 1031 1040 1039 1052 1287 1053 1070 1032 1053 1003 946 949 954 940 942 944 935 937 954 1057 944 972 953 1003 934
Non-privileged user can delete records from RDB$SECURITY_CLASSES table
194 CS 593 611 629 602 643 616 630 600 605 590 630 690 644 604 624 550 547 544 554 554 554 560 547 539 596 587 550 546 648 570 544
Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause)
195 SS 381 394 442 441 410 402 416 413 407 410 561 412 425 441 414 360 372 375 375 365 365 358 360 363 376 386 374 373 373 361 358
Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause)
196 CS 1159 1191 1192 1261 1236 1240 1260 1195 1209 1215 1204 1198 1209 1189 1207 1116 1151 1114 1101 1100 1131 1096 1116 1167 1126 1137 1103 1111 1132 1104 1123
non-priviledged user can insert and update rdb$database
197 SS 722 721 722 752 726 725 728 736 733 744 945 783 743 1100 821 680 691 671 675 690 674 674 712 697 673 726 669 706 722 890 673
non-priviledged user can insert and update rdb$database
198 CS 578 583 584 642 610 617 609 583 591 596 618 583 601 619 586 561 570 547 537 538 570 572 531 597 549 550 570 542 533 573 540
Equality predicate distribution does not work for some complex queries
199 SS 383 392 403 418 388 408 412 401 404 405 876 409 413 413 391 368 378 368 362 360 357 365 357 363 355 398 365 375 361 361 361
Equality predicate distribution does not work for some complex queries
200 CS 573 596 622 619 638 627 623 590 596 628 617 588 601 620 610 547 558 545 568 539 554 548 562 566 546 541 549 544 572 575 545
Create function/sp which references to non-existent exception <...>
201 SS 395 388 408 439 412 407 409 404 408 457 533 406 639 427 499 359 363 391 357 572 368 390 364 365 378 400 361 376 362 370 354
Create function/sp which references to non-existent exception <...>
202 CS 572 570 598 608 614 583 591 587 612 615 617 615 588 636 581 544 573 543 572 565 544 538 573 549 547 537 535 532 544 537 537
Duplicate names in package are not checked
203 SS 377 378 396 404 397 402 404 402 406 398 503 403 396 420 409 377 362 363 359 351 364 364 359 358 365 379 362 373 374 363 364
Duplicate names in package are not checked
204 CS 587 594 598 594 626 597 605 601 598 593 595 595 698 697 611 615 561 561 566 581 542 545 551 544 582 547 548 549 544 549 545
Preparation of erroneous DDL statement does not show the main command failed
205 SS 402 386 405 419 417 424 407 421 417 416 440 406 426 411 414 581 369 361 357 399 371 366 361 369 394 423 379 354 377 358 360
Preparation of erroneous DDL statement does not show the main command failed
206 CS 1844 1906 1902 1903 1922 1942 1887 1914 1968 1910 1910 1897 1957 1988 1903 1797 1862 1826 1795 1786 1815 1813 1814 1796 1819 1808 1781 1820 1779 1812 1808
Poor performance of explicit cursors containing correlated subqueries in the select list
207 SS 1476 1480 1506 1494 1517 1512 1499 1932 1489 1510 1629 1487 1575 1573 1542 1438 1459 1438 1446 1429 1464 1450 1406 1394 1477 1476 1442 1456 1414 1419 1414
Poor performance of explicit cursors containing correlated subqueries in the select list
208 CS 583 585 583 623 643 618 603 599 621 622 585 584 627 595 595 555 570 570 562 550 583 583 548 574 565 547 547 547 553 565 546
Incorrect line/column information in runtime errors
209 SS 379 395 398 406 397 475 404 403 409 402 406 411 403 399 402 365 357 357 371 362 360 355 359 358 359 385 361 373 360 361 364
Incorrect line/column information in runtime errors
210 CS 3293 3308 3347 3355 3517 3428 3386 3399 3421 3353 3397 3349 3678 3458 3439 3176 3246 3128 3110 3097 3114 3248 3110 3062 3337 3278 3121 3096 3090 3077 3110
Report more details for "object in use" errors
211 SS 1287 1325 1354 1370 1373 1447 1600 1493 1368 1381 1412 1350 1391 1390 1387 1228 1280 1244 1227 1232 1241 1229 1235 1231 1248 1295 1260 1234 1240 1234 1222
Report more details for "object in use" errors
212 CS 805 605 814 813 835 810 843 863 849 853 826 851 843 842 816 828 759 811 756 783 752 754 763 748 801 770 754 755 763 752 754
Allow referencing cursors as record variables in PSQL
213 SS 538 405 562 583 575 565 572 577 572 563 579 574 573 548 555 509 513 524 544 531 513 519 510 498 517 560 530 508 521 532 503
Allow referencing cursors as record variables in PSQL
214 CS 573 580 586 591 604 587 602 620 582 591 624 582 619 635 585 539 567 574 544 563 567 563 566 541 546 553 548 545 572 549 567
Useless extraction of generic DDL trigger
215 SS 383 388 394 399 399 402 405 402 406 393 407 401 405 405 395 366 389 361 357 360 362 365 359 364 363 378 354 361 357 364 362
Useless extraction of generic DDL trigger
216 CS 797 792 838 797 848 840 805 838 804 842 798 839 842 818 843 751 759 767 768 769 751 747 800 754 770 770 759 772 802 825 783
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
217 SS 531 540 645 574 556 567 565 572 562 580 586 545 562 569 566 518 512 512 523 515 503 517 504 506 504 547 516 508 508 505 509
Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
218 CS 2919 2902 2923 2942 2938 2932 2946 2932 2931 2958 2915 2910 2927 2968 2986 2894 2909 2878 3080 2876 3446 2879 2916 2896 2886 2867 2967 2877 2932 2887 2901
Allow output to trace explain plan form.
219 SS 2674 2683 2776 2703 2704 2699 2688 2685 2695 2708 2706 2685 2683 2682 2687 2659 2661 2644 2653 2647 2652 2649 2656 2662 2666 2715 2651 2653 2652 2639 2645
Allow output to trace explain plan form.
220 CS 782 831 812 832 836 831 801 800 787 826 828 794 830 840 860 799 759 748 754 754 752 741 756 751 743 752 766 772 778 752 751
Regression: NOT NULL constraint, declared in domain, does not work
221 SS 535 537 663 571 548 569 560 560 568 578 599 563 543 550 564 507 507 504 523 508 511 499 536 496 503 534 507 511 503 502 500
Regression: NOT NULL constraint, declared in domain, does not work
222 CS 1999 2259 2146 2146 2166 2157 2152 2147 2171 2135 2141 2145 2154 2231 2127 1956 1964 1979 1990 1916 1921 1981 1917 1912 1965 1977 1976 1970 1964 1937 2009
FB3: CREATE USER GRANT ADMIN ROLE does not work
223 SS 1234 1292 1542 1330 1314 1358 1547 1336 1323 1461 1315 1290 1352 1304 1507 1163 1159 1148 1137 1138 1146 1153 1130 1129 1207 1262 1164 1167 1157 1167 1161
FB3: CREATE USER GRANT ADMIN ROLE does not work
224 CS 1092 1203 1183 1247 1211 1221 1179 1192 1242 1181 1190 1180 1213 1254 1204 1104 1062 1027 1063 1037 1042 1022 1023 1017 1015 1016 1009 1031 1054 1036 1081
gbak fails to restore database containing dependency between views and packaged functions
225 SS 807 886 1071 961 951 957 943 921 941 910 947 926 943 935 1323 792 749 775 773 769 772 788 766 743 758 818 796 770 772 770 781
gbak fails to restore database containing dependency between views and packaged functions
226 CS 579 592 599 591 624 596 592 593 593 596 625 657 621 600 623 548 569 544 544 548 583 575 550 539 562 549 547 576 551 540 547
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
227 SS 393 395 517 421 407 427 414 557 411 574 567 410 406 413 412 370 376 366 363 372 373 360 365 361 360 385 391 408 356 361 357
OR/IN predicates for RDB$DBKEY lead to NATURAL plan
228 CS 569 582 582 624 597 607 590 590 587 588 601 665 586 610 589 546 546 546 549 533 568 533 568 567 547 541 559 570 537 543 566
FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval
229 SS 389 395 502 412 399 417 408 401 401 491 401 405 433 405 404 383 362 405 376 380 357 361 349 356 364 371 366 362 365 358 363
FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval
230 CS 2186 2300 12840 12807 2344 2496 2344 2366 2378 2366 2348 2347 2377 2403 2381 2191 2126 2146 2176 2165 2133 2160 2141 2123 2169 2162 2153 2158 2182 2148 2117
New gbak option to enable encryption during restore
231 SS 1686 1645 12410 12726 1686 2045 2048 1656 2069 2071 1686 2061 2068 2047 2060 1533 2000 1522 1521 1544 1992 1514 1992 2046 1521 1619 1519 1492 1546 1505 1483
New gbak option to enable encryption during restore
232 CS 592 598 593 631 636 613 656 628 598 592 599 599 642 602 597 576 607 554 565 558 553 554 582 558 578 551 542 554 614 581 555
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
233 SS 389 401 481 417 420 413 412 423 448 524 411 406 420 437 415 366 362 374 364 375 365 364 365 360 376 400 379 366 361 369 363
Allow hash/merge joins for non-field (dbkey or derived expression) equalities
234 CS 589 593 591 628 649 650 601 608 592 609 624 604 623 642 598 602 552 576 558 555 552 545 565 549 588 584 558 541 579 563 547
Allow to use index when GROUP BY on field which has DESCENDING index
235 SS 385 390 422 412 414 410 421 400 427 518 415 404 411 413 412 379 381 361 360 364 373 364 358 363 374 399 373 357 364 378 362
Allow to use index when GROUP BY on field which has DESCENDING index
236 CS 788 811 839 837 841 816 834 819 810 852 800 841 824 868 820 764 752 741 743 785 745 791 756 747 761 751 754 752 767 746 746
DB_KEY based join of two tables may be ineffective
237 SS 537 548 683 551 550 555 576 554 561 655 591 550 592 563 560 519 498 526 500 504 500 502 504 506 499 552 503 504 509 501 504
DB_KEY based join of two tables may be ineffective
238 CS 590 619 588 604 639 593 616 598 596 599 645 593 633 653 624 541 549 546 551 551 592 584 546 567 584 609 559 550 588 573 568
Server does not accept the right plan
239 SS 384 405 489 431 410 419 411 399 427 463 412 447 446 408 417 370 360 366 363 363 375 361 360 360 373 393 357 364 374 361 361
Server does not accept the right plan
240 CS 586 624 597 599 623 634 635 605 582 591 584 594 602 621 586 602 594 552 559 541 548 541 579 571 587 542 570 565 623 569 581
DDL trigger remains active after dropped
241 SS 392 392 539 423 417 403 415 404 426 446 416 428 441 403 407 356 401 363 356 375 371 371 360 362 364 392 379 363 364 362 385
DDL trigger remains active after dropped
242 CS 802 616 810 830 847 835 845 829 846 817 814 814 810 924 830 789 771 778 769 772 789 785 784 810 774 785 793 794 823 772 788
FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN
243 SS 541 411 664 580 559 573 592 561 653 765 587 586 579 588 562 530 535 532 517 536 528 538 520 522 527 572 528 529 533 532 545
FB 3.0 crashes on EXIT (or QUIT) command if use UTF8-collation + create domain based on it + issue SHOW DOMAIN
244 CS 576 585 589 602 639 596 588 622 609 617 597 608 624 642 599 553 542 556 556 574 544 540 545 578 555 545 555 547 555 550 569
Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments
245 SS 396 388 452 406 402 407 406 411 413 545 409 432 427 412 412 361 360 354 360 388 368 382 358 360 361 406 400 368 365 362 392
Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments
246 CS 574 591 628 596 672 601 601 593 657 600 597 621 646 590 590 575 573 545 550 550 539 547 544 544 545 554 543 547 572 572 547
Can't create column check constraint when the column is domain based
247 SS 387 386 460 397 402 416 421 400 396 504 413 409 400 411 397 371 368 370 377 385 366 368 354 356 370 388 400 369 357 371 358
Can't create column check constraint when the column is domain based
248 CS 906 946 938 985 950 938 935 938 937 939 953 920 992 955 920 883 887 853 853 858 856 945 848 838 857 867 845 892 878 881 844
Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
249 SS 639 652 707 672 677 673 676 679 679 859 668 671 686 665 697 618 616 620 609 613 615 620 620 614 623 702 621 627 612 621 618
Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
250 CS 594 602 592 638 624 602 607 635 598 650 601 601 604 640 640 576 597 572 543 546 585 557 580 552 545 608 553 559 584 555 547
Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N }
251 SS 388 398 471 434 414 417 420 426 417 516 425 414 423 422 420 375 372 376 364 378 361 373 362 378 360 400 375 376 362 374 378
Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>" and field_C is leading part of compound index key: { field_C, field_N }
252 CS 794 834 847 799 856 844 802 831 847 838 903 817 835 822 845 765 749 808 763 759 759 766 748 743 789 764 748 751 755 764 759
Regression: computed index based on a computed column stores NULL for all its keys
253 SS 563 535 592 595 590 571 569 582 1040 673 562 544 1022 1040 1052 509 519 510 543 533 516 513 498 497 521 565 683 666 675 517 501
Regression: computed index based on a computed column stores NULL for all its keys
254 CS 583 583 617 587 611 594 600 584 607 589 593 623 641 593 630 543 560 549 568 613 547 542 560 548 553 557 551 563 584 545 534
"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
255 SS 392 391 482 405 401 406 418 409 785 498 416 409 418 835 394 395 366 358 372 373 361 366 362 355 358 397 379 372 357 378 363
"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table
256 CS 3193 3201 3173 3567 3220 3213 3201 3249 3238 3177 3205 3189 3260 3193 3208 3140 3399 3291 3193 3191 3136 3206 3166 3158 3133 3189 3102 3416 3128 3116 3112
Regression: Join order in v3 is less optimal than in v2.x
257 SS 2865 2844 3622 2904 2879 2900 3073 2873 2888 4159 3066 2866 2943 2943 2863 3014 2842 2846 2851 2836 2941 2830 2803 2797 2819 2864 2842 2828 2823 2826 2923
Regression: Join order in v3 is less optimal than in v2.x
258 CS 4835 4856 4856 4887 4876 4879 4862 4861 4851 4869 4866 4874 4880 4897 4907 4819 4820 4811 4808 4812 4801 4806 4817 4785 4875 4816 4810 4798 4820 4817 4812
Implement ability to validate tables and indices online (without exclusive access to database)
259 SS 4559 4585 4717 4595 4592 4604 4592 4790 4585 4627 4744 4579 4566 4596 5116 4548 4543 4527 4516 4533 4535 4524 4539 4531 4542 4556 4532 4530 4563 4529 4537
Implement ability to validate tables and indices online (without exclusive access to database)
260 CS 637 650 669 681 681 705 655 747 686 660 661 646 670 658 695 629 634 591 604 633 640 629 608 620 611 609 605 597 604 622 596
Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
261 SS 431 466 635 486 470 468 506 480 477 475 484 463 479 467 463 406 418 419 420 407 422 421 438 407 421 423 424 419 408 405 402
Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
262 CS 605 605 613 651 653 653 618 618 649 646 649 653 629 607 648 652 588 605 590 563 561 560 565 594 558 565 592 562 596 559 570
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
263 SS 400 408 511 416 437 460 459 427 450 441 490 430 445 423 433 375 385 378 377 377 372 387 374 408 369 380 377 382 393 375 376
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
264 CS 590 619 599 609 635 597 606 601 601 600 597 615 644 626 592 588 584 581 612 549 546 552 543 579 587 582 580 549 578 549 574
Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
265 SS 378 393 461 408 402 423 437 416 422 421 463 419 417 430 411 365 359 374 363 376 358 375 362 358 363 362 361 368 380 365 358
Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
266 CS 592 591 644 646 653 636 630 593 601 596 597 653 637 610 635 584 559 547 558 556 556 548 588 542 543 555 594 552 548 546 602
Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..."
267 SS 380 392 509 415 403 414 427 412 411 402 440 400 434 423 401 375 382 373 370 378 364 370 376 361 361 378 375 362 374 374 360
Command "Alter table <T> alter <C> type <domain_>" does not work: "BLR syntax error: expected valid BLR code ..."
268 CS 594 608 617 616 652 615 612 646 608 603 642 613 617 639 634 602 562 551 563 562 569 552 560 562 587 585 554 567 563 582 559
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
269 SS 385 408 452 420 415 435 441 421 418 419 469 419 438 437 424 369 374 380 369 384 370 376 378 366 375 377 380 379 386 377 362
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
270 CS 667 673 681 675 718 721 689 685 711 712 708 691 750 724 705 623 639 625 656 633 751 653 661 626 659 639 631 623 623 633 624
Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles)
271 SS 426 449 592 455 467 456 486 904 466 923 909 465 454 888 980 414 409 414 411 412 411 421 410 431 411 409 405 409 417 413 416
Bugcheck 167 (invalid SEND request) while working with GTT from several attachments (using EXECUTE STATEMENT ... ON EXTERNAL and different roles)
272 CS 561 598 617 619 620 628 589 597 587 589 590 590 592 591 627 552 570 552 548 547 541 535 548 541 545 541 540 542 540 538 542
Parameterized exception: wrong output when number of arguments greater than 7
273 SS 402 383 462 419 391 400 439 414 401 413 428 405 435 418 404 372 360 364 460 364 355 571 362 369 609 361 365 360 372 607 446
Parameterized exception: wrong output when number of arguments greater than 7
274 CS 686 722 723 730 750 759 808 719 722 722 732 746 803 722 757 666 674 677 653 657 654 669 681 651 659 666 681 647 692 654 659
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
275 SS 405 427 606 434 456 441 456 452 444 450 466 445 433 482 468 384 387 388 378 375 400 394 387 392 398 380 389 378 378 411 380
AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-sysdba user which has RDB$ADMIN role
276 CS 585 587 637 596 640 646 595 586 599 609 587 604 596 653 624 600 565 576 543 552 554 585 556 546 553 552 567 577 545 556 542
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
277 SS 392 397 409 414 408 422 437 396 416 418 437 407 412 415 447 363 382 375 379 377 361 384 364 362 365 389 366 364 366 359 408
Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
278 CS 590 601 591 595 627 600 605 600 596 624 625 600 598 591 593 576 547 554 546 557 560 609 555 571 543 555 590 551 541 553 548
Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL
279 SS 399 408 406 404 404 415 429 409 406 405 423 402 401 424 415 374 362 418 373 374 364 358 362 366 363 397 372 360 365 360 363
Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL
280 CS 594 597 608 617 650 663 652 618 618 623 643 643 664 640 639 560 551 558 558 559 592 621 582 558 576 566 569 584 588 552 584
Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
281 SS 408 413 429 428 434 440 452 430 425 441 464 429 444 430 433 373 374 435 371 377 385 375 373 374 378 404 377 379 370 376 374
Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
282 CS 2767 2848 2906 2863 2869 2890 2870 2881 2855 2845 2877 2836 2917 2888 2882 2728 2736 2766 2667 2658 2683 2677 2665 2768 2696 2746 2720 2669 2689 2651 2665
Regression: generators can be seen/modified by unprivileged users
283 SS 1627 1646 1628 1661 1647 1686 1803 1631 1698 1662 1807 1627 1702 1677 1656 1525 1529 1627 1528 1537 1510 1540 1502 1489 1542 1715 1552 1522 1525 1528 3237
Regression: generators can be seen/modified by unprivileged users
284 CS 568 576 614 591 636 588 597 596 587 581 594 575 619 621 616 544 545 551 534 548 540 540 567 538 540 569 537 565 537 534 541
Regression: List of aggregation is not checked properly
285 SS 377 377 394 393 403 396 438 394 397 406 427 401 421 400 406 366 364 370 360 363 362 378 352 352 363 366 366 365 363 349 494
Regression: List of aggregation is not checked properly
286 CS 670 677 784 795 793 782 774 773 772 770 792 782 802 815 811 677 651 645 626 643 630 617 654 616 626 641 630 663 641 654 625
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
287 SS 468 476 572 581 574 574 588 568 612 579 599 564 570 584 589 460 442 438 435 438 446 442 445 444 443 460 451 448 443 441 656
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
288 CS 2384 2453 2434 2470 2487 2492 2486 2455 2456 2431 2446 2426 2519 2444 2584 2341 2402 2366 2304 2367 2294 2295 2310 2281 2318 2301 2310 2326 2337 2272 2314
Make user names behave according to SQL identifiers rules
289 SS 1399 1385 1390 1412 1401 1410 1976 1404 1423 1644 1518 1408 1398 1429 1422 1311 1354 1453 1323 1342 1315 1333 1359 1303 1323 1791 1726 1440 1338 1300 1332
Make user names behave according to SQL identifiers rules
290 CS 606 645 612 608 647 621 648 614 615 616 610 643 609 619 636 605 578 567 565 617 554 567 564 555 566 573 570 581 571 585 554
EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
291 SS 415 414 440 420 431 417 468 434 438 421 451 431 424 441 424 418 379 459 372 376 373 370 374 378 376 404 382 409 375 377 375
EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
292 CS 587 593 609 608 636 607 604 612 603 612 602 605 627 652 658 586 588 539 542 559 561 548 555 555 559 582 543 559 569 576 554
Make ISQL display character set when sqlda_display is on
293 SS 392 390 426 410 420 420 431 420 411 425 442 438 425 436 418 372 377 387 372 365 363 367 367 359 360 395 368 372 372 372 408
Make ISQL display character set when sqlda_display is on
294 CS 1552 1565 1573 1579 1625 1616 1611 1626 1615 1590 1594 1573 1632 1608 1620 1488 1474 1479 1470 1471 1474 1466 1558 1443 1487 1471 1465 1546 1499 1464 1458
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
295 SS 948 950 1037 963 964 960 1038 971 956 964 1035 961 960 999 947 892 870 940 889 899 870 876 859 853 885 960 890 886 899 898 1203
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
296 CS 1123 1129 1133 1156 1151 1136 1140 1194 1127 1139 1127 1136 1142 1144 1148 1119 1114 1061 1053 1066 1075 1066 1128 1059 1044 1046 1081 1106 1065 1039 1049
SHOW GRANTS does not display info about exceptions which were granted to user
297 SS 704 708 743 725 703 705 765 777 699 714 762 719 715 708 754 636 650 674 655 644 644 644 631 645 642 729 651 663 675 733 809
SHOW GRANTS does not display info about exceptions which were granted to user
298 CS 603 609 629 602 634 639 644 647 612 611 609 614 666 666 664 564 586 565 605 561 708 567 564 545 560 563 559 558 557 552 550
Altering a trigger indicating other table than the original does not reflect the change
299 SS 410 407 429 423 415 424 452 423 419 419 457 447 419 428 440 383 379 379 372 368 375 393 367 363 377 407 372 414 379 376 509
Altering a trigger indicating other table than the original does not reflect the change
300 CS 6690 6690 6715 6704 6728 6697 6690 6736 6719 6752 6710 6758 6710 6725 6718 6649 6638 6728 6656 6629 6736 6678 6625 6607 6635 6635 6659 6629 6615 6650 6604
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"
301 SS 6447 6442 6447 6459 6474 6456 6715 6981 6449 6478 7054 6455 6443 6447 6478 6415 6409 6457 6411 6411 6421 6412 6412 6443 6411 6844 6708 6404 6413 6423 6542
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"
302 CS 599 643 604 633 641 604 686 607 608 637 631 636 635 620 595 564 558 606 549 590 587 622 556 548 587 558 564 547 548 576 586
Crash on pasring of script containing `execute block` with lot of nested begin..end statements
303 SS 394 407 419 420 425 423 432 424 429 421 441 423 641 433 406 393 360 377 368 364 372 366 374 371 365 395 370 376 361 364 366
Crash on pasring of script containing `execute block` with lot of nested begin..end statements
304 CS 591 610 593 619 619 621 715 629 626 586 634 603 624 619 620 549 548 576 570 577 590 593 543 566 550 542 597 577 558 538 543
Invalid internal BLR filter conversion
305 SS 386 397 398 408 401 423 449 407 401 404 440 407 413 415 417 366 368 355 375 357 367 364 356 366 361 405 356 367 353 357 350
Invalid internal BLR filter conversion
306 CS 587 596 629 619 631 610 672 588 603 592 627 587 611 598 628 583 553 543 543 549 570 571 547 535 593 546 710 538 542 540 539
ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
307 SS 380 387 416 405 408 392 438 403 410 406 433 403 403 417 410 365 356 373 364 373 376 358 363 375 377 384 374 360 359 362 360
ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
308 CS 798 720 807 887 852 836 900 825 824 855 839 843 860 850 820 775 778 764 760 789 788 818 765 771 785 766 846 762 782 769 753
Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
309 SS 544 454 779 563 566 567 624 572 575 564 614 568 578 560 576 515 521 510 513 518 535 516 514 518 514 554 507 584 518 515 508
Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
310 CS 2946 3001 2958 3000 2948 2997 3037 2980 2987 2939 2959 2948 2976 2948 2948 2929 2902 2903 2912 2884 2977 2944 2932 2881 2891 2887 3141 2883 2924 2935 2884
IIF function prevents the condition from being pushed into the union for better optimization
311 SS 2712 2716 2740 2743 2725 2720 2815 2721 2743 2754 2757 2733 2724 2751 2731 2930 2694 2696 2690 2680 2691 2692 2673 2686 2683 2687 2674 2709 2688 2672 2689
IIF function prevents the condition from being pushed into the union for better optimization
312 CS 591 588 603 596 638 599 680 602 627 587 625 595 625 637 609 541 578 543 555 549 617 617 543 568 548 547 939 540 577 540 576
Add label about deterministic flag for stored function in SHOW and extract commands
313 SS 397 387 422 426 428 405 458 414 410 421 434 411 410 434 414 357 443 368 452 362 361 368 354 362 378 389 364 362 360 372 363
Add label about deterministic flag for stored function in SHOW and extract commands
314 CS 1185 1201 1197 1239 1270 1216 1306 1217 1203 1197 1186 1200 1185 1223 1234 1123 1120 1111 1124 1140 1209 1171 1143 1149 1119 1147 1242 1114 1162 1108 1143
Operator REVOKE can modify rights granted to system tables at DB creation time
315 SS 730 730 1087 748 772 733 737 779 778 744 810 776 747 740 730 690 668 683 667 667 674 675 668 671 671 747 678 675 714 848 664
Operator REVOKE can modify rights granted to system tables at DB creation time
316 CS 1202 1232 1212 1214 1278 1214 1313 1253 1209 1206 1210 1210 1257 1251 1252 1186 1181 1122 1131 1124 1198 1123 1116 1138 1126 1144 1206 1120 1146 1122 1117
Non-privileged user can implicitly count records in a restricted table
317 SS 720 723 756 760 744 736 753 742 803 741 749 747 777 777 749 717 697 694 689 684 688 672 698 668 687 733 687 686 704 674 675
Non-privileged user can implicitly count records in a restricted table
318 CS 1558 1615 12423 12380 1627 1636 1651 1650 1621 1624 1632 1611 1656 1629 1661 1550 1567 1523 1524 1540 1527 1526 1522 1519 1541 1532 1526 1529 1528 1518 1517
Restore of encrypted backup of database with SQL dialect 1 fails
319 SS 1153 1207 12009 11930 1257 1174 1190 1195 1214 1189 1208 1184 1224 1189 1204 1113 1100 1105 1102 1095 1119 1115 1100 1106 1132 1104 1317 1128 1104 1106 1099
Restore of encrypted backup of database with SQL dialect 1 fails

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1725
http://tracker.firebirdsql.org/browse/CORE-214
http://tracker.firebirdsql.org/browse/CORE-2806
http://tracker.firebirdsql.org/browse/CORE-2812
http://tracker.firebirdsql.org/browse/CORE-2826
http://tracker.firebirdsql.org/browse/CORE-2835
http://tracker.firebirdsql.org/browse/CORE-2881
http://tracker.firebirdsql.org/browse/CORE-2910
http://tracker.firebirdsql.org/browse/CORE-2912
http://tracker.firebirdsql.org/browse/CORE-2916
http://tracker.firebirdsql.org/browse/CORE-2930
http://tracker.firebirdsql.org/browse/CORE-2985
http://tracker.firebirdsql.org/browse/CORE-3029
http://tracker.firebirdsql.org/browse/CORE-3055
http://tracker.firebirdsql.org/browse/CORE-3056
http://tracker.firebirdsql.org/browse/CORE-3064
http://tracker.firebirdsql.org/browse/CORE-3085
http://tracker.firebirdsql.org/browse/CORE-3101
http://tracker.firebirdsql.org/browse/CORE-3103
http://tracker.firebirdsql.org/browse/CORE-3174
http://tracker.firebirdsql.org/browse/CORE-3176
http://tracker.firebirdsql.org/browse/CORE-3180
http://tracker.firebirdsql.org/browse/CORE-3222
http://tracker.firebirdsql.org/browse/CORE-3239
http://tracker.firebirdsql.org/browse/CORE-3283
http://tracker.firebirdsql.org/browse/CORE-3305
http://tracker.firebirdsql.org/browse/CORE-3311
http://tracker.firebirdsql.org/browse/CORE-3312
http://tracker.firebirdsql.org/browse/CORE-3338
http://tracker.firebirdsql.org/browse/CORE-3353
http://tracker.firebirdsql.org/browse/CORE-3357
http://tracker.firebirdsql.org/browse/CORE-3364
http://tracker.firebirdsql.org/browse/CORE-3394
http://tracker.firebirdsql.org/browse/CORE-3419
http://tracker.firebirdsql.org/browse/CORE-3421
http://tracker.firebirdsql.org/browse/CORE-3450
http://tracker.firebirdsql.org/browse/CORE-3474
http://tracker.firebirdsql.org/browse/CORE-3491
http://tracker.firebirdsql.org/browse/CORE-3502
http://tracker.firebirdsql.org/browse/CORE-3509
http://tracker.firebirdsql.org/browse/CORE-3530
http://tracker.firebirdsql.org/browse/CORE-3545
http://tracker.firebirdsql.org/browse/CORE-3547
http://tracker.firebirdsql.org/browse/CORE-3553
http://tracker.firebirdsql.org/browse/CORE-3569
http://tracker.firebirdsql.org/browse/CORE-3594
http://tracker.firebirdsql.org/browse/CORE-3598
http://tracker.firebirdsql.org/browse/CORE-3610
http://tracker.firebirdsql.org/browse/CORE-3627
http://tracker.firebirdsql.org/browse/CORE-3672
http://tracker.firebirdsql.org/browse/CORE-3690
http://tracker.firebirdsql.org/browse/CORE-3691
http://tracker.firebirdsql.org/browse/CORE-3722
http://tracker.firebirdsql.org/browse/CORE-3735
http://tracker.firebirdsql.org/browse/CORE-3736
http://tracker.firebirdsql.org/browse/CORE-3761
http://tracker.firebirdsql.org/browse/CORE-3834
http://tracker.firebirdsql.org/browse/CORE-3881
http://tracker.firebirdsql.org/browse/CORE-3894
http://tracker.firebirdsql.org/browse/CORE-3902
http://tracker.firebirdsql.org/browse/CORE-3925
http://tracker.firebirdsql.org/browse/CORE-3947
http://tracker.firebirdsql.org/browse/CORE-3963
http://tracker.firebirdsql.org/browse/CORE-3973
http://tracker.firebirdsql.org/browse/CORE-3997
http://tracker.firebirdsql.org/browse/CORE-4027
http://tracker.firebirdsql.org/browse/CORE-4038
http://tracker.firebirdsql.org/browse/CORE-4070
http://tracker.firebirdsql.org/browse/CORE-4074
http://tracker.firebirdsql.org/browse/CORE-4075
http://tracker.firebirdsql.org/browse/CORE-4084
http://tracker.firebirdsql.org/browse/CORE-4102
http://tracker.firebirdsql.org/browse/CORE-4117
http://tracker.firebirdsql.org/browse/CORE-4118
http://tracker.firebirdsql.org/browse/CORE-4119
http://tracker.firebirdsql.org/browse/CORE-4122
http://tracker.firebirdsql.org/browse/CORE-4137
http://tracker.firebirdsql.org/browse/CORE-4149
http://tracker.firebirdsql.org/browse/CORE-4156
http://tracker.firebirdsql.org/browse/CORE-4160
http://tracker.firebirdsql.org/browse/CORE-4165
http://tracker.firebirdsql.org/browse/CORE-4203
http://tracker.firebirdsql.org/browse/CORE-4205
http://tracker.firebirdsql.org/browse/CORE-4210
http://tracker.firebirdsql.org/browse/CORE-4214
http://tracker.firebirdsql.org/browse/CORE-4244
http://tracker.firebirdsql.org/browse/CORE-4252
http://tracker.firebirdsql.org/browse/CORE-4262
http://tracker.firebirdsql.org/browse/CORE-4276
http://tracker.firebirdsql.org/browse/CORE-4280
http://tracker.firebirdsql.org/browse/CORE-4281
http://tracker.firebirdsql.org/browse/CORE-4285
http://tracker.firebirdsql.org/browse/CORE-4304
http://tracker.firebirdsql.org/browse/CORE-4315
http://tracker.firebirdsql.org/browse/CORE-4318
http://tracker.firebirdsql.org/browse/CORE-4342
http://tracker.firebirdsql.org/browse/CORE-4350
http://tracker.firebirdsql.org/browse/CORE-4359
http://tracker.firebirdsql.org/browse/CORE-4365
http://tracker.firebirdsql.org/browse/CORE-4371
http://tracker.firebirdsql.org/browse/CORE-4373
http://tracker.firebirdsql.org/browse/CORE-4376
http://tracker.firebirdsql.org/browse/CORE-4379
http://tracker.firebirdsql.org/browse/CORE-4381
http://tracker.firebirdsql.org/browse/CORE-4386
http://tracker.firebirdsql.org/browse/CORE-4403
http://tracker.firebirdsql.org/browse/CORE-4415
http://tracker.firebirdsql.org/browse/CORE-4447
http://tracker.firebirdsql.org/browse/CORE-4451
http://tracker.firebirdsql.org/browse/CORE-4453
http://tracker.firebirdsql.org/browse/CORE-4468
http://tracker.firebirdsql.org/browse/CORE-4470
http://tracker.firebirdsql.org/browse/CORE-4492
http://tracker.firebirdsql.org/browse/CORE-4498
http://tracker.firebirdsql.org/browse/CORE-4524
http://tracker.firebirdsql.org/browse/CORE-4528
http://tracker.firebirdsql.org/browse/CORE-4529
http://tracker.firebirdsql.org/browse/CORE-4530
http://tracker.firebirdsql.org/browse/CORE-4539
http://tracker.firebirdsql.org/browse/CORE-4555
http://tracker.firebirdsql.org/browse/CORE-4557
http://tracker.firebirdsql.org/browse/CORE-4572
http://tracker.firebirdsql.org/browse/CORE-4585
http://tracker.firebirdsql.org/browse/CORE-4653
http://tracker.firebirdsql.org/browse/CORE-4665
http://tracker.firebirdsql.org/browse/CORE-4673
http://tracker.firebirdsql.org/browse/CORE-4694
http://tracker.firebirdsql.org/browse/CORE-4702
http://tracker.firebirdsql.org/browse/CORE-4707
http://tracker.firebirdsql.org/browse/CORE-4725
http://tracker.firebirdsql.org/browse/CORE-4733
http://tracker.firebirdsql.org/browse/CORE-4735
http://tracker.firebirdsql.org/browse/CORE-4738
http://tracker.firebirdsql.org/browse/CORE-4744
http://tracker.firebirdsql.org/browse/CORE-4754
http://tracker.firebirdsql.org/browse/CORE-4755
http://tracker.firebirdsql.org/browse/CORE-4766
http://tracker.firebirdsql.org/browse/CORE-4774
http://tracker.firebirdsql.org/browse/CORE-4782
http://tracker.firebirdsql.org/browse/CORE-4786
http://tracker.firebirdsql.org/browse/CORE-4806
http://tracker.firebirdsql.org/browse/CORE-4807
http://tracker.firebirdsql.org/browse/CORE-4809
http://tracker.firebirdsql.org/browse/CORE-4811
http://tracker.firebirdsql.org/browse/CORE-4819
http://tracker.firebirdsql.org/browse/CORE-4826
http://tracker.firebirdsql.org/browse/CORE-4836
http://tracker.firebirdsql.org/browse/CORE-4839
http://tracker.firebirdsql.org/browse/CORE-4846
http://tracker.firebirdsql.org/browse/CORE-4855
http://tracker.firebirdsql.org/browse/CORE-4884
http://tracker.firebirdsql.org/browse/CORE-4905
http://tracker.firebirdsql.org/browse/CORE-4917
http://tracker.firebirdsql.org/browse/CORE-4921
http://tracker.firebirdsql.org/browse/CORE-4927
http://tracker.firebirdsql.org/browse/CORE-4940
http://tracker.firebirdsql.org/browse/CORE-4980
http://tracker.firebirdsql.org/browse/CORE-4985
http://tracker.firebirdsql.org/browse/CORE-6071
=== end of list ===

Last commits information (all timestamps in UTC):