Itgenrst004 error on avg() with Query Tool 24.0.658

Vragen
,
1

The query:

select avg(Dummy_Int32)
from DUAL@DataDictionary

raises:

itgenrst004:
The type of the actual data must match the data type of the column ‘AVG_DUMMY_INT32_’ in ‘’.
Ensure that the actual data data type (currently ‘Double’) in row #1 is cast to the data type (currently ‘int32’).
AVG_DUMMY_INT32_ (Double, metadata int32): 25

Error seems similar to Itgensql151 on QueryTool Beta 24.1.113 on loading Fortnox inmemory table.

2

Does this error also occur on:

https://download.invantive.com/release/msi/Invantive%20Query%20Tool-24.0.733-net48.msi

The bug has been signaled some weeks ago and a fix should have been shipped in recent release.

3

After testing, the error is still here in latest releases:

  • 24.0.733-PROD
  • 24.1.116-BETA
4

Relates to Itgenrst004 op avg in BETA-release 24.1 (Dutch).

Needs retest.