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

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

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