1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
|
----------------------------------------------------
SQL keywords introduced in different server versions
----------------------------------------------------
An asterisk (*) mark shows that a keyword doesn't exist in the SQL specification
and hence should be considered a non-standard language extention.
Firebird 1.0
------------
Added as reserved words:
CURRENT_USER
CURRENT_ROLE
BREAK *
DESCRIPTOR
FIRST
RECREATE *
SKIP *
SUBSTRING
Firebird 1.5
------------
Added as reserved words:
CURRENT_CONNECTION *
CURRENT_TRANSACTION *
BIGINT
CASE
RELEASE
ROW_COUNT
SAVEPOINT
Added as non-reserved words:
COALESCE
DELETING *
INSERTING *
LAST
LEAVE
LOCK *
NULLIF
NULLS
STATEMENT
UPDATING *
USING
Moved from reserved words to non-reserved:
BREAK *
DESCRIPTOR
FIRST
SKIP *
SUBSTRING
Firebird 2.0
------------
Added as reserved words:
BIT_LENGTH
BOTH
CHAR_LENGTH
CHARACTER_LENGTH
CLOSE
CROSS
FETCH
LEADING
LOWER
OCTET_LENGTH
OPEN
ROWS
TRAILING
TRIM
Moved from non-reserved words to reserved:
USING
Added as non-reserved words:
BACKUP *
BLOCK *
COLLATION
COMMENT *
DIFFERENCE *
IIF *
NEXT
SCALAR_ARRAY *
SEQUENCE
RESTART
RETURNING *
Moved from reserved words to non-reserved:
ACTION
CASCADE
FREE_IT *
RESTRICT
ROLE
TYPE
WEEKDAY *
YEARDAY *
Removed reserved words:
BASENAME *
CACHE *
CHECK_POINT_LEN *
GROUP_COMMIT_WAIT *
LOGFILE *
LOG_BUF_SIZE *
NUM_LOG_BUFS *
RAW_PARTITIONS *
Firebird 2.1
------------
Added as reserved words:
CONNECT
DISCONNECT
GLOBAL
INSENSITIVE
RECURSIVE
SENSITIVE
START
Added as non-reserved words:
ABS
ACCENT *
ACOS *
ALWAYS *
ASCII_CHAR *
ASCII_VAL *
ASIN *
ATAN *
ATAN2 *
BIN_AND *
BIN_OR *
BIN_SHL *
BIN_SHR *
BIN_XOR *
CEIL
CEILING
COS *
COSH *
COT *
DATEADD *
DATEDIFF *
DECODE *
EXP
FLOOR
GEN_UUID *
GENERATED
HASH *
LIST *
LN
LOG *
LOG10 *
LPAD *
MATCHED
MATCHING *
MAXVALUE *
MILLISECOND *
MINVALUE *
MOD
OVERLAY
PAD
PI *
PLACING
POWER
PRESERVE
RAND *
REPLACE *
REVERSE *
ROUND *
RPAD *
SIGN *
SIN *
SINH *
SPACE
SQRT
TAN *
TANH *
TEMPORARY
TRUNC *
WEEK *
Firebird 2.5
------------
Added as reserved words:
SIMILAR
Added as non-reserved words:
AUTONOMOUS *
BIN_NOT *
CALLER *
CHAR_TO_UUID *
COMMON *
DATA
FIRSTNAME *
GRANTED
LASTNAME *
MIDDLENAME *
MAPPING *
OS_NAME *
SOURCE *
TWO_PHASE *
UUID_TO_CHAR *
Firebird 3.0
------------
Added as reserved words:
BOOLEAN
CORR
COVAR_POP
COVAR_SAMP
DELETING *
DETERMINISTIC
FALSE
INSERTING *
OFFSET
OVER
RDB$RECORD_VERSION *
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
RETURN
ROW
SCROLL
SQLSTATE *
STDDEV_POP
STDDEV_SAMP
TRUE
UNKNOWN
UPDATING *
VAR_POP
VAR_SAMP
Added as non-reserved words:
ABSOLUTE
ACOSH *
ASINH *
ATANH *
BODY *
CONTINUE
DDL *
DECRYPT *
DENSE_RANK
ENCRYPT *
ENGINE *
FIRST_VALUE
IDENTITY
INCREMENT
LAST_VALUE
LAG
LEAD
LINGER *
NAME
NTH_VALUE
PACKAGE *
PARTITION
PLUGIN *
PRIOR
RANK
RELATIVE
ROW_NUMBER
SERVERWIDE *
TAGS *
TRUSTED *
USAGE
|
