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