Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for new Firebird 4 data types #55

Open
Boberoo opened this issue Sep 29, 2021 · 0 comments
Open

Support for new Firebird 4 data types #55

Boberoo opened this issue Sep 29, 2021 · 0 comments

Comments

@Boberoo
Copy link
Contributor

Boberoo commented Sep 29, 2021

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant