[
https://issues.apache.org/jira/browse/NIFI-8027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17250592#comment-17250592
]
ASF subversion and git services commented on NIFI-8027:
-------------------------------------------------------
Commit 989287adafefd38273c85ec5e7391d131197a90b in nifi's branch
refs/heads/main from Tamas Palfy
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=989287a ]
NIFI-8027 In AbstractExecuteSQL make 'SQL Pre-Query' and 'SQL Post-Query'
properties support escaping semicolons to allow them be part of statements.
Signed-off-by: Matthew Burgess <[email protected]>
This closes #4732
> Allow semicolons in SQL Pre-Query and SQL Post-Query statements
> ---------------------------------------------------------------
>
> Key: NIFI-8027
> URL: https://issues.apache.org/jira/browse/NIFI-8027
> Project: Apache NiFi
> Issue Type: Improvement
> Reporter: Tamas Palfy
> Assignee: Tamas Palfy
> Priority: Major
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Certain session-wide settings require complex statements that contain
> semicolons.
> AbstractExecuteSQL.SQL_PRE_QUERY and AbstractExecuteSQL.SQL_POST_QUERY
> however uses semicolons as the delimiter for multiple statements.
> We could add the option to escape semicolons which then won't be considered a
> closing of a statement.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
