Helen Borrie wrote / napísal (a):

>At 11:13 AM 24/02/2005 +0100, you wrote:
>
>
>
>>Hello,
>>
>>I have performed this:
>>- backed up my DB
>>- reinstalled FB 1.5.2 on 1.5.0 (both SS, on linux Slackware 10. The
>>1.5.0 was backed up by installation program)
>>- I copied my own library udf_nd.so to the new installation (contains
>>several functions, e.g. TS_FMT)
>>- restored the DB
>>
>>Now, when I perform
>>select '02/14/2005', ts_fmt('02/14/2005', '%Y-%m') from rdb$database;
>>I get the error
>>"arithmetic exception, numeric overflow, or string truncation"
>>
>>Please help me, what could be wrong ?
>>
>>
>
>Well, the engine has no idea what data type or column name to return in the
>second field.
>
>Try supplying a CAST expression and a column name, e.g.
>
>select
> '02/14/2005',
> CAST(ts_fmt('02/14/2005', '%Y-%m') AS CHAR(5)) AS field2
>from rdb$database;
>
>

Thank you, but it throws the same exception. However, this select was
just an example, here is the real one:

SELECT TS_FMT(DatumZP,'%Y-%m') AS Usek , sum(CenaNetA) as Vystup1,
sum(CenaNetB) as Vystup2 FROM OdbFak GROUP BY TS_FMT(DatumZP,'%Y-%m')

and this was working prior to the reinstallation, so I wonder where else
may be error. Now I tried with the old DB file, throws the same error.
So it is either bug in (my instance of) FB 1.5.2 (which was not in
1.5.0). I don't know what may be the problem. Could I ommit to copy some
files or settings ?

Thank you again

Rado



[Non-text portions of this message have been removed]