Issue Details (XML | Word | Printable)

Key: CORE-6168
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Pieter Bas Hofstede
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Engine cant determine datatype in SQL: Unknown SQL Data type (32752). In current snapshot build

Created: 22/Oct/19 06:35 PM   Updated: 26/Jun/20 06:36 AM
Component/s: Engine
Affects Version/s: 4.0 Beta 2
Fix Version/s: 4.0 Beta 2

Environment:
Windows 10
Problem doesn't occur in Beta1.
Occurs in current snapshot build 4.0.1635 (and some earlier)

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


 Description  « Hide
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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 09/Dec/19 04:58 PM
You can avoid that setting
DataTypeCompatibility = 3.0
in firebird.conf