2.1 Error Codes SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 101 335544366 segment Segment buffer length shorter than expected 100 335544338 from_no_match 336397222 dsql_derived_alias_select Internal dsql error: alias type expected by pass1_expand_select_node -104 336397223 dsql_derived_alias_field Internal dsql error: alias type expected by pass1_field supported -406 335544457 out_of_bounds Subscript out of bounds -407 335544435 nullsegkey Null segment of UNIQUE KEY -413 335544334 convert_error Conversion error from string "@1" -413 335544454 nofilter

Firebird 2.0 Error Codes Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 100 335544338 from_no_match No match for first value expression supported -406 335544457 out_of_bounds Subscript out of bounds -407 335544435 nullsegkey Null segment of UNIQUE KEY Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -413 335544334 convert_error dsql_shadow_number_err Shadow number must be a positive integer -599 335544607 node_err Gen.c: node not supported -599 335544625 node_name_err A node name is not permitted in a secondary, shadow, cache or log file

1.5 Error Codes from msg.gbak, release sources SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 100 335544338 from_no_match No match for first value expression supported -406 335544457 out_of_bounds Subscript out of bounds -407 335544435 nullsegkey Null segment of UNIQUE KEY -413 335544334 convert_error Conversion error from string "" -413 335544454 dsql_shadow_number_err Shadow number must be a positive integer -599 335544607 node_err Gen.c: node not supported -599 335544625 node_name_err A node name is not permitted in a secondary, shadow, cache or log file

длины, зачастую очень большого объёма. Типы данных 45 Синтаксис: BLOB [SUB_TYPE ] [SEGMENT SIZE ] [CHARACTER SET ] Сокращённый синтаксис: CHAR} [VARYING] [(size)] [] | BLOB [SUB_TYPE {subtype_num | subtype_name}] [SEGMENT SIZE seglen] [CHARACTER SET charset] | BLOB [(seglen [, subtype_num])] ::= [[x:]y CHAR} [VARYING] [(size)] [] | BLOB [SUB_TYPE {subtype_num | subtype_name}] [SEGMENT SIZE seglen] [CHARACTER SET charset] | BLOB [(seglen [, subtype_num])] ::= [x:y [

to (2 63 - 1) The data type is available in Dialect 3 only BLOB Varying The size of a BLOB segment is limited to 64K. The maximum size of a BLOB field is 4 GB A data type of a dynamically variable storing large amounts of data, such as images, text, digital sounds. The basic structural unit is a segment. The blob subtype defines its content CHAR(n), CHARACTER(n) n characters. Size in bytes depends ] [SEGMENT SIZE <segment size>] [CHARACTER SET ] [COLLATE ] Chapter 3. Data Types and Subtypes 36 Shortened syntax BLOB (<segment size>) BLOB (<segment size>,

number of characters is not specified, 1 is used by default. BLOB Varying The size of a BLOB segment is limited to 64K. The maximum size of a BLOB field is 4 GB A data type of variable size for storing large amounts of data, such as images, text, digital sounds. The basic structural unit is a segment. The blob subtype defines its content BOOLEAN 8 bits false, true, unknown Boolean data type ] [SEGMENT SIZE <segment size>] [CHARACTER SET ] [COLLATE ] Chapter 3. Data Types and Subtypes 52 Shortened syntax BLOB (<segment size>) BLOB (<segment size>,

großen Datenmengen, wie z.B. Bilder, Texte, Audiodaten. Die strukturelle Basiseinheit is das Segment. Der BLOB-Untertyp definiert dessen Inhalt. BOOLEAN 8 Bits false, true, unknown Boolean-Datentyp BLOB [SUB_TYPE ] [SEGMENT SIZE <segment size>] [CHARACTER SET ] [COLLATE ] Verkürzte Syntax BLOB (<segment size>) BLOB (<segment size>, ) BLOB (, ) Syntax der BLOB-Datentypen ::= BLOB [SUB_TYPE {subtype_num | subtype_name}] [SEGMENT SIZE seglen] [CHARACTER SET charset] Chapter 3. Datentypen und Untertypen 56 | BLOB [(seglen

22 6.2. Get segment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 6.3. Put segment . . . . . . op_open_blob2) 6.2. Get segment Client Int32 Operation code (op_get_segment) Int32 Blob handle Int32 Segment length (max length = 32768) Chapter 6. Blobs 22 Int32 Data segment (0) Server Generic Generic response — where Data is the blob segment. 6.3. Put segment Client Int32 Operation code (op_batch_segments) Int32 Blob handle Buffer Blob Segments Server Generic response 6.4. Seek Client

PAGE_SIZE, PAGES, PASSWORD, PRIVILEGES, PROTECTED, READ, RESERV, RESERVING, RETAIN, SCHEMA, SEGMENT, SHADOW, SHARED, SINGULAR, SIZE, SNAPSHOT, SORT, STABILITY, STARTING, STARTS, STATEMENT HELP, IMMEDIATE, INDICATOR, INIT, INPUT, ISQL, LC_MESSAGES, LC_TYPE, LEV, LOG_BUFFER_SIZE, MAX_SEGMENT, MAXIMUM, MESSAGE, MINIMUM, NOAUTO, NUM_LOG_BUFFERS, OUTPUT, PAGELENGTH, PREPARE, PUBLIC, PRIVILEGES PROTECTED 22 Руководство по языку SQL READ RESERV RESERVING RESTRICT RETAIN ROLE SCHEMA SEGMENT SHADOW SHARED SINGULAR SIZE SNAPSHOT SORT STABILITY STARTING STARTS STATEMENT STATISTICS SUB_TYPE

btr_level One byte, unsigned. Byte 0x21 on the page. The index level. Level zero indicates a leaf node. 10.2. Index Jump Info Following on from the above, at byte 0x22 on the page, is an Index Jump Info structure. The value here is the number of bytes left to be used before we have to create a new jump node. jumpers One byte, unsigned. Offset 0x05 in the structure. The running total of the current number pointer to where this node can be read from the page USHORT prefix; // length of prefix against previous jump node USHORT length; // length of data in jump node (together with prefix