Uploaded image for project: 'StreamSets Data Collector'
  1. StreamSets Data Collector
  2. SDC-5605

JDBC Producer cannot insert values into PostgreSQL table with uppercase table name

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: P1 (Blocker)
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.5.0.0
    • Component/s: None
    • Labels:
      None
    • Target Version/s:
    • Sprint:
      SDC Sprint 55
    • Doc Impact:
      Complete
    • Testing Status:
      Testing Completed

      Description

      The PostgreSQL database by DEFAULT is case INSENSITIVE in all unquoted identifiers. (https://www.postgresql.org/docs/9.4/static/sql-syntax-lexical.html, http://stackoverflow.com/a/9538743/1591777).

      Currently, JDBC Producer cannot insert values into PostgreSQL table with uppercase table name.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jisun Ji Sun Kim (Inactive)
              Reporter:
              aneta Aneta Cechova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: