Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-32393

cbimport CSV fails when --infer-types is used on a field that is "NAN"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 6.0.1, 6.5.0
    • 6.0.0, 6.5.0
    • tools
    • None
    • Untriaged
    • Unknown

    Description

      Problem
      cbimport CSV fails to import a document with when using --infer-types where a field is NaN. This is because NaN is a valid float under the IEEE-754 specification meaning Not a Number.

      Steps to reproduce

      1. Create the following CSV

        a,b
        100,NAN
        

      2. Import the CSV

        cbimport csv -c couchbase://localhost -u Administrator -p password -b default -d file:///test.csv --field-separator , -g direct::#MONO_INCR# --omit-empty --infer-types
        

      Expectation
      For the import not to fail and for NAN to be treated as a string and not a float.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            pvarley Patrick Varley (Inactive)
            pvarley Patrick Varley (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty