[
https://issues.apache.org/jira/browse/NIFI-15305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18051661#comment-18051661
]
ASF subversion and git services commented on NIFI-15305:
--------------------------------------------------------
Commit d8edf5731688441414399a772d735383a5e65df9 in nifi's branch
refs/heads/main from Pierre Villard
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=d8edf57316 ]
NIFI-15405 Restored code inadvertently removed by 3beed0da3e3 (#10765)
- NIFI-15394 Included scoped Controller Services when Clearing Bulletins for
Process Groups
- NIFI-12598 Allow Starting/Stopping of PG components to be recorded in Flow
Configuration History
- NIFI-15305 Fixed Date Time conversion for floating point as string
- NIFI-15395 Clearing Bulletins with no component returns a 200
Signed-off-by: David Handermann <[email protected]>
> PutDatabaseRecord Timestamp Inconsistent Parsing
> ------------------------------------------------
>
> Key: NIFI-15305
> URL: https://issues.apache.org/jira/browse/NIFI-15305
> Project: Apache NiFi
> Issue Type: Bug
> Components: Extensions
> Affects Versions: 2.6.0
> Reporter: Taylor Obyen
> Assignee: David Handermann
> Priority: Minor
> Fix For: 2.8.0
>
> Attachments: image-2025-12-06-19-30-42-959.png
>
> Time Spent: 1h 50m
> Remaining Estimate: 0h
>
> There is a bug with the PutDatabaseRecord processor in which epoch timestamps
> are parsed as millisecond timestamps when provided a number with no decimals
> and seconds when there is a decimal.
>
> NiFi Version: 2.6.0
> PostgreSQL Version: 18.1
> PostgreSQL Driver Version: 42.7.8
> Record Reader: JsonTreeReader (No modifications)
> Statement Type: INSERT
>
> Table schema
> {code:java}
> CREATE TABLE public.test (
> id int GENERATED BY DEFAULT AS IDENTITY,
> ts timestamptz NOT NULL
> ); {code}
>
> Input:
> {code:java}
> {
> "ts": 1765056655230
> } {code}
> Timestamp loaded into PostgreSQL: `{color:#00875a}2025-12-06 16:30:55.230
> -0500{color}`
>
> Input:
> {code:java}
> {
> "ts": 1765056655230.746
> } {code}
> Timestamp loaded into PostgreSQL: `{color:#FF0000}57902-06-03 07:20:30746.
> -0400{color}`
>
> The information tip for the Timestamp Format field in the JsonTreeReader
> Controller Service indicates that timestamp fields are assumed to be the
> epoch in milliseconds unless a time format is specified:
> !image-2025-12-06-19-30-42-959.png|width=584,height=235!
>
> The behavior was introduced in: NIFI-12710
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
