README.keywords 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112
  1. ----------------------------------------------------
  2. SQL keywords introduced in different server versions
  3. ----------------------------------------------------
  4. An asterisk (*) mark shows that a keyword doesn't exist in the SQL specification
  5. and hence should be considered a non-standard language extention.
  6. Firebird 1.0:
  7. Added as reserved words:
  8. CURRENT_USER
  9. CURRENT_ROLE
  10. BREAK *
  11. DESCRIPTOR
  12. FIRST
  13. RECREATE *
  14. SKIP *
  15. SUBSTRING
  16. Firebird 1.5:
  17. Added as reserved words:
  18. CURRENT_CONNECTION *
  19. CURRENT_TRANSACTION *
  20. BIGINT
  21. CASE
  22. RELEASE
  23. ROW_COUNT
  24. SAVEPOINT
  25. Added as non-reserved words:
  26. COALESCE
  27. DELETING *
  28. INSERTING *
  29. LAST
  30. LEAVE
  31. LOCK *
  32. NULLIF
  33. NULLS
  34. STATEMENT
  35. UPDATING *
  36. USING
  37. Moved from reserved words to non-reserved:
  38. BREAK *
  39. DESCRIPTOR
  40. FIRST
  41. SKIP *
  42. SUBSTRING
  43. Firebird 2.0:
  44. Added as reserved words:
  45. BIT_LENGTH
  46. BOTH
  47. CHAR_LENGTH
  48. CHARACTER_LENGTH
  49. CLOSE
  50. CROSS
  51. FETCH
  52. LEADING
  53. LOWER
  54. OCTET_LENGTH
  55. OPEN
  56. ROWS
  57. TRAILING
  58. TRIM
  59. Moved from non-reserved words to reserved:
  60. USING
  61. Added as non-reserved words:
  62. BACKUP *
  63. BLOCK *
  64. COLLATION
  65. COMMENT *
  66. DIFFERENCE *
  67. IIF *
  68. NEXT
  69. SCALAR_ARRAY *
  70. SEQUENCE
  71. RESTART
  72. RETURNING *
  73. Moved from reserved words to non-reserved:
  74. ACTION
  75. CASCADE
  76. FREE_IT *
  77. RESTRICT
  78. ROLE
  79. TYPE
  80. WEEKDAY *
  81. YEARDAY *
  82. Removed reserved words:
  83. BASENAME *
  84. CACHE *
  85. CHECK_POINT_LEN *
  86. GROUP_COMMIT_WAIT *
  87. LOGFILE *
  88. LOG_BUF_SIZE *
  89. NUM_LOG_BUFS *
  90. RAW_PARTITIONS *