nix-5x all-outcomes

Generated 19.10.2021 09:34
Tested: FB50. Build: 5.0.0.259; SS: 19.10.21 06:20:57 - 19.10.21 07:54:31; CS: 19.10.21 07:57:21 - 19.10.21 09:31:36;
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...

Outcomes for the whole set of tests in the last 30 runs: <

NN Test name mode 5.0.0.259
2021-10-19 5.0.0.257
2021-10-15 5.0.0.253
2021-10-13 5.0.0.249
2021-10-12 5.0.0.245
2021-10-10 5.0.0.244
2021-10-08 5.0.0.243
2021-10-06 5.0.0.242
2021-10-05 5.0.0.241
2021-10-03 5.0.0.240
2021-10-01 5.0.0.236
2021-09-30 5.0.0.232
2021-09-29 5.0.0.231
2021-09-28 5.0.0.229
2021-09-26 5.0.0.228
2021-09-23 5.0.0.220
2021-09-23 5.0.0.219
2021-09-20 5.0.0.218
2021-09-19 5.0.0.215
2021-09-17 5.0.0.212
2021-09-16 5.0.0.208
2021-09-16 5.0.0.202
2021-09-14 5.0.0.198
2021-09-12 5.0.0.197
2021-09-11 5.0.0.196
2021-09-10 5.0.0.193
2021-09-09 5.0.0.192
2021-09-08 5.0.0.187
2021-09-07 5.0.0.186
2021-09-04 5.0.0.181
2021-09-03
Test TITLE

1
bugs core 0001

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
FBserver shutsdown when a user password is attempted to be modified to a empty string

2
bugs core 0001

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
FBserver shutsdown when a user password is attempted to be modified to a empty string

3
bugs core 0002

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect value returned with execute statement calculation

4
bugs core 0002

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect value returned with execute statement calculation

5
bugs core 0010

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Navigation vs IS NULL vs compound index

6
bugs core 0010

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Navigation vs IS NULL vs compound index

7
bugs core 0014

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Trigger do it wrong

8
bugs core 0014

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Trigger do it wrong

9
bugs core 0037

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Navigation vs IS NULL vs compound index

10
bugs core 0037

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Navigation vs IS NULL vs compound index

11
bugs core 0039

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
cannot create procedure with long chain of else-if clauses

12
bugs core 0039

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
cannot create procedure with long chain of else-if clauses

13
bugs core 0053

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
FIRST 1 vs ORDER DESC vs explicit plan (ODS11)

14
bugs core 0053

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
FIRST 1 vs ORDER DESC vs explicit plan (ODS11)

15
bugs core 0058

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
WHERE CURRENT OF doesn't work

16
bugs core 0058

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
WHERE CURRENT OF doesn't work

17
bugs core 0059

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Automatic not null in PK columns incomplete

18
bugs core 0059

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Automatic not null in PK columns incomplete

19
bugs core 0063

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Sequence of commands crash FB server

20
bugs core 0063

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sequence of commands crash FB server

21
bugs core 0070

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Expression index regression since 2.0a3

22
bugs core 0070

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression index regression since 2.0a3

23
bugs core 0076

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Invalid ROW_COUNT variable value after DELETE

24
bugs core 0076

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Invalid ROW_COUNT variable value after DELETE

25
bugs core 0085

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Query with not in (select) returns wrong result

26
bugs core 0085

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Query with not in (select) returns wrong result

27
bugs core 0086

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
Index bug

28
bugs core 0086

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Index bug

29
bugs core 0088

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Join on diffrent datatypes

30
bugs core 0088

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Join on diffrent datatypes

31
bugs core 0089

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Using where params in SUM return incorrect results

32
bugs core 0089

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Using where params in SUM return incorrect results

33
bugs core 0091

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Recreate and self-referencing indexes

34
bugs core 0091

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Recreate and self-referencing indexes

35
bugs core 0099

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Strange/Inconsistent query results

36
bugs core 0099

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Strange/Inconsistent query results

37
bugs core 0101

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
JOIN the same table - problem with alias names

38
bugs core 0101

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
JOIN the same table - problem with alias names

39
bugs core 0104

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Dropping and recreating a table in the same txn disables PK

40
bugs core 0104

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Dropping and recreating a table in the same txn disables PK

41
bugs core 0115

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
bug with ALL keyword

42
bugs core 0115

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
bug with ALL keyword

43
bugs core 0116

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
CREATE TABLE - no blob for external

44
bugs core 0116

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE TABLE - no blob for external

45
bugs core 0117

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Expression evaluation not supported on LEFT JOIN

46
bugs core 0117

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression evaluation not supported on LEFT JOIN

47
bugs core 0119

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
numeric div in dialect 3 mangles data

48
bugs core 0119

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
numeric div in dialect 3 mangles data

49
bugs core 0142

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
index breaks = ANY result

50
bugs core 0142

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
index breaks = ANY result

51
bugs core 0143

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Using where params in SUM return incorrect results

52
bugs core 0143

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Using where params in SUM return incorrect results

53
bugs core 0148

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SELECT '1' UNION SELECT '12'

54
bugs core 0148

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SELECT '1' UNION SELECT '12'

55
bugs core 0149

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Left joining views with null fails

56
bugs core 0149

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Left joining views with null fails

57
bugs core 0152

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Sqlsubtype incorrect on timestamp math, constant arithmetic

58
bugs core 0152

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sqlsubtype incorrect on timestamp math, constant arithmetic

59
bugs core 0165

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Query using VIEW with UNION causes crash

60
bugs core 0165

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Query using VIEW with UNION causes crash

61
bugs core 0166

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
cannot specify PLAN in UPDATE statement

62
bugs core 0166

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
cannot specify PLAN in UPDATE statement

63
bugs core 0185

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
DB crashes if trigger BU deletes own row

64
bugs core 0185

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DB crashes if trigger BU deletes own row

65
bugs core 0188

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
trigger on view with union receive nulls

66
bugs core 0188

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
trigger on view with union receive nulls

67
bugs core 0190

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
trigger with except-s on view with union

68
bugs core 0190

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
trigger with except-s on view with union

69
bugs core 0195

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bugcheck 291

70
bugs core 0195

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 291

71
bugs core 0196

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SYSDBA can grant non existent roles

72
bugs core 0196

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SYSDBA can grant non existent roles

73
bugs core 0198

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
wrong order by in table join storedproc

74
bugs core 0198

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
wrong order by in table join storedproc

75
bugs core 0200

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Empty column names with aggregate funcs

76
bugs core 0200

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Empty column names with aggregate funcs

77
bugs core 0202

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ORDER BY works wrong with collate PT_PT

78
bugs core 0202

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ORDER BY works wrong with collate PT_PT

79
bugs core 0203

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
CREATE VIEW ignores PLAN

80
bugs core 0203

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW ignores PLAN

81
bugs core 0209

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
CHECK constraints fire twice

82
bugs core 0209

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CHECK constraints fire twice

83
bugs core 0210

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
CS server crash altering SP in 2 connect

84
bugs core 0210

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CS server crash altering SP in 2 connect

85
bugs core 0211

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SELECT...HAVING...NOT IN crashes server

86
bugs core 0211

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SELECT...HAVING...NOT IN crashes server

87
bugs core 0214

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Count ( DISTINCT ... ) is too slow

88
bugs core 0214

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Count ( DISTINCT ... ) is too slow

89
bugs core 0216

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Too many grants lose privileges

90
bugs core 0216

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Too many grants lose privileges

91
bugs core 0223

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTER TABLE altering to VARCHAR

92
bugs core 0223

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER TABLE altering to VARCHAR

93
bugs core 0282

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
DOMAINs don't register their dependency on other objects

94
bugs core 0282

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DOMAINs don't register their dependency on other objects

95
bugs core 0284

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Blob Comparison with constant

96
bugs core 0284

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Blob Comparison with constant

97
bugs core 0297

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
bug #585624 IB server stalled by simple script

98
bugs core 0297

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
bug #585624 IB server stalled by simple script

99
bugs core 0304

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ANY user can drop procedures, generators, exceptions.

100
bugs core 0304

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ANY user can drop procedures, generators, exceptions.

101
bugs core 0335

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unsuccessful execution caused by system error <...> bad BLR -- invalid stream

102
bugs core 0335

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unsuccessful execution caused by system error <...> bad BLR -- invalid stream

103
bugs core 0336

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
DateTime math imprecision

104
bugs core 0336

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DateTime math imprecision

105
bugs core 0337

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
bug #910430 ISQL and database dialect

106
bugs core 0337

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
bug #910430 ISQL and database dialect

107
bugs core 0366

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Complex view crashes server

108
bugs core 0366

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Complex view crashes server

109
bugs core 0389

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
NULLS FIRST does not work with unions

110
bugs core 0389

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
NULLS FIRST does not work with unions

111
bugs core 0405

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Garbage vs indices/constraints

112
bugs core 0405

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Garbage vs indices/constraints

113
bugs core 0426

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong sort order when using es_ES collate

114
bugs core 0426

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong sort order when using es_ES collate

115
bugs core 0461

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
JOIN including a complex view kills the server

116
bugs core 0461

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
JOIN including a complex view kills the server

117
bugs core 0474

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Redundant evaluations in COALESCE

118
bugs core 0474

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Redundant evaluations in COALESCE

119
bugs core 0475

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ORDER BY has no effect

120
bugs core 0475

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ORDER BY has no effect

121
bugs core 0479

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Grants overwrite previous rdb$security_classes entries

122
bugs core 0479

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grants overwrite previous rdb$security_classes entries

123
bugs core 0480

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Foreign key relation VARCHAR <-> INT

124
bugs core 0480

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Foreign key relation VARCHAR <-> INT

125
bugs core 0501

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Lot of syntax tests for COALESCE()

126
bugs core 0501

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Lot of syntax tests for COALESCE()

127
bugs core 0517

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ambiguous statements return unpredictable results

128
bugs core 0517

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ambiguous statements return unpredictable results

129
bugs core 0521

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Permissions are checked case-insensitively

130
bugs core 0521

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Permissions are checked case-insensitively

131
bugs core 0555

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Inconsistent results using STARTING WITH and COALESCE

132
bugs core 0555

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Inconsistent results using STARTING WITH and COALESCE

133
bugs core 0583

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
before triggers are firing after checks

134
bugs core 0583

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
before triggers are firing after checks

135
bugs core 0606

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Tricky role defeats basic SQL security

136
bugs core 0606

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Tricky role defeats basic SQL security

137
bugs core 0610

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
FIRST is applied before aggregation

138
bugs core 0610

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
FIRST is applied before aggregation

139
bugs core 0611

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SKIP is off by one

140
bugs core 0611

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SKIP is off by one

141
bugs core 0623

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ORDER BY on a VIEW turns values in fields into NULL

142
bugs core 0623

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ORDER BY on a VIEW turns values in fields into NULL

143
bugs core 0625

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Token unknown in simple SELECT with GROUP BY and ORDER BY

144
bugs core 0625

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Token unknown in simple SELECT with GROUP BY and ORDER BY

145
bugs core 0629

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Grouping on derived fields processing NULL data kills IB

146
bugs core 0629

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grouping on derived fields processing NULL data kills IB

147
bugs core 0655

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Blob Type 1 compatibility with VarChar

148
bugs core 0655

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Blob Type 1 compatibility with VarChar

149
bugs core 0696

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
User Account maintanance in SQL

150
bugs core 0696

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
User Account maintanance in SQL

151
bugs core 0733

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Compress Data over the Network

152
bugs core 0733

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Compress Data over the Network

153
bugs core 0769

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wildcards/Regular Expressions in WHERE clause - SIMILAR TO predicate

154
bugs core 0769

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Wildcards/Regular Expressions in WHERE clause - SIMILAR TO predicate

155
bugs core 0790

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Alter view

156
bugs core 0790

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Alter view

