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