You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
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.
The text was updated successfully, but these errors were encountered: