HASH(realvalue) implemented as HASH((integer)realvalue)

Currently real values are converted to integers before hashing.  This is unlikely to cause bugs, but it may well cause inefficiencies - because records are grouped together that into clumps.

It cannot really be fixed because it would create too many backward compatibility problems, but creating a Jira so that the behaviour is documented.

The workaround is to type transfer the value to DATA before hashing.

i.e.

HASH((>DATA<)realvalue)

which will prevent the conversion.