JFIF $
d d 7
Viewing File: /usr/share/doc/firebird/sql.extensions/README.keywords
----------------------------------------------------
SQL keywords introduced in different server versions
----------------------------------------------------
Deviations from the standard:
* : keyword does not exist in the SQL:2016 specification and should be
considered a non-standard language extention.
(1) : reserved word in SQL:2016, non-reserved in Firebird
(2) : non-reserved word in SQL:2016, reserved word in Firebird
Firebird 1.0
------------
Added as reserved words:
BREAK *
CURRENT_ROLE
CURRENT_USER
DESCRIPTOR (2)
FIRST (2)
RECREATE *
SKIP
SUBSTRING
Firebird 1.5
------------
Added as reserved words:
BIGINT
CASE
CURRENT_CONNECTION *
CURRENT_TRANSACTION *
RELEASE
ROW_COUNT
SAVEPOINT
Added as non-reserved words:
COALESCE (1)
DELETING *
INSERTING *
LAST
LEAVE *
LOCK *
NULLIF (1)
NULLS
STATEMENT
UPDATING *
USING (1)
Moved from reserved words to non-reserved:
BREAK *
DESCRIPTOR
FIRST
SKIP (1)
SUBSTRING (1)
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 (1)
ACCENT *
ACOS (1)
ALWAYS
ASCII_CHAR *
ASCII_VAL *
ASIN (1)
ATAN (1)
ATAN2 *
BIN_AND *
BIN_OR *
BIN_SHL *
BIN_SHR *
BIN_XOR *
CEIL (1)
CEILING (1)
COS (1)
COSH (1)
COT *
DATEADD *
DATEDIFF *
DECODE *
EXP (1)
FLOOR (1)
GEN_UUID *
GENERATED
HASH *
LIST *
LN (1)
LOG (1)
LOG10 (1)
LPAD *
MATCHED
MATCHING *
MAXVALUE
MILLISECOND *
MINVALUE
MOD (1)
OVERLAY (1)
PAD
PI *
PLACING
POWER (1)
PRESERVE
RAND *
REPLACE *
REVERSE *
ROUND *
RPAD *
SIGN *
SIN (1)
SINH (1)
SPACE
SQRT (1)
TAN (1)
TANH (1)
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
DETERMINISTIC
FALSE
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
VAR_POP
VAR_SAMP
Moved from non-reserved words to reserved:
DELETING *
INSERTING *
RDB$GET_CONTEXT *
RDB$SET_CONTEXT *
UPDATING *
Added as non-reserved words:
ABSOLUTE
ACOSH *
ASINH *
ATANH *
BODY *
CONTINUE
DDL *
DECRYPT *
DENSE_RANK (1)
ENCRYPT *
ENGINE *
FIRST_VALUE (1)
IDENTITY (1)
INCREMENT
LAST_VALUE (1)
LAG (1)
LEAD (1)
LINGER *
NAME
NTH_VALUE (1)
PACKAGE *
PARTITION (1)
PLUGIN *
PRIOR
RANK (1)
RELATIVE
ROW_NUMBER (1)
SERVERWIDE *
TAGS *
TRUSTED *
USAGE
Firebird 4.0
------------
Added as reserved words:
BINARY
DECFLOAT
LATERAL
LOCAL
LOCALTIME
LOCALTIMESTAMP
PUBLICATION *
RDB$GET_TRANSACTION_CN *
RDB$ERROR *
RDB$ROLE_IN_USE *
RDB$SYSTEM_PRIVILEGE *
TIMEZONE_HOUR
TIMEZONE_MINUTE
UNBOUNDED (2)
VARBINARY
WINDOW
WITHOUT
Added as non-reserved words:
BASE64_DECODE *
BASE64_ENCODE *
BIND *
COMPARE_DECFLOAT *
CONSISTENCY *
COUNTER *
CTR_BIG_ENDIAN *
CTR_LENGTH *
CTR_LITTLE_ENDIAN *
CUME_DIST (1)
DEFINER
DISABLE *
ENABLE *
EXCESS *
EXCLUDE
EXTENDED *
FIRST_DAY *
FOLLOWING
HEX_DECODE *
HEX_ENCODE *
IDLE *
INVOKER
IV *
LAST_DAY *
LEGACY *
LPARAM *
MAKE_DBKEY *
MESSAGE *
MODE *
NATIVE *
NORMALIZE_DECFLOAT *
NTILE (1)
NUMBER
OTHERS
OVERRIDING
PERCENT_RANK (1)
PRECEDING
PRIVILEGE *
QUANTIZE *
RANGE (1)
RESET *
RSA_DECRYPT *
RSA_ENCRYPT *
RSA_PRIVATE *
RSA_PUBLIC *
RSA_SIGN_HASH *
RSA_VERIFY_HASH *
SALT_LENGTH *
SECURITY
SESSION
SIGNATURE *
SQL (1)
SYSTEM (1)
TIES
TOTALORDER *
TRAPS *
ZONE
Back to Directory
nL+D550H?Mx ,D"v]qv;6*Zqn)ZP 0 !1 A "#a$2Qr D8 a Ri[f\mIykIw0 cuFcRı?lO7к_f˓[C$殷WF<_W ԣs KcëIzyQy /_LKℂ;C",pFA: /]=H ~,ls/9ć:[=/#f;)x {ٛEQ )~ =𘙲r*2~ a _V=' kumF D}KYYC)({ *g&f`툪ry`=^cJ.I](*`wq 1dđ#̩͑0;H]u搂@:~וKL Nsh}OIR*8:2 !lDJVo( 3=M(zȰ+i*NA r6KnSl )!JJӁ* %݉?|D}d5:eP0R;{$X'xF@.ÊB {,WJuQɲRI;9QE琯62fT.DUJ;*cP A\ILNj!J۱+O\ ͔]ޒ SJȧc%ANolՎprULZԛerE2=XDXgVQeӓk yP7U*omQIs,K`)6\G3t?pgjrmۛجwluGtf h9uyP0D;Uڽ"OXlif$)&|ML0Zrm1[HXPlPR0'G=i2N +0e2]] 9VTPO7h(F*癈 '=QVZDF,d߬~TX
G[`le69CR(!S2!P
<0x < !1AQ "Raq02Br#SCTb
?Ζ"]mH5WR7k.ۛ!}Q~+yԏz|@T20S~Kek *zFf^2X*(@8r?CIuI|֓>^ExLgNUY+{.RѪ
τVYTD I62'8Y2 7'\TP.6d&˦@Vqi|8- OΕ]ʔ U=TL8=;6c| !qfF3aů&~$l}'NWUs$Uk^SV:U# 6w++s&r+nڐ{@29 gL
u"TÙM=6 (^"7r} =6YݾlCuhquympǦ
G jhsǜNlɻ}o7 #S6aw4!OSrD57%|?x>L
|/nD6?/8w#[)L7+6〼T ATg ! %5MmZ/c-{1_Je"|^$'O&ޱմ Trb$ w)R$&
N1EtdU3Uȉ1pM" N*(DN yd96.(jQ)X
5cQɎMyW? Q*!R>6=7)Xj5`J]e 8%t!+'!1Q 5 !1 AQaqё#2"0BRb ? Gt^## .llQT $v,,m 㵜5 ubV =sY+@d{N! dnO< .-B; _wJt6;QJd.Qc%p{ 1,sNDdFHI0ГoXшe黅XۢF:)[FGXƹ/w_cMeD,ʡcc. WDtA$j@:) -# u
c1<@ۗ9F)KJ-hpP]_x[qBlbp ʖw q"LFGd ƶ*s+ډ_Zc"? %t[IP 6J]#=ɺVvvCGsGh1 >)6|ey?Lӣm,4GWUi` ]uJVoV DG< SB 6ϏQ@ TiUly OU0kfV~~}SZ@*WUUi##; s/[ =!7}" WN]'(L! ~y5g9T̅JkbM' +s:S + B)v@Mj
e Cf jE 0Y\QnzG1д~Wo{T 9?`Rmyhsy3!HAD]mc1~2L Su7xT;j$`}4->L#vzŏ ILS ֭ T { rjGKC; bpU= -`BsK.SFw4Mq]ZdHS0)tLg