mariuz wrote:

>>> > > mariuz wrote:
>>>> > > > ---- ACTUAL OUTPUT
>>>> > > > insert
>>>> > > > DECIMAL[2] fail
>>>> > > > in: -2.0304723312257E+14
>>>> > > > out: -203047233122569.984
>>> > >
>>> > > I've seen different results depending on which OS you are running and 32/64 bit.
>>> > > I don't treat this as a 'failure' but rather a badly constructed test case? The
>>> > > 'failure' was demonstrated with the generic tests in ibtest.php which didn't
>>> > > actually give the right value when working with the higher value numeric sizes
>>> > > such as NUMERIC(18,8), but I think these are now fixed.
>> > The value is inserted correctly : - 203047233122569.984 is generated randomly rand_number(18,3) , that is why it differs every time on each test
>> >
>> > I think is just a failure on how the value is printed on the output
>> > I will check with a simpler test
>> >
> It's a core php issue in the way the scientific notation is shown instead of full number (if the number is big enough)
>
> http://stackoverflow.com/questions/491154/round-in-php-shows-scientific-notation-instead-of-full-number
>
> Here are my tests (I only insert this value -195264376833689.984 instead of random one)
> https://gist.github.com/1746550
> and results
>
> https://gist.github.com/1746543

I was fairly happy that it was a faulty test rather than anything wrong with
Firebird ;)

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php