ES-291

Floating point number type decimals cannot be written to integer type fields during insertion processing by the PostgreSQL adapter

Phenomenon

If floating point type values are written to the following integer type fields during insertion processing by the PostgreSQL adapter, an error occurs and the output fails.

• SMALLINT

• INTEGER

• BIGINT

[Output error]

could not exec statement: pq: invalid input syntax for integer: \"123.456\"
dropped tuple

Affected versions

Ver.2.1.0

Corrected version

Ver.2.2.0

Affected module

HULFT IoT EdgeStreaming Studio

HULFT IoT EdgeStreaming Runtime

Condition to reproduce

This phenomenon occurs when floating point type values are written to integer type fields during insertion processing by the PostgreSQL adapter.

Alternative workaround

When writing floating point type decimal to the data types shown below, use the Rounding logic or the Rounding (precision) logic.

When you use the Rounding (precision) logic, set the "Precision" to "0".

• SMALLINT

• INTEGER

• BIGINT

Status description

Floating point type values can be written to the following integer type fields during insertion processing by the PostgreSQL adapter:

• SMALLINT

• INTEGER

• BIGINT