[jira] Closed: (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:all-tabpanel ]

Knut Anders Hatlen closed DERBY-3682.
-------------------------------------

       Resolution: Fixed
    Fix Version/s: 10.5.0.0
       Derby Info:   (was: [Patch Available])

Thanks for reviewing the patch Dag. Committed revision 660153.

I guess JDBC.escape() could also be generalized, but tests which have these strings that need special escaping tend to use parameter markers and setString() instead. And if the tests are specialized in order to check that the parser handles the strings correctly, the full statement text is normally hand-crafted in the test.

> 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
>             Fix For: 10.5.0.0
>
>         Attachments: d3682.diff, d3682a.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.