Difference in result of the operation when using a query value
|
If you use SQLite3 in database connection information or in a virtual query, the results of computing FLOAT data values might differ between HULFT-DataMagic Ver.2 and DataMagic Ver.3.
Example:
In HULFT-DataMagic Ver.2, when "5 / 2" is executed, 2.500000000 is returned as a floating-point value.
In DataMagic Ver.3, when "5 / 2" is executed, 2 is returned as an integer value.
Workaround:
If you want to acquire a computation result as a floating-point value,
cast the first value to FLOAT as in select CAST(NO1 as FLOAT) / NO2.