157
bugs core 0800

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Easy metadata extract improvements

158
bugs core 0800

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Easy metadata extract improvements

159
bugs core 0805

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Privileges of dynamic statements in SP

160
bugs core 0805

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Privileges of dynamic statements in SP

161
bugs core 0824

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
accent ignoring collation for unicode

162
bugs core 0824

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
accent ignoring collation for unicode

163
bugs core 0842

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Specific query crashing server

164
bugs core 0842

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Specific query crashing server

165
bugs core 0847

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
computed field can't be changed to non-computed using 'alter table alter column type xy'

166
bugs core 0847

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
computed field can't be changed to non-computed using 'alter table alter column type xy'

167
bugs core 0850

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
DYN allows to set defaults for computed fields when altering a field

168
bugs core 0850

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DYN allows to set defaults for computed fields when altering a field

169
bugs core 0851

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Field can be used multiple times in multi-segment index definition

170
bugs core 0851

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Field can be used multiple times in multi-segment index definition

171
bugs core 0852

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
substring(current_user from 4) fails

172
bugs core 0852

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
substring(current_user from 4) fails

173
bugs core 0855

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Aggregates in the WHERE clause vs derived tables

174
bugs core 0855

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Aggregates in the WHERE clause vs derived tables

175
bugs core 0856

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unable to set FName, MName, LName fields in security to blank

176
bugs core 0856

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unable to set FName, MName, LName fields in security to blank

177
bugs core 0857

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Containing not working correctly

178
bugs core 0857

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Containing not working correctly

179
bugs core 0858

tracker
CS S S S S S S S S S S S S S S S X S S S S S S S S S S S S S S
Server crash when using UDF

180
bugs core 0858

tracker
SS S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S
Server crash when using UDF

181
bugs core 0866

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Removing a NOT NULL constraint is not visible until reconnect

182
bugs core 0866

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Removing a NOT NULL constraint is not visible until reconnect

183
bugs core 0870

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Engine crashes while trying to backup a logically corrupt db

184
bugs core 0870

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Engine crashes while trying to backup a logically corrupt db

185
bugs core 0871

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect handling of null within view - returns 0

186
bugs core 0871

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect handling of null within view - returns 0

187
bugs core 0878

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
problem when dropping column that is a primary key

188
bugs core 0878

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
problem when dropping column that is a primary key

189
bugs core 0879

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Dependencies are not cleared when creation of expression index fails

190
bugs core 0879

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Dependencies are not cleared when creation of expression index fails

191
bugs core 0881

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Singleton isn't respected in COMPUTED BY expressions

192
bugs core 0881

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Singleton isn't respected in COMPUTED BY expressions

193
bugs core 0883

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
The built-in BLR printer doesn't support all FB2 features

194
bugs core 0883

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The built-in BLR printer doesn't support all FB2 features

195
bugs core 0885

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
It is impossible to take away rights on update of a column

196
bugs core 0885

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
It is impossible to take away rights on update of a column

197
bugs core 0886

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SPs in views

198
bugs core 0886

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SPs in views

199
bugs core 0888

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
DDL - object in use

200
bugs core 0888

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DDL - object in use

201
bugs core 0896

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SUBSTRING with NULL offset or length don't return NULL

202
bugs core 0896

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SUBSTRING with NULL offset or length don't return NULL

203
bugs core 0899

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Problems with explicit cursors in unwanted states

204
bugs core 0899

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problems with explicit cursors in unwanted states

205
bugs core 0903

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
New value of column is accessable before update

206
bugs core 0903

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New value of column is accessable before update

207
bugs core 0907

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server crash on violation of NOT NULL constraint

208
bugs core 0907

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crash on violation of NOT NULL constraint

209
bugs core 0908

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Garbage in plan output of complex statement

210
bugs core 0908

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Garbage in plan output of complex statement

211
bugs core 0924

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
An attempt to select DB_KEY from a procedure crashes the server

212
bugs core 0924

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
An attempt to select DB_KEY from a procedure crashes the server

213
bugs core 0925

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALL predicate works incorrectly for some subqueries

214
bugs core 0925

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALL predicate works incorrectly for some subqueries

215
bugs core 0927

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Grants don't work for procedures used inside views

216
bugs core 0927

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grants don't work for procedures used inside views

217
bugs core 0929

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bug in DSQL parameter

218
bugs core 0929

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bug in DSQL parameter

219
bugs core 0932

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Comment in create database

220
bugs core 0932

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Comment in create database

221
bugs core 0945

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bad error message when tring to create FK to non-existent table

222
bugs core 0945

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad error message when tring to create FK to non-existent table

223
bugs core 0952

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
AV when blob is used in expression index

224
bugs core 0952

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV when blob is used in expression index

225
bugs core 0959

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
GSTAT does not work using the localhost connection string

226
bugs core 0959

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GSTAT does not work using the localhost connection string

227
bugs core 0965

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Many aggregate functions within a single select list may cause a server crash

228
bugs core 0965

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Many aggregate functions within a single select list may cause a server crash

229
bugs core 0967

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SQL with incorrect characters (outside the ASCII range) may be processed wrongly

230
bugs core 0967

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SQL with incorrect characters (outside the ASCII range) may be processed wrongly

231
bugs core 0972

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Case insensitive collation for UTF-8

232
bugs core 0972

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Case insensitive collation for UTF-8

233
bugs core 0979

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Make RDB$DB_KEY in outer joins return NULL when appropriate

234
bugs core 0979

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make RDB$DB_KEY in outer joins return NULL when appropriate

235
bugs core 0986

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset

236
bugs core 0986

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset

237
bugs core 0995

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
select with FIRST and LEFT JOIN needs excess SORT in plan

238
bugs core 0995

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
select with FIRST and LEFT JOIN needs excess SORT in plan

239
bugs core 0996

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Keyword AS not recognized in clause FROM

240
bugs core 0996

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Keyword AS not recognized in clause FROM

241
bugs core 1000

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect results when left join on subquery with constant column

242
bugs core 1000

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect results when left join on subquery with constant column

243
bugs core 1002

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
bad handling of // comments in ISQL

244
bugs core 1002

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
bad handling of // comments in ISQL

245
bugs core 1004

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
context already in use (BLR error)

246
bugs core 1004

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
context already in use (BLR error)

247
bugs core 1005

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
DISTINCT vs NULLS LAST clause: wrong order of NULLs

248
bugs core 1005

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DISTINCT vs NULLS LAST clause: wrong order of NULLs

249
bugs core 1006

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it

250
bugs core 1006

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it

251
bugs core 1009

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Restoring RDB$BASE_FIELD for expression

252
bugs core 1009

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Restoring RDB$BASE_FIELD for expression

253
bugs core 1010

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Local buffer overrun in DYN_error() that takes down the server

254
bugs core 1010

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Local buffer overrun in DYN_error() that takes down the server

255
bugs core 1018

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Provide mechanism to get engine version without needing to call API function

256
bugs core 1018

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Provide mechanism to get engine version without needing to call API function

257
bugs core 1019

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Make information available regading ODS Version and Dialect via SQL

258
bugs core 1019

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make information available regading ODS Version and Dialect via SQL

259
bugs core 1025

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones

260
bugs core 1025

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones

261
bugs core 1026 utf8

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Estonian collation in UTF8 charset

262
bugs core 1026 utf8

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Estonian collation in UTF8 charset

263
bugs core 1029

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)

264
bugs core 1029

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)

265
bugs core 1033

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
like doesn't work for computed values (at least in a view)

266
bugs core 1033

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
like doesn't work for computed values (at least in a view)

267
bugs core 1036

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
extend retutnning support added in ver 2 in update record of table and in updateble view

268
bugs core 1036

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
extend retutnning support added in ver 2 in update record of table and in updateble view

269
bugs core 1040

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong single-segment ascending index on character field with NULL and empty string values

270
bugs core 1040

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong single-segment ascending index on character field with NULL and empty string values

271
bugs core 1055

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong parameter matching for self-referenced procedures

272
bugs core 1055

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Wrong parameter matching for self-referenced procedures

273
bugs core 1056

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
A query could produce different results, depending on the presence of an index

274
bugs core 1056

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
A query could produce different results, depending on the presence of an index

275
bugs core 1058

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation

276
bugs core 1058

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation

277
bugs core 1063

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
Server hangs eating CPU and performs huge I/O copying different codepage fields

278
bugs core 1063

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Server hangs eating CPU and performs huge I/O copying different codepage fields

279
bugs core 1073

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SINGULAR buggy when nulls present

280
bugs core 1073

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SINGULAR buggy when nulls present

281
bugs core 1076

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition

282
bugs core 1076

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition

283
bugs core 1078

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
View with equally named source fields not faisible

284
bugs core 1078

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View with equally named source fields not faisible

285
bugs core 1083

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
User (not SYSDBA) what have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA

286
bugs core 1083

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
User (not SYSDBA) what have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA

287
bugs core 1089

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong ordering with views, distinct, left join and order by

288
bugs core 1089

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong ordering with views, distinct, left join and order by

289
bugs core 1090

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error msg "Could not find UNIQUE INDEX" when in fact one is present

290
bugs core 1090

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error msg "Could not find UNIQUE INDEX" when in fact one is present

291
bugs core 1095

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Support BETWEEN predicate for select expressions

292
bugs core 1095

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Support BETWEEN predicate for select expressions

293
bugs core 1108

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong results with GROUP BY on constants

294
bugs core 1108

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results with GROUP BY on constants

295
bugs core 1112

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Crash when dealing with a string literal longer than 32K

296
bugs core 1112

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Crash when dealing with a string literal longer than 32K

297
bugs core 1117

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Remove or extend limit of command text length (64K)

298
bugs core 1117

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Remove or extend limit of command text length (64K)

299
bugs core 1120

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Conversion from string to number is not standard compliant

300
bugs core 1120

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Conversion from string to number is not standard compliant

301
bugs core 1122

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Recursive Query bug in FB2.1

302
bugs core 1122

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Recursive Query bug in FB2.1

303
bugs core 1126

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
UNION vs UTF8 literals : arithmetic exception is thrown

304
bugs core 1126

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UNION vs UTF8 literals : arithmetic exception is thrown

305
bugs core 1130

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bad optimization -- <procedure> left join <subquery> (or <view>)

306
bugs core 1130

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad optimization -- <procedure> left join <subquery> (or <view>)

307
bugs core 1142

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Cannot alter generator's comment to the same value

308
bugs core 1142

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cannot alter generator's comment to the same value

309
bugs core 1145

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server locks up while attempting to commit a deletion of an expression index

310
bugs core 1145

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server locks up while attempting to commit a deletion of an expression index

311
bugs core 1146

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
AV in rse\invalidate_child_rpbs for recursive queies

312
bugs core 1146

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV in rse\invalidate_child_rpbs for recursive queies

313
bugs core 1148

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Every user can view server log using services API

314
bugs core 1148

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Every user can view server log using services API

315
bugs core 1150

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error conversion error from string " " using outer join on int64 and int fields

316
bugs core 1150

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error conversion error from string " " using outer join on int64 and int fields

317
bugs core 1152

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
cannot erase a table with check constraints referencing more than a single columns

318
bugs core 1152

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
cannot erase a table with check constraints referencing more than a single columns

319
bugs core 1153

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Activating index change "STARTING" working as "LIKE" in join condition

320
bugs core 1153

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Activating index change "STARTING" working as "LIKE" in join condition

321
bugs core 1156

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Prepare fails when having a parameter in a DSQL statement before a sub query

322
bugs core 1156

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Prepare fails when having a parameter in a DSQL statement before a sub query

323
bugs core 1162

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Problem altering numeric field type

324
bugs core 1162

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem altering numeric field type

325
bugs core 1165

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL

326
bugs core 1165

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL

327
bugs core 1167

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
CHARACTER SET GBK is not installed

328
bugs core 1167

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CHARACTER SET GBK is not installed

