Open Boberoo opened 3 years ago
I have run some tests on Firebird 4, and it works well.
The main problem I ran into, is this error:
Unknown SQL Data type (32752)
It happens if I do something like:
select sum(MyNum) from MyTable
MyNum is a decimal(18,5)
Firebird is converting it to the new decfloat type, which FIBPlus does not recognise.
It is fantastic, as large calculations that used to cause overflow error don't any more.
It can be avoided by adding a cast() or using the compatibility features, but it would be nice if the new data types were added to FIBPlus.
The other place I had a Unknown SQL Data type (3275x) error was:
select * from mon$attachments
That was due to the new datetime with local portion. Got around it by casting to a regular timestamp, or invoking the use of legacy types.
I have run some tests on Firebird 4, and it works well.
The main problem I ran into, is this error:
Unknown SQL Data type (32752)
It happens if I do something like:
MyNum is a decimal(18,5)
Firebird is converting it to the new decfloat type, which FIBPlus does not recognise.
It is fantastic, as large calculations that used to cause overflow error don't any more.
It can be avoided by adding a cast() or using the compatibility features, but it would be nice if the new data types were added to FIBPlus.
The other place I had a Unknown SQL Data type (3275x) error was:
That was due to the new datetime with local portion. Got around it by casting to a regular timestamp, or invoking the use of legacy types.