Reserved words and changes

<< Changes to the Firebird API and ODS | Firebird 2.5.3 Release Notes | Configuration parameter additions and changes >>

Reserved words and changes

Note: Asterisks (*) mark keywords that are reserved, or otherwise recognised by Firebird's grammar as keywords, but are not reserved words in the SQL standard.

Clean-up of reserved words

A. Peshkov

Tracker reference CORE-2638

The number of Firebird-specific reserved words has been reduced significantly, in order to mitigate the pain of keyword conflicts when converting other databases to Firebird. Where possible, words that are not reserved by the standard have been made non-reserved in Firebird's grammar.

A small list remains of words that are reserved in Firebird but not in the SQL standard. They are:

ADD *DB_KEY *GDSCODE *INDEX *
LONG *PLAN *POST_EVENT *RETURNING_VALUES *
SQLCODE *VARIABLE *VIEW * 

All other non-standard keywords previously reserved are now available for any reasonable purpose.

Newly reserved words

SIMILARSQLSTATE  

Keywords added as non-reserved

AUTONOMOUS *BIN_NOT *CALLER *
CHAR_TO_UUID *COMMON *DATA
FIRSTNAME *GRANTEDLASTNAME *
MIDDLENAME *MAPPING *OS_NAME *
SOURCE *TWO_PHASE *UUID_TO_CHAR *

back to top of page
<< Changes to the Firebird API and ODS | Firebird 2.5.3 Release Notes | Configuration parameter additions and changes >>