[NIFI-8749] PutDatabaseRecord Insert Datetime Type Time Zone Issue

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.13.0, 1.14.0, 1.13.2
• Fix Version/s: 1.15.0
• Assignee: David Handermann
• Reporter: Billy Lin
• Created: 01/Jul/21 03:04
• Updated: 30/Mar/23 15:24
• Resolved: 31/Aug/21 20:21

Description

when I query a record from Mysql to get an AVRO Flowfile, then use  PutDatabaseRecord(version 1.13.2) insert to another table (with same table structure), the data of the 'datetime' type column will change. The original data of the first table I query from is '2021-06-28 13:14:20.0'. and the data of the second table which I insert to becomes '2021-06-28 06:14:20.0'.The gap is 7 hours.

our local timezone is PDT (-7:00). It seems that Nifi has done some timezone conversion work. But the 'datetime' type in mysql should have no relation to timezone

 

when we use version 1.7.1 ,it works fine.

Issue Links

• causes: NIFI-9187 Test Record Path failure
• fixes: NIFI-9187 Test Record Path failure
• relates to: NIFI-11367 Database DATE value displayed incorrectly in record output if timezone is GMT-X
• links to: GitHub Pull Request #5305
• links to: GitHub Pull Request #5361