Correct inconsistent terms in firebird message database [CORE1396]

Submitted by: Bill Oliver (verbguy)

Votes: 1

Several terms in the firebird message file have two different spellings/spacings or casings. Very trivial, but annoying.

After discussing in devel, I changed these terms in our private copy of the Firebird messagge file: data base to database, datatype to data type, file name to filename. id to ID, and username to user name. I didn't change terms when used in a prompt or command line help.

Below is the sql script I used to make the changes and the output from the sql script (showing before and after) for review.

-- sql script begins -- data base to database (and file name to filename for next one) select fac_code, number, text from messages where fac_code = 3 and number = 1; update messages set text = 'database filename (%s) already given' where fac_code = 3 and number = 1; select fac_code, number, text from messages where fac_code = 3 and number = 1;

-- datatype to data type select fac_code, number, text from messages where fac_code = 0 and number = 449; update messages set text = 'Data type misalignment. The attempted to read or write a value that was not stored on a memory boundary.' where fac_code = 0 and number = 449; select fac_code, number, text from messages where fac_code = 0 and number = 449;

select fac_code, number, text from messages where fac_code = 0 and number = 469; update messages set text = 'Specified EXTRACT part does not exist in input data type' where fac_code = 0 and number = 469; select fac_code, number, text from messages where fac_code = 0 and number = 469;

select fac_code, number, text from messages where fac_code = 0 and number = 476; update messages set text = 'Client SQL dialect %d does not support reference to %s data type' where fac_code = 0 and number = 476; select fac_code, number, text from messages where fac_code = 0 and number = 476;

select fac_code, number, text from messages where fac_code = 0 and number = 549; update messages set text = 'Data type %s is not supported for sorting operation' where fac_code = 0 and number = 549; select fac_code, number, text from messages where fac_code = 0 and number = 549;

select fac_code, number, text from messages where fac_code = 1 and number = 267; update messages set text = ' Data type information:' where fac_code = 1 and number = 267; select fac_code, number, text from messages where fac_code = 1 and number = 267;

select fac_code, number, text from messages where fac_code = 1 and number = 278; update messages set text = ' Data type information:' where fac_code = 1 and number = 278; select fac_code, number, text from messages where fac_code = 1 and number = 278;

select fac_code, number, text from messages where fac_code = 1 and number = 340; update messages set text = ' Data type information:' where fac_code = 1 and number = 340; select fac_code, number, text from messages where fac_code = 1 and number = 340;

select fac_code, number, text from messages where fac_code = 1 and number = 475; update messages set text = ' Data type information:' where fac_code = 1 and number = 475; select fac_code, number, text from messages where fac_code = 1 and number = 475;

select fac_code, number, text from messages where fac_code = 7 and number = 5; update messages set text = 'Database SQL dialect %d does not support reference to %s data type' where fac_code = 7 and number = 5; select fac_code, number, text from messages where fac_code = 7 and number = 5;

select fac_code, number, text from messages where fac_code = 7 and number = 16; update messages set text = 'Data types %sare not comparable in expression %s' where fac_code = 7 and number = 16; select fac_code, number, text from messages where fac_code = 7 and number = 16;

select fac_code, number, text from messages where fac_code = 8 and number = 207; update messages set text = 'Cannot change data type for column %s. Changing data type is not supported for BLOB or ARRAY columns.' where fac_code = 8 and number = 207; select fac_code, number, text from messages where fac_code = 8 and number = 207;

select fac_code, number, text from messages where fac_code = 8 and number = 209; update messages set text = 'Cannot change data type for %s. Conversion from base type %s to %s is not supported.' where fac_code = 8 and number = 209; select fac_code, number, text from messages where fac_code = 8 and number = 209;

select fac_code, number, text from messages where fac_code = 8 and number = 210; update messages set text = 'Cannot change data type for column %s from a character type to a non-character type.' where fac_code = 8 and number = 210; select fac_code, number, text from messages where fac_code = 8 and number = 210;

select fac_code, number, text from messages where fac_code = 14 and number = 301; update messages set text = 'Data type needs modification' where fac_code = 14 and number = 301; select fac_code, number, text from messages where fac_code = 14 and number = 301;

-- 'file name' to 'filename' select fac_code, number, text from messages where fac_code = 0 and number = 305; update messages set text = 'A node name is not permitted in a secondary, shadow, cache or log filename' where fac_code = 0 and number = 305; select fac_code, number, text from messages where fac_code = 0 and number = 305;

