Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-8750

PutDatabaseRecord Insert Varchar Type Data Issue

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Duplicate
    • 1.13.2
    • 1.14.0
    • None
    • None

    Description

      when I query a record from Mysql to get an AVRO Flowfile, then use PutDatabaseRecord(version 1.13.2) insert to another table that has one more column then the avro flowfile. the data of the varchar(60) will change. The original data of the first table I query from is '0069443370'. and the data of the second table which I insert to becomes '69443370'.

      when the sceond target table has the same structure of the first table, it works fine.

      when we use version 1.7.1 ,it works fine.

      Attachments

        1. cc1.png
          49 kB
          Billy Lin
        2. cc222.png
          7 kB
          Billy Lin
        3. cc5.png
          12 kB
          Billy Lin
        4. cc6.png
          12 kB
          Billy Lin

        Issue Links

          Activity

            People

              Unassigned Unassigned
              adg7511 Billy Lin
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: