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

Engine cant determine datatype in SQL: Unknown SQL Data type (32752). In current snapshot build [CORE6168] #6416

Closed
firebird-automations opened this issue Oct 22, 2019 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Pieter Bas Hofstede (pieterbashofstede)

Example SQL using RDB$ tables to be reproducable on any database.
As you can see, the column type of douple precision * 1.00 can be determined.
But the column (number 3) of type of smallint * 1.00 can't and needs casting to be able to run. The same applies for numerics and (small)ints for example.

select
avg(i.RDB$STATISTICS),
avg(i.RDB$STATISTICS * 1.00),
avg(i.RDB$FIELD_POSITION),
avg(i.RDB$FIELD_POSITION * 1.00),
cast(avg(i.RDB$FIELD_POSITION * 1.00) as decimal(9,2))
from
RDB$INDEX_SEGMENTS i

====== Test Details ======

Can not be tested using current fbtest package: client 3.x and server 4.x required for this.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

security: Developers [ 10012 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

You can avoid that setting
DataTypeCompatibility = 3.0
in firebird.conf

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 2 [ 10888 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Deferred

Test Details: Can not be tested using currnt fbtest package: client 3.x and server 4.x required for this.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

Test Details: Can not be tested using currnt fbtest package: client 3.x and server 4.x required for this. => Can not be tested using current fbtest package: client 3.x and server 4.x required for this.

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

No branches or pull requests

2 participants