select fac_code, number, text from messages where fac_code = 0 and number = 512; update messages set text = 'Cannot change difference filename while database is in backup mode' where fac_code = 0 and number = 512; select fac_code, number, text from messages where fac_code = 0 and number = 512;

select fac_code, number, text from messages where fac_code = 1 and number = 23; update messages set text = 'Please retry, supplying an application script filename' where fac_code = 1 and number = 23; select fac_code, number, text from messages where fac_code = 1 and number = 23;

select fac_code, number, text from messages where fac_code = 1 and number = 204; update messages set text = 'database filename required on READY' where fac_code = 1 and number = 204; select fac_code, number, text from messages where fac_code = 1 and number = 204;

select fac_code, number, text from messages where fac_code = 1 and number = 429; update messages set text = 'database filename required on DROP DATABASE' where fac_code = 1 and number = 429; select fac_code, number, text from messages where fac_code = 1 and number = 429;

select fac_code, number, text from messages where fac_code = 2 and number = 297; update messages set text = 'A node name is not permitted in a shadow, secondary, or log filename' where fac_code = 2 and number = 297; select fac_code, number, text from messages where fac_code = 2 and number = 297;

select fac_code, number, text from messages where fac_code = 2 and number = 298; update messages set text = 'A non-Decnet node name is not permitted in an external filename' where fac_code = 2 and number = 298; select fac_code, number, text from messages where fac_code = 2 and number = 298;

select fac_code, number, text from messages where fac_code = 2 and number = 299; update messages set text = 'A node name is not permitted in an external filename' where fac_code = 2 and number = 299; select fac_code, number, text from messages where fac_code = 2 and number = 299;

select fac_code, number, text from messages where fac_code = 2 and number = 322; update messages set text = 'a node name is not permitted in a shared cache filename' where fac_code = 2 and number = 322; select fac_code, number, text from messages where fac_code = 2 and number = 322;

select fac_code, number, text from messages where fac_code = 8 and number = 231; update messages set text = 'Filename is invalid' where fac_code = 8 and number = 231; select fac_code, number, text from messages where fac_code = 8 and number = 231;

select fac_code, number, text from messages where fac_code = 12 and number = 227; update messages set text = 'Type a filename to open and hit return' where fac_code = 12 and number = 227; select fac_code, number, text from messages where fac_code = 12 and number = 227;

select fac_code, number, text from messages where fac_code = 15 and number = 163; update messages set text = 'root filename not listed for shadow' where fac_code = 15 and number = 163; select fac_code, number, text from messages where fac_code = 15 and number = 163;

-- id to ID select fac_code, number, text from messages where fac_code = 0 and number = 151; update messages set text = 'there is no index in table %s with ID %d' where fac_code = 0 and number = 151; select fac_code, number, text from messages where fac_code = 0 and number = 151;

select fac_code, number, text from messages where fac_code = 0 and number = 394; update messages set text = 'invalid blob ID' where fac_code = 0 and number = 394; select fac_code, number, text from messages where fac_code = 0 and number = 394;

select fac_code, number, text from messages where fac_code = 3 and number = 66; update messages set text = 'bad pool ID' where fac_code = 3 and number = 66; select fac_code, number, text from messages where fac_code = 3 and number = 66;

select fac_code, number, text from messages where fac_code = 12 and number = 120; update messages set text = ' restoring gen ID value of: %ld' where fac_code = 12 and number = 120; select fac_code, number, text from messages where fac_code = 12 and number = 120;

select fac_code, number, text from messages where fac_code = 12 and number = 143; update messages set text = ' writing gen ID of: %ld' where fac_code = 12 and number = 143; select fac_code, number, text from messages where fac_code = 12 and number = 143;

select fac_code, number, text from messages where fac_code = 12 and number = 164; update messages set text = 'writing ID generators' where fac_code = 12 and number = 164; select fac_code, number, text from messages where fac_code = 12 and number = 164;

select fac_code, number, text from messages where fac_code = 15 and number = 153; update messages set text = 'invalid pool ID encountered' where fac_code = 15 and number = 153; select fac_code, number, text from messages where fac_code = 15 and number = 153;

-- username to user name select fac_code, number, text from messages where fac_code = 0 and number = 427; update messages set text = 'The user name entered is too long. Maximum length is 31 bytes.' where fac_code = 0 and number = 427; select fac_code, number, text from messages where fac_code = 0 and number = 427;

select fac_code, number, text from messages where fac_code = 0 and number = 429; update messages set text = 'A user name is required for this operation.' where fac_code = 0 and number = 429; select fac_code, number, text from messages where fac_code = 0 and number = 429;

commit;

-- -- output from sql script here, showing before and after changes --