Correct inconsistent terms in firebird message database [CORE1396] #1814

firebird-automations · 2007-08-02T13:12:32Z

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
--