Issue Details (XML | Word | Printable)

Key: CORE-1286
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Alexander Tyutik
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Bug with COMPUTED BY fields

Created: 30/May/07 04:30 AM   Updated: 29/May/08 05:05 PM
Component/s: None
Affects Version/s: 2.0.0, 2.0.1, 2.1 Alpha 1
Fix Version/s: 2.1 Beta 1, 2.0.2

Time Tracking:
Not Specified

Environment: IBExpert
Issue Links:
Relate
 


 Description  « Hide
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.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 26/Jul/07 04:46 AM
Fix verified for 2.1 Beta 1, test added.