New reserved words and changes
<< Procedural SQL (PSQL) | Firebird 2.1.6 Release Notes | Indexing & optimizations >>
New reserved words and changes
The following keywords have been added, or have changed status, since Firebird 1.5. Those marked with an asterisk (*) are not present in the SQL standard.
Newly reserved words
BIT_LENGTH(v.2.0)BOTH(v.2.0)CHAR_LENGTH(v.2.0)CHARACTER_LENGTH(v.2.0)CLOSE(v.2.0)CONNECT(v.2.1)<<—CROSS(v.2.0)DISCONNECT(v.2.1)<<—FETCH(v.2.0)GLOBAL(v.2.1)<<—INSENSITIVE(v.2.1)<<—LEADING(v.2.0)LOWER(v.2.0)OCTET_LENGTH(v.2.0)OPEN(v.2.0)RECURSIVE(v.2.1)<<—ROWS(v.2.0)SENSITIVE(v.2.1)<<-START(v.2.1)<<—TRAILING(v.2.0)TRIM(v.2.0)
Changed from non-reserved to reserved
USING(v.2.0)
Keywords added as non-reserved
ABS(v.2.1)<<—ACCENT* (v.2.1)<<—ACOS* (v.2.1)<<—ALWAYS* (v.2.1)<<—ASCII_CHAR* (v.2.1)<<—ASCII_VAL* (v.2.1)<<—ASIN* (v.2.1)<<—ATAN* (v.2.1)<<—ATAN2* (v.2.1)<<—BACKUP* (v.2.0)BIN_AND* (v.2.1)<<—BIN_OR* (v.2.1)<<—BIN_SHL* (v.2.1)<<—BIN_SHR* (v.2.1)<<—BIN_XOR* (v.2.1)<<—BLOCK* (v.2.0)CEIL(v.2.1)<<—CEILING(v.2.1)<<—COLLATION(v.2.0)COMMENT* (v.2.0)COS* (v.2.1)<<—COSH* (v.2.1)<<—COT* (v.2.1)<<—DATEADD* (v.2.1)<<—DATEDIFF* (v.2.1)<<—DECODE* (v.2.1)<<—DIFFERENCE* (v.2.0)EXP(v.2.1)<<—FLOOR(v.2.1)<<—GEN_UUID(v.2.1)<<—GENERATED(v.2.1)<<—HASH* (v.2.1)<<—IIF* (v.2.0)LIST* (v.2.1)<<—LN(v.2.1)<<—LOG* (v.2.1)<<—LOG10* (v.2.1)<<—LPAD* (v.2.1)<<—MATCHED(v.2.1)<<—MATCHING* (v.2.1)<<—MAXVALUE* (v.2.1)<<—MILLISECOND* (v.2.1)<<—MINVALUE* (v.2.1)<<—MOD(v.2.1)<<—NEXT(v.2.0)OVERLAY(v.2.1)<<—PAD(v.2.1)<<—PI* (v.2.1)<<—PLACING(v.2.1)<<—POWER(v.2.1)<<—PRESERVE(v.2.1)<<—RAND* (v.2.1)<<—REPLACE* (v.2.1)<<—RESTART(v.2.0)RETURNING* (v.2.0)REVERSE* (v.2.1)<<—ROUND* (v.2.1)<<—RPAD* (v.2.1)<<—SCALAR_ARRAY* (v.2.0)SEQUENCE(v.2.0)SIGN* (v.2.1)<<—SIN* (v.2.1)<<—SINH* (v.2.1)<<—SPACE(v.2.1)<<—SQRT(v.2.1)<<—TAN* (v.2.1)<<—TANH* (v.2.1)<<—TEMPORARY(v.2.1)<<—TRUNC* (v.2.1)<<—WEEK* (v.2.1)<<—
Keywords no longer reserved
ACTION(v.2.0)CASCADE(v.2.0)FREE_IT* (v.2.0)RESTRICT(v.2.0)ROLE(v.2.0)TYPE(v.2.0)WEEKDAY* (v.2.0)YEARDAY* (v.2.0)
No longer reserved as keywords
BASENAME* (v.2.0)GROUP_COMMIT_WAIT* (v.2.0)NUM_LOG_BUFS* (v.2.0)CACHE* (v.2.0)LOGFILE* (v.2.0)RAW_PARTITIONS* (v.2.0)CHECK_POINT_LEN* (v.2.0)LOG_BUF_SIZE* (v.2.0)
back to top of page
<< Procedural SQL (PSQL) | Firebird 2.1.6 Release Notes | Indexing & optimizations >>
