From: Alexander Tyutik (JIRA) <tracker@fi...> - 2007-05-29 08:31:59
Bug with COMPUTED BY fields
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.1 Alpha 1
Reporter: Alexander Tyutik
I have DB with all character fields of UTF8 charset. I've connected to DB with UTF8 charset and tried to add computed field to existing table:
1) ALTER TABLE "Test" ADD STR1 COMPUTED BY ('BLA-BLA-BLA');
After this i've got next error when tried to read table's data: "Arithmetic exception, numeric overflow or string truncation"
2) ALTER TABLE "Test" ADD STR2 COMPUTED BY (_UTF8 'BLA-BLA-BLA');
First time server crashes with "Terminated abnormally" in log file. After server restarted field wass successfully created, but when i tried to read records i've got same error as above.
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira