................... 450 Функции для работы с UUID ....................................................................................... 451 CHAR_TO_UUID ............................................ ............................. 451 GEN_UUID ............................................................................................................. 451 UUID_TO_CHAR ............................. сказанное: SELECT UUID_TO_CHAR(X) AS C1, UUID_TO_CHAR(X) AS C2, UUID_TO_CHAR(X) AS C3 FROM (SELECT GEN_UUID() AS X FROM RDB$DATABASE) T;

CHAR_LENGTH(), CHARACTER_LENGTH() CHAR_TO_UUID() COALESCE() COS() COSH() COT() DATEADD() DATEDIFF() DECODE() EXP() EXTRACT() MILLISECOND WEEK FLOOR() GEN_ID() GEN_UUID() HASH() IIF() LEFT() LN() LOG() RIGHT() ROUND() RPAD() SIGN() SIN() SINH() SQRT() SUBSTRING() TAN() TANH() TRIM() TRUNC() UPPER() UUID_TO_CHAR() 15.Внешние функции (UDF) abs acos addDay addHour addMilliSecond addMinute addMonth addSecond слова: AUTONOMOUS, BIN_NOT, CALLER, CHAR_TO_UUID, COMMON, DATA, FIRSTNAME, GRANTED, LASTNAME, MAPPING, MIDDLENAME, OS_NAME, SOURCE, TWO_PHASE и UUID_TO_CHAR. • Более не зарезервированные, но ключевые

dropping a tables, so no need to check frequently • Look for tables called _vt_(HOLD|PURGE|DROP)_<UUID>_ (be very strict about the pattern search, because why not) • If time is right, RENAME to make VReplication work. Examples for valid cases CREATE TABLE `entry` ( `id` int NOT NULL, `uuid` varchar(40) DEFAULT NULL, `ts` timestamp NULL DEFAULT NULL, `customer_id ` int NOT NULL, PRIMARY NOT NULL, `uuid` varchar(40) DEFAULT NULL, `ts` timestamp NULL DEFAULT NULL, `customer_id ` int , PRIMARY KEY (`id`), KEY ts_idx(`ts`) ) CREATE TABLE `target ` ( `id` int NOT NULL, `uuid` varchar(40)

470 8.7. UUID Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 470 8.7.1. CHAR_TO_UUID() . . . . . 470 8.7.2. GEN_UUID() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 471 8.7.3. UUID_TO_CHAR() . . . . 6. Data Manipulation (DML) Statements 265 SELECT UUID_TO_CHAR(X) AS C1, UUID_TO_CHAR(X) AS C2, UUID_TO_CHAR(X) AS C3 FROM (SELECT GEN_UUID() AS X FROM RDB$DATABASE) T; The result if this

dropping a tables, so no need to check frequently • Look for tables called _vt_(HOLD|PURGE|DROP)_<UUID>_ (be very strict about the pattern search, because why not) • If time is right, RENAME with that ID. If taken (because the statement returns an integrity error), try another ID. • use a UUID scheme, and generate truely unique IDs. Now that this is out of the way, let’s get to MySQL auto-increment [parameters...] WorkflowStart WorkflowStart <uuid> WorkflowStop WorkflowStop <uuid> WorkflowDelete WorkflowDelete <uuid> WorkflowWait WorkflowWait <uuid> WorkflowTree WorkflowTree WorkflowAction WorkflowAction

dropping a tables, so no need to check frequently • Look for tables called _vt_(HOLD|PURGE|DROP)_<UUID>_ (be very strict about the pattern search, because why not) • If time is right, RENAME with that ID. If taken (because the statement returns an integrity error), try another ID. • use a UUID scheme, and generate truely unique IDs. Now that this is out of the way, let’s get to MySQL auto-increment [parameters...] WorkflowStart WorkflowStart <uuid> WorkflowStop WorkflowStop <uuid> WorkflowDelete WorkflowDelete <uuid> WorkflowWait WorkflowWait <uuid> WorkflowTree WorkflowTree WorkflowAction WorkflowAction

449 8.7. UUID Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 450 8.7.1. CHAR_TO_UUID() . . . . . 450 8.7.2. GEN_UUID() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 450 8.7.3. UUID_TO_CHAR() . . . . kann. Das Folgende zeigt ein Beispiel dafür. SELECT UUID_TO_CHAR(X) AS C1, UUID_TO_CHAR(X) AS C2, UUID_TO_CHAR(X) AS C3 FROM (SELECT GEN_UUID() AS X FROM RDB$DATABASE) T; Das Ergebnis, wenn

356 8.7. UUID Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 357 8.7.1. CHAR_TO_UUID() . . . . . 357 8.7.2. GEN_UUID() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 357 8.7.3. UUID_TO_CHAR() . . . . 8.7. UUID Functions 8.7.1. CHAR_TO_UUID() Available in DSQL, PSQL Added in 2.5 Syntax CHAR_TO_UUID (ascii_uuid) Table 153. CHAR_TO_UUID Function Parameter Parameter Description ascii_uuid A 36-character

Denormalize to Optimize 54 Planning for Concurrent Writes 54 Using Natural or Surrogate Row Keys 54 UUID Types for Column Names 55 Managing and Accessing Data in Cassandra 55 About Writes in Cassandra IntegerType varint Arbitrary-precision integer LongType int, bigint 8-byte long UUIDType uuid Type 1 or type 4 UUID DateType timestamp Date plus time, encoded as 8 bytes since epoch BooleanType boolean to use surrogate or natural keys for a column family. A surrogate key is a generated key (such as a UUID) that uniquely identifies a row, but has no relation to the actual data in the row. For some column

собирае- тесь индексировать поле с глобально уни- кальными идентификаторами, то лучше использовать UUID - это другой формат представления GUID, представляемый как CHAR(22). - прим. перев.) Переход с MS /************************************************************** UUID_CREATE Returns a UUID (cstring(22), compressed, reversed, URL compatible UUID) Parameters: cstring(22) dummy to allow Interbase to perform *************************************/ DECLARE EXTERNAL FUNCTION UUID_CREATE CSTRING(22) RETURNS PARAMETER 1 ENTRY_POINT 'fn_uuid_create' MODULE_NAME 'uuidlib'; /*******************************