Uwe Geercken created NIFI-3610: ---------------------------------- Summary: PutSql truncates data after 80 characters Key: NIFI-3610 URL: https://issues.apache.org/jira/browse/NIFI-3610 Project: Apache NiFi Issue Type: Bug Components: Core UI Affects Versions: 1.1.1 Environment: Fedora 25 Reporter: Uwe Geercken
I have a ConvertJsonToSQL processor with following attribute: sql.args.4.value Type: flights, Station: hel, Month offset: -1, Environment: dev hello uwe what are you doing here the sql.args.4.type is: -1 (LONGVARCHAR) This processor is connected to a PutSQL processor. The same attribute looks like this: sql.args.4.value Type: flights, Station: hel, Month offset: -1, Environment: dev hello uwe what a The data is truncated after 80 characters and arrives like this in the database. I have checked the database - it allows up to 255 characters. The insert query from PutSQL - just for the completeness - is: INSERT INTO process_monitoring (process_name, process_name_monitoring, last_runtime_automatic, parameters) VALUES (?, ?, ?, ?). And the record does get inserted - but column "parameters" is truncated to 80 characters. -- This message was sent by Atlassian JIRA (v6.3.15#6346)