329
bugs core 1171

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
isql exponential format of numbers has zero pad on windows

330
bugs core 1171

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql exponential format of numbers has zero pad on windows

331
bugs core 1172

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Symbols ignored for ES_ES_CI_AI collation

332
bugs core 1172

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Symbols ignored for ES_ES_CI_AI collation

333
bugs core 1173

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Expression index based on computed fields

334
bugs core 1173

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression index based on computed fields

335
bugs core 1175

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference

336
bugs core 1175

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference

337
bugs core 1179

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
"CH" and "LL" are not separate spanish alphabet letters since 1994

338
bugs core 1179

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"CH" and "LL" are not separate spanish alphabet letters since 1994

339
bugs core 1181

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Union returns inconsistent field names

340
bugs core 1181

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Union returns inconsistent field names

341
bugs core 1183

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference

342
bugs core 1183

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference

343
bugs core 1188

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Select Starting with :Param (Empty string) doesn't work if using index with many fields

344
bugs core 1188

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Select Starting with :Param (Empty string) doesn't work if using index with many fields

345
bugs core 1196

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Long SQL statements break TCP/IP connection

346
bugs core 1196

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Long SQL statements break TCP/IP connection

347
bugs core 1213

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
CURRENT OF support views

348
bugs core 1213

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CURRENT OF support views

349
bugs core 1215

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong SELECT query results using index to evaluate >= condition

350
bugs core 1215

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong SELECT query results using index to evaluate >= condition

351
bugs core 1227

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
LIST() function seems not work if used twice or more in a query

352
bugs core 1227

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIST() function seems not work if used twice or more in a query

353
bugs core 1244

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server crash on select * from <recursive CTE>

354
bugs core 1244

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crash on select * from <recursive CTE>

355
bugs core 1245

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect column values with outer joins and views

356
bugs core 1245

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Incorrect column values with outer joins and views

357
bugs core 1246

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect column values with outer joins and derived tables

358
bugs core 1246

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect column values with outer joins and derived tables

359
bugs core 1248

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect timestamp arithmetic when one of operands is negative number

360
bugs core 1248

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect timestamp arithmetic when one of operands is negative number

361
bugs core 1249

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Full shutdown mode doesn't work on Classic if there are other connections to the database

362
bugs core 1249

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Full shutdown mode doesn't work on Classic if there are other connections to the database

363
bugs core 1253

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
LIST(DISTINCT) concatenate VARCHAR values as CHAR

364
bugs core 1253

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIST(DISTINCT) concatenate VARCHAR values as CHAR

365
bugs core 1254

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Problem with DISTINCT and insensitive collations

366
bugs core 1254

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with DISTINCT and insensitive collations

367
bugs core 1255

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
String truncation error when concatenating _UTF8 string onto extract(year result

368
bugs core 1255

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
String truncation error when concatenating _UTF8 string onto extract(year result

369
bugs core 1256

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Table columns hide destination variables of RETURNING INTO

370
bugs core 1256

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Table columns hide destination variables of RETURNING INTO

371
bugs core 1263

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
GSec incorrectly processes some switches

372
bugs core 1263

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GSec incorrectly processes some switches

373
bugs core 1267

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Small bug with default value for domains in PSQL

374
bugs core 1267

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Small bug with default value for domains in PSQL

375
bugs core 1271

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Ceation of invalid procedures/triggers allowed

376
bugs core 1271

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Ceation of invalid procedures/triggers allowed

377
bugs core 1274

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different

378
bugs core 1274

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different

379
bugs core 1286

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bug with COMPUTED BY fields

380
bugs core 1286

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bug with COMPUTED BY fields

381
bugs core 1291

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)

382
bugs core 1291

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)

383
bugs core 1292

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Can't create table using long username and UTF8 as attachment charset

384
bugs core 1292

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Can't create table using long username and UTF8 as attachment charset

385
bugs core 1295

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bad optimization of queries with DB_KEY

386
bugs core 1295

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad optimization of queries with DB_KEY

387
bugs core 1306

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Indices not used for views

388
bugs core 1306

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Indices not used for views

389
bugs core 1312

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
A remote attacker can check, if a file is present in the system, running firebird server

390
bugs core 1312

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
A remote attacker can check, if a file is present in the system, running firebird server

391
bugs core 1313

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
RDB$DB_KEY not supported in derived tables and merge command

392
bugs core 1313

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$DB_KEY not supported in derived tables and merge command

393
bugs core 1315

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Data type unknown

394
bugs core 1315

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Data type unknown

395
bugs core 1316

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
NOT NULL constraint for procedure parameters and variables

396
bugs core 1316

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
NOT NULL constraint for procedure parameters and variables

397
bugs core 1318

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error "Identifier ... is too long using multiple (nested) derived tables

398
bugs core 1318

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "Identifier ... is too long using multiple (nested) derived tables

399
bugs core 1329

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
size of alias name in a table

400
bugs core 1329

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
size of alias name in a table

401
bugs core 1331

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
Charset transliterations don't work with EXECUTE STATEMENT

402
bugs core 1331

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Charset transliterations don't work with EXECUTE STATEMENT

403
bugs core 1334

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Joins with NULL RDB$DB_KEY crash the server

404
bugs core 1334

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Joins with NULL RDB$DB_KEY crash the server

405
bugs core 1338

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Problem with view , computed field and functions

406
bugs core 1338

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with view , computed field and functions

407
bugs core 1343

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bug with a simple case and a subquery

408
bugs core 1343

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bug with a simple case and a subquery

409
bugs core 1346

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
lpad and rpad with two columns not working

410
bugs core 1346

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
lpad and rpad with two columns not working

411
bugs core 1347

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unexpected "cannot transliterate" error

412
bugs core 1347

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unexpected "cannot transliterate" error

413
bugs core 1356

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
TYPE OF COLUMN in PSQL

414
bugs core 1356

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
TYPE OF COLUMN in PSQL

415
bugs core 1361

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Index operations for global temporary tables are not visible for the active connection

416
bugs core 1361

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Index operations for global temporary tables are not visible for the active connection

417
bugs core 1362

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Too large numbers cause positive infinity to be inserted into database

418
bugs core 1362

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Too large numbers cause positive infinity to be inserted into database

419
bugs core 1363

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ISQL crash when converted-from-double string longer than 23 bytes

420
bugs core 1363

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ISQL crash when converted-from-double string longer than 23 bytes

421
bugs core 1366

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
French insensitive collation FR_FR_CI_AI

422
bugs core 1366

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
French insensitive collation FR_FR_CI_AI

423
bugs core 1371

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Execute block fails within execute statement

424
bugs core 1371

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Execute block fails within execute statement

425
bugs core 1373

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields

426
bugs core 1373

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields

427
bugs core 1377

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Add an ability to change role without reconnecting to database.

428
bugs core 1377

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Add an ability to change role without reconnecting to database.

429
bugs core 1378

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Domain names and charset issues

430
bugs core 1378

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Domain names and charset issues

431
bugs core 1379

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Invalid parameter type when using it in CHAR_LENGTH function

432
bugs core 1379

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Invalid parameter type when using it in CHAR_LENGTH function

433
bugs core 1384

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1

434
bugs core 1384

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIKE doesn't work correctly with collations using SPECIALS-FIRST=1

435
bugs core 1386

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Generated columns

436
bugs core 1386

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Generated columns

437
bugs core 1389

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Indexed MIN/MAX aggregates produce three index reads instead of the expected one indexed read

438
bugs core 1389

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Indexed MIN/MAX aggregates produce three index reads instead of the expected one indexed read

439
bugs core 1395

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Few problems with domains's check constraints

440
bugs core 1395

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Few problems with domains's check constraints

441
bugs core 1401

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Global temporary table instance may pick up not all indices

442
bugs core 1401

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Global temporary table instance may pick up not all indices

443
bugs core 1402

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
CREATE VIEW without column list when UNION is used

444
bugs core 1402

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW without column list when UNION is used

445
bugs core 1409

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Support for autonomous transactions

446
bugs core 1409

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support for autonomous transactions

447
bugs core 1419

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong current timestamp evaluation for selectable procedures

448
bugs core 1419

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong current timestamp evaluation for selectable procedures

449
bugs core 1428

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect timestamp substraction in 3 dialect when result is negative number

450
bugs core 1428

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect timestamp substraction in 3 dialect when result is negative number

451
bugs core 1431

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Greek characters in cp1251 vs uppercasing

452
bugs core 1431

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Greek characters in cp1251 vs uppercasing

453
bugs core 1432

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Collation not propagated between record formats

454
bugs core 1432

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Collation not propagated between record formats

455
bugs core 1434

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect result with EXECUTE STATEMENT and VARCHAR columns

456
bugs core 1434

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result with EXECUTE STATEMENT and VARCHAR columns

457
bugs core 1436

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Outer joins don't work properly with the MON$ tables

458
bugs core 1436

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer joins don't work properly with the MON$ tables

459
bugs core 1444

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Execute statement 'select ....' into new....

460
bugs core 1444

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Execute statement 'select ....' into new....

461
bugs core 1451

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Using RDB$DB_KEY in where section while selecting from a procedure crashes the server

462
bugs core 1451

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Using RDB$DB_KEY in where section while selecting from a procedure crashes the server

463
bugs core 1453

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Allow usage of functions in LIST delimiter parameter

464
bugs core 1453

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow usage of functions in LIST delimiter parameter

465
bugs core 1454

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTER mechanism for computed fields

466
bugs core 1454

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER mechanism for computed fields

467
bugs core 1462

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server crash caused by a buffer overrun in the optimizer when more than 255 relation references exist in the query

468
bugs core 1462

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crash caused by a buffer overrun in the optimizer when more than 255 relation references exist in the query

469
bugs core 1482

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Make optimizer to consider ORDER BY optimization when making decision about join order

470
bugs core 1482

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Make optimizer to consider ORDER BY optimization when making decision about join order

471
bugs core 1489

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
DATEADD wrong work with NULL arguments

472
bugs core 1489

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DATEADD wrong work with NULL arguments

473
bugs core 1492

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
BLOB isn't compatible with [VAR]CHAR in COALESCE

474
bugs core 1492

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
BLOB isn't compatible with [VAR]CHAR in COALESCE

475
bugs core 1497

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax

476
bugs core 1497

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax

477
bugs core 1506

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server crash with isc_dsql_execute_immediate and zero length string

478
bugs core 1506

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crash with isc_dsql_execute_immediate and zero length string

479
bugs core 1509

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Conversion from double to varchar insert trailing spaces

480
bugs core 1509

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Conversion from double to varchar insert trailing spaces

481
bugs core 1510

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bad XSQLVAR [NULL flags] for (2COALESCE(NULL,NULL))

482
bugs core 1510

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bad XSQLVAR [NULL flags] for (2COALESCE(NULL,NULL))

483
bugs core 1511

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
POSITION(string_exp1, string_exp2 [, start])

484
bugs core 1511

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
POSITION(string_exp1, string_exp2 [, start])

485
bugs core 1512

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Connection lost running script

486
bugs core 1512

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Connection lost running script

487
bugs core 1514

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Many new 2.1 built in functions have incorrect NULL semantics

488
bugs core 1514

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Many new 2.1 built in functions have incorrect NULL semantics

489
bugs core 1518

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Adding a non-null restricted column to a populated table renders the table inconsistent

490
bugs core 1518

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Adding a non-null restricted column to a populated table renders the table inconsistent

491
bugs core 1522

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Inconsistent DATEDIFF behaviour

492
bugs core 1522

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Inconsistent DATEDIFF behaviour

493
bugs core 1525

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Computed field + index not working in WHERE

494
bugs core 1525

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Computed field + index not working in WHERE

495
bugs core 1528

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Functions DATEDIFF does not work in dialect 1

496
bugs core 1528

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Functions DATEDIFF does not work in dialect 1

