description: Trying to input an illegal character (e.g. danish letters ?,?,?) in a field name crashes the program with

Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
Cannot transliterate character between character sets.

Afterwards the rdb$relation_fields.rdb$field_name is impossible to address for the table.

Running the following SQL will fix the problem:

update rdb$relation_fields
set rdb$field_name = 'NewFieldName'
where rdb$relation_name = 'NEW_TABLE'

However, I guess illegal characters should be caught by the engine before going into the rdb$relation_fields.rdb$field_name :)

=>

Bug encountered with IBExpert and Firebird-2.0.1.12855-1 embedded server.
Creating a new table (NEW_TABLE) and then inputting an illegal character (e.g. danish letters ?,?,?) in the default fields field name crashes the program with the message:

Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
Cannot transliterate character between character sets.

Afterwards the rdb$relation_fields.rdb$field_name is impossible to address for the table.

Running the following SQL will fix the problem:

update rdb$relation_fields
set rdb$field_name = 'NewFieldName'
where rdb$relation_name = 'NEW_TABLE'

However, I guess illegal characters should be caught by the engine before going into the rdb$relation_fields.rdb$field_name :)

Workflow: jira [ 12060 ] => Firebird [ 15561 ]