Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.3.0
-
Fix Version/s: 2.4.0
-
Component/s: DB Dialect Interbase
-
Labels:None
-
Number of attachments :
Description
During initial load, the following error occurs:
java.sql.SQLException: [interclient][interbase]arithmetic exception, numeric overflow, or string truncation
The problem happens when an Interbase table has multiple varchar/char columns that need wrapped with sym_escape() function. The amount of data in the columns seems to make a difference also. For example, more than 500 characters.
It appears to be an issue with the sym_escape() function. It's defined as an external function that returns a cstring(32660). If it is defined as cstring(4096), the initial load works. The data capture is currently limited to 4096 characters per row on this platform already, so that seems fine for now.