497
bugs core 1533

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
JOIN on first record of ordered derived table returns wrong record

498
bugs core 1533

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
JOIN on first record of ordered derived table returns wrong record

499
bugs core 1539

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'

500
bugs core 1539

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
select * from rdb$triggers where rdb$trigger_source like 'CHECK%'

501
bugs core 1544

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
RDB$procedures generator overflow

502
bugs core 1544

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$procedures generator overflow

503
bugs core 1549

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Subquery-based predicates are not evaluated early in the join order

504
bugs core 1549

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Subquery-based predicates are not evaluated early in the join order

505
bugs core 1550

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses

506
bugs core 1550

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses

507
bugs core 1550 postfix

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses

508
bugs core 1550 postfix

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses

509
bugs core 1551

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
AV when all statements are cancelled

510
bugs core 1551

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV when all statements are cancelled

511
bugs core 1554

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
select ... where ... <> ALL (select ... join ...) bug

512
bugs core 1554

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
select ... where ... <> ALL (select ... join ...) bug

513
bugs core 1555

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
'select ...from...where...not in (select...from...)' no results

514
bugs core 1555

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
'select ...from...where...not in (select...from...)' no results

515
bugs core 1559

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Dropping NOT NULL contranint doesn'have the desired effect

516
bugs core 1559

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Dropping NOT NULL contranint doesn'have the desired effect

517
bugs core 1560

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
NULLIF crashes when first parameter is constant empty string

518
bugs core 1560

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
NULLIF crashes when first parameter is constant empty string

519
bugs core 1572

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Multiple Rows in Singleton Select not reported in a View

520
bugs core 1572

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Multiple Rows in Singleton Select not reported in a View

521
bugs core 1582

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ABS() rounds NUMERIC values

522
bugs core 1582

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ABS() rounds NUMERIC values

523
bugs core 1584

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server crashed or bugcheck when inserting in monitoring tables.

524
bugs core 1584

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashed or bugcheck when inserting in monitoring tables.

525
bugs core 1592

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Altering procedure parameters can lead to unrestorable database

526
bugs core 1592

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Altering procedure parameters can lead to unrestorable database

527
bugs core 1605

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bugcheck 232 (invalid operation) for an aggregated query

528
bugs core 1605

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 232 (invalid operation) for an aggregated query

529
bugs core 1606

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Ability to insert child record if parent record is locked but foreign key target unchanged

530
bugs core 1606

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Ability to insert child record if parent record is locked but foreign key target unchanged

531
bugs core 1607

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Correlated subquery is optimized badly if it depends on the union stream

532
bugs core 1607

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Correlated subquery is optimized badly if it depends on the union stream

533
bugs core 1609

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
PSQL output parameter size limited

534
bugs core 1609

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
PSQL output parameter size limited

535
bugs core 1619

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Some aggregate functions does NOT support NULL-constant in 3-d dialect

536
bugs core 1619

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Some aggregate functions does NOT support NULL-constant in 3-d dialect

537
bugs core 1620

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect error message (column number) if the empty SQL string is prepared

538
bugs core 1620

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect error message (column number) if the empty SQL string is prepared

539
bugs core 1624

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
MERGE not correctly worked with parameters in MATCHING clause

540
bugs core 1624

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
MERGE not correctly worked with parameters in MATCHING clause

541
bugs core 1640

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Create or Alter view

542
bugs core 1640

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Create or Alter view

543
bugs core 1642

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Non-privileged monitoring reports wrong attachment data

544
bugs core 1642

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Non-privileged monitoring reports wrong attachment data

545
bugs core 1649

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
AV when recursive query used MERGE JOIN in execution plan

546
bugs core 1649

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV when recursive query used MERGE JOIN in execution plan

547
bugs core 1650

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Infinite row generation in "select gen_id(..) from rdb$database" with "group by"

548
bugs core 1650

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Infinite row generation in "select gen_id(..) from rdb$database" with "group by"

549
bugs core 1656

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Ability to format UUID from char(16) OCTETS to human readable form and vice versa

550
bugs core 1656

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Ability to format UUID from char(16) OCTETS to human readable form and vice versa

551
bugs core 1677

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Floor & ceiling functions give wrong results with exact numeric arguments

552
bugs core 1677

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Floor & ceiling functions give wrong results with exact numeric arguments

553
bugs core 1689

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
'There are <n> dependencies' error message shows the wrong count of dependent objects.

554
bugs core 1689

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
'There are <n> dependencies' error message shows the wrong count of dependent objects.

555
bugs core 1690

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
arithmetic exception, numeric overflow, or string truncation in utf8 tables

556
bugs core 1690

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
arithmetic exception, numeric overflow, or string truncation in utf8 tables

557
bugs core 1693

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers

558
bugs core 1693

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers

559
bugs core 1694

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bug in create/alter Database trigger (with Russian comment)

560
bugs core 1694

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bug in create/alter Database trigger (with Russian comment)

561
bugs core 1712

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Buffer overflow in conversion

562
bugs core 1712

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Buffer overflow in conversion

563
bugs core 1715

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect "key size exceeds implementation restriction for index" error

564
bugs core 1715

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect "key size exceeds implementation restriction for index" error

565
bugs core 1716

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong variable initialization in recursive procedures

566
bugs core 1716

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong variable initialization in recursive procedures

567
bugs core 1724

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Common table expressions cannot be used in computed columns and quantified predicates (IN / ANY / ALL)

568
bugs core 1724

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Common table expressions cannot be used in computed columns and quantified predicates (IN / ANY / ALL)

569
bugs core 1725

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan

570
bugs core 1725

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unable to restore a database with inactive indices if any SP/trigger contains an explicit plan

571
bugs core 1735

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bug in SET DEFAULT statement

572
bugs core 1735

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bug in SET DEFAULT statement

573
bugs core 1746

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Expression index can be created while doing inserts into table

574
bugs core 1746

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression index can be created while doing inserts into table

575
bugs core 1749

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
DDL statement with AUTODDL ON won't show statistics

576
bugs core 1749

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DDL statement with AUTODDL ON won't show statistics

577
bugs core 1750

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Include information about context variables into the monitoring tables

578
bugs core 1750

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Include information about context variables into the monitoring tables

579
bugs core 1752

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
Results of a join with different collations depend on the execution plan

580
bugs core 1752

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Results of a join with different collations depend on the execution plan

581
bugs core 1760

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Support hex numeric and string literals

582
bugs core 1760

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support hex numeric and string literals

583
bugs core 1774

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Problem with COLLATE ES_ES_CI_AI

584
bugs core 1774

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with COLLATE ES_ES_CI_AI

585
bugs core 1782

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ISQL crashes when fetching data for a column having alias longer than 30 characters

586
bugs core 1782

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ISQL crashes when fetching data for a column having alias longer than 30 characters

587
bugs core 1784

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT

588
bugs core 1784

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT

589
bugs core 1787

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Consistency check when subquery is ordered by aggregate function from other context

590
bugs core 1787

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Consistency check when subquery is ordered by aggregate function from other context

591
bugs core 1793

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
AV at prepare of query with unused parametrized CTE

592
bugs core 1793

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV at prepare of query with unused parametrized CTE

593
bugs core 1795

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server crashes on SQL script

594
bugs core 1795

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes on SQL script

595
bugs core 1797

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
OLD/NEW.RDB$DB_KEY returns incorrect result in triggers

596
bugs core 1797

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
OLD/NEW.RDB$DB_KEY returns incorrect result in triggers

597
bugs core 1798

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
RDB$DB_KEY evaluates to NULL in INSERT ... RETURNING

598
bugs core 1798

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$DB_KEY evaluates to NULL in INSERT ... RETURNING

599
bugs core 1802

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Maximum key size using PXW_CSY collation

600
bugs core 1802

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Maximum key size using PXW_CSY collation

601
bugs core 1810

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Usernames with '.' character

602
bugs core 1810

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Usernames with '.' character

603
bugs core 1811

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect parser's reaction to the unquoted usage of the keyword "VALUE"

604
bugs core 1811

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Incorrect parser's reaction to the unquoted usage of the keyword "VALUE"

605
bugs core 1812

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Index is not used for some date/time expressions in dialect 1

606
bugs core 1812

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Index is not used for some date/time expressions in dialect 1

607
bugs core 1815

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Ability to grant role to another role

608
bugs core 1815

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Ability to grant role to another role

609
bugs core 1828

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error with ABS in dialect 1

610
bugs core 1828

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error with ABS in dialect 1

611
bugs core 1830

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Possible index corruption with multiply updates of the same record in the same transaction and using of savepoints

612
bugs core 1830

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Possible index corruption with multiply updates of the same record in the same transaction and using of savepoints

613
bugs core 1837

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Procedure text is stored truncated in system tables if any variable have default value

614
bugs core 1837

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Procedure text is stored truncated in system tables if any variable have default value

615
bugs core 1839

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
AV when sorting by field, calculated using recursive CTE

616
bugs core 1839

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
AV when sorting by field, calculated using recursive CTE

617
bugs core 1841

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
If some VIEW used derived tables and long table namesliases, It is possible to overflow RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME

618
bugs core 1841

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
If some VIEW used derived tables and long table namesliases, It is possible to overflow RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME

619
bugs core 1842

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
DEFAULT values are unnecessary evaluated

620
bugs core 1842

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DEFAULT values are unnecessary evaluated

621
bugs core 1845

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Some standard calls show server installation directory to regular users

622
bugs core 1845

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Some standard calls show server installation directory to regular users

623
bugs core 1846

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Allow index walk (ORDER plan) when there is a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B

624
bugs core 1846

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow index walk (ORDER plan) when there is a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B

625
bugs core 1859

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Arithmetic overflow or division by zero has occurred. in MAX function

626
bugs core 1859

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Arithmetic overflow or division by zero has occurred. in MAX function

627
bugs core 1865

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
BLR error on restore database with computed by Field

628
bugs core 1865

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
BLR error on restore database with computed by Field

629
bugs core 1869

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Roles granting/revoking logic

630
bugs core 1869

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Roles granting/revoking logic

631
bugs core 1875

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error on script with current_date

632
bugs core 1875

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error on script with current_date

633
bugs core 1885

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
CREATE COLLATION connection lost under Posix

634
bugs core 1885

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE COLLATION connection lost under Posix

635
bugs core 1891

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SHOW VIEW shows non-sense information for view fields with expressions

636
bugs core 1891

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SHOW VIEW shows non-sense information for view fields with expressions

637
bugs core 1894

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Circular dependencies between computed fields crashs the engine

638
bugs core 1894

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Circular dependencies between computed fields crashs the engine

639
bugs core 1907

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Dropping and adding a domain constraint in the same transaction leaves incorrect dependencies

640
bugs core 1907

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Dropping and adding a domain constraint in the same transaction leaves incorrect dependencies

641
bugs core 1910

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Not valid fields in MERGE's insert clause are allowed

642
bugs core 1910

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Not valid fields in MERGE's insert clause are allowed

643
bugs core 1926

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
MON$DATABASE returns outdated transaction counters

644
bugs core 1926

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
MON$DATABASE returns outdated transaction counters

645
bugs core 1930

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled

646
bugs core 1930

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled

647
bugs core 1935

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SIMILAR TO character classes are incorrectly recognized

648
bugs core 1935

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO character classes are incorrectly recognized

649
bugs core 1936

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
The log(base, number) built-in function doesn't check parameters and delivers NAN values instead.

650
bugs core 1936

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The log(base, number) built-in function doesn't check parameters and delivers NAN values instead.

651
bugs core 1943

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
GROUP BY RAND() returns infinite rows

652
bugs core 1943

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GROUP BY RAND() returns infinite rows

653
bugs core 1945

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Custom attribute for collation to sort numbers in numeric order

654
bugs core 1945

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Custom attribute for collation to sort numbers in numeric order

