[jira] Commented: (DERBY-3682) SYSCS_BULK_INSERT doesn't quote identifiers or strings properly

["Knut Anders Hatlen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-3682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12598940#action_12598940 ] 

Knut Anders Hatlen commented on DERBY-3682:
-------------------------------------------

The tests passed, but I'll upload a new patch since we should use shared code in IdUtil/StringUtil to quote the strings and identifiers instead of having a private implementation in SystemProcedures.

> SYSCS_BULK_INSERT doesn't quote identifiers or strings properly
> ---------------------------------------------------------------
>
>                 Key: DERBY-3682
>                 URL: https://issues.apache.org/jira/browse/DERBY-3682
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.4.1.3
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>            Priority: Minor
>         Attachments: d3682.diff
>
>
> Discovered by Mamta A. Satoor in DERBY-1062.
> SYSCS_BULK_INSERT builds an insert statement in which it doesn't quote the schema name or the table name. It also takes string parameters that are inserted into the statement text with single quotes around them, but that won't work if those strings contain single quote characters.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.