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

Generated 23.02.2021 10:14
OS and hardware info:  Linux 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) ; logical CPUs: 2 ; total memory: 7.6 Gb 
Loading data. Please wait...

Duration: ratio of execution time (ms) to median, for the whole set of tests in the last 30 runs:
NN Test name mode median_ms 3.0.8.33420
2021-02-23
3.0.8.33418
2021-02-18
3.0.8.33416
2021-02-16
3.0.8.33415
2021-02-15
X X X X X X X X X X X X X X X X X X X X X X X X X X
Test TITLE
1 CS 754 0.96 1.73 0.92 1.03
FBserver shutsdown when a user password is attempted to be modified to a empty string
2 SS 480 1.16 1.00 0.00 0.97
FBserver shutsdown when a user password is attempted to be modified to a empty string
3 CS 1200 0.97 1.06 0.96 1.02
Incorrect value returned with execute statement calculation
4 SS 980 0.90 1.02 1.24 0.97
Incorrect value returned with execute statement calculation
5 CS 1099 1.00 0.95 1.04 1.00
Navigation vs IS NULL vs compound index
6 SS 910 0.98 1.01 1.16 0.98
Navigation vs IS NULL vs compound index
7 CS 1939 1.10 0.96 1.03 0.96
Trigger do it wrong
8 SS 1704 1.00 0.98 0.99 1.00
Trigger do it wrong
9 CS 2279 1.04 0.95 1.04 0.92
Navigation vs IS NULL vs compound index
10 SS 1829 0.97 1.02 0.54 1.03
Navigation vs IS NULL vs compound index
11 CS 1239 1.01 1.26 0.97 0.98
cannot create procedure with long chain of else-if clauses
12 SS 1019 1.01 0.97 1.19 0.99
cannot create procedure with long chain of else-if clauses
13 CS 1210 1.02 1.00 0.99 0.91
FIRST 1 vs ORDER DESC vs explicit plan (ODS11)
14 SS 1059 0.99 1.00 0.89 1.03
FIRST 1 vs ORDER DESC vs explicit plan (ODS11)
15 CS 1489 0.94 1.06 0.98 1.02
WHERE CURRENT OF doesn't work
16 SS 1189 1.07 0.99 0.96 1.00
WHERE CURRENT OF doesn't work
17 CS 1304 0.91 1.37 1.08 0.91
Automatic not null in PK columns incomplete
18 SS 909 1.06 0.93 1.18 0.92
Automatic not null in PK columns incomplete
19 CS 1274 1.24 1.01 0.93 0.98
Sequence of commands crash FB server
20 SS 1024 1.37 0.97 0.91 1.02
Sequence of commands crash FB server
21 CS 1220 0.99 1.16 0.81 1.00
Expression index regression since 2.0a3
22 SS 935 1.00 0.99 0.98 1.15
Expression index regression since 2.0a3
23 CS 1375 1.07 0.98 0.99 1.00
Invalid ROW_COUNT variable value after DELETE
24 SS 1185 0.99 1.01 0.99 1.00
Invalid ROW_COUNT variable value after DELETE
25 CS 1799 1.13 1.01 0.95 0.98
Query with not in (select) returns wrong result
26 SS 1534 1.00 1.08 0.99 0.95
Query with not in (select) returns wrong result
27 CS 839 1.13 0.98 1.00 1.00
Index bug
28 SS 629 0.98 1.03 1.01 0.96
Index bug
29 CS 1640 0.95 1.29 1.01 0.98
Join on diffrent datatypes
30 SS 1359 1.00 1.02 0.97 0.99
Join on diffrent datatypes
31 CS 1499 0.96 1.15 0.98 1.01
Using where params in SUM return incorrect results
32 SS 1284 1.01 0.92 1.00 0.99
Using where params in SUM return incorrect results
33 CS 1839 1.25 1.00 0.98 1.00
Recreate and self-referencing indexes
34 SS 1764 1.01 1.04 0.98 0.97
Recreate and self-referencing indexes
35 CS 1194 1.14 1.00 0.99 0.97
Strange/Inconsistent query results
36 SS 1000 0.99 0.93 1.01 1.01
Strange/Inconsistent query results
37 CS 1154 1.03 1.25 0.88 0.96
JOIN the same table - problem with alias names
38 SS 900 1.44 1.01 0.98 0.88
JOIN the same table - problem with alias names
39 CS 1489 0.96 1.02 1.08 0.98
Dropping and recreating a table in the same txn disables PK
40 SS 1514 1.04 0.91 0.95 1.08
Dropping and recreating a table in the same txn disables PK
41 CS 1174 0.98 1.39 0.99 1.00
bug with ALL keyword
42 SS 1039 0.96 1.05 0.96 1.03
bug with ALL keyword
43 CS 850 1.04 1.14 0.95 0.92
CREATE TABLE - no blob for external
44 SS 715 1.00 0.87 0.99 1.06
CREATE TABLE - no blob for external
45 CS 1460 1.04 1.07 0.87 0.95
Expression evaluation not supported on LEFT JOIN
46 SS 1174 0.97 0.99 1.33 1.00
Expression evaluation not supported on LEFT JOIN
47 CS 649 1.01 1.03 0.90 0.98
numeric div in dialect 3 mangles data
48 SS 419 1.02 0.92 0.97 1.04
numeric div in dialect 3 mangles data
49 CS 1470 1.00 0.95 1.00 1.04
index breaks = ANY result
50 SS 1304 0.99 0.98 1.28 1.00
index breaks = ANY result
51 CS 1215 0.97 0.98 1.01 1.08
Using where params in SUM return incorrect results
52 SS 1034 0.93 0.98 1.65 1.01
Using where params in SUM return incorrect results
53 CS 1059 1.04 0.94 0.95 1.07
SELECT '1' UNION SELECT '12'
54 SS 884 1.46 0.94 0.93 1.05
SELECT '1' UNION SELECT '12'
55 CS 1905 0.98 1.09 0.99 1.00
Left joining views with null fails
56 SS 1759 0.89 1.03 0.96 1.03
Left joining views with null fails
57 CS 710 0.85 1.01 0.98 1.09
Sqlsubtype incorrect on timestamp math, constant arithmetic
58 SS 435 0.98 0.94 1.01 1.05
Sqlsubtype incorrect on timestamp math, constant arithmetic
59 CS 1809 1.00 1.30 0.99 0.99
Query using VIEW with UNION causes crash
60 SS 1855 0.92 0.96 1.20 1.03
Query using VIEW with UNION causes crash
61 CS 1485 0.99 1.34 0.98 1.00
cannot specify PLAN in UPDATE statement
62 SS 1289 0.93 0.99 1.25 1.00
cannot specify PLAN in UPDATE statement
63 CS 1274 1.01 1.16 0.98 0.78
DB crashes if trigger BU deletes own row
64 SS 1019 0.98 1.00 1.59 0.99
DB crashes if trigger BU deletes own row
65 CS 1749 1.00 0.99 1.01 0.57
trigger on view with union receive nulls
66 SS 1635 1.03 1.00 0.61 0.99
trigger on view with union receive nulls
67 CS 1319 0.99 1.00 0.99 1.06
trigger with except-s on view with union
68 SS 1089 1.01 0.99 1.22 0.97
trigger with except-s on view with union
69 CS 1524 1.06 0.97 0.93 1.02
Bugcheck 291
70 SS 1484 0.88 0.95 1.19 1.05
Bugcheck 291
71 CS 849 0.94 1.00 0.00 1.02
SYSDBA can grant non existent roles
72 SS 519 1.05 0.98 1.01 0.92
SYSDBA can grant non existent roles
73 CS 1564 0.96 1.39 1.03 0.92
wrong order by in table join storedproc
74 SS 1280 0.94 0.90 1.05 1.35
wrong order by in table join storedproc
75 CS 624 1.05 0.94 0.94 1.64
Empty column names with aggregate funcs
76 SS 399 1.07 0.97 0.95 1.02
Empty column names with aggregate funcs
77 CS 1489 0.67 0.98 1.01 1.01
ORDER BY works wrong with collate PT_PT
78 SS 1244 0.80 1.01 1.14 0.98
ORDER BY works wrong with collate PT_PT
79 CS 3279 1.05 0.99 0.94 1.00
CREATE VIEW ignores PLAN
80 SS 2894 1.01 0.98 0.98 1.05
CREATE VIEW ignores PLAN
81 CS 1349 0.96 1.18 1.00 0.99
CHECK constraints fire twice
82 SS 1174 1.02 1.00 0.99 0.99
CHECK constraints fire twice
83 CS 1145 0.99 1.00 0.97 1.00
CS server crash altering SP in 2 connect
84 SS 794 1.02 0.98 0.95 1.03
CS server crash altering SP in 2 connect
85 CS 639 1.00 1.00 0.93 1.00
SELECT...HAVING...NOT IN crashes server
86 SS 415 1.06 1.01 0.96 0.98
SELECT...HAVING...NOT IN crashes server
87 CS 24624 1.00 0.95 1.01 0.99
Count ( DISTINCT ... ) is too slow
88 SS 23959 0.96 1.03 1.43 0.96
Count ( DISTINCT ... ) is too slow
89 CS 16824 1.02 1.00 0.99 0.98
Too many grants lose privileges
90 SS 17474 0.97 0.97 1.02 1.16
Too many grants lose privileges
91 CS 1079 1.00 1.46 0.99 1.00
ALTER TABLE altering to VARCHAR
92 SS 909 0.88 1.03 0.96 1.11
ALTER TABLE altering to VARCHAR
93 CS 1414 0.98 1.10 0.93 1.01
DOMAINs don't register their dependency on other objects
94 SS 1159 1.05 0.93 0.94 1.12
DOMAINs don't register their dependency on other objects
95 CS 1274 1.00 0.97 1.01 0.99
Blob Comparison with constant
96 SS 1084 0.95 0.92 1.04 1.49
Blob Comparison with constant
97 CS 2744 1.05 1.02 0.72 0.97
bug #585624 IB server stalled by simple script
98 SS 2409 1.03 0.83 1.21 0.96
bug #585624 IB server stalled by simple script
99 CS 2924 0.96 1.04 0.84 1.03
ANY user can drop procedures, generators, exceptions.
100 SS 2224 0.95 1.02 1.08 0.97
ANY user can drop procedures, generators, exceptions.
101 CS 1229 1.06 0.92 1.05 0.94
Unsuccessful execution caused by system error <...> bad BLR -- invalid stream
102 SS 965 0.99 0.97 1.01 1.00
Unsuccessful execution caused by system error <...> bad BLR -- invalid stream
103 CS 655 1.00 0.99 1.08 0.99
DateTime math imprecision
104 SS 405 1.01 0.96 0.98 1.01
DateTime math imprecision
105 CS 879 1.12 1.18 0.81 0.87
bug #910430 ISQL and database dialect
106 SS 730 1.00 1.06 0.72 0.00
bug #910430 ISQL and database dialect
107 CS 7259 0.97 1.02 0.97 1.06
Complex view crashes server
108 SS 8295 1.01 0.84 1.30 0.98
Complex view crashes server
109 CS 1094 0.94 1.06 1.03 0.96
NULLS FIRST does not work with unions
110 SS 844 0.98 0.95 1.01 1.03
NULLS FIRST does not work with unions
111 CS 1354 0.97 1.07 0.94 1.02
Garbage vs indices/constraints
112 SS 999 1.14 1.01 0.99 0.95
Garbage vs indices/constraints
113 CS 1154 0.98 1.01 0.91 1.21
Wrong sort order when using es_ES collate
114 SS 964 0.97 1.02 1.17 0.91
Wrong sort order when using es_ES collate
115 CS 8694 0.94 1.71 0.98 1.01
JOIN including a complex view kills the server
116 SS 8824 0.99 1.00 1.15 0.95
JOIN including a complex view kills the server
117 CS 814 1.01 1.05 0.94 0.98
Redundant evaluations in COALESCE
118 SS 544 1.00 0.99 1.11 0.93
Redundant evaluations in COALESCE
119 CS 1589 0.98 1.01 0.91 1.02
ORDER BY has no effect
120 SS 1340 0.91 1.00 1.17 0.99
ORDER BY has no effect
121 CS 2269 0.98 1.09 0.95 1.01
Grants overwrite previous rdb$security_classes entries
122 SS 2020 1.01 0.98 1.05 0.93
Grants overwrite previous rdb$security_classes entries
123 CS 1150 1.00 1.39 0.97 0.99
Foreign key relation VARCHAR <-> INT
124 SS 934 0.93 1.04 1.26 0.95
Foreign key relation VARCHAR <-> INT
125 CS 2664 0.97 1.34 0.98 1.01
Lot of syntax tests for COALESCE()
126 SS 2574 0.77 1.06 1.01 0.98
Lot of syntax tests for COALESCE()
127 CS 799 1.01 1.06 0.88 0.98
ambiguous statements return unpredictable results
128 SS 539 1.07 1.05 0.94 0.94
ambiguous statements return unpredictable results
129 CS 1204 1.17 1.29 0.83 0.83
Permissions are checked case-insensitively
130 SS 1189 1.02 1.00 0.99 0.95
Permissions are checked case-insensitively
131 CS 1074 0.99 1.17 0.98 1.00
Inconsistent results using STARTING WITH and COALESCE
132 SS 794 0.98 0.93 1.01 1.04
Inconsistent results using STARTING WITH and COALESCE
133 CS 1364 0.99 1.04 0.95 1.00
before triggers are firing after checks
134 SS 1219 0.99 1.00 1.13 0.95
before triggers are firing after checks
135 CS 1764 1.04 0.98 1.01 0.94
Tricky role defeats basic SQL security
136 SS 1269 0.99 0.97 1.04 1.00
Tricky role defeats basic SQL security
137 CS 1384 1.03 1.00 0.99 0.96
FIRST is applied before aggregation
138 SS 1119 1.00 1.00 1.00 0.98
FIRST is applied before aggregation
139 CS 1225 1.08 0.81 1.00 0.99
SKIP is off by one
140 SS 1004 0.97 1.02 1.39 0.97
SKIP is off by one
141 CS 1674 1.00 0.99 0.99 1.11
ORDER BY on a VIEW turns values in fields into NULL
142 SS 1475 0.99 0.98 1.01 1.00
ORDER BY on a VIEW turns values in fields into NULL
143 CS 1454 0.92 1.08 0.98 1.01
Token unknown in simple SELECT with GROUP BY and ORDER BY
144 SS 1150 1.07 1.00 1.00 1.00
Token unknown in simple SELECT with GROUP BY and ORDER BY
145 CS 2744 1.05 1.11 0.94 0.91
Grouping on derived fields processing NULL data kills IB
146 SS 2389 0.97 0.97 1.41 1.02
Grouping on derived fields processing NULL data kills IB
147 CS 1249 0.93 1.06 1.38 0.85
Blob Type 1 compatibility with VarChar
148 SS 849 1.01 1.09 0.98 0.94
Blob Type 1 compatibility with VarChar
149 CS 839 1.00 1.09 0.00 0.96
User Account maintanance in SQL
150 SS 559 1.01 0.96 1.01 0.98
User Account maintanance in SQL
151 CS 1779 1.15 1.32 0.79 0.84
Compress Data over the Network
152 SS 1284 1.11 1.13 0.88 0.86
Compress Data over the Network
153 CS 640 1.01 1.06 0.98 0.95
Wildcards/Regular Expressions in WHERE clause - SIMILAR TO predicate
154 SS 454 0.98 1.01 1.01 0.94
Wildcards/Regular Expressions in WHERE clause - SIMILAR TO predicate
155 CS 1589 0.99 1.47 1.00 0.91
Alter view
156 SS 1430 0.98 1.01 1.23 0.92
Alter view
157 CS 1169 1.08 1.41 0.87 0.91
Easy metadata extract improvements
158 SS 925 1.00 1.75 0.99 0.85
Easy metadata extract improvements
159 CS 2479 1.06 0.98 0.88 1.01
Privileges of dynamic statements in SP
160 SS 1689 1.03 1.48 0.90 0.97
Privileges of dynamic statements in SP
161 CS 725 1.00 0.95 1.33 0.99
accent ignoring collation for unicode
162 SS 440 1.04 0.95 1.02 0.97
accent ignoring collation for unicode
163 CS 644 0.96 0.91 1.13 1.03
Specific query crashing server
164 SS 404 0.96 0.98 1.80 1.01
Specific query crashing server
165 CS 1290 1.04 1.07 0.95 0.85
computed field can't be changed to non-computed using 'alter table alter column type xy'
166 SS 1009 1.10 0.96 1.03 0.91
computed field can't be changed to non-computed using 'alter table alter column type xy'
167 CS 1244 1.14 0.88 0.94 1.05
DYN allows to set defaults for computed fields when altering a field
168 SS 905 1.14 1.07 0.92 0.92
DYN allows to set defaults for computed fields when altering a field
169 CS 1114 1.00 0.99 1.03 0.99
Field can be used multiple times in multi-segment index definition
170 SS 864 0.99 1.64 1.00 0.99
Field can be used multiple times in multi-segment index definition
171 CS 664 1.09 1.06 0.91 0.93
substring(current_user from 4) fails
172 SS 415 1.05 0.96 0.91 1.03
substring(current_user from 4) fails
173 CS 604 1.04 0.96 0.94 1.07
Aggregates in the WHERE clause vs derived tables
174 SS 414 1.15 0.96 0.96 1.03
Aggregates in the WHERE clause vs derived tables
175 CS 929 0.99 1.01 0.91 1.06
Unable to set FName, MName, LName fields in security to blank
176 SS 614 1.00 1.00 0.92 0.99
Unable to set FName, MName, LName fields in security to blank
177 CS 1285 0.92 1.07 0.89 2.14
Containing not working correctly
178 SS 980 1.00 1.00 1.07 0.99
Containing not working correctly
179 CS 999 1.15 0.96 0.95 1.04
Server crash when using UDF
180 SS 769 0.96 0.98 1.16 1.01
Server crash when using UDF
181 CS 1364 0.99 1.00 0.90 1.11
Removing a NOT NULL constraint is not visible until reconnect
182 SS 1029 0.99 1.00 0.90 1.11
Removing a NOT NULL constraint is not visible until reconnect
183 CS 675 0.99 1.00 0.90 1.02
Engine crashes while trying to backup a logically corrupt db
184 SS 414 1.06 1.01 0.99 0.96
Engine crashes while trying to backup a logically corrupt db
185 CS 1580 0.91 1.22 1.02 0.97
Incorrect handling of null within view - returns 0
186 SS 1180 1.08 0.99 1.00 0.94
Incorrect handling of null within view - returns 0
187 CS 1834 0.98 1.39 1.00 0.99
problem when dropping column that is a primary key
188 SS 1689 0.99 0.98 1.25 1.00
problem when dropping column that is a primary key
189 CS 1194 0.98 0.98 1.05 1.01
Dependencies are not cleared when creation of expression index fails
190 SS 1109 0.91 0.97 1.45 1.02
Dependencies are not cleared when creation of expression index fails
191 CS 1324 1.01 0.98 0.90 1.01
Singleton isn't respected in COMPUTED BY expressions
192 SS 1059 0.97 1.00 1.01 1.00
Singleton isn't respected in COMPUTED BY expressions
193 CS 749 1.01 1.01 0.98 0.95
The built-in BLR printer doesn't support all FB2 features
194 SS 524 1.08 1.03 0.93 0.97
The built-in BLR printer doesn't support all FB2 features
195 CS 2420 0.97 1.00 0.99 1.06
It is impossible to take away rights on update of a column
196 SS 2194 1.12 0.90 1.05 0.94
It is impossible to take away rights on update of a column
197 CS 1319 1.03 1.00 0.97 1.00
SPs in views
198 SS 1069 1.04 0.94 1.07 0.95
SPs in views
199 CS 804 1.00 0.98 0.99 1.00
DDL - object in use
200 SS 569 0.98 1.03 1.01 0.96
DDL - object in use
201 CS 670 1.02 1.13 0.92 0.97
SUBSTRING with NULL offset or length don't return NULL
202 SS 420 1.07 0.97 1.02 0.95
SUBSTRING with NULL offset or length don't return NULL
203 CS 1710 0.98 1.11 0.92 1.01
Problems with explicit cursors in unwanted states
204 SS 1370 0.94 1.08 1.00 0.99
Problems with explicit cursors in unwanted states
205 CS 1239 1.03 1.74 0.96 0.80
New value of column is accessable before update
206 SS 1079 0.94 0.99 1.07 1.01
New value of column is accessable before update
207 CS 1814 1.00 1.13 0.94 0.99
Server crash on violation of NOT NULL constraint
208 SS 1625 1.13 0.95 0.96 1.03
Server crash on violation of NOT NULL constraint
209 CS 1144 1.19 1.03 0.97 0.90
Garbage in plan output of complex statement
210 SS 869 0.89 1.04 1.15 0.95
Garbage in plan output of complex statement
211 CS 1515 0.93 1.10 1.06 0.91
An attempt to select DB_KEY from a procedure crashes the server
212 SS 1219 1.00 0.96 0.99 1.00
An attempt to select DB_KEY from a procedure crashes the server
213 CS 1514 1.00 0.99 0.97 1.04
ALL predicate works incorrectly for some subqueries
214 SS 1304 0.94 0.98 1.05 1.01
ALL predicate works incorrectly for some subqueries
215 CS 1919 0.98 1.20 0.94 1.01
Grants don't work for procedures used inside views
216 SS 1579 0.98 0.96 1.20 1.01
Grants don't work for procedures used inside views
217 CS 1284 0.98 0.77 1.10 1.01
Bug in DSQL parameter
218 SS 1100 1.04 0.93 0.95 1.19
Bug in DSQL parameter
219 CS 839 0.96 0.97 1.02 1.74
Comment in create database
220 SS 640 1.00 1.00 1.00 1.03
Comment in create database
221 CS 1165 1.00 0.99 1.01 0.99
Bad error message when tring to create FK to non-existent table
222 SS 1009 1.00 0.96 1.36 1.00
Bad error message when tring to create FK to non-existent table
223 CS 1504 0.97 1.39 0.95 1.02
AV when blob is used in expression index
224 SS 1284 1.03 0.98 0.77 1.01
AV when blob is used in expression index
225 CS 2104 1.19 1.61 0.68 0.80
GSTAT does not work using the localhost connection string
226 SS 1894 1.20 1.25 0.79 0.78
GSTAT does not work using the localhost connection string
227 CS 1104 1.01 1.24 0.97 0.98
Many aggregate functions within a single select list may cause a server crash
228 SS 884 0.98 1.01 1.10 0.92
Many aggregate functions within a single select list may cause a server crash
229 CS 1139 1.01 0.89 0.99 1.00
SQL with incorrect characters (outside the ASCII range) may be processed wrongly
230 SS 885 0.98 1.01 1.20 0.95
SQL with incorrect characters (outside the ASCII range) may be processed wrongly
231 CS 1180 1.02 0.97 0.95 1.03
Case insensitive collation for UTF-8
232 SS 935 1.03 1.02 0.96 0.97
Case insensitive collation for UTF-8
233 CS 1414 0.98 0.96 1.71 1.01
Make RDB$DB_KEY in outer joins return NULL when appropriate
234 SS 1179 0.91 0.91 1.27 1.08
Make RDB$DB_KEY in outer joins return NULL when appropriate
235 CS 1880 1.03 0.96 0.92 1.09
select with FIRST and LEFT JOIN needs excess SORT in plan
236 SS 1574 1.04 0.96 0.99 1.00
select with FIRST and LEFT JOIN needs excess SORT in plan
237 CS 1225 1.08 0.97 0.98 1.01
Keyword AS not recognized in clause FROM
238 SS 980 0.97 0.97 1.19 1.02
Keyword AS not recognized in clause FROM
239 CS 1319 0.96 1.25 0.84 1.03
Incorrect results when left join on subquery with constant column
240 SS 1015 0.96 1.06 0.97 1.02
Incorrect results when left join on subquery with constant column
241 CS 669 1.19 1.03 0.91 0.97
bad handling of /*/ comments in ISQL
242 SS 415 1.01 0.98 0.96 1.08
bad handling of /*/ comments in ISQL
243 CS 1119 0.98 1.01 0.94 1.06
context already in use (BLR error)
244 SS 869 1.00 1.15 1.00 1.00
context already in use (BLR error)
245 CS 1179 0.99 1.15 0.99 1.00
DISTINCT vs NULLS LAST clause: wrong order of NULLs
246 SS 874 0.98 1.07 0.99 1.00
DISTINCT vs NULLS LAST clause: wrong order of NULLs
247 CS 3729 0.92 1.12 1.04 0.95
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
248 SS 3205 1.00 0.98 0.99 1.07
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
249 CS 890 1.03 0.97 1.02 0.94
Restoring RDB$BASE_FIELD for expression
250 SS 589 1.00 1.00 1.01 0.96
Restoring RDB$BASE_FIELD for expression
251 CS 1164 0.91 0.77 1.08 1.25
Local buffer overrun in DYN_error() that takes down the server
252 SS 749 1.12 0.91 0.97 1.02
Local buffer overrun in DYN_error() that takes down the server
253 CS 660 0.96 1.03 0.95 1.03
Provide mechanism to get engine version without needing to call API function
254 SS 405 1.01 0.98 0.96 1.05
Provide mechanism to get engine version without needing to call API function
255 CS 645 1.02 0.92 0.97 1.11
Make information available regading ODS Version and Dialect via SQL
256 SS 425 1.05 0.98 1.01 0.94
Make information available regading ODS Version and Dialect via SQL
257 CS 1294 1.01 1.05 0.95 0.98
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
258 SS 1064 1.02 0.96 0.97 1.09
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
259 CS 1259 1.01 0.98 0.98 1.49
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)
260 SS 1044 1.00 0.99 1.10 0.97
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)
261 CS 1584 0.92 0.91 1.16 1.07
like doesn't work for computed values (at least in a view)
262 SS 1154 0.97 1.02 0.86 1.02
like doesn't work for computed values (at least in a view)
263 CS 1725 0.99 0.95 1.00 1.11
extend retutnning support added in ver 2 in update record of table and in updateble view
264 SS 1509 1.03 0.96 1.53 0.92
extend retutnning support added in ver 2 in update record of table and in updateble view
265 CS 1269 0.99 1.11 1.00 0.93
Wrong single-segment ascending index on character field with NULL and empty string values
266 SS 965 0.98 1.01 1.01 0.95
Wrong single-segment ascending index on character field with NULL and empty string values
267 CS 1099 0.95 1.01 0.99 1.06
Wrong parameter matching for self-referenced procedures
268 SS 909 0.99 1.00 1.00 1.04
Wrong parameter matching for self-referenced procedures
269 CS 1274 1.04 1.43 0.95 0.94
A query could produce different results, depending on the presence of an index
270 SS 1019 1.01 0.98 1.08 0.95
A query could produce different results, depending on the presence of an index
271 CS 915 0.99 1.09 1.00 0.96
ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation
272 SS 660 0.98 1.01 1.03 0.98
ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation
273 CS 1695 1.00 1.13 0.99 0.98
Server hangs eating CPU and performs huge I/O copying different codepage fields
274 SS 1180 0.96 1.00 1.06 0.99
Server hangs eating CPU and performs huge I/O copying different codepage fields
275 CS 1254 1.01 1.35 0.94 0.98
SINGULAR buggy when nulls present
276 SS 1014 0.96 0.95 1.09 1.03
SINGULAR buggy when nulls present
277 CS 1375 1.57 1.69 0.42 0.42
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
278 SS 1070 1.64 1.62 0.37 0.36
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition
279 CS 1369 1.02 0.99 0.97 1.00
View with equally named source fields not faisible
280 SS 1179 1.02 0.96 1.14 0.97
View with equally named source fields not faisible
281 CS 1770 0.91 1.18 1.06 0.93
User (not SYSDBA) what have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA
282 SS 1334 0.99 1.00 1.13 0.95
User (not SYSDBA) what have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA
283 CS 2185 1.01 1.25 0.91 0.98
Wrong ordering with views, distinct, left join and order by
284 SS 1910 0.96 0.99 1.14 1.00
Wrong ordering with views, distinct, left join and order by
285 CS 1465 1.06 0.92 1.05 0.94
Error msg "Could not find UNIQUE INDEX" when in fact one is present
286 SS 1069 1.04 0.96 0.93 1.03
Error msg "Could not find UNIQUE INDEX" when in fact one is present
287 CS 769 0.96 1.22 1.03 0.96
Support BETWEEN predicate for select expressions
288 SS 509 1.11 0.94 1.05 0.94
Support BETWEEN predicate for select expressions
289 CS 1150 1.06 0.99 0.95 1.00
Wrong results with GROUP BY on constants
290 SS 925 0.90 1.02 1.64 0.97
Wrong results with GROUP BY on constants
291 CS 599 0.93 1.03 1.01 0.98
Crash when dealing with a string literal longer than 32K
292 SS 394 1.01 0.98 1.01 0.93
Crash when dealing with a string literal longer than 32K
293 CS 864 1.04 1.02 0.97 0.94
Remove or extend limit of command text length (64K)
294 SS 700 1.04 0.97 0.94 1.02
Remove or extend limit of command text length (64K)
295 CS 629 1.01 0.92 1.04 0.98
Conversion from string to number is not standard compliant
296 SS 429 1.00 0.88 1.02 1.00
Conversion from string to number is not standard compliant
297 CS 1249 1.02 1.00 0.99 0.95
Recursive Query bug in FB2.1
298 SS 994 1.02 0.93 0.98 1.01
Recursive Query bug in FB2.1
299 CS 634 1.05 1.08 0.88 0.94
UNION vs UTF8 literals : arithmetic exception is thrown
300 SS 409 1.12 1.00 1.00 0.97
UNION vs UTF8 literals : arithmetic exception is thrown
301 CS 1009 1.00 1.00 0.94 1.07
Bad optimization -- <procedure> left join <subquery> (or <view>)
302 SS 810 1.00 0.94 2.04 1.00
Bad optimization -- <procedure> left join <subquery> (or <view>)
303 CS 1034 0.97 1.33 0.88 1.02
Cannot alter generator's comment to the same value
304 SS 869 1.04 0.97 1.02 0.90
Cannot alter generator's comment to the same value
305 CS 1514 0.99 1.71 0.94 1.00
Server locks up while attempting to commit a deletion of an expression index
306 SS 1399 0.89 1.00 1.80 1.00
Server locks up while attempting to commit a deletion of an expression index
307 CS 1329 1.01 0.75 1.01 0.98
AV in rse\invalidate_child_rpbs for recursive queies
308 SS 940 0.95 1.00 1.00 1.06
AV in rse\invalidate_child_rpbs for recursive queies
309 CS 1199 1.48 1.48 0.50 0.51
Every user can view server log using services API
310 SS 965 1.51 1.61 0.48 0.45
Every user can view server log using services API
311 CS 1464 0.96 1.17 0.96 1.03
Error conversion error from string " " using outer join on int64 and int fields
312 SS 1179 0.99 1.00 0.99 1.09
Error conversion error from string " " using outer join on int64 and int fields
313 CS 1469 0.93 1.02 1.05 0.97
cannot erase a table with check constraints referencing more than a single columns
314 SS 1259 1.12 0.90 1.09 0.85
cannot erase a table with check constraints referencing more than a single columns
315 CS 1569 1.01 1.40 0.96 0.98
Activating index change "STARTING" working as "LIKE" in join condition
316 SS 1389 0.97 0.95 1.23 1.02
Activating index change "STARTING" working as "LIKE" in join condition
317 CS 609 1.01 0.93 0.98 1.06
Prepare fails when having a parameter in a DSQL statement before a sub query
318 SS 405 1.20 0.96 0.96 1.03
Prepare fails when having a parameter in a DSQL statement before a sub query
319 CS 1054 0.87 1.06 0.93 1.09
Problem altering numeric field type
320 SS 824 0.95 1.04 1.12 0.95
Problem altering numeric field type
321 CS 1250 1.00 0.92 1.02 0.99
WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL
322 SS 1024 0.96 1.01 1.37 0.98
WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL
323 CS 1054 0.96 1.04 0.94 1.03
CHARACTER SET GBK is not installed
324 SS 1029 1.23 0.76 0.00 0.00
CHARACTER SET GBK is not installed
325 CS 624 1.02 0.94 0.97 1.05
isql exponential format of numbers has zero pad on windows
326 SS 420 1.02 1.00 1.00 0.97
isql exponential format of numbers has zero pad on windows
327 CS 1614 0.91 1.01 0.98 1.02
Symbols ignored for ES_ES_CI_AI collation
328 SS 1345 0.98 0.93 1.13 1.01
Symbols ignored for ES_ES_CI_AI collation
329 CS 1854 1.45 1.01 0.98 0.93
Expression index based on computed fields
330 SS 1514 1.01 0.98 0.97 1.06
Expression index based on computed fields
331 CS 989 0.93 1.04 1.04 0.96
Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference
332 SS 709 1.00 1.08 0.97 0.00
Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference
333 CS 1230 1.07 1.04 0.95 0.81
"CH" and "LL" are not separate spanish alphabet letters since 1994
334 SS 1040 1.41 1.03 0.96 0.93
"CH" and "LL" are not separate spanish alphabet letters since 1994
335 CS 1344 1.01 1.00 0.95 0.99
Union returns inconsistent field names
336 SS 1074 0.99 0.99 1.18 1.00
Union returns inconsistent field names
337 CS 1230 1.00 1.00 1.02 0.81
View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference
338 SS 1034 1.00 1.02 0.99 0.98
View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference
339 CS 1629 0.97 1.15 0.95 1.02
Select Starting with :Param (Empty string) doesn't work if using index with many fields
340 SS 1409 0.98 1.01 1.13 0.90
Select Starting with :Param (Empty string) doesn't work if using index with many fields
341 CS 669 0.98 0.89 1.01 1.06
Long SQL statements break TCP/IP connection
342 SS 455 1.07 1.01 0.94 0.98
Long SQL statements break TCP/IP connection
343 CS 1465 0.98 0.93 1.18 1.01
CURRENT OF support views
344 SS 1244 0.98 0.98 1.28 1.01
CURRENT OF support views
345 CS 2930 1.41 1.02 0.97 0.97
Wrong SELECT query results using index to evaluate >= condition
346 SS 2634 0.96 1.05 1.03 0.92
Wrong SELECT query results using index to evaluate >= condition
347 CS 1249 0.93 1.06 0.82 1.07
LIST() function seems not work if used twice or more in a query
348 SS 959 1.14 0.89 1.09 0.90
LIST() function seems not work if used twice or more in a query
349 CS 1190 0.94 1.16 1.02 0.97
Server crash on select * from <recursive CTE>
350 SS 925 0.99 0.96 1.22 1.00
Server crash on select * from <recursive CTE>
351 CS 1615 0.93 0.96 1.05 1.03
Incorrect column values with outer joins and views
352 SS 1209 1.09 1.04 0.89 0.95
Incorrect column values with outer joins and views
353 CS 1384 0.97 1.15 0.86 1.02
Incorrect column values with outer joins and derived tables
354 SS 1069 1.01 0.98 0.94 1.06
Incorrect column values with outer joins and derived tables
355 CS 809 1.05 1.39 0.91 0.95
Full shutdown mode doesn't work on Classic if there are other connections to the database
356 SS 1509 1.01 0.98 1.00 1.00
Full shutdown mode doesn't work on Classic if there are other connections to the database
357 CS 1184 1.10 0.97 1.00 0.99
LIST(DISTINCT) concatenate VARCHAR values as CHAR
358 SS 975 0.98 0.90 1.01 1.02
LIST(DISTINCT) concatenate VARCHAR values as CHAR
359 CS 1489 0.67 1.18 1.53 0.81
Problem with DISTINCT and insensitive collations
360 SS 1020 0.97 0.94 1.15 1.02
Problem with DISTINCT and insensitive collations
361 CS 629 1.06 1.00 1.00 1.00
String truncation error when concatenating _UTF8 string onto extract(year result
362 SS 434 1.01 0.96 0.99 1.01
String truncation error when concatenating _UTF8 string onto extract(year result
363 CS 1185 0.94 1.01 1.04 0.98
Table columns hide destination variables of RETURNING INTO
364 SS 925 0.96 1.03 1.24 0.92
Table columns hide destination variables of RETURNING INTO
365 CS 589 0.96 1.22 1.00 0.00
GSec incorrectly processes some switches
366 SS 404 1.03 1.01 0.93 0.99
GSec incorrectly processes some switches
367 CS 915 0.99 1.73 1.00 0.98
Small bug with default value for domains in PSQL
368 SS 650 1.00 1.00 0.98 1.00
Small bug with default value for domains in PSQL
369 CS 1094 1.23 1.07 0.85 0.92
Ceation of invalid procedures/triggers allowed
370 SS 799 1.01 0.00 0.98 1.00
Ceation of invalid procedures/triggers allowed
371 CS 1349 1.04 1.03 0.96 0.97
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
372 SS 1069 1.04 1.00 0.98 0.99
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
373 CS 1489 0.67 1.20 1.04 0.95
Bug with COMPUTED BY fields
374 SS 1039 0.98 1.00 1.00 1.00
Bug with COMPUTED BY fields
375 CS 2619 0.87 1.10 1.03 0.96
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
376 SS 2269 1.03 0.88 1.00 1.00
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)
377 CS 1539 0.99 1.19 0.94 1.00
Can't create table using long username and UTF8 as attachment charset
378 SS 1159 0.98 1.01 1.06 0.92
Can't create table using long username and UTF8 as attachment charset
379 CS 609 1.14 1.01 0.98 0.91
Bad optimization of queries with DB_KEY
380 SS 409 0.92 1.02 1.02 0.97
Bad optimization of queries with DB_KEY
381 CS 1514 1.01 0.98 0.98 1.04
Indices not used for views
382 SS 1220 1.00 1.03 0.99 0.95
Indices not used for views
383 CS 689 1.49 1.03 0.94 0.97
A remote attacker can check, if a file is present in the system, running firebird server
384 SS 424 0.89 1.01 1.01 0.99
A remote attacker can check, if a file is present in the system, running firebird server
385 CS 1174 0.97 1.01 1.00 0.99
RDB$DB_KEY not supported in derived tables and merge command
386 SS 889 0.98 0.97 1.02 1.01
RDB$DB_KEY not supported in derived tables and merge command
387 CS 614 0.99 1.20 1.00 0.95
Data type unknown
388 SS 395 1.01 0.98 1.06 0.98
Data type unknown
389 CS 930 1.07 0.94 0.98 1.01
NOT NULL constraint for procedure parameters and variables
390 SS 749 0.94 1.02 1.58 0.97
NOT NULL constraint for procedure parameters and variables
391 CS 664 1.02 0.99 1.00 0.97
Error "Identifier ... is too long using multiple (nested) derived tables
392 SS 424 1.01 0.99 0.98 1.03
Error "Identifier ... is too long using multiple (nested) derived tables
393 CS 1165 1.00 0.99 0.92 1.46
size of alias name in a table
394 SS 919 0.96 0.97 1.02 1.09
size of alias name in a table
395 CS 725 1.00 0.95 0.99 1.04
Charset transliterations don't work with EXECUTE STATEMENT
396 SS 539 1.05 1.00 1.00 1.00
Charset transliterations don't work with EXECUTE STATEMENT
397 CS 1764 1.02 1.33 0.97 0.89
Joins with NULL RDB$DB_KEY crash the server
398 SS 1344 0.97 0.98 1.03 1.01
Joins with NULL RDB$DB_KEY crash the server
399 CS 1169 0.99 0.85 1.25 1.00
Problem with view , computed field and functions
400 SS 994 0.93 1.01 1.32 0.98
Problem with view , computed field and functions
401 CS 595 1.10 1.00 0.97 0.99
Bug with a simple case and a subquery
402 SS 409 0.90 1.02 0.97 1.02
Bug with a simple case and a subquery
403 CS 645 1.02 1.11 0.97 0.94
lpad and rpad with two columns not working
404 SS 419 1.02 1.02 0.95 0.97
lpad and rpad with two columns not working
405 CS 655 0.89 1.03 0.97 1.02
Unexpected "cannot transliterate" error
406 SS 419 1.12 1.00 0.88 1.00
Unexpected "cannot transliterate" error
407 CS 1344 1.12 1.01 0.98 0.98
TYPE OF COLUMN in PSQL
408 SS 1089 0.95 0.99 1.01 1.00
TYPE OF COLUMN in PSQL
409 CS 2429 1.05 1.02 0.93 0.97
Index operations for global temporary tables are not visible for the active connection
410 SS 1714 0.99 0.99 1.00 1.00
Index operations for global temporary tables are not visible for the active connection
411 CS 1184 0.96 1.23 0.98 1.01
Too large numbers cause positive infinity to be inserted into database
412 SS 929 0.99 0.97 1.01 1.10
Too large numbers cause positive infinity to be inserted into database
413 CS 584 1.02 0.97 1.00 0.99
ISQL crash when converted-from-double string longer than 23 bytes
414 SS 400 1.00 1.00 1.04 0.97
ISQL crash when converted-from-double string longer than 23 bytes
415 CS 1359 0.96 1.37 1.00 0.99
French insensitive collation FR_FR_CI_AI
416 SS 1270 0.94 0.92 1.05 1.27
French insensitive collation FR_FR_CI_AI
417 CS 789 0.96 1.17 1.00 1.00
Execute block fails within execute statement
418 SS 584 0.95 1.05 0.97 1.02
Execute block fails within execute statement
419 CS 1449 1.18 1.04 0.93 0.95
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields
420 SS 1180 1.01 0.89 1.09 0.98
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields
421 CS 849 1.03 1.02 0.97 0.95
Add an ability to change role without reconnecting to database.
422 SS 629 0.98 0.98 1.06 1.01
Add an ability to change role without reconnecting to database.
423 CS 654 0.94 1.03 1.03 0.96
Domain names and charset issues
424 SS 404 1.01 0.98 0.98 1.01
Domain names and charset issues
425 CS 630 1.03 1.06 0.93 0.96
Invalid parameter type when using it in CHAR_LENGTH function
426 SS 424 1.01 1.03 0.98 0.94
Invalid parameter type when using it in CHAR_LENGTH function
427 CS 1074 0.96 1.03 0.86 1.08
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
428 SS 759 1.00 0.97 1.00 0.00
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1
429 CS 1079 0.98 1.43 0.98 1.01
Generated columns
430 SS 944 0.86 0.93 1.06 1.21
Generated columns
431 CS 2685 1.00 1.25 0.99 0.98
Indexed MIN/MAX aggregates produce three index reads instead of the expected one indexed read
432 SS 2454 0.96 0.97 1.29 1.02
Indexed MIN/MAX aggregates produce three index reads instead of the expected one indexed read
433 CS 1394 0.88 1.11 0.85 1.30
Few problems with domains's check constraints
434 SS 1014 1.01 0.97 1.05 0.98
Few problems with domains's check constraints
435 CS 1170 0.96 1.03 1.11 0.96
Global temporary table instance may pick up not all indices
436 SS 979 1.03 0.94 1.14 0.97
Global temporary table instance may pick up not all indices
437 CS 1379 0.72 1.09 0.97 1.02
CREATE VIEW without column list when UNION is used
438 SS 1190 1.01 0.97 0.98 1.14
CREATE VIEW without column list when UNION is used
439 CS 1230 1.76 0.81 0.99 1.00
Support for autonomous transactions
440 SS 965 1.00 1.19 0.95 0.99
Support for autonomous transactions
441 CS 1424 1.01 0.70 0.99 1.13
Wrong current timestamp evaluation for selectable procedures
442 SS 1169 1.01 0.98 1.12 0.98
Wrong current timestamp evaluation for selectable procedures
443 CS 624 1.02 0.97 0.97 1.04
Incorrect timestamp substraction in 3 dialect when result is negative number
444 SS 414 1.13 1.01 0.89 0.99
Incorrect timestamp substraction in 3 dialect when result is negative number
445 CS 1184 0.97 1.01 1.08 0.98
Greek characters in cp1251 vs uppercasing
446 SS 1029 0.84 0.98 1.33 1.01
Greek characters in cp1251 vs uppercasing
447 CS 1294 0.94 1.02 1.01 0.98
Collation not propagated between record formats
448 SS 1069 1.00 0.95 1.00 1.00
Collation not propagated between record formats
449 CS 634 1.02 0.99 0.91 1.00
Incorrect result with EXECUTE STATEMENT and VARCHAR columns
450 SS 439 0.95 0.91 2.57 1.04
Incorrect result with EXECUTE STATEMENT and VARCHAR columns
451 CS 635 0.99 1.00 0.96 1.00
Outer joins don't work properly with the MON$ tables
452 SS 450 0.97 1.02 1.06 0.93
Outer joins don't work properly with the MON$ tables
453 CS 1389 1.03 0.95 0.97 1.02
Execute statement 'select ....' into new....
454 SS 1170 0.94 1.00 1.00 1.03
Execute statement 'select ....' into new....
455 CS 1080 0.99 1.02 0.94 1.00
Using RDB$DB_KEY in where section while selecting from a procedure crashes the server
456 SS 794 1.02 0.90 1.05 0.98
Using RDB$DB_KEY in where section while selecting from a procedure crashes the server
457 CS 1139 1.08 1.02 0.97 0.95
Allow usage of functions in LIST delimiter parameter
458 SS 969 1.01 0.97 1.21 0.98
Allow usage of functions in LIST delimiter parameter
459 CS 1289 1.07 0.93 0.99 1.00
ALTER mechanism for computed fields
460 SS 1084 1.02 0.97 0.95 1.06
ALTER mechanism for computed fields
461 CS 1364 0.73 1.07 1.38 0.92
Server crash caused by a buffer overrun in the optimizer when more than 255 relation references exist in the query
462 SS 970 1.07 1.00 1.00 1.00
Server crash caused by a buffer overrun in the optimizer when more than 255 relation references exist in the query
463 CS 5544 1.00 0.89 0.99 1.05
Make optimizer to consider ORDER BY optimization when making decision about join order
464 SS 5059 1.01 1.01 0.97 0.99
Make optimizer to consider ORDER BY optimization when making decision about join order
465 CS 670 0.91 1.82 1.00 1.00
DATEADD wrong work with NULL arguments
466 SS 430 1.00 0.95 1.00 1.00
DATEADD wrong work with NULL arguments
467 CS 1404 1.02 1.73 0.97 0.93
BLOB isn't compatible with [VAR]CHAR in COALESCE
468 SS 1124 0.99 1.00 1.20 0.98
BLOB isn't compatible with [VAR]CHAR in COALESCE
469 CS 644 0.89 1.10 0.89 1.92
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax
470 SS 419 1.07 1.00 0.92 1.00
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax
471 CS 779 1.03 1.01 0.98 0.92
Server crash with isc_dsql_execute_immediate and zero length string
472 SS 519 1.00 0.98 1.09 0.00
Server crash with isc_dsql_execute_immediate and zero length string
473 CS 624 1.05 1.24 0.94 0.92
Conversion from double to varchar insert trailing spaces
474 SS 445 0.94 1.01 1.05 0.98
Conversion from double to varchar insert trailing spaces
475 CS 804 0.98 1.01 0.92 1.01
Bad XSQLVAR [NULL flags] for (2*COALESCE(NULL,NULL))
476 SS 514 0.95 0.99 1.16 1.00
Bad XSQLVAR [NULL flags] for (2*COALESCE(NULL,NULL))
477 CS 615 0.97 0.97 1.02 1.08
POSITION(string_exp1, string_exp2 [, start])
478 SS 404 1.18 0.99 1.01 0.96
POSITION(string_exp1, string_exp2 [, start])
479 CS 1859 1.04 0.96 0.98 1.01
Connection lost running script
480 SS 1659 0.99 0.97 1.00 1.01
Connection lost running script
481 CS 659 0.97 0.92 1.07 1.03
Many new 2.1 built in functions have incorrect NULL semantics
482 SS 420 1.90 1.02 0.97 0.97
Many new 2.1 built in functions have incorrect NULL semantics
483 CS 1594 0.96 1.10 0.95 1.03
Adding a non-null restricted column to a populated table renders the table inconsistent
484 SS 1309 1.00 1.04 1.00 0.96
Adding a non-null restricted column to a populated table renders the table inconsistent
485 CS 639 1.00 1.07 0.98 1.00
Inconsistent DATEDIFF behaviour
486 SS 444 0.96 1.03 1.21 0.90
Inconsistent DATEDIFF behaviour
487 CS 1199 0.97 1.40 0.94 1.02
Computed field + index not working in WHERE
488 SS 1039 1.01 1.10 0.98 0.99
Computed field + index not working in WHERE
489 CS 644 0.94 0.96 1.10 1.03
Functions DATEDIFF does not work in dialect 1
490 SS 440 1.04 1.00 0.97 1.00
Functions DATEDIFF does not work in dialect 1
491 CS 1270 1.17 1.03 0.96 0.96
JOIN on first record of ordered derived table returns wrong record
492 SS 999 0.99 1.03 0.99 1.01
JOIN on first record of ordered derived table returns wrong record
493 CS 1159 1.17 0.98 1.01 0.97
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
494 SS 895 1.01 0.98 0.97 1.02
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'
495 CS 1225 0.81 1.02 1.01 0.98
Subquery-based predicates are not evaluated early in the join order
496 SS 919 1.29 0.98 0.94 1.01
Subquery-based predicates are not evaluated early in the join order
497 CS 1114 1.01 1.15 0.95 0.98
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
498 SS 915 0.96 1.03 1.58 0.96
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
499 CS 1945 0.88 1.12 1.11 0.82
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
500 SS 1374 1.03 0.96 1.36 0.96
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
501 CS 2495 1.01 1.06 0.98 0.98
AV when all statements are cancelled
502 SS 1929 0.98 1.01 0.98 1.75
AV when all statements are cancelled
503 CS 624 0.99 0.97 1.00 1.07
select ... where ... <> ALL (select ... join ...) bug
504 SS 409 1.00 1.00 0.92 1.05
select ... where ... <> ALL (select ... join ...) bug
505 CS 1855 1.09 0.94 0.53 1.05
'select ...from...where...not in (select...from...)' no results
506 SS 1584 1.01 0.94 1.00 0.99
'select ...from...where...not in (select...from...)' no results
507 CS 1174 1.03 1.31 0.96 0.93
Dropping NOT NULL contranint doesn'have the desired effect
508 SS 1014 1.00 1.26 0.99 0.94
Dropping NOT NULL contranint doesn'have the desired effect
509 CS 664 0.85 1.00 1.00 0.99
NULLIF crashes when first parameter is constant empty string
510 SS 419 1.00 1.00 1.00 0.90
NULLIF crashes when first parameter is constant empty string
511 CS 1610 0.96 1.10 1.01 0.98
Multiple Rows in Singleton Select not reported in a View
512 SS 1440 1.00 0.99 0.87 1.50
Multiple Rows in Singleton Select not reported in a View
513 CS 615 1.02 0.97 0.92 1.10
ABS() rounds NUMERIC values
514 SS 440 0.97 1.00 1.00 1.02
ABS() rounds NUMERIC values
515 CS 724 0.97 1.29 0.88 1.02
Server crashed or bugcheck when inserting in monitoring tables.
516 SS 424 0.98 0.94 1.08 1.01
Server crashed or bugcheck when inserting in monitoring tables.
517 CS 1249 0.80 1.26 0.95 1.04
Bugcheck 232 (invalid operation) for an aggregated query
518 SS 1054 0.95 1.03 0.96 1.10
Bugcheck 232 (invalid operation) for an aggregated query
519 CS 2054 0.99 1.04 1.00 0.97
Ability to insert child record if parent record is locked but foreign key target unchanged
520 SS 1685 0.97 1.00 1.01 0.99
Ability to insert child record if parent record is locked but foreign key target unchanged
521 CS 700 0.99 1.24 1.00 0.00
Correlated subquery is optimized badly if it depends on the union stream
522 SS 499 0.98 1.08 1.02 0.98
Correlated subquery is optimized badly if it depends on the union stream
523 CS 1234 0.81 1.98 1.19 0.81
PSQL output parameter size limited
524 SS 1379 0.91 0.93 1.08 1.06
PSQL output parameter size limited
525 CS 794 1.04 0.95 0.86 1.04
Some aggregate functions does NOT support NULL-constant in 3-d dialect
526 SS 470 0.00 0.00 1.00 0.00
Some aggregate functions does NOT support NULL-constant in 3-d dialect
527 CS 945 1.00 0.99 1.31 0.99
Incorrect error message (column number) if the empty SQL string is prepared
528 SS 649 1.03 1.04 0.96 0.97
Incorrect error message (column number) if the empty SQL string is prepared
529 CS 1359 0.99 1.46 0.96 1.00
MERGE not correctly worked with parameters in MATCHING clause
530 SS 1209 0.90 1.09 0.83 1.10
MERGE not correctly worked with parameters in MATCHING clause
531 CS 1819 1.10 1.07 0.92 0.87
Create or Alter view
532 SS 1430 1.00 0.91 1.11 1.00
Create or Alter view
533 CS 1874 1.01 0.99 0.98 1.00
Non-privileged monitoring reports wrong attachment data
534 SS 1304 1.01 0.98 0.98 1.09
Non-privileged monitoring reports wrong attachment data
535 CS 1309 1.00 0.97 1.00 1.00
AV when recursive query used MERGE JOIN in execution plan
536 SS 1054 1.04 1.01 0.96 0.98
AV when recursive query used MERGE JOIN in execution plan
537 CS 909 0.97 1.34 0.92 1.02
Infinite row generation in "select gen_id(..) from rdb$database" with "group by"
538 SS 630 1.03 1.04 0.92 0.96
Infinite row generation in "select gen_id(..) from rdb$database" with "group by"
539 CS 614 0.96 0.99 1.00 1.04
Ability to format UUID from char(16) OCTETS to human readable form and vice versa
540 SS 404 1.01 1.06 0.98 0.98
Ability to format UUID from char(16) OCTETS to human readable form and vice versa
541 CS 650 1.00 0.86 1.01 1.00
Floor & ceiling functions give wrong results with exact numeric arguments
542 SS 440 1.02 1.00 0.95 1.00
Floor & ceiling functions give wrong results with exact numeric arguments
543 CS 1689 1.00 0.95 1.03 1.00
'There are <n> dependencies' error message shows the wrong count of dependent objects.
544 SS 1480 1.04 0.99 1.00 0.97
'There are <n> dependencies' error message shows the wrong count of dependent objects.
545 CS 1294 1.04 0.97 1.01 0.98
arithmetic exception, numeric overflow, or string truncation in utf8 tables
546 SS 1004 0.99 1.00 0.98 1.14
arithmetic exception, numeric overflow, or string truncation in utf8 tables
547 CS 844 0.99 1.01 0.97 1.00
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
548 SS 589 1.03 0.95 1.03 0.96
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
549 CS 1105 1.00 1.37 0.94 0.99
Bug in create/alter Database trigger (with Russian comment)
550 SS 824 0.98 0.99 1.00 1.03
Bug in create/alter Database trigger (with Russian comment)
551 CS 1129 1.00 1.04 1.00 0.97
Buffer overflow in conversion
552 SS 910 0.98 1.00 1.00 1.05
Buffer overflow in conversion
553 CS 1404 1.00 1.42 0.99 0.97
Incorrect "key size exceeds implementation restriction for index" error
554 SS 1179 0.98 1.01 1.11 0.84
Incorrect "key size exceeds implementation restriction for index" error
555 CS 1165 1.02 0.99 1.00 0.97
Wrong variable initialization in recursive procedures
556 SS 1290 1.27 0.72 1.44 0.72
Wrong variable initialization in recursive procedures
557 CS 789 1.00 1.00 1.01 0.92
Common table expressions cannot be used in computed columns and quantified predicates (IN / ANY / ALL)
558 SS 544 1.00 1.06 0.99 0.90
Common table expressions cannot be used in computed columns and quantified predicates (IN / ANY / ALL)
559 CS 3059 1.72 2.01 0.27 0.26
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
560 SS 4809 1.00 1.03 0.11 0.00
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan
561 CS 1374 0.89 0.95 1.04 1.36
Bug in SET DEFAULT statement
562 SS 1064 0.98 1.06 0.93 1.01
Bug in SET DEFAULT statement
563 CS 19275 1.95 1.91 0.08 0.07
Expression index can be created while doing inserts into table
564 SS 1365 26.93 0.95 0.92 1.04
Expression index can be created while doing inserts into table
565 CS 879 0.96 1.03 1.04 0.86
DDL statement with AUTODDL ON won't show statistics
566 SS 569 0.96 1.00 1.00 1.07
DDL statement with AUTODDL ON won't show statistics
567 CS 670 1.08 1.04 0.92 0.95
Include information about context variables into the monitoring tables
568 SS 449 1.02 0.97 0.95 1.06
Include information about context variables into the monitoring tables
569 CS 944 0.88 0.98 1.01 1.01
Results of a join with different collations depend on the execution plan
570 SS 705 1.02 0.97 0.93 1.07
Results of a join with different collations depend on the execution plan
571 CS 994 1.26 1.59 0.65 0.73
Support hex numeric and string literals
572 SS 530 1.98 0.77 0.79 1.20
Support hex numeric and string literals
573 CS 1184 1.01 1.00 0.99 0.84
Problem with COLLATE ES_ES_CI_AI
574 SS 959 1.02 0.97 0.93 1.65
Problem with COLLATE ES_ES_CI_AI
575 CS 739 0.97 1.16 1.02 0.97
ISQL crashes when fetching data for a column having alias longer than 30 characters
576 SS 524 0.99 0.00 0.00 1.01
ISQL crashes when fetching data for a column having alias longer than 30 characters
577 CS 965 1.06 0.95 1.00 0.99
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT
578 SS 789 0.97 1.02 1.36 0.87
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT
579 CS 1389 1.36 1.08 0.91 0.88
Consistency check when subquery is ordered by aggregate function from other context
580 SS 1095 0.96 0.90 1.03 1.11
Consistency check when subquery is ordered by aggregate function from other context
581 CS 979 0.97 1.37 0.96 1.03
AV at prepare of query with unused parametrized CTE
582 SS 809 0.86 0.96 1.03 1.17
AV at prepare of query with unused parametrized CTE
583 CS 1739 0.98 0.98 1.02 1.01
Server crashes on SQL script
584 SS 1425 1.02 0.97 0.97 1.03
Server crashes on SQL script
585 CS 1654 0.85 1.45 1.14 0.80
OLD/NEW.RDB$DB_KEY returns incorrect result in triggers
586 SS 1224 0.93 1.06 1.16 0.91
OLD/NEW.RDB$DB_KEY returns incorrect result in triggers
587 CS 1179 0.93 0.96 1.14 1.03
RDB$DB_KEY evaluates to NULL in INSERT ... RETURNING
588 SS 890 1.01 1.02 0.96 0.98
RDB$DB_KEY evaluates to NULL in INSERT ... RETURNING
589 CS 1110 0.98 1.13 1.01 0.92
Maximum key size using PXW_CSY collation
590 SS 914 0.98 1.47 1.01 0.95
Maximum key size using PXW_CSY collation
591 CS 1769 0.95 0.99 1.02 1.00
Usernames with '.' character
592 SS 1359 1.01 1.03 0.96 0.98
Usernames with '.' character
593 CS 1099 1.11 0.95 0.98 1.01
Incorrect parser's reaction to the unquoted usage of the keyword "VALUE"
594 SS 854 1.04 0.97 1.03 0.96
Incorrect parser's reaction to the unquoted usage of the keyword "VALUE"
595 CS 1215 1.12 0.99 0.98 1.00
Index is not used for some date/time expressions in dialect 1
596 SS 914 0.98 1.00 1.10 0.99
Index is not used for some date/time expressions in dialect 1
597 CS 1180 1.02 1.01 0.96 0.98
Error with ABS in dialect 1
598 SS 935 0.99 1.07 1.00 0.94
Error with ABS in dialect 1
599 CS 1379 1.02 0.97 0.97 1.04
Possible index corruption with multiply updates of the same record in the same transaction and using of savepoints
600 SS 1099 1.00 1.10 1.00 0.98
Possible index corruption with multiply updates of the same record in the same transaction and using of savepoints
601 CS 915 1.06 0.97 1.00 0.99
Procedure text is stored truncated in system tables if any variable have default value
602 SS 680 1.07 0.97 1.00 1.00
Procedure text is stored truncated in system tables if any variable have default value
603 CS 1579 0.98 1.00 0.99 1.32
AV when sorting by field, calculated using recursive CTE
604 SS 1344 1.01 0.98 0.95 1.16
AV when sorting by field, calculated using recursive CTE
605 CS 1049 1.02 1.43 0.94 0.97
If some VIEW used derived tables and long table namesliases, It is possible to overflow RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME
606 SS 875 1.01 0.96 1.18 0.98
If some VIEW used derived tables and long table namesliases, It is possible to overflow RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME
607 CS 1449 0.95 1.04 0.88 1.04
DEFAULT values are unnecessary evaluated
608 SS 1119 1.01 1.00 0.93 0.99
DEFAULT values are unnecessary evaluated
609 CS 1054 2.79 0.90 1.03 0.96
Some standard calls show server installation directory to regular users
610 SS 529 3.45 0.98 0.96 1.01
Some standard calls show server installation directory to regular users
611 CS 1409 1.08 1.17 0.91 0.90
Allow index walk (ORDER plan) when there is a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B
612 SS 1145 1.09 0.98 0.96 1.01
Allow index walk (ORDER plan) when there is a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B
613 CS 1135 1.17 1.00 0.99 0.98
Arithmetic overflow or division by zero has occurred. in MAX function
614 SS 879 0.98 0.93 1.38 1.01
Arithmetic overflow or division by zero has occurred. in MAX function
615 CS 1680 2.11 0.95 1.03 0.96
BLR error on restore database with computed by Field
616 SS 1294 2.18 0.97 1.01 0.98
BLR error on restore database with computed by Field
617 CS 2049 0.98 0.97 1.01 1.06
Roles granting/revoking logic
618 SS 1589 1.03 1.00 0.62 1.00
Roles granting/revoking logic
619 CS 1159 0.97 1.16 1.02 0.88
Error on script with current_date
620 SS 844 1.00 0.95 0.99 1.03
Error on script with current_date
621 CS 789 0.00 1.17 1.00 0.93
CREATE COLLATION connection lost under Posix
622 SS 590 0.00 0.93 1.16 1.00
CREATE COLLATION connection lost under Posix
623 CS 1299 1.03 1.00 1.00 0.93
SHOW VIEW shows non-sense information for view fields with expressions
624 SS 1364 1.21 0.73 1.39 0.78
SHOW VIEW shows non-sense information for view fields with expressions
625 CS 1470 1.00 1.06 1.00 0.95
Circular dependencies between computed fields crashs the engine
626 SS 1279 0.95 1.04 1.32 0.78
Circular dependencies between computed fields crashs the engine
627 CS 1639 0.96 1.12 0.90 1.03
Dropping and adding a domain constraint in the same transaction leaves incorrect dependencies
628 SS 1120 0.89 0.99 1.00 1.01
Dropping and adding a domain constraint in the same transaction leaves incorrect dependencies
629 CS 1269 0.99 1.55 0.96 1.00
Not valid fields in MERGE's insert clause are allowed
630 SS 1009 1.00 1.06 1.00 0.98
Not valid fields in MERGE's insert clause are allowed
631 CS 889 0.78 1.12 1.10 0.89
MON$DATABASE returns outdated transaction counters
632 SS 504 0.83 0.77 1.16 1.32
MON$DATABASE returns outdated transaction counters
633 CS 1299 1.01 1.24 0.96 0.98
Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled
634 SS 960 1.01 0.98 0.94 1.01
Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled
635 CS 799 0.94 0.98 1.01 1.05
SIMILAR TO character classes are incorrectly recognized
636 SS 569 1.00 0.92 0.00 1.00
SIMILAR TO character classes are incorrectly recognized
637 CS 609 1.08 0.95 0.95 1.05
The log(base, number) built-in function doesn't check parameters and delivers NAN values instead.
638 SS 419 1.05 1.00 0.97 1.00
The log(base, number) built-in function doesn't check parameters and delivers NAN values instead.
639 CS 665 1.06 0.90 0.97 1.02
GROUP BY RAND() returns infinite rows
640 SS 400 2.44 0.95 1.00 1.00
GROUP BY RAND() returns infinite rows
641 CS 1609 1.00 0.92 0.99 1.06
Custom attribute for collation to sort numbers in numeric order
642 SS 1365 0.98 1.01 1.20 0.98
Custom attribute for collation to sort numbers in numeric order
643 CS 1725 0.99 0.99 1.03 1.00
Bugcheck 291
644 SS 1489 1.22 0.94 0.96 1.04
Bugcheck 291
645 CS 799 1.02 0.98 0.96 1.01
Incorrect extraction of MILLISECONDs
646 SS 539 1.01 0.98 0.98 1.07
Incorrect extraction of MILLISECONDs
647 CS 1100 0.99 0.90 1.00 1.28
Set the fixed and documented check order for WHERE clause and other conditional sentences
648 SS 905 1.01 1.01 0.98 0.98
Set the fixed and documented check order for WHERE clause and other conditional sentences
649 CS 979 0.98 0.97 1.03 1.01
Non-SYSDBA user can change FW mode of database.
650 SS 579 1.05 1.00 0.98 1.00
Non-SYSDBA user can change FW mode of database.
651 CS 1120 1.08 1.00 0.98 0.99
Altering domains name drops dependencies using the domain
652 SS 834 1.04 0.95 1.01 0.98
Altering domains name drops dependencies using the domain
653 CS 3055 1.53 1.00 0.99 0.99
UTF8 UNICODE_CI collate can?t be used in foreing key constraint
654 SS 2694 1.02 0.94 0.99 1.00
UTF8 UNICODE_CI collate can?t be used in foreing key constraint
655 CS 1119 1.02 0.97 0.96 1.08
bad BLR -- invalid stream for union select
656 SS 939 0.92 1.04 0.95 1.64
bad BLR -- invalid stream for union select
657 CS 1684 0.99 1.00 0.99 1.02
Broken foreign key handling for multi-segmented index using multi-level collations
658 SS 1474 0.91 1.05 1.04 0.95
Broken foreign key handling for multi-segmented index using multi-level collations
659 CS 620 0.99 1.28 1.00 1.00
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user
660 SS 409 1.07 0.97 1.02 0.92
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user
661 CS 1104 3.19 0.94 0.96 1.03
ALTER USER XXX INACTIVE
662 SS 874 3.12 1.00 0.99 0.90
ALTER USER XXX INACTIVE
663 CS 1639 1.01 0.98 0.61 1.07
Support SQL 2008 syntax for MERGE statement with DELETE extension
664 SS 1510 1.01 0.94 2.31 0.98
Support SQL 2008 syntax for MERGE statement with DELETE extension
665 CS 799 0.92 0.94 1.05 1.07
SUBSTRING with regular expression (SIMILAR TO) capability
666 SS 549 1.03 0.92 0.96 1.09
SUBSTRING with regular expression (SIMILAR TO) capability
667 CS 1069 0.93 0.99 1.47 1.00
NOT NULL procedure parameters
668 SS 740 1.00 1.00 1.00 1.02
NOT NULL procedure parameters
669 CS 5634 0.99 1.00 0.98 1.05
I/O statistics for stored procedures are not accounted in monitoring tables
670 SS 5549 0.98 0.96 1.01 1.05
I/O statistics for stored procedures are not accounted in monitoring tables
671 CS 2049 1.01 1.10 0.98 0.93
Only one client can access a readonly database
672 SS 954 0.98 1.01 0.92 1.04
Only one client can access a readonly database
673 CS 1154 0.99 0.93 1.05 1.00
UTF-8 conversion error (string truncation)
674 SS 934 1.00 0.99 0.95 1.01
UTF-8 conversion error (string truncation)
675 CS 695 1.00 0.93 0.99 1.05
"EXECUTE BLOCK" statement does not support "CREATE USER"
676 SS 480 1.00 0.93 1.00 1.06
"EXECUTE BLOCK" statement does not support "CREATE USER"
677 CS 1445 1.02 0.96 1.07 0.97
Problem with a read-only marked database
678 SS 1105 1.02 1.04 0.97 0.95
Problem with a read-only marked database
679 CS 989 0.98 1.02 0.92 1.02
Incorrect buffer size for ORDER BY expression with system fields
680 SS 769 0.00 0.96 1.26 1.00
Incorrect buffer size for ORDER BY expression with system fields
681 CS 1149 1.01 0.87 1.10 0.98
Null in the first record in a condition on rdb$db_key
682 SS 1004 0.92 0.94 1.13 1.05
Null in the first record in a condition on rdb$db_key
683 CS 1695 1.00 1.11 0.99 0.94
Stored procedure recursively called by calculated field fails after reconnect
684 SS 1434 0.99 1.01 1.42 0.91
Stored procedure recursively called by calculated field fails after reconnect
685 CS 735 0.99 1.08 0.95 1.00
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT
686 SS 529 1.15 0.96 0.98 1.01
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT
687 CS 685 0.96 1.10 1.03 0.91
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining
688 SS 409 1.05 1.02 0.92 0.97
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining
689 CS 1185 0.99 1.00 0.85 1.02
Domain-level CHECK constraints wrongly process NULL values
690 SS 824 1.00 1.79 0.92 0.99
Domain-level CHECK constraints wrongly process NULL values
691 CS 1539 1.00 1.00 1.05 0.95
update or insert with gen_id() with wrong generator value
692 SS 1209 0.98 1.06 0.97 1.01
update or insert with gen_id() with wrong generator value
693 CS 1280 0.87 1.37 0.91 1.08
connection lost to database when used AUTONOMOUS TRANSACTION
694 SS 1029 0.96 0.88 1.16 1.03
connection lost to database when used AUTONOMOUS TRANSACTION
695 CS 1339 1.02 0.96 0.97 1.47
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
696 SS 1049 0.99 1.00 0.96 1.04
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
697 CS 1594 0.99 1.12 0.95 1.01
don't work subquery in COALESCE
698 SS 1340 1.04 0.93 1.03 0.96
don't work subquery in COALESCE
699 CS 1430 0.96 1.06 1.03 0.96
Computed expressions may be optimized badly if used inside the RETURNING clause of the INSERT statement
700 SS 1149 1.02 1.00 0.93 1.00
Computed expressions may be optimized badly if used inside the RETURNING clause of the INSERT statement
701 CS 1254 1.09 1.09 0.84 0.90
ALTER VIEW WITH CHECK OPTION crashes the engin
702 SS 975 1.01 1.10 0.98 0.88
ALTER VIEW WITH CHECK OPTION crashes the engin
703 CS 1179 0.95 1.04 0.88 1.08
GROUP by and RDB$DB_KEY problems
704 SS 920 1.00 1.00 1.18 0.89
GROUP by and RDB$DB_KEY problems
705 CS 1139 1.05 1.14 0.91 0.94
Comparision with IN and subquery with RDB$DB_KEY returns wrong result
706 SS 899 0.97 1.02 1.07 0.95
Comparision with IN and subquery with RDB$DB_KEY returns wrong result
707 CS 1319 0.97 1.49 0.75 1.02
Incorrect VIEW expansion when RDB$DB_KEY is used in view body
708 SS 1054 1.02 1.01 0.98 0.94
Incorrect VIEW expansion when RDB$DB_KEY is used in view body
709 CS 1359 1.01 0.96 0.98 1.02
Expression indexes bug: incorrect result for the inverted boolean
710 SS 1305 0.83 0.87 1.12 1.37
Expression indexes bug: incorrect result for the inverted boolean
711 CS 1499 1.02 0.95 0.98 1.01
Parts of RDB$DB_KEY of views may be inverted when using outer joins
712 SS 1209 1.04 0.96 0.97 1.02
Parts of RDB$DB_KEY of views may be inverted when using outer joins
713 CS 1274 0.97 1.05 1.01 0.98
Suboptimal join plan if there are selective non-indexed predicates involved
714 SS 1130 1.07 1.01 0.98 0.97
Suboptimal join plan if there are selective non-indexed predicates involved
715 CS 694 1.12 1.05 0.93 0.95
RDB$DB_KEY in subselect expression incorrectly returns NULL
716 SS 414 1.03 1.11 0.96 0.96
RDB$DB_KEY in subselect expression incorrectly returns NULL
717 CS 1589 1.39 0.98 0.88 1.01
View over global temporary table
718 SS 1185 1.02 0.84 0.97 1.02
View over global temporary table
719 CS 1254 0.98 1.03 1.01 0.98
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor
720 SS 999 1.02 0.98 0.98 1.23
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor
721 CS 770 3.55 1.24 0.72 0.75
Query plan is missing for the long query
722 SS 410 6.00 0.97 1.02 0.92
Query plan is missing for the long query
723 CS 1229 0.81 1.44 0.95 1.04
Incorrect ROW_COUNT value with indexed retrieval and subquery
724 SS 1039 0.94 1.01 1.24 0.98
Incorrect ROW_COUNT value with indexed retrieval and subquery
725 CS 1644 0.60 1.16 0.99 1.00
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
726 SS 1484 1.05 0.90 1.05 0.95
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record
727 CS 1484 0.67 1.13 0.97 1.03
Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate
728 SS 1230 0.99 0.95 1.33 1.00
Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate
729 CS 724 0.99 0.85 1.02 1.00
Error messages after parameters substitution contains '8' characters instead of line break
730 SS 419 1.00 0.88 1.00 1.00
Error messages after parameters substitution contains '8' characters instead of line break
731 CS 634 0.97 1.02 1.02 0.96
SIMILAR TO predicate hangs with "|" option
732 SS 409 1.02 1.00 1.00 0.97
SIMILAR TO predicate hangs with "|" option
733 CS 1384 0.98 0.97 1.04 1.01
Join of SP with view or table may fail with "No current record for fetch operation"
734 SS 1135 1.03 1.12 0.88 0.96
Join of SP with view or table may fail with "No current record for fetch operation"
735 CS 2709 1.05 0.96 0.96 1.03
error in operator "and" in as clausule where
736 SS 2479 0.97 0.80 1.03 1.02
error in operator "and" in as clausule where
737 CS 1024 1.07 1.02 0.97 0.97
Unexpected (wrong) results with COALESCE and GROUP BY
738 SS 889 0.98 1.01 1.31 0.97
Unexpected (wrong) results with COALESCE and GROUP BY
739 CS 2080 1.11 1.07 0.92 0.73
Add support for -nodbtriggers switch in gbak into services API
740 SS 1539 1.24 0.87 1.13 0.85
Add support for -nodbtriggers switch in gbak into services API
741 CS 1429 0.98 1.01 1.10 0.97
Extremely slow executing a cross join of 3 tables in Firebird 2.X
742 SS 1349 1.00 1.00 1.14 0.97
Extremely slow executing a cross join of 3 tables in Firebird 2.X
743 CS 1650 0.97 1.04 0.98 1.01
RDB$VIEW_RELATIONS is not cleaned when altering a view
744 SS 1459 0.68 1.03 1.16 0.96
RDB$VIEW_RELATIONS is not cleaned when altering a view
745 CS 1134 0.98 1.11 1.01 0.88
constraints on sp output parameters are checked even when the sp returns zero rows
746 SS 909 0.96 0.90 1.10 1.03
constraints on sp output parameters are checked even when the sp returns zero rows
747 CS 2000 1.61 0.93 0.95 1.05
New gbak option to ignore specific tables data during the backup
748 SS 1755 1.67 0.96 1.03 0.94
New gbak option to ignore specific tables data during the backup
749 CS 16044 0.99 0.97 1.04 1.00
Offset value for SUBSTRING from BLOB more than 32767 makes exception
750 SS 18385 0.88 0.96 1.11 1.03
Offset value for SUBSTRING from BLOB more than 32767 makes exception
751 CS 1265 0.94 0.90 1.05 1.05
GROUP BY concatenation with empty string
752 SS 1049 0.96 1.03 1.18 0.89
GROUP BY concatenation with empty string
753 CS 619 0.98 1.13 0.98 1.01
Problem with column names with Accents and triggers
754 SS 410 1.00 1.02 1.00 0.97
Problem with column names with Accents and triggers
755 CS 909 0.95 1.02 0.97 1.27
Implement domain check of input parameters of execute block
756 SS 609 1.88 1.00 1.00 1.00
Implement domain check of input parameters of execute block
757 CS 1859 1.00 1.38 0.90 1.00
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
758 SS 965 0.98 0.95 1.08 1.01
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well
759 CS 1180 1.03 1.15 0.96 0.84
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.
760 SS 889 1.01 0.98 1.07 0.96
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.
761 CS 784 2.81 0.99 1.00 0.99
gbak doesn't return error code
762 SS 545 2.12 0.99 0.88 1.00
gbak doesn't return error code
763 CS 754 1.01 0.00 0.00 0.98
EXECUTE STATEMENT on EXTERNAL SOURCE does not check the status of the transaction
764 SS 460 1.02 0.97 1.10 0.97
EXECUTE STATEMENT on EXTERNAL SOURCE does not check the status of the transaction
765 CS 1349 1.00 1.11 1.00 0.96
'...exception...string right truncation' when alter view with join
766 SS 1215 0.85 1.15 1.01 0.98
'...exception...string right truncation' when alter view with join
767 CS 994 1.05 1.14 0.94 0.85
internal Firebird consistency check when alter dependent procedures
768 SS 784 0.86 1.09 1.08 0.91
internal Firebird consistency check when alter dependent procedures
769 CS 649 0.93 0.96 1.03 1.57
internal error when select upper(<blob>) from union
770 SS 399 0.97 1.00 1.32 1.00
internal error when select upper(<blob>) from union
771 CS 914 0.93 1.04 0.98 1.01
ALTER DOMAIN with dependencies may leave a transaction handle in inconsistent state causing segmentation faults
772 SS 690 0.98 1.01 0.95 1.05
ALTER DOMAIN with dependencies may leave a transaction handle in inconsistent state causing segmentation faults
773 CS 1149 1.34 1.01 0.98 0.97
Grouping by function doesn't work properly
774 SS 939 0.95 1.10 0.99 1.01
Grouping by function doesn't work properly
775 CS 735 0.99 1.04 1.00 0.96
GFIX causes BUGCHECK errors with non valid transaction numbers
776 SS 430 0.97 0.97 1.02 1.02
GFIX causes BUGCHECK errors with non valid transaction numbers
777 CS 1425 1.03 1.02 0.91 0.97
Records left in RDB$PAGES after rollback of CREATE TABLE statement
778 SS 1175 0.98 0.99 1.00 1.01
Records left in RDB$PAGES after rollback of CREATE TABLE statement
779 CS 1524 0.96 1.60 0.97 1.02
Wrong (primary) constraint name is reported for the foreign key violation during FK creation
780 SS 1309 0.98 1.01 1.25 0.94
Wrong (primary) constraint name is reported for the foreign key violation during FK creation
781 CS 1259 1.01 0.88 1.03 0.98
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
782 SS 1100 1.29 0.96 0.90 1.03
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)
783 CS 1309 0.99 1.07 1.00 1.00
Wrong dependent object type (RELATION) in RDB$DEPEDENCIES for VIEW's
784 SS 1084 1.01 1.70 0.95 0.98
Wrong dependent object type (RELATION) in RDB$DEPEDENCIES for VIEW's
785 CS 999 1.03 0.98 0.90 1.02
Unexpected error "arithmetic exception, numeric overflow, or string truncation" while evaluating SUBSTRING the second time
786 SS 749 0.97 1.01 1.08 0.98
Unexpected error "arithmetic exception, numeric overflow, or string truncation" while evaluating SUBSTRING the second time
787 CS 804 0.98 1.01 0.89 1.03
Include PLAN in mon$statements
788 SS 529 1.70 0.98 0.96 1.01
Include PLAN in mon$statements
789 CS 1519 0.95 1.15 1.00 1.00
Make mon$statement_id value constant among monitoring snapshots
790 SS 1024 0.96 1.02 0.97 1.13
Make mon$statement_id value constant among monitoring snapshots
791 CS 844 2.55 1.02 0.82 0.97
Incomplete API information values
792 SS 504 3.66 0.95 1.02 0.97
Incomplete API information values
793 CS 974 1.09 0.96 0.96 1.03
SIMILAR TO produces random results with [x-y] expressions
794 SS 764 1.00 0.96 0.99 1.09
SIMILAR TO produces random results with [x-y] expressions
795 CS 1140 1.01 1.04 0.96 0.98
Firebird float support does not conform to Interbase spec
796 SS 929 0.94 0.95 1.20 1.04
Firebird float support does not conform to Interbase spec
797 CS 1730 1.00 1.22 0.97 0.99
select * from (select cast(.... returns null
798 SS 1499 0.93 0.98 1.05 1.02
select * from (select cast(.... returns null
799 CS 804 0.99 1.00 1.05 0.99
ALTER DOMAIN invalid RDB$FIELD_SUB_TYPE
800 SS 609 0.96 1.03 1.13 0.95
ALTER DOMAIN invalid RDB$FIELD_SUB_TYPE
801 CS 709 0.95 0.87 1.04 1.17
Incorrect result for the derived expression based on aggregate and computation
802 SS 415 0.96 1.03 1.15 0.96
Incorrect result for the derived expression based on aggregate and computation
803 CS 589 1.01 1.13 0.94 0.98
Hidden variables conflict with output parameters, causing assertions, unexpected errors or possibly incorrect results
804 SS 385 1.06 1.03 0.96 0.95
Hidden variables conflict with output parameters, causing assertions, unexpected errors or possibly incorrect results
805 CS 1350 0.87 1.12 1.40 0.82
Too long column name for select alias should be rejected
806 SS 985 0.92 1.01 1.19 0.98
Too long column name for select alias should be rejected
807 CS 679 0.97 0.00 1.00 1.04
Incorrect handling of LOWER/UPPER when result string shrinks in terms of byte length
808 SS 429 0.00 1.04 0.93 1.00
Incorrect handling of LOWER/UPPER when result string shrinks in terms of byte length
809 CS 1094 1.01 0.96 1.05 0.98
Logical multibyte maximum string length is not respected when assigning numbers
810 SS 849 1.00 1.00 0.98 1.08
Logical multibyte maximum string length is not respected when assigning numbers
811 CS 1154 1.00 1.29 0.97 0.99
String truncation reading 8859-1 Spanish column using isc_dsql_fetch with UTF-8 connection..
812 SS 839 1.14 1.00 1.00 0.97
String truncation reading 8859-1 Spanish column using isc_dsql_fetch with UTF-8 connection..
813 CS 804 1.13 1.05 0.89 0.94
ALTER TRIGGER / PROCEDURE wrong error message
814 SS 549 1.00 0.94 1.14 1.00
ALTER TRIGGER / PROCEDURE wrong error message
815 CS 1309 1.02 1.00 0.96 1.00
ALTER VIEW could remove column used in stored procedure or trigger
816 SS 1070 1.00 1.00 1.08 0.96
ALTER VIEW could remove column used in stored procedure or trigger
817 CS 620 1.01 0.98 1.09 0.95
Wrong matching of SIMILAR TO expression with brackets
818 SS 380 1.00 0.97 1.07 1.00
Wrong matching of SIMILAR TO expression with brackets
819 CS 1424 0.96 0.99 1.09 1.00
If you drop two different indexes within the same transaction, you get database corruption
820 SS 1135 0.98 0.99 1.00 1.07
If you drop two different indexes within the same transaction, you get database corruption
821 CS 2234 2.19 1.20 0.74 0.79
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
822 SS 1459 2.92 0.68 0.98 1.01
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags
823 CS 645 1.02 1.10 0.95 0.97
AV preparing a query with aggregate over derived table
824 SS 420 1.07 0.97 1.00 1.00
AV preparing a query with aggregate over derived table
825 CS 1409 0.97 1.18 0.92 1.02
Parsing error in EXECUTE STATEMENT with named parameters
826 SS 1184 1.02 1.01 0.92 0.98
Parsing error in EXECUTE STATEMENT with named parameters
827 CS 1260 0.90 1.13 0.88 1.09
Make CREATE VIEW infer column names for views involving a GROUP BY clause or derived table
828 SS 1109 1.08 0.90 1.07 0.92
Make CREATE VIEW infer column names for views involving a GROUP BY clause or derived table
829 CS 1484 0.97 1.15 0.97 1.02
Alter table not respecting collation
830 SS 1289 0.77 1.00 1.27 0.99
Alter table not respecting collation
831 CS 1334 0.95 1.52 0.99 1.00
ALTER VIEW doesn't clear dependencies on old views
832 SS 1114 1.00 0.99 1.15 0.89
ALTER VIEW doesn't clear dependencies on old views
833 CS 1400 1.03 0.96 0.80 1.03
Server adds "NOT" at the end of default value for the TIMESTAMP field
834 SS 994 0.97 0.98 1.09 1.01
Server adds "NOT" at the end of default value for the TIMESTAMP field
835 CS 955 0.98 1.01 1.23 0.93
String values in error messages are not converted to connection charset
836 SS 715 1.00 1.02 0.99 0.95
String values in error messages are not converted to connection charset
837 CS 789 0.97 1.10 1.02 0.97
CREATE USER command: Invalid error message
838 SS 529 1.00 0.00 1.00 0.00
CREATE USER command: Invalid error message
839 CS 1159 1.00 1.00 0.90 1.03
Server crashes on UPDATE OR INSERT statement
840 SS 889 1.06 1.01 0.98 0.94
Server crashes on UPDATE OR INSERT statement
841 CS 1139 0.99 0.96 1.01 1.00
Query SELECT ... WHERE ... IN (SELECT DISTINCT ... ) returns a wrong result set.
842 SS 919 1.02 1.03 0.97 0.96
Query SELECT ... WHERE ... IN (SELECT DISTINCT ... ) returns a wrong result set.
843 CS 1419 1.00 1.00 1.00 0.90
Server fails when doing DROP DATABASE right after error in statistical fnction
844 SS 1210 1.01 0.98 0.92 1.01
Server fails when doing DROP DATABASE right after error in statistical fnction
845 CS 1235 1.03 0.93 1.00 0.99
UNICODE_CI internal gds software consistency check
846 SS 965 1.21 1.01 0.93 0.98
UNICODE_CI internal gds software consistency check
847 CS 1129 0.97 1.02 0.96 1.04
External table data not visible to other sessions in Classic
848 SS 850 1.01 0.98 1.23 0.91
External table data not visible to other sessions in Classic
849 CS 1590 5.87 1.01 0.97 0.98
mon$memory_usage: Sorting memory should be reported as owned by the statement
850 SS 1214 7.80 1.00 0.99 0.97
mon$memory_usage: Sorting memory should be reported as owned by the statement
851 CS 659 1.03 1.07 0.96 0.92
Success message when connecting to tiny trash database file
852 SS 399 1.00 0.92 1.00 1.02
Success message when connecting to tiny trash database file
853 CS 1160 1.11 0.97 1.00
Append the IP address of the remote host to error messages in firebird.log for TCP connections
854 SS 970 0.92 1.00 1.00
Append the IP address of the remote host to error messages in firebird.log for TCP connections
855 CS 1364 0.98 1.01 0.98 1.08
Implementation limit of DISTINCT items are not enforced, causing generation of incorrect BLR
856 SS 1069 1.00 0.99 0.93 1.17
Implementation limit of DISTINCT items are not enforced, causing generation of incorrect BLR
857 CS 679 0.97 1.11 0.89 1.02
Binary shift functions give wrong results with negative shift values
858 SS 409 1.07 1.00 1.00 1.00
Binary shift functions give wrong results with negative shift values
859 CS 654 1.16 1.02 0.91 0.97
Built-in trigonometric functions can produce NaN and Infinity
860 SS 409 1.09 0.97 0.95 1.02
Built-in trigonometric functions can produce NaN and Infinity
861 CS 1279 0.89 1.08 1.34 0.91
Tricky index names can defeat the parsing logic when generating a human readable plan
862 SS 954 1.15 0.91 1.08 0.91
Tricky index names can defeat the parsing logic when generating a human readable plan
863 CS 944 1.01 1.13 0.95 0.98
Wrong processing a SP parameters with arrays
864 SS 670 0.99 1.00 1.10 1.00
Wrong processing a SP parameters with arrays
865 CS 2599 1.01 1.21 0.98 0.98
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
866 SS 2499 0.97 0.95 1.03 1.02
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables
867 CS 1060 0.94 1.05 0.92 1.66
PSQL doesnt allow to use singleton query result as input parameter of stored procedure when procedure accessed using 'execute procedure'
868 SS 764 1.09 0.96 1.03 0.94
PSQL doesnt allow to use singleton query result as input parameter of stored procedure when procedure accessed using 'execute procedure'
869 CS 1674 1.32 0.93 0.59 1.06
CI column does not group correctly with a second column
870 SS 1279 0.78 1.00 1.06 1.00
CI column does not group correctly with a second column
871 CS 660 0.00 1.00 0.95 1.07
Maximum and minimum identifier length should be enforced by DSQL
872 SS 430 1.02 1.09 0.92 0.97
Maximum and minimum identifier length should be enforced by DSQL
873 CS 1399 0.92 1.02 0.97 1.45
internal error [335544384]
874 SS 1215 1.07 1.00 0.91 0.99
internal error [335544384]
875 CS 859 1.01 0.95 1.00 1.00
The server crashes when selecting from the MON$ tables in the ON DISCONNECT trigger
876 SS 619 1.00 0.96 1.01 1.00
The server crashes when selecting from the MON$ tables in the ON DISCONNECT trigger
877 CS 1579 1.13 0.93 1.05 0.94
select rdb$db_key from a view with a more than 1 table joined, results in conversion error
878 SS 1000 1.00 1.00 1.25 1.00
select rdb$db_key from a view with a more than 1 table joined, results in conversion error
879 CS 874 1.07 0.98 0.97 1.01
Parameters and variables cannot be used as expressions in EXECUTE PROCEDURE parameters without a colon prefix
880 SS 659 0.92 1.00 1.00 1.00
Parameters and variables cannot be used as expressions in EXECUTE PROCEDURE parameters without a colon prefix
881 CS 654 1.05 0.94 1.23 0.93
Infinity should not escape from the engine
882 SS 415 0.98 1.01 0.98 1.03
Infinity should not escape from the engine
883 CS 1119 1.07 0.96 0.95 1.03
Infinity from UDF should be trapped by the engine
884 SS 810 1.01 1.13 0.94 0.98
Infinity from UDF should be trapped by the engine
885 CS 1044 0.97 1.01 0.98 1.07
Wrong results for CASE used together with GROUP BY
886 SS 835 1.04 0.95 0.90 1.08
Wrong results for CASE used together with GROUP BY
887 CS 1160 1.05 0.96 1.03 0.93
Attachments using NONE charset may cause reads from MON$ tables to fail
888 SS 604 1.00 1.02 0.99 0.99
Attachments using NONE charset may cause reads from MON$ tables to fail
889 CS 975 1.09 1.08 0.86 0.91
Multibyte CHAR value requested as VARCHAR is returned with padded spaces
890 SS 635 0.99 0.95 1.00 1.11
Multibyte CHAR value requested as VARCHAR is returned with padded spaces
891 CS 739 1.00 1.18 0.94 1.00
Introducer (_charset) problems with monitoring and persistent modules
892 SS 459 1.00 1.00 1.00 0.95
Introducer (_charset) problems with monitoring and persistent modules
893 CS 939 1.17 1.00 1.00 1.00
Connection lost immediatelly after compiling procedure with RPAD system function
894 SS 930 1.37 0.00 1.00 0.75
Connection lost immediatelly after compiling procedure with RPAD system function
895 CS 1134 1.02 1.09 0.93 0.97
Silent truncation when using utf8 parameters and utf8 client character set encoding
896 SS 929 0.89 1.07 1.16 0.92
Silent truncation when using utf8 parameters and utf8 client character set encoding
897 CS 620 1.01 1.09 0.93 0.98
Invalid BLOB ID when working with monitoring tables
898 SS 420 0.95 1.02 1.04 0.97
Invalid BLOB ID when working with monitoring tables
899 CS 1254 1.01 0.98 0.87 1.02
SELECT WITH LOCK with no fields are accessed clears the data
900 SS 974 1.03 0.99 1.00 0.94
SELECT WITH LOCK with no fields are accessed clears the data
901 CS 7229 0.96 1.02 0.97 1.03
Unique index with a lot of NULL keys can be corrupted at level 1
902 SS 6939 1.00 0.95 1.01 0.99
Unique index with a lot of NULL keys can be corrupted at level 1
903 CS 1319 0.98 1.01 1.30 0.89
Incorrect "string right truncation" error with NONE column and multibyte connection charset
904 SS 925 0.98 0.99 1.08 1.00
Incorrect "string right truncation" error with NONE column and multibyte connection charset
905 CS 645 1.00 0.96 1.14 0.99
COUNT(*) incorrectly returns 0 when a condition of an outer join doesn't match
906 SS 414 1.03 1.11 0.96 0.96
COUNT(*) incorrectly returns 0 when a condition of an outer join doesn't match
907 CS 635 11.02 1.00 0.99 0.92
Write note into log when automatic sweep is started
908 SS 424 18.67 1.01 0.96 0.98
Write note into log when automatic sweep is started
909 CS 1929 0.78 1.16 1.19 0.83
Full outer join cannot use available indices (very slow execution)
910 SS 1264 1.02 0.97 1.32 0.96
Full outer join cannot use available indices (very slow execution)
911 CS 1789 0.99 0.98 1.00 1.06
System triggers on view with check option are not removed
912 SS 1679 1.00 1.00 0.94 1.07
System triggers on view with check option are not removed
913 CS 1320 0.99 1.50 0.96 1.00
Support the "? in (SELECT some_col FROM some_table)" subqueries
914 SS 1064 1.16 0.98 1.01 0.96
Support the "? in (SELECT some_col FROM some_table)" subqueries
915 CS 784 1.03 1.09 0.96 0.96
Common table expression context could be used with parameters
916 SS 529 0.00 0.98 1.00 1.00
Common table expression context could be used with parameters
917 CS 1234 1.05 0.94 0.94 1.11
Do not print "invalid request BLR" for par.cpp errors with valid BLR
918 SS 930 0.94 0.96 1.16 1.03
Do not print "invalid request BLR" for par.cpp errors with valid BLR
919 CS 630 1.04 1.17 0.93 0.95
Wrong evaluation result with divide and unary plus\minus operations
920 SS 415 0.96 0.96 1.03 1.03
Wrong evaluation result with divide and unary plus\minus operations
921 CS 1034 1.01 1.26 0.93 0.98
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
922 SS 769 1.01 0.96 0.98 1.03
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)
923 CS 1175 1.01 0.98 0.94 1.03
Storage of malformed blob is allowed when copying from a blob with NONE/OCTETS charset
924 SS 984 0.95 1.00 1.01 0.99
Storage of malformed blob is allowed when copying from a blob with NONE/OCTETS charset
925 CS 1674 2.30 1.02 0.93 0.97
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
926 SS 1424 2.50 0.94 0.95 1.04
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings
927 CS 1354 0.95 1.05 0.89 1.04
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
928 SS 809 1.06 0.95 1.04 0.93
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment
929 CS 7980 0.95 1.13 1.00 0.99
Recursive EXECUTE STATEMENT works wrong
930 SS 2465 0.98 0.99 1.03 1.00
Recursive EXECUTE STATEMENT works wrong
931 CS 1280 0.96 1.11 1.03 0.93
isql hangs when trying to show a view based on a procedure
932 SS 1039 0.96 0.90 1.06 1.03
isql hangs when trying to show a view based on a procedure
933 CS 959 0.97 1.13 1.02 0.94
Naive metadata extraction code in isql is defeated by "check" keyword typed in mixed case
934 SS 749 0.98 0.96 1.09 1.01
Naive metadata extraction code in isql is defeated by "check" keyword typed in mixed case
935 CS 685 1.02 0.93 0.97 1.03
SIMILAR TO works wrongly
936 SS 425 0.98 0.96 1.01 1.03
SIMILAR TO works wrongly
937 CS 764 0.00 1.07 0.00 0.92
substring from timestamp - unexpected result
938 SS 514 1.00 1.10 0.99 0.95
substring from timestamp - unexpected result
939 CS 2129 0.98 1.04 1.01 0.98
Use of RDB$ADMIN role does not provide SYSDBA rights in GRANT/REVOKE
940 SS 1649 1.06 0.97 0.98 1.01
Use of RDB$ADMIN role does not provide SYSDBA rights in GRANT/REVOKE
941 CS 1739 0.97 1.10 0.98 1.01
Error "page 0 is of wrong type (expected 6, found 1)" is thrown while accessing a non-corrupted table
942 SS 1684 1.27 0.97 1.02 0.97
Error "page 0 is of wrong type (expected 6, found 1)" is thrown while accessing a non-corrupted table
943 CS 1529 1.15 0.96 1.01 0.98
ALTERING OR DROPPING PROCEDURE which has type of domain parameter leads to attempt to delete that domain
944 SS 1374 1.01 0.94 0.98 1.08
ALTERING OR DROPPING PROCEDURE which has type of domain parameter leads to attempt to delete that domain
945 CS 630 1.01 1.06 0.98 0.95
Include client library version and protocol version in mon$attachments
946 SS 465 0.88 1.35 0.96 1.03
Include client library version and protocol version in mon$attachments
947 CS 644 1.03 0.97 1.02 0.94
AV using recursive query as subquery in SELECT list and ORDER'ing by them
948 SS 429 0.00 1.00 1.23 0.97
AV using recursive query as subquery in SELECT list and ORDER'ing by them
949 CS 649 0.95 1.09 0.93 1.04
Make rdb$system_flag not null
950 SS 420 1.14 0.92 0.97 1.02
Make rdb$system_flag not null
951 CS 604 4.76 1.00 0.99 0.99
isql extracts the array dimensions after the character set name
952 SS 429 5.80 0.93 1.02 0.97
isql extracts the array dimensions after the character set name
953 CS 1090 1.04 0.99 0.96 1.00
DB_KEY is always zero for external tables
954 SS 869 1.01 1.00 1.00 0.94
DB_KEY is always zero for external tables
955 CS 1339 0.97 0.98 1.05 1.01
Problem with default value of SP parameter
956 SS 1059 1.03 0.98 0.97 1.01
Problem with default value of SP parameter
957 CS 1404 0.97 1.33 1.02 0.71
Incomplete plan output (lack of view names) when selecting from views containing procedures inside
958 SS 1145 0.97 0.96 1.16 1.02
Incomplete plan output (lack of view names) when selecting from views containing procedures inside
959 CS 1294 1.00 1.11 0.94 0.99
Changing sort directon in delete statement cause deletion of all records in table
960 SS 1054 1.05 1.03 0.95 0.96
Changing sort directon in delete statement cause deletion of all records in table
961 CS 849 1.01 1.03 0.94 0.98
Problems with COMMENT ON and strings using introducer (charset)
962 SS 594 1.01 1.10 0.99 0.99
Problems with COMMENT ON and strings using introducer (charset)
963 CS 1155 0.97 1.04 0.95 1.02
Views based on procedures can't be created if the proc's output fields participate in an expression
964 SS 989 1.01 0.98 0.96 5.65
Views based on procedures can't be created if the proc's output fields participate in an expression
965 CS 1200 1.02 1.09 0.97 0.96
Unsuccessful execution' error when updating a record
966 SS 985 1.00 0.99 1.03 0.97
Unsuccessful execution' error when updating a record
967 CS 1799 1.00 0.99 0.94 1.00
Prohibit any improper mixture of explicit and implicit joins
968 SS 1684 0.94 1.05 1.74 0.93
Prohibit any improper mixture of explicit and implicit joins
969 CS 7960 0.95 0.99 1.02 1.00
If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure rigger executed first time
970 SS 7489 0.96 1.03 0.92 1.15
If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure rigger executed first time
971 CS 604 1.05 0.96 1.00 0.99
Error "no current row for fetch operation" when subquery includes a non-trivial derived table
972 SS 410 1.04 0.97 0.87 1.02
Error "no current row for fetch operation" when subquery includes a non-trivial derived table
973 CS 1339 0.91 1.05 1.03 0.96
Join condition fails for UTF-8 databases.
974 SS 1034 1.05 1.01 0.98 0.94
Join condition fails for UTF-8 databases.
975 CS 814 1.03 1.21 0.97 0.96
isql shouldn't display db and user name when extracting a script
976 SS 449 1.00 1.00 1.00 0.97
isql shouldn't display db and user name when extracting a script
977 CS 1690 1.01 1.21 0.95 0.98
Changing data that affects an expression index that contains references to null date fields fails
978 SS 1460 1.32 0.98 1.01 0.97
Changing data that affects an expression index that contains references to null date fields fails
979 CS 2639 0.99 1.19 0.95 1.00
Natural is used to select instead of primary key index
980 SS 2389 1.13 1.00 1.00 0.98
Natural is used to select instead of primary key index
981 CS 669 4.73 0.91 1.09 0.86
Cannot remove user with dot in login
982 SS 425 5.55 0.98 1.01 0.98
Cannot remove user with dot in login
983 CS 2700 0.92 1.17 0.97 1.02
View created from JOIN and LEFT JOIN doesnt order
984 SS 2574 0.95 1.02 1.28 0.97
View created from JOIN and LEFT JOIN doesnt order
985 CS 2104 1.03 1.17 0.96 0.95
Outer ORDER BY clause has no effect
986 SS 1829 0.95 1.02 1.33 0.97
Outer ORDER BY clause has no effect
987 CS 769 0.94 1.03 1.00 1.00
EVL_expr: invalid operation (232)
988 SS 529 1.01 0.98 1.01 0.96
EVL_expr: invalid operation (232)
989 CS 1155 1.02 0.98 1.01 0.98
String right truncation error when char column longer than 4096 bytes compared with string constant
990 SS 959 0.95 0.93 1.23 1.04
String right truncation error when char column longer than 4096 bytes compared with string constant
991 CS 624 7.54 1.00 0.99 0.97
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
992 SS 399 14.18 0.95 0.97 1.02
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
993 CS 1430 1.07 0.69 0.98 1.01
isql should show packaged procedures and functions categorized per package
994 SS 1110 0.97 1.01 1.03 0.98
isql should show packaged procedures and functions categorized per package
995 CS 1410 1.89 0.93 0.99 1.00
Query with "NOT IN <subselect from view>" fails
996 SS 1159 1.03 0.90 0.96 1.03
Query with "NOT IN <subselect from view>" fails
997 CS 674 0.89 0.90 1.43 1.09
A memory corruption cause incorrect query evaluation and may crash the server
998 SS 404 0.94 1.03 1.16 0.96
A memory corruption cause incorrect query evaluation and may crash the server
999 CS 1104 0.96 1.03 0.95 1.11
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
1000 SS 829 1.00 0.93 1.01 1.00
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE
1001 CS 1354 1.13 1.02 0.73 0.97
Expression in a subquery may be treated as invariant and produce incorrect results
1002 SS 1099 1.01 0.99 0.90 1.19
Expression in a subquery may be treated as invariant and produce incorrect results
1003 CS 4949 0.97 1.03 0.98 1.01
Don't send full length of field over the wire when field is null
1004 SS 4014 0.92 0.88 1.07 1.50
Don't send full length of field over the wire when field is null
1005 CS 1214 0.88 1.12 1.05 0.94
Unable to catch exceptions that are thrown inside a dynamic builded execute block.
1006 SS 899 1.11 1.03 0.96 0.95
Unable to catch exceptions that are thrown inside a dynamic builded execute block.
1007 CS 1409 1.07 0.99 0.97 1.00
PK index is not used for derived tables
1008 SS 1150 1.00 1.00 0.99 1.01
PK index is not used for derived tables
1009 CS 1309 0.97 1.02 1.04 0.94
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
1010 SS 1069 0.97 1.00 1.07 1.00
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
1011 CS 759 0.96 0.00 1.00 1.00
COLLATE expressions are applied incorrectly
1012 SS 529 0.98 0.98 1.01 1.01
COLLATE expressions are applied incorrectly
1013 CS 1239 0.97 1.03 1.02 0.80
Broken error handling in the case of a conversion error happened during index creation
1014 SS 1054 0.99 1.00 1.00 0.92
Broken error handling in the case of a conversion error happened during index creation
1015 CS 1324 0.97 0.99 1.04 1.00
Incorrect execution of volatile SQL statements inside EXECUTE STATEMENT
1016 SS 1054 0.98 0.97 1.28 1.01
Incorrect execution of volatile SQL statements inside EXECUTE STATEMENT
1017 CS 1069 1.13 0.97 0.98 1.01
Character set used in constants is not registered as dependency
1018 SS 774 1.00 1.00 0.99 0.98
Character set used in constants is not registered as dependency
1019 CS 2349 0.86 1.36 1.13 0.85
Problem with dependencies between a procedure and a view using that procedure
1020 SS 1864 1.03 0.97 1.31 0.53
Problem with dependencies between a procedure and a view using that procedure
1021 CS 1615 1.10 0.99 0.95 1.00
"Invalid ESCAPE sequence" when connecting to the database
1022 SS 1249 1.53 1.04 0.96 0.80
"Invalid ESCAPE sequence" when connecting to the database
1023 CS 1329 0.95 0.93 1.14 1.04
DROP VIEW drops output parameters of used stored procedures
1024 SS 1094 1.00 0.99 2.60 0.93
DROP VIEW drops output parameters of used stored procedures
1025 CS 1804 1.17 0.99 0.97 1.00
Wrong field position after ALTER POSITION
1026 SS 1499 0.92 1.07 0.96 1.03
Wrong field position after ALTER POSITION
1027 CS 1010 6.13 1.07 0.87 0.92
Trace output could contain garbage data left from filtered out statements
1028 SS 619 9.30 0.96 0.95 1.03
Trace output could contain garbage data left from filtered out statements
1029 CS 700 1.04 0.99 1.00 0.00
parsing error recursive query with two recursive parts
1030 SS 490 0.00 1.00 1.00 0.95
parsing error recursive query with two recursive parts
1031 CS 1155 1.07 0.96 0.94 1.03
Case-sensitive character class names in SIMILAR TO
1032 SS 969 0.92 1.07 1.43 0.83
Case-sensitive character class names in SIMILAR TO
1033 CS 1174 0.97 1.57 1.00 0.99
count(*) from big table returns negative result
1034 SS 879 0.98 1.02 1.01 0.98
count(*) from big table returns negative result
1035 CS 649 1.30 1.04 0.95 0.93
Incorrect ROW_COUNT value after SINGULAR condition
1036 SS 400 1.20 1.00 0.99 1.00
Incorrect ROW_COUNT value after SINGULAR condition
1037 CS 649 0.90 1.00 1.01 0.00
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them
1038 SS 450 1.02 0.97 0.97 1.02
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them
1039 CS 1890 0.97 1.07 0.89 1.02
Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" error
1040 SS 1664 0.97 0.92 1.15 1.02
Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" error
1041 CS 789 0.97 1.00 0.00 1.00
Unexpected "Invalid SIMILAR TO pattern" error
1042 SS 529 2.21 0.96 1.02 0.98
Unexpected "Invalid SIMILAR TO pattern" error
1043 CS 1339 0.99 1.08 0.85 1.00
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
1044 SS 960 1.00 1.35 0.99 1.00
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
1045 CS 934 6.92 1.07 0.93 0.88
Error in Trace plugin (use local symbols in query)
1046 SS 604 9.68 0.95 0.99 1.00
Error in Trace plugin (use local symbols in query)
1047 CS 1494 0.96 1.24 0.98 1.01
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
1048 SS 1299 1.19 0.98 0.76 1.01
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
1049 CS 4740 0.93 0.91 1.06 1.15
Concurrent transaction number not reported if lock timeout occurs
1050 SS 3600 0.93 0.86 1.23 1.06
Concurrent transaction number not reported if lock timeout occurs
1051 CS 779 1.01 0.00 0.94 1.00
Error on delete user "ADMIN"
1052 SS 514 1.00 1.05 0.91 0.99
Error on delete user "ADMIN"
1053 CS 839 1.01 0.96 0.98 1.03
Procedure suspend check may cause restore to fail
1054 SS 599 1.03 0.96 0.96 1.58
Procedure suspend check may cause restore to fail
1055 CS 895 7.20 0.92 1.00 0.99
Add attachment's CHARACTER SET name into corresponding trace records
1056 SS 615 9.81 0.95 1.00 0.99
Add attachment's CHARACTER SET name into corresponding trace records
1057 CS 940 0.96 1.03 0.96 1.03
Check ability to use RECREATE, ALTER and CREATE OR ALTER SEQUENCE/GENERATOR statements
1058 SS 730 1.00 0.98 1.16 1.00
Check ability to use RECREATE, ALTER and CREATE OR ALTER SEQUENCE/GENERATOR statements
1059 CS 1499 0.99 1.27 0.96 1.00
Error "no current record for fetch operation" after ALTER VIEW
1060 SS 1254 0.94 0.98 1.03 1.01
Error "no current record for fetch operation" after ALTER VIEW
1061 CS 1680 0.98 1.01 1.26 0.98
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
1062 SS 1420 1.00 0.99 0.95 1.04
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
1063 CS 1440 1.01 0.69 1.52 0.98
Wrong resultset
1064 SS 1174 0.99 1.05 0.98 1.00
Wrong resultset
1065 CS 1409 0.98 0.97 1.08 1.01
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)
1066 SS 1109 1.05 0.99 0.96 1.00
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)
1067 CS 759 1.02 0.97 0.96 1.05
Wrong logic is used to resolve EXECUTE BLOCK parameters collations
1068 SS 564 0.99 0.86 2.14 1.00
Wrong logic is used to resolve EXECUTE BLOCK parameters collations
1069 CS 1404 1.04 1.01 0.98 0.95
Wrong resultset
1070 SS 1079 0.99 0.92 1.17 1.00
Wrong resultset
1071 CS 1019 1.32 0.99 1.00 0.91
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
1072 SS 720 1.05 1.00 0.94 1.00
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
1073 CS 1804 0.98 1.13 1.01 0.95
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
1074 SS 1654 0.91 1.02 1.09 0.97
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
1075 CS 1314 0.98 1.01 0.98 1.04
Allow the usage of blobs in COMPUTED BY expressions
1076 SS 1114 0.89 1.01 0.98 1.23
Allow the usage of blobs in COMPUTED BY expressions
1077 CS 1024 0.99 1.02 1.00 0.98
Using both the procedure name and alias inside an explicit plan crashes the server
1078 SS 759 0.97 1.03 0.00 1.00
Using both the procedure name and alias inside an explicit plan crashes the server
1079 CS 1294 1.04 1.02 0.77 0.97
Better performance for (table.field = :param or :param = -1) in where clause
1080 SS 1064 1.05 0.99 0.93 1.00
Better performance for (table.field = :param or :param = -1) in where clause
1081 CS 1559 0.95 2.07 1.01 0.98
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
1082 SS 1364 0.87 0.93 1.06 1.20
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
1083 CS 1265 1.11 1.04 0.89 0.95
Incorrect LEFT JOIN result using table and derived constant subquery
1084 SS 909 0.92 0.99 1.14 1.01
Incorrect LEFT JOIN result using table and derived constant subquery
1085 CS 635 0.96 0.99 1.06 1.00
Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral
1086 SS 414 0.98 1.01 1.03 0.86
Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral
1087 CS 1424 1.03 1.35 0.95 0.96
ROW_COUNT is not cleared before the singleton INSERT statement
1088 SS 1139 1.06 1.00 0.99 0.87
ROW_COUNT is not cleared before the singleton INSERT statement
1089 CS 1769 0.94 1.33 0.89 1.05
Parameters doesn't work with NOT IN from a selectable procedure
1090 SS 1589 0.97 0.93 1.06 1.02
Parameters doesn't work with NOT IN from a selectable procedure
1091 CS 4009 0.99 1.02 0.99 1.00
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
1092 SS 3794 0.99 1.00 0.99 1.00
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
1093 CS 2359 0.98 1.02 1.00 1.00
Updating blob field cause server crash with ACCESS_VIOLATION exception
1094 SS 2084 0.99 1.01 1.00 0.98
Updating blob field cause server crash with ACCESS_VIOLATION exception
1095 CS 2960 1.00 0.98 1.07 0.99
Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction
1096 SS 1849 1.07 1.02 0.93 0.97
Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction
1097 CS 1014 0.97 1.03 0.99 1.00
Cannot alter the domain after migrating from older versions
1098 SS 894 1.01 0.98 1.06 0.96
Cannot alter the domain after migrating from older versions
1099 CS 3994 0.90 1.09 1.13 0.84
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT. See also: CORE-3283
1100 SS 3130 0.97 1.02 0.95 1.03
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT. See also: CORE-3283
1101 CS 1054 1.02 0.94 1.09 0.97
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
1102 SS 894 0.98 1.01 1.29 0.98
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.
1103 CS 1455 0.96 1.04 0.98 1.01
Partial rollback is possible for a selectable procedure modifying data
1104 SS 1180 1.43 1.00 0.94 0.99
Partial rollback is possible for a selectable procedure modifying data
1105 CS 2159 0.90 1.33 1.06 0.93
Preserve comments for parameters after altering procedures
1106 SS 1794 0.99 1.00 1.13 0.92
Preserve comments for parameters after altering procedures
1107 CS 2874 0.96 1.80 0.94 1.03
The last column in a view is returning as a null value even when it's not
1108 SS 2619 0.98 0.98 1.33 1.01
The last column in a view is returning as a null value even when it's not
1109 CS 1170 0.92 1.00 1.04 1.00
Parameterized requests involving blob fields fails when connected using charset UTF8
1110 SS 865 1.05 1.14 0.94 0.94
Parameterized requests involving blob fields fails when connected using charset UTF8
1111 CS 1549 0.98 1.18 1.00 1.00
Empty result when select from SP that contains two CTE (second of them with GROUP BY clause) and INNER join
1112 SS 1280 0.95 0.78 1.23 1.04
Empty result when select from SP that contains two CTE (second of them with GROUP BY clause) and INNER join
1113 CS 1674 1.00 0.99 0.97 1.00
Expression index with TRIM may lead to incorrect indexed lookup
1114 SS 1534 0.91 1.04 1.04 0.95
Expression index with TRIM may lead to incorrect indexed lookup
1115 CS 1460 0.99 0.68 1.07 1.00
View with "subselect" column join table and not use index
1116 SS 1204 1.05 0.99 0.96 1.00
View with "subselect" column join table and not use index
1117 CS 1274 0.99 1.00 0.92 1.13
ALTER VIEW with not matched columns in declaration and selection crashs the server
1118 SS 1054 1.05 0.93 1.01 0.98
ALTER VIEW with not matched columns in declaration and selection crashs the server
1119 CS 985 1.61 1.00 0.86 0.99
page 0 is of wrong type (expected 6, found 1)
1120 SS 545 2.12 0.88 1.10 0.89
page 0 is of wrong type (expected 6, found 1)
1121 CS 769 1.00 1.18 0.00 0.98
ATAN2 returns incorrect value for (0, 0)
1122 SS 525 1.00 0.98 1.00 0.99
ATAN2 returns incorrect value for (0, 0)
1123 CS 1410 0.97 1.13 1.00 1.00
Constraint violation error of CAST is not raised inside views
1124 SS 1205 0.99 1.01 0.95 1.00
Constraint violation error of CAST is not raised inside views
1125 CS 1925 1.01 1.02 0.96 0.98
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query
1126 SS 1679 0.97 1.01 0.98 1.01
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query
1127 CS 1309 1.00 1.37 0.98 1.00
String truncation occurs when selecting from a view containing NOT IN inside
1128 SS 1129 0.98 0.93 1.01 1.07
String truncation occurs when selecting from a view containing NOT IN inside
1129 CS 1459 1.09 0.96 1.03 0.94
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
1130 SS 1094 1.00 1.09 0.99 0.96
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE
1131 CS 639 0.96 1.00 1.00 1.00
ASCII_VAL() fails if argument contains multi-byte character anywhere
1132 SS 434 1.03 0.99 1.01 0.99
ASCII_VAL() fails if argument contains multi-byte character anywhere
1133 CS 634 0.97 1.00 0.99 1.04
RIGHT() fails with multibyte text blobs > 1024 chars
1134 SS 405 1.01 0.93 0.98 1.01
RIGHT() fails with multibyte text blobs > 1024 chars
1135 CS 635 1.05 1.02 0.92 0.97
OVERLAY() fails when used with text BLOBs containing multi-byte chars
1136 SS 409 1.02 0.97 0.90 1.02
OVERLAY() fails when used with text BLOBs containing multi-byte chars
1137 CS 1394 1.00 0.99 0.97 1.00
LIKE, STARTING and CONTAINING fail if second operand >= 32K
1138 SS 1379 1.60 0.81 1.13 0.87
LIKE, STARTING and CONTAINING fail if second operand >= 32K
1139 CS 30224 0.97 1.01 0.99 1.00
Support for text BLOBs >= 32K as first argument for TRIM()
1140 SS 30834 0.95 1.04 0.95 1.07
Support for text BLOBs >= 32K as first argument for TRIM()
1141 CS 1625 1.03 1.04 0.96 0.95
Makes GEN_UUID return a compliant RFC-4122 UUID
1142 SS 1129 0.88 1.11 1.18 0.88
Makes GEN_UUID return a compliant RFC-4122 UUID
1143 CS 1549 1.20 1.00 0.98 0.99
UTF8 UNICODE_CI collate can not be used in compound index
1144 SS 1304 0.96 1.03 0.76 1.04
UTF8 UNICODE_CI collate can not be used in compound index
1145 CS 2484 1.17 1.01 0.91 0.98
Recursive stored procedure shouldnt require execute right to call itself
1146 SS 1959 1.04 0.93 0.96 1.03
Recursive stored procedure shouldnt require execute right to call itself
1147 CS 635 1.11 1.05 0.94 0.92
POSITION: Wrong result with '' if third argument present
1148 SS 405 1.01 0.96 1.03 0.98
POSITION: Wrong result with '' if third argument present
1149 CS 4979 1.03 1.55 0.96 0.96
SUBSTRING on long blobs truncates result to 32767 if third argument not present
1150 SS 5364 0.87 1.01 1.16 0.98
SUBSTRING on long blobs truncates result to 32767 if third argument not present
1151 CS 1589 1.04 1.30 0.95 0.62
The server could crash using views with GROUP BY
1152 SS 1339 1.00 0.97 1.36 1.00
The server could crash using views with GROUP BY
1153 CS 1764 1.01 0.87 1.02 0.98
Error "request depth exceeded" may appear while preparing a select query against a view with explicit plan
1154 SS 1709 0.78 1.21 1.21 0.78
Error "request depth exceeded" may appear while preparing a select query against a view with explicit plan
1155 CS 1179 0.93 1.16 0.84 1.06
LIST() may overwrite last part of output with zero characters
1156 SS 929 0.95 1.02 0.97 1.16
LIST() may overwrite last part of output with zero characters
1157 CS 990 0.93 1.02 1.01 0.98
Wrong result for RIGHT(UTF8 varchar)
1158 SS 705 0.97 1.02 0.89 1.07
Wrong result for RIGHT(UTF8 varchar)
1159 CS 980 1.00 0.98 1.00 1.07
EXECUTE STATEMENT parses the SQL text using wrong charset
1160 SS 680 0.00 1.08 0.96 1.00
EXECUTE STATEMENT parses the SQL text using wrong charset
1161 CS 1390 0.94 1.83 0.84 1.05
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
1162 SS 1204 0.93 0.93 1.35 1.06
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT
1163 CS 1099 1.00 1.00 0.98 0.99
New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction that created a record version
1164 SS 949 1.26 0.93 0.89 1.06
New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction that created a record version
1165 CS 1554 1.42 1.00 0.99 0.99
Error "context already in use" for the simple case function with a sub-select operand
1166 SS 1384 0.98 1.01 1.09 0.97
Error "context already in use" for the simple case function with a sub-select operand
1167 CS 1154 0.99 1.00 0.99 1.06
Distinct aggregates return wrong (duplicated) data
1168 SS 910 1.01 0.95 1.14 0.98
Distinct aggregates return wrong (duplicated) data
1169 CS 1179 1.12 0.97 0.99 1.00
"BLOB not found" error after creation/altering of the invalid trigger
1170 SS 960 0.93 1.51 0.96 1.03
"BLOB not found" error after creation/altering of the invalid trigger
1171 CS 1374 0.98 0.95 1.01 1.01
Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure
1172 SS 1120 1.00 0.98 1.08 0.99
Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure
1173 CS 1254 0.98 1.07 0.96 1.01
RDB$GET_CONTEXT and between in view
1174 SS 1039 1.00 0.99 0.96 1.02
RDB$GET_CONTEXT and between in view
1175 CS 1425 1.24 0.99 1.00 0.97
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
1176 SS 1139 0.93 1.04 1.04 0.95
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause
1177 CS 664 1.23 1.02 0.91 0.97
Sub-optimal join plan when the slave table depends on the master one via the OR predicate
1178 SS 409 1.00 1.00 1.02 0.97
Sub-optimal join plan when the slave table depends on the master one via the OR predicate
1179 CS 1289 1.03 1.00 0.96 0.99
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
1180 SS 1284 0.93 1.03 1.08 0.96
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction
1181 CS 1539 1.52 0.64 0.85 1.14
Ability to cancel waiting in lock manager
1182 SS 1300 1.22 0.86 1.13 0.83
Ability to cancel waiting in lock manager
1183 CS 1314 3.94 0.95 1.01 0.98
Client writes error messages into firebird.log when database is shutted down
1184 SS 1130 4.50 0.85 1.01 0.98
Client writes error messages into firebird.log when database is shutted down
1185 CS 1340 1.03 1.02 0.97 0.94
Server crashes while recreating the table with a NULL -> NOT NULL change
1186 SS 1179 0.91 1.54 1.08 0.91
Server crashes while recreating the table with a NULL -> NOT NULL change
1187 CS 644 1.04 1.20 0.96 0.96
Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments
1188 SS 415 1.01 0.96 1.13 0.98
Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments
1189 CS 1384 0.93 1.04 0.95 1.05
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
1190 SS 1165 1.00 0.98 1.03 0.99
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE
1191 CS 1530 0.86 0.84 1.13 1.32
Error in autonomous transaction with empty exception handler: can insert duplicate values into PK/UK column (leads to unrestorable backup)
1192 SS 1064 0.99 0.97 1.00 1.12
Error in autonomous transaction with empty exception handler: can insert duplicate values into PK/UK column (leads to unrestorable backup)
1193 CS 1364 0.98 1.01 1.03 0.98
RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements
1194 SS 1084 1.00 0.99 1.02 0.98
RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements
1195 CS 759 1.05 1.00 0.94 1.00
Predicate (blob_field LIKE ?) describes the parameter as VARCHAR(30) rather than as BLOB
1196 SS 509 1.00 1.01 1.00 0.00
Predicate (blob_field LIKE ?) describes the parameter as VARCHAR(30) rather than as BLOB
1197 CS 1474 1.05 0.94 1.06 0.88
Wrong comparsion of DATE and TIMESTAMP if index is used
1198 SS 1139 1.16 1.00 0.98 0.99
Wrong comparsion of DATE and TIMESTAMP if index is used
1199 CS 1819 1.04 1.10 0.54 0.95
Generators are set to 0 after restore
1200 SS 1420 0.96 1.00 1.03 0.99
Generators are set to 0 after restore
1201 CS 1740 1.16 1.00 1.00 1.00
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
1202 SS 1380 0.99 1.47 1.00 1.00
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
1203 CS 7999 1.06 1.01 0.98 0.98
Cursors should ignore changes made by the same statement
1204 SS 7630 0.96 0.90 1.43 1.03
Cursors should ignore changes made by the same statement
1205 CS 1514 0.66 1.24 0.97 1.02
Cursors should ignore changes made by the same statement
1206 SS 1300 1.11 0.97 0.98 1.01
Cursors should ignore changes made by the same statement
1207 CS 1005 0.94 0.97 1.04 1.02
Blob filter to translate internal debug info into text representation
1208 SS 804 0.97 0.99 1.09 1.00
Blob filter to translate internal debug info into text representation
1209 CS 2269 0.89 1.18 0.81 1.10
Extend syntax for ALTER USER CURRENT_USER
1210 SS 1474 0.97 1.03 1.32 0.93
Extend syntax for ALTER USER CURRENT_USER
1211 CS 1519 1.04 1.04 0.65 0.95
It is possible to store string with lenght 31 chars into column varchar(25)
1212 SS 1195 0.98 0.83 1.01 1.06
It is possible to store string with lenght 31 chars into column varchar(25)
1213 CS 1160 0.99 1.06 1.00 0.96
Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format
1214 SS 924 1.02 1.00 0.99 0.97
Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format
1215 CS 1319 0.98 0.94 1.01 1.05
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
1216 SS 1099 0.97 1.02 1.09 0.94
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
1217 CS 785 1.14 0.92 1.07 0.87
GRANT ADMIN ROLE not accepted
1218 SS 504 1.02 0.97 0.97 1.04
GRANT ADMIN ROLE not accepted
1219 CS 999 1.01 1.12 0.90 0.99
Allow write operations to temporary tables in read only transactions
1220 SS 719 1.00 1.01 0.98 1.00
Allow write operations to temporary tables in read only transactions
1221 CS 1690 0.98 1.43 0.95 1.01
Collation errors with [type of] <domain>, type of column
1222 SS 1429 1.06 0.69 1.49 0.93
Collation errors with [type of] <domain>, type of column
1223 CS 940 6.58 0.98 1.01 0.89
Improve diagnostics of internal trace errors
1224 SS 639 9.16 0.96 0.93 1.03
Improve diagnostics of internal trace errors
1225 CS 1049 1.08 1.00 0.93 0.99
Inserting K?se into a CHARACTER SET ASCII column succeeds
1226 SS 840 0.97 1.02 1.03 0.94
Inserting K?se into a CHARACTER SET ASCII column succeeds
1227 CS 854 1.00 1.00 0.95 0.99
Database trigger created as INACTIVE is active
1228 SS 589 1.00 0.94 1.03 1.00
Database trigger created as INACTIVE is active
1229 CS 7294 0.99 0.94 1.00 1.00
Recurse leads to hangs/crash server
1230 SS 3919 1.13 0.93 1.00 0.99
Recurse leads to hangs/crash server
1231 CS 769 0.00 1.00 0.90 1.03
BOOLEAN not present in system table RDB$TYPES
1232 SS 519 1.00 1.00 0.94 1.01
BOOLEAN not present in system table RDB$TYPES
1233 CS 1474 1.03 0.94 0.97 1.03
[FB3] AV with "UPDATE OR INSERT"
1234 SS 1179 0.98 1.01 0.84 1.56
[FB3] AV with "UPDATE OR INSERT"
1235 CS 895 0.97 1.03 1.01 0.98
[FB3] Wrong RDB$PARAMETER_MECHANISM
1236 SS 684 1.10 0.96 1.03 0.93
[FB3] Wrong RDB$PARAMETER_MECHANISM
1237 CS 1044 0.96 0.98 1.10 1.01
Server crashing with UTF8 blobs
1238 SS 849 0.98 0.97 1.09 1.01
Server crashing with UTF8 blobs
1239 CS 930 1.12 1.03 0.94 0.96
ISQL pads UTF-8 data incorrectly
1240 SS 704 1.02 0.98 1.07 0.96
ISQL pads UTF-8 data incorrectly
1241 CS 1429 1.00 1.21 0.97 0.99
Allow conversion from/to BLOBs and others types in the API functions (XSQLVAR or blr messages)
1242 SS 1129 0.99 1.00 1.24 0.99
Allow conversion from/to BLOBs and others types in the API functions (XSQLVAR or blr messages)
1243 CS 1190 1.00 1.18 0.93 0.99
Collation is not installed with icu > 4.2
1244 SS 925 0.93 1.02 1.04 0.97
Collation is not installed with icu > 4.2
1245 CS 2499 1.01 0.80 0.98 1.04
Inefficient optimization (regression)
1246 SS 2004 0.97 0.95 1.02 1.02
Inefficient optimization (regression)
1247 CS 1180 0.96 0.99 1.00 1.00
Added not null timestamp col with default causes error on select of old null records
1248 SS 990 1.01 0.98 1.06 0.95
Added not null timestamp col with default causes error on select of old null records
1249 CS 1284 0.98 0.99 1.23 1.00
DDL operations fail after backup/restore
1250 SS 1045 0.87 0.92 1.62 1.07
DDL operations fail after backup/restore
1251 CS 1199 1.02 1.03 0.97 0.92
Regression in joins on procedures
1252 SS 1044 1.02 1.04 0.92 0.97
Regression in joins on procedures
1253 CS 859 1.00 1.00 1.34 0.00
Parameters inside the CAST function are described as not nullable
1254 SS 534 1.01 0.97 0.99 1.04
Parameters inside the CAST function are described as not nullable
1255 CS 730 1.03 1.01 0.98 0.98
LIST function wrongly concatenates binary blobs
1256 SS 549 1.03 0.89 1.05 0.96
LIST function wrongly concatenates binary blobs
1257 CS 809 0.98 1.01 0.00 1.00
ASCII_VAL raises error instead of return 0 for empty strings
1258 SS 534 1.08 0.97 0.97 1.02
ASCII_VAL raises error instead of return 0 for empty strings
1259 CS 779 0.98 1.05 1.00 1.00
Blob transliteration may not happen inside the union
1260 SS 550 1.00 0.94 0.00 1.38
Blob transliteration may not happen inside the union
1261 CS 1195 1.02 1.01 0.98 0.97
Concurrency problem when using named cursors
1262 SS 1045 0.86 0.83 1.13 1.42
Concurrency problem when using named cursors
1263 CS 1389 0.98 1.01 0.96 1.04
Altering of a TYPE OF COLUMN parameter affects the original column
1264 SS 1104 0.98 0.97 1.29 1.01
Altering of a TYPE OF COLUMN parameter affects the original column
1265 CS 609 0.93 1.05 1.03 0.96
Adding a value to a timestamp below '16.11.1858 00:00:01' throws 'value exceeds the range for valid timestamp'
1266 SS 409 1.10 0.97 0.95 1.02
Adding a value to a timestamp below '16.11.1858 00:00:01' throws 'value exceeds the range for valid timestamp'
1267 CS 1354 1.02 0.92 0.97 1.07
DROP VIEW ignores the existing non-column dependencies
1268 SS 1099 1.03 0.96 1.23 0.93
DROP VIEW ignores the existing non-column dependencies
1269 CS 1279 0.96 1.03 0.93 1.03
ALTER VIEW crashes the server if the new version has an artificial (aggregate or union) stream at the position of a regular context in the older version
1270 SS 994 1.00 0.95 1.07 0.99
ALTER VIEW crashes the server if the new version has an artificial (aggregate or union) stream at the position of a regular context in the older version
1271 CS 1014 1.01 0.98 1.08 0.94
Alter procedure allows to add the parameter with the same name
1272 SS 759 0.94 0.96 1.08 1.03
Alter procedure allows to add the parameter with the same name
1273 CS 574 1.08 0.97 1.02 0.97
Server crash with built in function LPAD with string as second parameter
1274 SS 410 1.02 1.09 0.97 0.95
Server crash with built in function LPAD with string as second parameter
1275 CS 635 0.97 1.02 1.14 0.97
SIMILAR TO: False matches on descending ranges
1276 SS 434 0.94 1.24 1.01 0.99
SIMILAR TO: False matches on descending ranges
1277 CS 634 1.03 0.96 0.92 1.13
Support for WHEN SQLSTATE
1278 SS 419 1.02 0.97 0.90 1.04
Support for WHEN SQLSTATE
1279 CS 1439 1.09 0.96 1.00 0.99
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
1280 SS 1334 1.01 0.98 0.98 1.01
BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
1281 CS 2079 3.98 0.96 0.95 1.03
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
1282 SS 2224 3.86 0.75 1.24 0.75
There is no need to undo changes made in GTT created with ON COMMIT DELETE ROWS option when transaction is rolled back
1283 CS 1404 1.03 1.15 0.91 0.96
Inconsistent domain's constraint validation in PSQL
1284 SS 1119 0.93 0.97 1.14 1.02
Inconsistent domain's constraint validation in PSQL
1285 CS 1179 0.99 1.35 0.95 1.00
Aliases for the RETURNING clause
1286 SS 910 0.98 1.02 1.01 0.94
Aliases for the RETURNING clause
1287 CS 1485 0.67 1.02 0.97 1.02
Floating-point negative zero doesn't match positive zero in the index
1288 SS 1329 0.96 0.96 1.18 1.03
Floating-point negative zero doesn't match positive zero in the index
1289 CS 809 0.96 1.01 1.08 0.98
GFIX returns an error after correctly shutting down a database
1290 SS 730 1.01 0.98 0.97 1.01
GFIX returns an error after correctly shutting down a database
1291 CS 116349 1.05 0.93 0.98 1.01
Database corruption after end of session : page xxx is of wrong type expected 4 found 7
1292 SS 111055 1.01 1.06 0.96 0.98
Database corruption after end of session : page xxx is of wrong type expected 4 found 7
1293 CS 614 0.94 0.95 1.05 1.04
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
1294 SS 395 1.13 1.01 0.91 0.98
Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
1295 CS 1000 1.03 1.00 1.00 0.97
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
1296 SS 674 1.00 1.00 0.99 0.97
Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
1297 CS 1174 1.19 1.02 0.97 0.94
AV in engine when preparing query against dropping table
1298 SS 925 1.07 0.95 1.02 0.97
AV in engine when preparing query against dropping table
1299 CS 730 0.97 1.06 0.98 1.01
CHAR(32767) present in XSQLVAR with length 32765
1300 SS 490 1.10 1.00 1.00 0.00
CHAR(32767) present in XSQLVAR with length 32765
1301 CS 1249 0.99 1.00 1.35 0.93
Can not drop table when computed field depends on later created another field
1302 SS 899 1.04 0.93 1.04 0.95
Can not drop table when computed field depends on later created another field
1303 CS 1310 1.02 1.05 0.91 0.97
Include expected and actual string lenght into error message for sqlcode -802
1304 SS 1019 1.01 0.98 0.92 1.05
Include expected and actual string lenght into error message for sqlcode -802
1305 CS 1610 3.95 1.07 0.92 0.92
TRACE: add statistics of actions that were after transaction finished
1306 SS 1185 4.54 0.99 0.97 1.00
TRACE: add statistics of actions that were after transaction finished
1307 CS 625 1.02 0.97 0.92 1.03
Possible drop role RDB$ADMIN
1308 SS 409 1.12 0.97 0.97 1.02
Possible drop role RDB$ADMIN
1309 CS 2014 0.99 1.00 1.05 0.93
Incorrect TEXT BLOB charset transliteration on VIEW with trigger
1310 SS 1869 0.94 1.05 1.15 0.93
Incorrect TEXT BLOB charset transliteration on VIEW with trigger
1311 CS 1529 1.00 1.00 1.00 0.94
Can insert DUPLICATE keys in UNIQUE index
1312 SS 1159 0.95 1.04 0.91 1.04
Can insert DUPLICATE keys in UNIQUE index
1313 CS 1200 1.00 0.92 0.99 1.02
Wrong data while retrieving from CTEs (or derived tables) with same column names
1314 SS 889 1.00 0.95 1.38 1.00
Wrong data while retrieving from CTEs (or derived tables) with same column names
1315 CS 1334 2.09 0.98 0.98 1.01
Plan returned for query with recursive CTE return wrong count of parenthesis
1316 SS 1175 1.70 0.92 1.05 0.94
Plan returned for query with recursive CTE return wrong count of parenthesis
1317 CS 1455 1.25 0.98 1.01 0.94
MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level)
1318 SS 1044 0.96 1.02 0.99 1.00
MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level)
1319 CS 1480 0.99 1.35 1.00 0.95
Server crashes with access violation when inserting row into table with unique index
1320 SS 1254 1.01 0.98 1.10 0.96
Server crashes with access violation when inserting row into table with unique index
1321 CS 2105 1.00 1.10 0.98 0.99
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
1322 SS 1899 1.05 1.00 0.96 0.99
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
1323 CS 1529 0.98 1.01 1.07 0.95
recreation of collation for utf8 from unicode with option NUMERIC-SORT=1 leads to FB death
1324 SS 1410 0.96 1.03 1.18 0.94
recreation of collation for utf8 from unicode with option NUMERIC-SORT=1 leads to FB death
1325 CS 964 7.32 1.08 0.91 0.90
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
1326 SS 624 10.59 0.94 1.02 0.97
FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
1327 CS 1569 1.00 1.45 0.96 1.00
computed index by substring function for long columns
1328 SS 1314 1.03 0.96 1.23 0.87
computed index by substring function for long columns
1329 CS 1064 0.93 1.60 1.01 0.98
CREATE INDEX considers NULL and empty string being the same in compound indices
1330 SS 779 0.93 1.00 0.00 1.08
CREATE INDEX considers NULL and empty string being the same in compound indices
1331 CS 2564 0.99 1.02 0.95 1.00
Wrong results if the recursive query contains an embedded GROUP BY clause
1332 SS 2510 1.19 0.96 1.03 0.91
Wrong results if the recursive query contains an embedded GROUP BY clause
1333 CS 764 1.00 0.99 0.96 1.00
Wrong warning message for ambiguous query
1334 SS 544 0.00 1.00 0.00 0.99
Wrong warning message for ambiguous query
1335 CS 769 1.00 1.18 0.00 0.91
Wrong warning message for ambiguous query
1336 SS 539 0.94 1.81 1.00 0.00
Wrong warning message for ambiguous query
1337 CS 1744 1.04 0.91 1.02 0.97
Missing constraint name in foreign key error message in FB 2.1.4
1338 SS 1459 1.06 1.01 0.98 0.96
Missing constraint name in foreign key error message in FB 2.1.4
1339 CS 1439 0.93 1.09 0.99 1.00
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
1340 SS 1365 0.90 1.01 1.06 0.98
Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
1341 CS 1079 0.95 1.06 0.92 1.04
internal Firebird consistency check in query with grouping by subquery+stored procedure+aggregate
1342 SS 769 1.02 1.00 1.00 0.94
internal Firebird consistency check in query with grouping by subquery+stored procedure+aggregate
1343 CS 1730 1.02 0.99 0.91 1.00
String truncation error when selecting from a VIEW with UNION inside
1344 SS 1454 1.01 1.00 0.99 0.98
String truncation error when selecting from a VIEW with UNION inside
1345 CS 1174 0.99 0.96 1.00 1.01
IS NOT DISTINCT FROM NULL doesn't use index
1346 SS 905 1.03 0.96 1.16 0.96
IS NOT DISTINCT FROM NULL doesn't use index
1347 CS 834 2.94 1.05 0.93 0.94
Segfault when closing attachment to database
1348 SS 579 3.40 1.03 0.84 0.96
Segfault when closing attachment to database
1349 CS 2099 0.99 0.96 1.04 1.01
GBAK fails to fix system generators while restoring
1350 SS 1945 1.02 0.98 0.99 1.00
GBAK fails to fix system generators while restoring
1351 CS 1199 1.00 1.47 1.00 0.83
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
1352 SS 875 1.00 1.00 0.99 0.98
Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
1353 CS 1929 0.96 1.25 0.95 1.03
WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table
1354 SS 1229 0.97 1.02 0.81 1.03
WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table
1355 CS 789 1.05 0.97 1.00 0.00
EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets
1356 SS 519 0.98 1.01 0.00 1.00
EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets
1357 CS 804 0.96 1.13 0.92 1.03
SELECT using IN list with 153 or more elements causes crash
1358 SS 579 1.00 1.01 0.89 1.00
SELECT using IN list with 153 or more elements causes crash
1359 CS 1910 0.96 1.16 1.01 0.98
The trigger together with the operator MERGE if in a condition of connection ON contains new is not compiled
1360 SS 1814 0.90 0.97 1.07 1.02
The trigger together with the operator MERGE if in a condition of connection ON contains new is not compiled
1361 CS 1180 1.02 0.96 1.02 0.97
SIMILAR TO works wrongly
1362 SS 899 0.96 1.03 0.93 1.05
SIMILAR TO works wrongly
1363 CS 1004 0.92 1.23 0.92 1.07
Conversion error when using a blob as an argument for the EXCEPTION statement
1364 SS 705 1.00 0.92 0.99 1.34
Conversion error when using a blob as an argument for the EXCEPTION statement
1365 CS 1729 1.04 1.06 0.87 0.96
Conversion error from string when using GROUP BY
1366 SS 1424 0.98 1.01 1.13 0.95
Conversion error from string when using GROUP BY
1367 CS 849 0.91 1.08 1.08 0.87
Report OS user name in MON$ATTACHMENTS
1368 SS 509 0.96 0.00 1.03 1.00
Report OS user name in MON$ATTACHMENTS
1369 CS 1705 0.99 1.14 0.99 1.00
fb server die when carry out the LEFT + INNER JOIN
1370 SS 1460 1.04 0.97 0.97 1.02
fb server die when carry out the LEFT + INNER JOIN
1371 CS 1665 1.01 0.98 1.12 0.98
with caller privileges option do not work with autonomous transaction option
1372 SS 1350 0.95 1.04 1.51 0.93
with caller privileges option do not work with autonomous transaction option
1373 CS 789 1.32 1.01 0.91 0.98
Warnings could be put twice in status-vector
1374 SS 519 1.01 0.98 1.05 0.98
Warnings could be put twice in status-vector
1375 CS 1169 1.00 1.35 0.98 0.99
Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause
1376 SS 959 1.08 0.92 1.05 0.94
Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause
1377 CS 654 0.99 1.00 0.93 1.02
Error "Invalid expression in the select list" can be unexpectedly raised if a string literal is used inside a GROUP BY clause in a multi-byte connection
1378 SS 440 0.95 1.00 1.04 1.00
Error "Invalid expression in the select list" can be unexpectedly raised if a string literal is used inside a GROUP BY clause in a multi-byte connection
1379 CS 1254 1.01 1.01 0.98 0.90
isql: zero divide + coredump when use "-pag 0" command switch & set heading on inside .sql script
1380 SS 890 1.02 0.97 1.22 0.95
isql: zero divide + coredump when use "-pag 0" command switch & set heading on inside .sql script
1381 CS 769 1.14 0.00 0.94 1.00
RDB$TYPES contain duplicate character sets
1382 SS 509 0.00 0.94 1.00 1.00
RDB$TYPES contain duplicate character sets
1383 CS 1304 0.98 1.09 0.99 1.00
Bad alias table choice joining CTE
1384 SS 1069 0.95 1.01 1.00 0.99
Bad alias table choice joining CTE
1385 CS 1094 0.99 1.06 1.00 0.91
Usage of a NATURAL JOIN with a derived table crashes the server
1386 SS 740 1.00 1.00 0.94 1.09
Usage of a NATURAL JOIN with a derived table crashes the server
1387 CS 615 1.15 1.07 0.86 0.92
Trace API: Faulty database filter crashes server
1388 SS 385 0.98 0.95 1.11 1.01
Trace API: Faulty database filter crashes server
1389 CS 1134 0.98 1.23 0.96 1.01
Computed column appears in non-existant rows of left join
1390 SS 939 0.96 0.97 1.06 1.02
Computed column appears in non-existant rows of left join
1391 CS 1699 0.91 1.01 0.98 1.14
Extend the error reported for index/constraint violations to include the problematic key value
1392 SS 1549 0.94 0.94 1.14 1.05
Extend the error reported for index/constraint violations to include the problematic key value
1393 CS 1660 1.03 0.97 1.00 0.99
Ambiguous field name in the trigger when it does a select from the table
1394 SS 1450 0.98 1.01 1.05 0.98
Ambiguous field name in the trigger when it does a select from the table
1395 CS 874 8.04 0.99 1.00 0.88
Server crashes on preparing empty query when trace is enabled
1396 SS 549 12.11 0.96 1.01 0.98
Server crashes on preparing empty query when trace is enabled
1397 CS 1199 1.00 0.99 1.02 0.96
Wrong numbers in error message for decreasing char/varchar columns
1398 SS 989 0.95 0.97 1.35 1.03
Wrong numbers in error message for decreasing char/varchar columns
1399 CS 2890 1.17 1.01 0.97 0.98
High memory usage when PSQL code SELECT's from stored procedure which modified some data
1400 SS 2695 0.98 1.27 1.01 0.93
High memory usage when PSQL code SELECT's from stored procedure which modified some data
1401 CS 740 1.00 1.00 1.00 1.00
row_number(), rank() and dense_rank() return BIGINT datatype in dialect 1
1402 SS 534 1.01 0.99 1.04 0.95
row_number(), rank() and dense_rank() return BIGINT datatype in dialect 1
</