655
bugs core 195

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bugcheck 291

656
bugs core 195

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 291

657
bugs core 1962

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect extraction of MILLISECONDs

658
bugs core 1962

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect extraction of MILLISECONDs

659
bugs core 1971

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Set the fixed and documented check order for WHERE clause and other conditional sentences

660
bugs core 1971

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Set the fixed and documented check order for WHERE clause and other conditional sentences

661
bugs core 1972

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Non-SYSDBA user can change FW mode of database.

662
bugs core 1972

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Non-SYSDBA user can change FW mode of database.

663
bugs core 1986

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Altering domains name drops dependencies using the domain

664
bugs core 1986

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Altering domains name drops dependencies using the domain

665
bugs core 1989

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
UTF8 UNICODE_CI collate can?t be used in foreing key constraint

666
bugs core 1989

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UTF8 UNICODE_CI collate can?t be used in foreing key constraint

667
bugs core 1992

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
bad BLR -- invalid stream for union select

668
bugs core 1992

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
bad BLR -- invalid stream for union select

669
bugs core 1997

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Broken foreign key handling for multi-segmented index using multi-level collations

670
bugs core 1997

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Broken foreign key handling for multi-segmented index using multi-level collations

671
bugs core 1999

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
TimeStamp in the every line output gbak.exe utility

672
bugs core 1999

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
TimeStamp in the every line output gbak.exe utility

673
bugs core 2001

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user

674
bugs core 2001

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
When trying to show "conversion error", "arithmetic exception/string truncation" may appear instead, misleading the user

675
bugs core 2004

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTER USER XXX INACTIVE

676
bugs core 2004

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
ALTER USER XXX INACTIVE

677
bugs core 2005

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Support SQL 2008 syntax for MERGE statement with DELETE extension

678
bugs core 2005

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support SQL 2008 syntax for MERGE statement with DELETE extension

679
bugs core 2006

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SUBSTRING with regular expression (SIMILAR TO) capability

680
bugs core 2006

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
SUBSTRING with regular expression (SIMILAR TO) capability

681
bugs core 2008

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
NOT NULL procedure parameters

682
bugs core 2008

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
NOT NULL procedure parameters

683
bugs core 2017

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
I/O statistics for stored procedures are not accounted in monitoring tables

684
bugs core 2017

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
I/O statistics for stored procedures are not accounted in monitoring tables

685
bugs core 2018

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Only one client can access a readonly database

686
bugs core 2018

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Only one client can access a readonly database

687
bugs core 2019

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
UTF-8 conversion error (string truncation)

688
bugs core 2019

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UTF-8 conversion error (string truncation)

689
bugs core 2022

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
"EXECUTE BLOCK" statement does not support "CREATE USER"

690
bugs core 2022

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"EXECUTE BLOCK" statement does not support "CREATE USER"

691
bugs core 2026

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Problem with a read-only marked database

692
bugs core 2026

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with a read-only marked database

693
bugs core 2027

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect buffer size for ORDER BY expression with system fields

694
bugs core 2027

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect buffer size for ORDER BY expression with system fields

695
bugs core 2031

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Null in the first record in a condition on rdb$db_key

696
bugs core 2031

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Null in the first record in a condition on rdb$db_key

697
bugs core 2032

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Stored procedure recursively called by calculated field fails after reconnect

698
bugs core 2032

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Stored procedure recursively called by calculated field fails after reconnect

699
bugs core 2036

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT

700
bugs core 2036

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parameters order of EXECUTE BLOCK statement is reversed if called from EXECUTE STATEMENT

701
bugs core 2038

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining

702
bugs core 2038

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New EXECUTE STATEMENT implementation asserts or throws an error if used both before and after commin/rollback retaining

703
bugs core 2039

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Domain-level CHECK constraints wrongly process NULL values

704
bugs core 2039

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Domain-level CHECK constraints wrongly process NULL values

705
bugs core 2041

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
update or insert with gen_id() with wrong generator value

706
bugs core 2041

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
update or insert with gen_id() with wrong generator value

707
bugs core 2042

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
connection lost to database when used AUTONOMOUS TRANSACTION

708
bugs core 2042

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
connection lost to database when used AUTONOMOUS TRANSACTION

709
bugs core 2044

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns

710
bugs core 2044

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns

711
bugs core 2051

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
don't work subquery in COALESCE

712
bugs core 2051

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
don't work subquery in COALESCE

713
bugs core 2053

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Computed expressions may be optimized badly if used inside the RETURNING clause of the INSERT statement

714
bugs core 2053

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Computed expressions may be optimized badly if used inside the RETURNING clause of the INSERT statement

715
bugs core 2061

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTER VIEW WITH CHECK OPTION crashes the engin

716
bugs core 2061

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER VIEW WITH CHECK OPTION crashes the engin

717
bugs core 2067

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
GROUP by and RDB$DB_KEY problems

718
bugs core 2067

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
GROUP by and RDB$DB_KEY problems

719
bugs core 2068

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Comparision with IN and subquery with RDB$DB_KEY returns wrong result

720
bugs core 2068

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Comparision with IN and subquery with RDB$DB_KEY returns wrong result

721
bugs core 2069

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect VIEW expansion when RDB$DB_KEY is used in view body

722
bugs core 2069

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect VIEW expansion when RDB$DB_KEY is used in view body

723
bugs core 2073

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Expression indexes bug: incorrect result for the inverted boolean

724
bugs core 2073

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression indexes bug: incorrect result for the inverted boolean

725
bugs core 2075

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Parts of RDB$DB_KEY of views may be inverted when using outer joins

726
bugs core 2075

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Parts of RDB$DB_KEY of views may be inverted when using outer joins

727
bugs core 2078

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
Suboptimal join plan if there are selective non-indexed predicates involved

728
bugs core 2078

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Suboptimal join plan if there are selective non-indexed predicates involved

729
bugs core 2081

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
RDB$DB_KEY in subselect expression incorrectly returns NULL

730
bugs core 2081

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$DB_KEY in subselect expression incorrectly returns NULL

731
bugs core 2098

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
View over global temporary table

732
bugs core 2098

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View over global temporary table

733
bugs core 2101

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor

734
bugs core 2101

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor

735
bugs core 2115

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Query plan is missing for the long query

736
bugs core 2115

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Query plan is missing for the long query

737
bugs core 2117

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect ROW_COUNT value with indexed retrieval and subquery

738
bugs core 2117

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect ROW_COUNT value with indexed retrieval and subquery

739
bugs core 2118

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record

740
bugs core 2118

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UPDATE OR INSERT with subquery used in the MATCHING part doesn't insert record

741
bugs core 2132

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate

742
bugs core 2132

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Indexed retrieval cannot be chosen if a stored procedure is used inside the comparison predicate

743
bugs core 2140

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error messages after parameters substitution contains '8' characters instead of line break

744
bugs core 2140

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error messages after parameters substitution contains '8' characters instead of line break

745
bugs core 2153

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SIMILAR TO predicate hangs with "|" option

746
bugs core 2153

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO predicate hangs with "|" option

747
bugs core 2155

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Join of SP with view or table may fail with "No current record for fetch operation"

748
bugs core 2155

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Join of SP with view or table may fail with "No current record for fetch operation"

749
bugs core 2164

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
error in operator "and" in as clausule where

750
bugs core 2164

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
error in operator "and" in as clausule where

751
bugs core 2176

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unexpected (wrong) results with COALESCE and GROUP BY

752
bugs core 2176

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unexpected (wrong) results with COALESCE and GROUP BY

753
bugs core 2192

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Extend maximum database page size to 32KB

754
bugs core 2192

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Extend maximum database page size to 32KB

755
bugs core 2197

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Add support for -nodbtriggers switch in gbak into services API

756
bugs core 2197

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Add support for -nodbtriggers switch in gbak into services API

757
bugs core 2200

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Extremely slow executing a cross join of 3 tables in Firebird 2.X

758
bugs core 2200

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Extremely slow executing a cross join of 3 tables in Firebird 2.X

759
bugs core 2202

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
RDB$VIEW_RELATIONS is not cleaned when altering a view

760
bugs core 2202

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RDB$VIEW_RELATIONS is not cleaned when altering a view

761
bugs core 2204

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
constraints on sp output parameters are checked even when the sp returns zero rows

762
bugs core 2204

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
constraints on sp output parameters are checked even when the sp returns zero rows

763
bugs core 2208

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
New gbak option to ignore specific tables data during the backup

764
bugs core 2208

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
New gbak option to ignore specific tables data during the backup

765
bugs core 2211

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Offset value for SUBSTRING from BLOB more than 32767 makes exception

766
bugs core 2211

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Offset value for SUBSTRING from BLOB more than 32767 makes exception

767
bugs core 2215

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
GROUP BY concatenation with empty string

768
bugs core 2215

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GROUP BY concatenation with empty string

769
bugs core 2216

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Nbackup as online dump

770
bugs core 2216

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Nbackup as online dump

771
bugs core 2227

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Problem with column names with Accents and triggers

772
bugs core 2227

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with column names with Accents and triggers

773
bugs core 2230

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Implement domain check of input parameters of execute block

774
bugs core 2230

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Implement domain check of input parameters of execute block

775
bugs core 2233

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well

776
bugs core 2233

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow non-SYSDBA users to monitor not only their current attachment but other their attachments as well

777
bugs core 2238

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.

778
bugs core 2238

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UTF8 and large varchar fields, is disinct from > Implementation limit exceeded.

779
bugs core 2251

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
gbak doesn't return error code

780
bugs core 2251

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
gbak doesn't return error code

781
bugs core 2252

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
EXECUTE STATEMENT on EXTERNAL SOURCE does not check the status of the transaction

782
bugs core 2252

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EXECUTE STATEMENT on EXTERNAL SOURCE does not check the status of the transaction

783
bugs core 2255

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
'...exception...string right truncation' when alter view with join

784
bugs core 2255

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
'...exception...string right truncation' when alter view with join

785
bugs core 2257

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
internal Firebird consistency check when alter dependent procedures

786
bugs core 2257

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
internal Firebird consistency check when alter dependent procedures

787
bugs core 2258

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
internal error when select upper(<blob>) from union

788
bugs core 2258

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
internal error when select upper(<blob>) from union

789
bugs core 2264

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTER DOMAIN with dependencies may leave a transaction handle in inconsistent state causing segmentation faults

790
bugs core 2264

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER DOMAIN with dependencies may leave a transaction handle in inconsistent state causing segmentation faults

791
bugs core 2265

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Grouping by function doesn't work properly

792
bugs core 2265

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grouping by function doesn't work properly

793
bugs core 2268

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
GFIX causes BUGCHECK errors with non valid transaction numbers

794
bugs core 2268

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GFIX causes BUGCHECK errors with non valid transaction numbers

795
bugs core 2274

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
MERGE non-standard behaviour, accepts multiple matches

796
bugs core 2274

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
MERGE non-standard behaviour, accepts multiple matches

797
bugs core 2284

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Records left in RDB$PAGES after rollback of CREATE TABLE statement

798
bugs core 2284

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Records left in RDB$PAGES after rollback of CREATE TABLE statement

799
bugs core 2289

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong (primary) constraint name is reported for the foreign key violation during FK creation

800
bugs core 2289

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong (primary) constraint name is reported for the foreign key violation during FK creation

801
bugs core 2291

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)

802
bugs core 2291

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
BUGCHECK 284 (cannot restore singleton select data (284), file: rse.cpp ...)

803
bugs core 2293

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong dependent object type (RELATION) in RDB$DEPEDENCIES for VIEW's

804
bugs core 2293

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong dependent object type (RELATION) in RDB$DEPEDENCIES for VIEW's

805
bugs core 2300

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unexpected error "arithmetic exception, numeric overflow, or string truncation" while evaluating SUBSTRING the second time

