AnibalV created NIFI-12313:
------------------------------
Summary: PutDatabaseRecord Insert datetime without microseconds
due to data type conversion
Key: NIFI-12313
URL: https://issues.apache.org/jira/browse/NIFI-12313
Project: Apache NiFi
Issue Type: Bug
Affects Versions: 1.23.2
Environment: Nifi 1.23.2.
SQL Server 2022
Reporter: AnibalV
Attachments: database.png, flowfile.png, nifi_flow.png
We have encountered an issue when migrating from version 1.12.1 to version
1.23.2, which is related to the change associated with this issue:
"[NIFI-8223] - PutDatabaseRecord should use table column datatype instead of
field datatype."
This issue introduced a change in the data transformation logic in the
PutDatabaseRecord processor, which converts a field (e.g., of type string) to
the data type of its corresponding database column.
This is causing problems because our field in the database is of type datetime2
and our string is "2023-10-19 14:14:59.999314" However, the processor is
converting it to "2023-10-19 14:14:59" without microseconds, despite setting
the format in the csvreader.
To address this, we have made an adjustment in the PutDatabaseRecord processor
so that users at the processor level can choose whether to apply the
transformation to the database column type or maintain the Nifi format.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
