turcsanyip commented on pull request #4734:
URL: https://github.com/apache/nifi/pull/4734#issuecomment-754619090
@exceptionfactory I ran some test flows and there is a regression in
ConvertRecord.
ConvertRecord setup:
- Json reader/writer (XML and CSV also affected)
- explicit Avro schema specified with Date logical type
- input date: "1970-01-05"
- expected output: the same date ("1970-01-05")
If I run it in a UTC+ time zone, the output is one day earlier
("1970-01-04").
The other PR on this jira (https://github.com/apache/nifi/pull/4677 by
@adenes) has the same issue so I think it needs to be fixed somewhere else in
the codebase (I guess where the java.sql.Date value is written from the record
to string).
There is one more use case which is not working. This is not a regression
and might have never worked but it would be great to fix it also:
ExecuteSQLRecord with Json/CSV/XML record writer (the date is one day earlier
then in the database if NiFi is running in a UTC+ time zone)
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