806
bugs core 2300

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unexpected error "arithmetic exception, numeric overflow, or string truncation" while evaluating SUBSTRING the second time

807
bugs core 2303

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Include PLAN in mon$statements

808
bugs core 2303

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Include PLAN in mon$statements

809
bugs core 2305

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Make mon$statement_id value constant among monitoring snapshots

810
bugs core 2305

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make mon$statement_id value constant among monitoring snapshots

811
bugs core 2307

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incomplete API information values

812
bugs core 2307

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incomplete API information values

813
bugs core 2308

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SIMILAR TO produces random results with [x-y] expressions

814
bugs core 2308

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO produces random results with [x-y] expressions

815
bugs core 2315

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Firebird float support does not conform to Interbase spec

816
bugs core 2315

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Firebird float support does not conform to Interbase spec

817
bugs core 2317

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
select * from (select cast(.... returns null

818
bugs core 2317

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
select * from (select cast(.... returns null

819
bugs core 2331

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTER DOMAIN invalid RDB$FIELD_SUB_TYPE

820
bugs core 2331

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER DOMAIN invalid RDB$FIELD_SUB_TYPE

821
bugs core 2339

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect result for the derived expression based on aggregate and computation

822
bugs core 2339

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result for the derived expression based on aggregate and computation

823
bugs core 2341

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Hidden variables conflict with output parameters, causing assertions, unexpected errors or possibly incorrect results

824
bugs core 2341

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Hidden variables conflict with output parameters, causing assertions, unexpected errors or possibly incorrect results

825
bugs core 2350

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Too long column name for select alias should be rejected

826
bugs core 2350

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Too long column name for select alias should be rejected

827
bugs core 2355

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect handling of LOWER/UPPER when result string shrinks in terms of byte length

828
bugs core 2355

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect handling of LOWER/UPPER when result string shrinks in terms of byte length

829
bugs core 2359

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Logical multibyte maximum string length is not respected when assigning numbers

830
bugs core 2359

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Logical multibyte maximum string length is not respected when assigning numbers

831
bugs core 2361

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
String truncation reading 8859-1 Spanish column using isc_dsql_fetch with UTF-8 connection..

832
bugs core 2361

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
String truncation reading 8859-1 Spanish column using isc_dsql_fetch with UTF-8 connection..

833
bugs core 2374

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTER TRIGGER / PROCEDURE wrong error message

834
bugs core 2374

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER TRIGGER / PROCEDURE wrong error message

835
bugs core 2386

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTER VIEW could remove column used in stored procedure or trigger

836
bugs core 2386

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER VIEW could remove column used in stored procedure or trigger

837
bugs core 2389

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong matching of SIMILAR TO expression with brackets

838
bugs core 2389

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong matching of SIMILAR TO expression with brackets

839
bugs core 2397

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
If you drop two different indexes within the same transaction, you get database corruption

840
bugs core 2397

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
If you drop two different indexes within the same transaction, you get database corruption

841
bugs core 2408

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags

842
bugs core 2408

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql -ex puts default values of sp parameters before the NOT NULL and COLLATE flags

843
bugs core 2416

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
AV preparing a query with aggregate over derived table

844
bugs core 2416

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV preparing a query with aggregate over derived table

845
bugs core 2420

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Parsing error in EXECUTE STATEMENT with named parameters

846
bugs core 2420

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parsing error in EXECUTE STATEMENT with named parameters

847
bugs core 2424

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Make CREATE VIEW infer column names for views involving a GROUP BY clause or derived table

848
bugs core 2424

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make CREATE VIEW infer column names for views involving a GROUP BY clause or derived table

849
bugs core 2426

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Alter table not respecting collation

850
bugs core 2426

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Alter table not respecting collation

851
bugs core 2427

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTER VIEW doesn't clear dependencies on old views

852
bugs core 2427

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ALTER VIEW doesn't clear dependencies on old views

853
bugs core 2430

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server adds "NOT" at the end of default value for the TIMESTAMP field

854
bugs core 2430

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server adds "NOT" at the end of default value for the TIMESTAMP field

855
bugs core 2431

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
String values in error messages are not converted to connection charset

856
bugs core 2431

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
String values in error messages are not converted to connection charset

857
bugs core 2434

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
CREATE USER command: Invalid error message

858
bugs core 2434

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE USER command: Invalid error message

859
bugs core 2441

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server crashes on UPDATE OR INSERT statement

860
bugs core 2441

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes on UPDATE OR INSERT statement

861
bugs core 2451

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Query SELECT ... WHERE ... IN (SELECT DISTINCT ... ) returns a wrong result set.

862
bugs core 2451

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Query SELECT ... WHERE ... IN (SELECT DISTINCT ... ) returns a wrong result set.

863
bugs core 2455

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server fails when doing DROP DATABASE right after error in statistical fnction

864
bugs core 2455

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server fails when doing DROP DATABASE right after error in statistical fnction

865
bugs core 2457

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
UNICODE_CI internal gds software consistency check

866
bugs core 2457

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
UNICODE_CI internal gds software consistency check

867
bugs core 2475

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
External table data not visible to other sessions in Classic

868
bugs core 2475

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
External table data not visible to other sessions in Classic

869
bugs core 2477

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
mon$memory_usage: Sorting memory should be reported as owned by the statement

870
bugs core 2477

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
mon$memory_usage: Sorting memory should be reported as owned by the statement

871
bugs core 2484

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Success message when connecting to tiny trash database file

872
bugs core 2484

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Success message when connecting to tiny trash database file

873
bugs core 2499

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Implementation limit of DISTINCT items are not enforced, causing generation of incorrect BLR

874
bugs core 2499

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Implementation limit of DISTINCT items are not enforced, causing generation of incorrect BLR

875
bugs core 2501

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Binary shift functions give wrong results with negative shift values

876
bugs core 2501

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Binary shift functions give wrong results with negative shift values

877
bugs core 2505

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Built-in trigonometric functions can produce NaN and Infinity

878
bugs core 2505

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Built-in trigonometric functions can produce NaN and Infinity

879
bugs core 2508

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Tricky index names can defeat the parsing logic when generating a human readable plan

880
bugs core 2508

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Tricky index names can defeat the parsing logic when generating a human readable plan

881
bugs core 2516

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong processing a SP parameters with arrays

882
bugs core 2516

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong processing a SP parameters with arrays

883
bugs core 2531

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables

884
bugs core 2531

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The famous "cannot transliterate" error may be thrown when selecting data from the monitoring tables

885
bugs core 2538

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
PSQL doesnt allow to use singleton query result as input parameter of stored procedure when procedure accessed using 'execute procedure'

886
bugs core 2538

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
PSQL doesnt allow to use singleton query result as input parameter of stored procedure when procedure accessed using 'execute procedure'

887
bugs core 2555

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
CI column does not group correctly with a second column

888
bugs core 2555

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CI column does not group correctly with a second column

889
bugs core 2560

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Maximum and minimum identifier length should be enforced by DSQL

890
bugs core 2560

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Maximum and minimum identifier length should be enforced by DSQL

891
bugs core 2566

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
internal error [335544384]

892
bugs core 2566

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
internal error [335544384]

893
bugs core 2573

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
The server crashes when selecting from the MON$ tables in the ON DISCONNECT trigger

894
bugs core 2573

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The server crashes when selecting from the MON$ tables in the ON DISCONNECT trigger

895
bugs core 2578

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
select rdb$db_key from a view with a more than 1 table joined, results in conversion error

896
bugs core 2578

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
select rdb$db_key from a view with a more than 1 table joined, results in conversion error

897
bugs core 2579

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Parameters and variables cannot be used as expressions in EXECUTE PROCEDURE parameters without a colon prefix

898
bugs core 2579

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parameters and variables cannot be used as expressions in EXECUTE PROCEDURE parameters without a colon prefix

899
bugs core 2581

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Infinity should not escape from the engine

900
bugs core 2581

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Infinity should not escape from the engine

901
bugs core 2582

tracker
CS S S S S S S S S S S S S S S S X S S S S S S S S S S S S S S
Infinity from UDF should be trapped by the engine

902
bugs core 2582

tracker
SS S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S
Infinity from UDF should be trapped by the engine

903
bugs core 2584

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong results for CASE used together with GROUP BY

904
bugs core 2584

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results for CASE used together with GROUP BY

905
bugs core 2602

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Attachments using NONE charset may cause reads from MON$ tables to fail

906
bugs core 2602

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Attachments using NONE charset may cause reads from MON$ tables to fail

907
bugs core 2606

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Multibyte CHAR value requested as VARCHAR is returned with padded spaces

908
bugs core 2606

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Multibyte CHAR value requested as VARCHAR is returned with padded spaces

909
bugs core 2607

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Introducer (_charset) problems with monitoring and persistent modules

910
bugs core 2607

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Introducer (_charset) problems with monitoring and persistent modules

911
bugs core 2612

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Connection lost immediatelly after compiling procedure with RPAD system function

912
bugs core 2612

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Connection lost immediatelly after compiling procedure with RPAD system function

913
bugs core 2615

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Silent truncation when using utf8 parameters and utf8 client character set encoding

914
bugs core 2615

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Silent truncation when using utf8 parameters and utf8 client character set encoding

915
bugs core 2632

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Invalid BLOB ID when working with monitoring tables

916
bugs core 2632

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Invalid BLOB ID when working with monitoring tables

917
bugs core 2633

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SELECT WITH LOCK with no fields are accessed clears the data

918
bugs core 2633

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SELECT WITH LOCK with no fields are accessed clears the data

919
bugs core 2635

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unique index with a lot of NULL keys can be corrupted at level 1

920
bugs core 2635

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unique index with a lot of NULL keys can be corrupted at level 1

921
bugs core 2650

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Improve sorting performance when long VARCHARs are involved

922
bugs core 2650

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Improve sorting performance when long VARCHARs are involved

923
bugs core 2651

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect "string right truncation" error with NONE column and multibyte connection charset

924
bugs core 2651

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect "string right truncation" error with NONE column and multibyte connection charset

925
bugs core 2660

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
COUNT() incorrectly returns 0 when a condition of an outer join doesn't match

926
bugs core 2660

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
COUNT() incorrectly returns 0 when a condition of an outer join doesn't match

927
bugs core 2668

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Write note into log when automatic sweep is started

928
bugs core 2668

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Write note into log when automatic sweep is started

929
bugs core 2678

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Full outer join cannot use available indices (very slow execution)

930
bugs core 2678

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Full outer join cannot use available indices (very slow execution)

931
bugs core 2685

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
System triggers on view with check option are not removed

932
bugs core 2685

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
System triggers on view with check option are not removed

933
bugs core 2697

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Support the "? in (SELECT some_col FROM some_table)" subqueries

934
bugs core 2697

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support the "? in (SELECT some_col FROM some_table)" subqueries

935
bugs core 2699

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Common table expression context could be used with parameters

936
bugs core 2699

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Common table expression context could be used with parameters

937
bugs core 2712

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Do not print "invalid request BLR" for par.cpp errors with valid BLR

938
bugs core 2712

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Do not print "invalid request BLR" for par.cpp errors with valid BLR

939
bugs core 2720

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong evaluation result with divide and unary plus\minus operations

940
bugs core 2720

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong evaluation result with divide and unary plus\minus operations

941
bugs core 2721

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)

942
bugs core 2721

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Issue with SIMILAR TO and UTF8 on 2.5 Beta 2 (and 1)

943
bugs core 2722

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Storage of malformed blob is allowed when copying from a blob with NONE/OCTETS charset

944
bugs core 2722

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Storage of malformed blob is allowed when copying from a blob with NONE/OCTETS charset

945
bugs core 2724

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings

946
bugs core 2724

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Validate or transform string of DML queries so that engine internals doesn't receive malformed strings

947
bugs core 2729

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment

948
bugs core 2729

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Current connection may be used by EXECUTE STATEMENT instead of creation of new attachment

949
bugs core 2731

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Recursive EXECUTE STATEMENT works wrong

950
bugs core 2731

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Recursive EXECUTE STATEMENT works wrong

951
bugs core 2735

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
isql hangs when trying to show a view based on a procedure

952
bugs core 2735

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql hangs when trying to show a view based on a procedure

953
bugs core 2741

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Naive metadata extraction code in isql is defeated by "check" keyword typed in mixed case

954
bugs core 2741

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Naive metadata extraction code in isql is defeated by "check" keyword typed in mixed case

955
bugs core 2755

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SIMILAR TO works wrongly

956
bugs core 2755

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SIMILAR TO works wrongly

957
bugs core 2756

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
substring from timestamp - unexpected result

958
bugs core 2756

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
substring from timestamp - unexpected result

959
bugs core 2765

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Use of RDB$ADMIN role does not provide SYSDBA rights in GRANT/REVOKE

960
bugs core 2765

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Use of RDB$ADMIN role does not provide SYSDBA rights in GRANT/REVOKE

961
bugs core 2766

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error "page 0 is of wrong type (expected 6, found 1)" is thrown while accessing a non-corrupted table

962
bugs core 2766

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "page 0 is of wrong type (expected 6, found 1)" is thrown while accessing a non-corrupted table

963
bugs core 2768

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTERING OR DROPPING PROCEDURE which has type of domain parameter leads to attempt to delete that domain

964
bugs core 2768

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
ALTERING OR DROPPING PROCEDURE which has type of domain parameter leads to attempt to delete that domain

965
bugs core 2780

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Include client library version and protocol version in mon$attachments

966
bugs core 2780

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Include client library version and protocol version in mon$attachments

967
bugs core 2783

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
AV using recursive query as subquery in SELECT list and ORDER'ing by them

968
bugs core 2783

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV using recursive query as subquery in SELECT list and ORDER'ing by them

969
bugs core 2787

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Make rdb$system_flag not null

970
bugs core 2787

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make rdb$system_flag not null

971
bugs core 2788

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
isql extracts the array dimensions after the character set name

972
bugs core 2788

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql extracts the array dimensions after the character set name

973
bugs core 2796

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
DB_KEY is always zero for external tables

974
bugs core 2796

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DB_KEY is always zero for external tables

975
bugs core 2797

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Problem with default value of SP parameter

976
bugs core 2797

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with default value of SP parameter

977
bugs core 2798

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incomplete plan output (lack of view names) when selecting from views containing procedures inside

978
bugs core 2798

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incomplete plan output (lack of view names) when selecting from views containing procedures inside

979
bugs core 2799

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Changing sort directon in delete statement cause deletion of all records in table

980
bugs core 2799

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Changing sort directon in delete statement cause deletion of all records in table

981
bugs core 2804

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Problems with COMMENT ON and strings using introducer (charset)

982
bugs core 2804

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problems with COMMENT ON and strings using introducer (charset)

983
bugs core 2806

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Views based on procedures can't be created if the proc's output fields participate in an expression

984
bugs core 2806

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Views based on procedures can't be created if the proc's output fields participate in an expression

985
bugs core 2811

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unsuccessful execution' error when updating a record

986
bugs core 2811

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unsuccessful execution' error when updating a record

987
bugs core 2812

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Prohibit any improper mixture of explicit and implicit joins

988
bugs core 2812

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Prohibit any improper mixture of explicit and implicit joins

989
bugs core 2817

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure rigger executed first time

990
bugs core 2817

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure rigger executed first time

991
bugs core 2822

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error "no current row for fetch operation" when subquery includes a non-trivial derived table

992
bugs core 2822

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "no current row for fetch operation" when subquery includes a non-trivial derived table

993
bugs core 2826

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Join condition fails for UTF-8 databases.

994
bugs core 2826

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Join condition fails for UTF-8 databases.

995
bugs core 2831

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
isql shouldn't display db and user name when extracting a script

996
bugs core 2831

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql shouldn't display db and user name when extracting a script

997
bugs core 2833

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Changing data that affects an expression index that contains references to null date fields fails

998
bugs core 2833

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Changing data that affects an expression index that contains references to null date fields fails

999
bugs core 2835

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Natural is used to select instead of primary key index

1000
bugs core 2835

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Natural is used to select instead of primary key index

1001
bugs core 2861

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Cannot remove user with dot in login

1002
bugs core 2861

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cannot remove user with dot in login

1003
bugs core 2870

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
View created from JOIN and LEFT JOIN doesnt order

1004
bugs core 2870

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View created from JOIN and LEFT JOIN doesnt order

1005
bugs core 2871

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Outer ORDER BY clause has no effect

1006
bugs core 2871

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer ORDER BY clause has no effect

1007
bugs core 2872

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
EVL_expr: invalid operation (232)

1008
bugs core 2872

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EVL_expr: invalid operation (232)

1009
bugs core 2875

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
String right truncation error when char column longer than 4096 bytes compared with string constant

1010
bugs core 2875

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
String right truncation error when char column longer than 4096 bytes compared with string constant

1011
bugs core 2879

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)

1012
bugs core 2879

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sweep could raise error : page 0 is of wrong type (expected 6, found 1)

1013
bugs core 2881

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
isql should show packaged procedures and functions categorized per package

1014
bugs core 2881

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
isql should show packaged procedures and functions categorized per package

1015
bugs core 2886

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Query with "NOT IN <subselect from view>" fails

1016
bugs core 2886

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Query with "NOT IN <subselect from view>" fails

1017
bugs core 2888

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
A memory corruption cause incorrect query evaluation and may crash the server

1018
bugs core 2888

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
A memory corruption cause incorrect query evaluation and may crash the server

1019
bugs core 2890

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE

1020
bugs core 2890

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE

1021
bugs core 2893

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Expression in a subquery may be treated as invariant and produce incorrect results

1022
bugs core 2893

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Expression in a subquery may be treated as invariant and produce incorrect results

1023
bugs core 2897

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Don't send full length of field over the wire when field is null

1024
bugs core 2897

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Don't send full length of field over the wire when field is null

1025
bugs core 2907

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unable to catch exceptions that are thrown inside a dynamic builded execute block.

1026
bugs core 2907

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unable to catch exceptions that are thrown inside a dynamic builded execute block.

1027
bugs core 2910

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
PK index is not used for derived tables

1028
bugs core 2910

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
PK index is not used for derived tables

1029
bugs core 2912

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )

1030
bugs core 2912

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )

