30 13. Database Validation and Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 13.1. Database Validation . . . . . . . . . 31 13.1.1. Default Validation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 13.1.2. Full Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 13.1.3. Read-only Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

335544347 not_valid Validation error for column @1, value "@2" -625 335544879 not_valid_for_var Validation error for variable @1, value "@2" -625 335544880 not_valid_for Validation error for @1, value

such as the number of input or output parameters, called routines and so on, do not affect the validation field even though they potentially invalidate the module. A typical such scenario might be one 335544347 not_valid Validation error for column @1, value "@2" -625 335544879 not_valid_for_var Validation error for variable @1, value "@2" -625 335544880 not_valid_for Validation error for @1, value CHAR(31) Not used RDB$VALIDATION_BLR BLOB BLR The binary language representation (BLR) of the SQL expression specifying the check of the CHECK value in the domain RDB$VALIDATION_SOURCE BLOB TEXT The

целостности. -625 335544347 not_valid Validation error for column @1, value "@2". Ошибка проверки данных для столбца @1, значение "@2". -625 335544879 not_valid_for_var Validation error for variable @1, value value "@2". Ошибка проверки данных для переменной @1, значение "@2". -625 335544880 not_valid_for Validation error for @1, value "@2". Обработка ошибок, коды и сообщения 591 SQLCODE GDSCODE SYMBOL TEXT RDB$QUERY_NAME CHAR(31) Не используется. RDB$VALIDATION_BLR BLOB BLR Двоичное представление (BLR) выражения SQL, задающее проверку значения CHECK у домена. RDB$VALIDATION_SOURCE BLOB TEXT Оригинальный исходный

NULL constraint to an existing domain will subject all columns using this comain to a full data validation, so ensure that the columns have no nulls before attempting the change. DROP NOT NULL Drop the constraint name.  The successful addition of the NOT NULL constraint is subject to a full data validation on the table, so ensure that the column has no nulls before attempting the change. An explicit such as the number of input or output parameters, called routines and so on, do not affect the validation field even though they potentially invalidate the module. A typical such scenario might be one

335544347 not_valid validation error for column @1, value "@2" -625 335544879 not_valid_for_var validation error for variable @1, value "@2" -625 335544880 not_valid_for validation error for @1, value Nicht in Verwendung RDB$VALIDATION_BLR BLOB BLR Die Binärsprachenrepräsentation (BLR) des SQL-Ausdrucks, der die Prüfung der CHECK-Werte in der Domain angibt RDB$VALIDATION_SOURCE BLOB TEXT Der originale some object types are enumerated: 0 - TABLE 1 - VIEW 2 - TRIGGER 3 - COMPUTED_FIELD 4 - VALIDATION 5 - PROCEDURE … Anhang D: Systemtabellen 671 Spaltenname Datentyp Beschreibung RDB$TYPE_NAME

integ_index_seg_mod Cannot update index segment used by an Integrity Constraint -625 335544347 not_valid Validation error for column , value "" -637 335544664 dsql_duplicate_spec Duplicate specification

integ_index_seg_mod Cannot update index segment used by an Integrity Constraint -625 335544347 not_valid Validation error for column %s, value "%s" -637 335544664 dsql_duplicate_spec Duplicate specification of

even though it was tolerated in InterBase and previous Firebird versions. Query Plans Stricter validation of user-specified plans User-specified plans are validated more strictly than they were formerly