Re: [Firebird-devel] Firebird 3.0.0.31348 - string truncation error

2014-10-03 Thread Alex Peshkoff
On 10/03/14 01:25, Thomas Steinmaurer wrote: RELATION_NAME = Statement failed, SQLSTATE = 22001 arithmetic exception, numeric overflow, or string truncation -string right truncation -expected length 10, actual 21 SQL Seems to be a problem with using the TYPE OF clause for the

Re: [Firebird-devel] Firebird 3.0.0.31348 - string truncation error

2014-10-03 Thread Thomas Steinmaurer
RELATION_NAME = Statement failed, SQLSTATE = 22001 arithmetic exception, numeric overflow, or string truncation -string right truncation -expected length 10, actual 21 SQL Seems to be a problem with using the TYPE OF clause for the data type. When I replace that with e.g.

[Firebird-devel] Firebird 3.0.0.31348 - string truncation error

2014-10-02 Thread Thomas Steinmaurer
Hello, I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit. In a UTF8 database, I have a table with the following name: A_VERY_LONG_TABLENAME And a package with a single selectable SP, basically querying the table names: SET TERM ^^ ; CREATE OR ALTER PACKAGE

Re: [Firebird-devel] Firebird 3.0.0.31348 - string truncation error

2014-10-02 Thread Thomas Steinmaurer
Hello, I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit. In a UTF8 database, I have a table with the following name: A_VERY_LONG_TABLENAME And a package with a single selectable SP, basically querying the table names: SET TERM ^^ ; CREATE OR ALTER PACKAGE