1031
bugs core 2913

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
COLLATE expressions are applied incorrectly

1032
bugs core 2913

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
COLLATE expressions are applied incorrectly

1033
bugs core 2916

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Broken error handling in the case of a conversion error happened during index creation

1034
bugs core 2916

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Broken error handling in the case of a conversion error happened during index creation

1035
bugs core 2920

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect execution of volatile SQL statements inside EXECUTE STATEMENT

1036
bugs core 2920

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect execution of volatile SQL statements inside EXECUTE STATEMENT

1037
bugs core 2922

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Character set used in constants is not registered as dependency

1038
bugs core 2922

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Character set used in constants is not registered as dependency

1039
bugs core 2923

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Problem with dependencies between a procedure and a view using that procedure

1040
bugs core 2923

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problem with dependencies between a procedure and a view using that procedure

1041
bugs core 2929

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
"Invalid ESCAPE sequence" when connecting to the database

1042
bugs core 2929

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"Invalid ESCAPE sequence" when connecting to the database

1043
bugs core 2930

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
DROP VIEW drops output parameters of used stored procedures

1044
bugs core 2930

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DROP VIEW drops output parameters of used stored procedures

1045
bugs core 2932

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong field position after ALTER POSITION

1046
bugs core 2932

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong field position after ALTER POSITION

1047
bugs core 2940

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Trace output could contain garbage data left from filtered out statements

1048
bugs core 2940

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Trace output could contain garbage data left from filtered out statements

1049
bugs core 2943

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
parsing error recursive query with two recursive parts

1050
bugs core 2943

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
parsing error recursive query with two recursive parts

1051
bugs core 2952

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Case-sensitive character class names in SIMILAR TO

1052
bugs core 2952

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Case-sensitive character class names in SIMILAR TO

1053
bugs core 2957

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
count() from big table returns negative result

1054
bugs core 2957

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
count() from big table returns negative result

1055
bugs core 2965

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect ROW_COUNT value after SINGULAR condition

1056
bugs core 2965

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect ROW_COUNT value after SINGULAR condition

1057
bugs core 2966

tracker
CS S S S S S S S S S S S S S S S X S S S S S S S S S S S S S S
Wrong results or unexpected errors while sorting a large data set

1058
bugs core 2966

tracker
SS S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S
Wrong results or unexpected errors while sorting a large data set

1059
bugs core 2969

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them

1060
bugs core 2969

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them

1061
bugs core 2971

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" error

1062
bugs core 2971

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" error

1063
bugs core 2974

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Unexpected "Invalid SIMILAR TO pattern" error

1064
bugs core 2974

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unexpected "Invalid SIMILAR TO pattern" error

1065
bugs core 2977

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)

1066
bugs core 2977

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)

1067
bugs core 2981

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error in Trace plugin (use local symbols in query)

1068
bugs core 2981

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error in Trace plugin (use local symbols in query)

1069
bugs core 2985

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well

1070
bugs core 2985

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well

1071
bugs core 2988

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Concurrent transaction number not reported if lock timeout occurs

1072
bugs core 2988

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Concurrent transaction number not reported if lock timeout occurs

1073
bugs core 3000

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error on delete user "ADMIN"

1074
bugs core 3000

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Error on delete user "ADMIN"

1075
bugs core 3003

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Procedure suspend check may cause restore to fail

1076
bugs core 3003

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Procedure suspend check may cause restore to fail

1077
bugs core 3008

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Add attachment's CHARACTER SET name into corresponding trace records

1078
bugs core 3008

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Add attachment's CHARACTER SET name into corresponding trace records

1079
bugs core 3018

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Check ability to use RECREATE, ALTER and CREATE OR ALTER SEQUENCE/GENERATOR statements

1080
bugs core 3018

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Check ability to use RECREATE, ALTER and CREATE OR ALTER SEQUENCE/GENERATOR statements

1081
bugs core 3024

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error "no current record for fetch operation" after ALTER VIEW

1082
bugs core 3024

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "no current record for fetch operation" after ALTER VIEW

1083
bugs core 3029

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler

1084
bugs core 3029

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler

1085
bugs core 3038

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong resultset

1086
bugs core 3038

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong resultset

1087
bugs core 3045

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)

1088
bugs core 3045

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)

1089
bugs core 3047

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong logic is used to resolve EXECUTE BLOCK parameters collations

1090
bugs core 3047

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong logic is used to resolve EXECUTE BLOCK parameters collations

1091
bugs core 3052

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong resultset

1092
bugs core 3052

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong resultset

1093
bugs core 3055

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used

1094
bugs core 3055

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used

1095
bugs core 3056

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued

1096
bugs core 3056

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued

1097
bugs core 3057

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Allow the usage of blobs in COMPUTED BY expressions

1098
bugs core 3057

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow the usage of blobs in COMPUTED BY expressions

1099
bugs core 3058

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
New generators are created with wrong value when more than 32K generators was previously created

1100
bugs core 3058

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New generators are created with wrong value when more than 32K generators was previously created

1101
bugs core 3064

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Using both the procedure name and alias inside an explicit plan crashes the server

1102
bugs core 3064

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Using both the procedure name and alias inside an explicit plan crashes the server

1103
bugs core 3073

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Foreign key cascade with SET DEFAULT uses the default value of the moment of the FK creation

1104
bugs core 3073

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Foreign key cascade with SET DEFAULT uses the default value of the moment of the FK creation

1105
bugs core 3076

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
Better performance for (table.field = :param or :param = -1) in where clause

