счетчике, который расположен внутри базы данных Firebird. Вы можете создать его, задав имя: CREATE GENERATOR GenTest; Затем вы можете получать его текущее значение, увеличивать его или уменьшать точно так Firebird 2 и более поздних версиях ключевое слово SEQUENCE может быть использован как синоним GENERATOR. Фактически, рекомендуется использовать синтаксис SEQUENCE во вновь создаваемом коде. Хотя слово не наделает бед.) Структура системной таблицы RDB$GENERATORS следующая: • RDB$GENERATOR_NAME CHAR(31) • RDB$GENERATOR_ID SMALLINT • RDB$SYSTEM_FLAG SMALLINT И для СУБД Firebird 2.0 и более старших

Firebird Generator Guide A guide on how and when to use generators in Firebird Frank Ingermann Version 0.3, 27 June 2020 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . 2. Generator Basics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2.1. What is a generator? . What is the maximum value of a generator?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 2.4.1. Client dialects and generator values . . . . . . . . . . .

186 Use Generator (Step 2.1) 187 Number Generator 187 Date / Time / DateTime Generator 187 Sequence Generator 188 Enum Generator 189 Text Generator 189 Image/Binary Generator 190 Foreign Foreign Key Generator 190 UUID Generator 191 Regular Expression Generator 192 Name Generator 193 Gender Generator 194 Title Generator 194 Marital Status Generator 195 Phone Number Number Generator 195 Email Generator 196 Job Title Generator 196 Social Network ID Generator 197 Payment Method Generator 197 Credit Card Type Generator 197 Credit Card Number Generator 198

191 Use Generator (Step 2.1) 192 Number Generator 192 Date / Time / DateTime Generator 192 Sequence Generator 193 Enum Generator 193 Text Generator 193 Image/Binary Generator 193 Foreign Foreign Key Generator 194 UUID Generator 194 Regular Expression Generator 194 Name Generator 196 Gender Generator 196 Title Generator 196 Marital Status Generator 196 Phone Number Number Generator 197 Email Generator 197 Job Title Generator 197 Social Network ID Generator 197 Payment Method Generator 198 Credit Card Type Generator 198 Credit Card Number Generator 198

191 Use Generator (Step 2.1) 192 Number Generator 192 Date / Time / DateTime Generator 192 Sequence Generator 193 Enum Generator 193 Text Generator 193 Image/Binary Generator 193 Foreign Foreign Key Generator 194 UUID Generator 194 Regular Expression Generator 194 Name Generator 196 Gender Generator 196 Title Generator 196 Marital Status Generator 196 Phone Number Number Generator 197 Email Generator 197 Job Title Generator 197 Social Network ID Generator 197 Payment Method Generator 198 Credit Card Type Generator 198 Credit Card Number Generator 198

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2.1. Was ist ein Generator?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 3.2. Verwendung der Generator-Befehle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 3.2.1. Einen Generator erzeugen (“Insert”) . . . . . . . . . . . . . . 10 3.2.4. Einen Generator direkt auf einen bestimmten Wert setzen (“Update”) . . . . . . . . . . . . . . . . 11 3.2.5. Einen Generator löschen (“Delete”) . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 12. Generator Page — Type 0x09. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Very large blobs will require a sequence of pages and the type 8 page holds blob data. 0x09 Generator Page. Holds an array of 64 bit generators. 0x0a Page 2 of any database is a Write Ahead Log page Chapter 11. Blob Data Page — Type 0x08 — TODO 45 Chapter 12. Generator Page — Type 0x09 Every database has at least one Generator Page, even if no generators (also known as sequences in Firebird

UUID, SNOWFLAKE. Besides, we have also extracted a key generator interface to make users implement self‐defined key generator. Built-In Key Generator UUID Use UUID.randomUUID() to generate the distributed millisecond. If the number generated in that millisecond exceeds 4,096 (2 to the power of 12), the generator will wait till the next millisecond to continue. Please refer to the following picture for the distributed sequence generator has provided a maximum clock‐back millisecond. If the clock‐back time has exceeded it, the program will report error. If it is within the tolerance range, the generator will wait

UUID, SNOWFLAKE. Besides, we have also extracted a key generator interface to make users implement self‐defined key generator. Built-In Key Generator UUID Use UUID.randomUUID() to generate the distributed millisecond. If the number generated in that millisecond exceeds 4,096 (2 to the power of 12), the generator will wait till the next millisecond to continue. Please refer to the following picture for the distributed sequence generator has provided a maximum clock‐back millisecond. If the clock‐back time has exceeded it, the program will report error. If it is within the tolerance range, the generator will wait

UUID, SNOWFLAKE. Besides, we have also extracted a key generator interface to make users implement self‐defined key generator. Built-In Key Generator UUID Use UUID.randomUUID() to generate the distributed millisecond. If the number generated in that millisecond exceeds 4,096 (2 to the power of 12), the generator will wait till the next millisecond to continue. Please refer to the following picture for the distributed sequence generator has provided a maximum clock‐back millisecond. If the clock‐back time has exceeded it, the program will report error. If it is within the tolerance range, the generator will wait