Debian Codegraph @

doc/sql.extensions/README.keywords

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