1106
bugs core 3076

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Better performance for (table.field = :param or :param = -1) in where clause

1107
bugs core 3085

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL

1108
bugs core 3085

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL

1109
bugs core 3090

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Incorrect LEFT JOIN result using table and derived constant subquery

1110
bugs core 3090

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect LEFT JOIN result using table and derived constant subquery

1111
bugs core 3091

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral

1112
bugs core 3091

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral

1113
bugs core 3092

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ROW_COUNT is not cleared before the singleton INSERT statement

1114
bugs core 3092

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ROW_COUNT is not cleared before the singleton INSERT statement

1115
bugs core 3094

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Parameters doesn't work with NOT IN from a selectable procedure

1116
bugs core 3094

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parameters doesn't work with NOT IN from a selectable procedure

1117
bugs core 3095

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction

1118
bugs core 3095

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction

1119
bugs core 3097

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Updating blob field cause server crash with ACCESS_VIOLATION exception

1120
bugs core 3097

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Updating blob field cause server crash with ACCESS_VIOLATION exception

1121
bugs core 3100

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction

1122
bugs core 3100

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction

1123
bugs core 3101

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Cannot alter the domain after migrating from older versions

1124
bugs core 3101

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cannot alter the domain after migrating from older versions

1125
bugs core 3103

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT. See also: CORE-3283

1126
bugs core 3103

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT. See also: CORE-3283

1127
bugs core 3131

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.

1128
bugs core 3131

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U.

1129
bugs core 3137

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Partial rollback is possible for a selectable procedure modifying data

1130
bugs core 3137

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Partial rollback is possible for a selectable procedure modifying data

1131
bugs core 3140

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Preserve comments for parameters after altering procedures

1132
bugs core 3140

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Preserve comments for parameters after altering procedures

1133
bugs core 3141

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
The last column in a view is returning as a null value even when it's not

1134
bugs core 3141

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The last column in a view is returning as a null value even when it's not

1135
bugs core 3164

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Parameterized requests involving blob fields fails when connected using charset UTF8

1136
bugs core 3164

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parameterized requests involving blob fields fails when connected using charset UTF8

1137
bugs core 3168

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
exclude_filter doesn't work for <services></section> section of the Trace facility

1138
bugs core 3168

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
exclude_filter doesn't work for <services></section> section of the Trace facility

1139
bugs core 3173

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Empty result when select from SP that contains two CTE (second of them with GROUP BY clause) and INNER join

1140
bugs core 3173

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Empty result when select from SP that contains two CTE (second of them with GROUP BY clause) and INNER join

1141
bugs core 3174

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Expression index with TRIM may lead to incorrect indexed lookup

1142
bugs core 3174

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Expression index with TRIM may lead to incorrect indexed lookup

1143
bugs core 3176

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
View with "subselect" column join table and not use index

1144
bugs core 3176

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View with "subselect" column join table and not use index

1145
bugs core 3180

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ALTER VIEW with not matched columns in declaration and selection crashs the server

1146
bugs core 3180

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
ALTER VIEW with not matched columns in declaration and selection crashs the server

1147
bugs core 3188

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
page 0 is of wrong type (expected 6, found 1)

1148
bugs core 3188

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
page 0 is of wrong type (expected 6, found 1)

1149
bugs core 3201

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ATAN2 returns incorrect value for (0, 0)

1150
bugs core 3201

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ATAN2 returns incorrect value for (0, 0)

1151
bugs core 3204

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Constraint violation error of CAST is not raised inside views

1152
bugs core 3204

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Constraint violation error of CAST is not raised inside views

1153
bugs core 3210

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query

1154
bugs core 3210

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query

1155
bugs core 3211

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
String truncation occurs when selecting from a view containing NOT IN inside

1156
bugs core 3211

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
String truncation occurs when selecting from a view containing NOT IN inside

1157
bugs core 3222

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE

1158
bugs core 3222

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
View with "WITH CHECK OPTION" doesn't like TRIM function in WHERE

1159
bugs core 3227

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
ASCII_VAL() fails if argument contains multi-byte character anywhere

1160
bugs core 3227

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ASCII_VAL() fails if argument contains multi-byte character anywhere

1161
bugs core 3228

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
RIGHT() fails with multibyte text blobs > 1024 chars

1162
bugs core 3228

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RIGHT() fails with multibyte text blobs > 1024 chars

1163
bugs core 3231

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
OVERLAY() fails when used with text BLOBs containing multi-byte chars

1164
bugs core 3231

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
OVERLAY() fails when used with text BLOBs containing multi-byte chars

1165
bugs core 3233

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
LIKE, STARTING and CONTAINING fail if second operand >= 32K

1166
bugs core 3233

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIKE, STARTING and CONTAINING fail if second operand >= 32K

1167
bugs core 3234

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Support for text BLOBs >= 32K as first argument for TRIM()

1168
bugs core 3234

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support for text BLOBs >= 32K as first argument for TRIM()

1169
bugs core 3238

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Makes GEN_UUID return a compliant RFC-4122 UUID

1170
bugs core 3238

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Makes GEN_UUID return a compliant RFC-4122 UUID

1171
bugs core 3239

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
UTF8 UNICODE_CI collate can not be used in compound index

1172
bugs core 3239

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UTF8 UNICODE_CI collate can not be used in compound index

1173
bugs core 3242

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Recursive stored procedure shouldnt require execute right to call itself

1174
bugs core 3242

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Recursive stored procedure shouldnt require execute right to call itself

1175
bugs core 3244

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
POSITION: Wrong result with '' if third argument present

1176
bugs core 3244

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
POSITION: Wrong result with '' if third argument present

1177
bugs core 3245

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
SUBSTRING on long blobs truncates result to 32767 if third argument not present

1178
bugs core 3245

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SUBSTRING on long blobs truncates result to 32767 if third argument not present

1179
bugs core 3255

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
The server could crash using views with GROUP BY

1180
bugs core 3255

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
The server could crash using views with GROUP BY

1181
bugs core 3256

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error "request depth exceeded" may appear while preparing a select query against a view with explicit plan

1182
bugs core 3256

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "request depth exceeded" may appear while preparing a select query against a view with explicit plan

1183
bugs core 3262

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
LIST() may overwrite last part of output with zero characters

1184
bugs core 3262

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIST() may overwrite last part of output with zero characters

1185
bugs core 3277

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
Wrong result for RIGHT(UTF8 varchar)

1186
bugs core 3277

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
Wrong result for RIGHT(UTF8 varchar)

1187
bugs core 3282

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
EXECUTE STATEMENT parses the SQL text using wrong charset

1188
bugs core 3282

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
EXECUTE STATEMENT parses the SQL text using wrong charset

1189
bugs core 3283

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT

1190
bugs core 3283

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
BAD PLAN with using LEFT OUTER JOIN in SUBSELECT

1191
bugs core 3291

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction that created a record version

1192
bugs core 3291

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction that created a record version

1193
bugs core 3296

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error "context already in use" for the simple case function with a sub-select operand

1194
bugs core 3296

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "context already in use" for the simple case function with a sub-select operand

1195
bugs core 3302

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Distinct aggregates return wrong (duplicated) data

1196
bugs core 3302

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Distinct aggregates return wrong (duplicated) data

1197
bugs core 3305

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
"BLOB not found" error after creation/altering of the invalid trigger

1198
bugs core 3305

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"BLOB not found" error after creation/altering of the invalid trigger

1199
bugs core 3306

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure

1200
bugs core 3306

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure

1201
bugs core 3310

tracker
CS P P P P P P P P P P P P P P P X P P P P P P     E         E     P P P P P P
RDB$GET_CONTEXT and between in view

1202
bugs core 3310

tracker
SS P P P P P P P P P P P P P P P P P P P P P P     E         E     P P P P P P
RDB$GET_CONTEXT and between in view

1203
bugs core 3311

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause

1204
bugs core 3311

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause

1205
bugs core 3312

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Sub-optimal join plan when the slave table depends on the master one via the OR predicate

1206
bugs core 3312

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sub-optimal join plan when the slave table depends on the master one via the OR predicate

1207
bugs core 3314

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction

1208
bugs core 3314

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
Dependencies are not removed after dropping the procedure and the table it depends on in the same transaction

1209
bugs core 3323

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Ability to cancel waiting in lock manager

1210
bugs core 3323

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Ability to cancel waiting in lock manager

1211
bugs core 3328

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Client writes error messages into firebird.log when database is shutted down

1212
bugs core 3328

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Client writes error messages into firebird.log when database is shutted down

1213
bugs core 3330

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server crashes while recreating the table with a NULL -> NOT NULL change

1214
bugs core 3330

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes while recreating the table with a NULL -> NOT NULL change

1215
bugs core 3335

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments

1216
bugs core 3335

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments

1217
bugs core 3338

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE

1218
bugs core 3338

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Code changes disabled support for expression indexes with COALESCE, CASE and DECODE

1219
bugs core 3340

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Error in autonomous transaction with empty exception handler: can insert duplicate values into PK/UK column (leads to unrestorable backup)

1220
bugs core 3340

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error in autonomous transaction with empty exception handler: can insert duplicate values into PK/UK column (leads to unrestorable backup)

1221
bugs core 3343

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements

1222
bugs core 3343

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements

1223
bugs core 3353

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Predicate (blob_field LIKE ?) describes the parameter as VARCHAR(30) rather than as BLOB

1224
bugs core 3353

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Predicate (blob_field LIKE ?) describes the parameter as VARCHAR(30) rather than as BLOB

1225
bugs core 3355

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Wrong comparsion of DATE and TIMESTAMP if index is used

1226
bugs core 3355

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong comparsion of DATE and TIMESTAMP if index is used

1227
bugs core 3357

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Generators are set to 0 after restore

1228
bugs core 3357

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Generators are set to 0 after restore

1229
bugs core 3360

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause

1230
bugs core 3360

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause

1231
bugs core 3362 basic

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Cursors should ignore changes made by the same statement

1232
bugs core 3362 basic

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cursors should ignore changes made by the same statement

1233
bugs core 3362 complex

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Cursors should ignore changes made by the same statement

1234
bugs core 3362 complex

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Cursors should ignore changes made by the same statement

1235
bugs core 3364

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Blob filter to translate internal debug info into text representation

1236
bugs core 3364

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Blob filter to translate internal debug info into text representation

1237
bugs core 3365

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Extend syntax for ALTER USER CURRENT_USER

1238
bugs core 3365

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Extend syntax for ALTER USER CURRENT_USER

1239
bugs core 3373

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
It is possible to store string with lenght 31 chars into column varchar(25)

1240
bugs core 3373

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
It is possible to store string with lenght 31 chars into column varchar(25)

1241
bugs core 3374

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format

1242
bugs core 3374

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format

1243
bugs core 3394

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector

1244
bugs core 3394

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector

1245
bugs core 3398

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
GRANT ADMIN ROLE not accepted

1246
bugs core 3398

tracker
SS P P P P P P P P P P P P P P P U P P P P P P P P P P P P P P
GRANT ADMIN ROLE not accepted

1247
bugs core 3399

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Allow write operations to temporary tables in read only transactions

1248
bugs core 3399

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow write operations to temporary tables in read only transactions

1249
bugs core 3401

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Collation errors with [type of] <domain>, type of column

1250
bugs core 3401

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Collation errors with [type of] <domain>, type of column

1251
bugs core 3413

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Improve diagnostics of internal trace errors

1252
bugs core 3413

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Improve diagnostics of internal trace errors

1253
bugs core 3416

tracker
CS P P P P P P P P P P P P P P P X P P P P P P P P P P P P P P
Inserting K?se into a CHARACTER SET ASCII column succeeds

1254
bugs core 3416

tracker
SS P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Inserting K?se into a CHARACTER SET ASCII column succeeds

1255
bugs core 3418

tracker
CS P P P P P P P P P P P P P P P X P