Details

    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Use a csv with columns of true/false.
      PDI detects that the column is boolean
      The MonetDB DDL generates a datatype of char(1)
      Bulkloader tries to upload the strings true/false and blows an error

        Issue Links

          Activity

          Hide
          jdixon James Dixon added a comment -

          Fix checked into the 4.4.0 and 4.4.0-GA branches

          Show
          jdixon James Dixon added a comment - Fix checked into the 4.4.0 and 4.4.0-GA branches
          Hide
          gdavid Golda Thomas added a comment - - edited

          Validated this issue using the PDI 4.4 installer build on 11/02/2012 on my win 7 machine.

          Tested this issue with the above CSV file which has a column with Boolean data type.
          PDI detects that the column in Boolean data type and bulk loader uploads the field correctly with Y or N.

          Was able to create an analyzer report and the report showed the correct Boolean value.

          This issue is resolved.

          Show
          gdavid Golda Thomas added a comment - - edited Validated this issue using the PDI 4.4 installer build on 11/02/2012 on my win 7 machine. Tested this issue with the above CSV file which has a column with Boolean data type. PDI detects that the column in Boolean data type and bulk loader uploads the field correctly with Y or N. Was able to create an analyzer report and the report showed the correct Boolean value. This issue is resolved.
          Hide
          rfellows Rob Fellows added a comment -

          I verified that this is also working as expected on Mac.

          Show
          rfellows Rob Fellows added a comment - I verified that this is also working as expected on Mac.
          Hide
          gdavid Golda Thomas added a comment -

          Tested this issue using the Latest PDI 4.4 build and this issue is resolved.

          Show
          gdavid Golda Thomas added a comment - Tested this issue using the Latest PDI 4.4 build and this issue is resolved.

            People

            • Assignee:
              gdavid Golda Thomas
              Reporter:
              dmoran Doug Moran
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: