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)
