Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3682

SYSCS_BULK_INSERT doesn't quote identifiers or strings properly

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.4.1.3
    • 10.5.1.1
    • SQL
    • None

    Description

      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.

      Attachments

        1. d3682a.diff
          11 kB
          Knut Anders Hatlen
        2. d3682.diff
          8 kB
          Knut Anders Hatlen

        Activity

          People

            knutanders Knut Anders Hatlen
            knutanders Knut Anders Hatlen
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: