Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1792

Timestamp --> Datetime insert: milliseconds are wrongly inserted in CS

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2.0
    • 1.2.1
    • None
    • None
    • 2018-20

    Description

      Using PDI bulk adapter the following issue is found:
      1. PDI type Timstamp is loaded into CS Datetime field using CSV file.
      2. The value of the field is 2018-01-01 00:00:01.220
      and this field should be loaded in CS DATETIME (6) field.

      Result observed in CS after load is:
      2018/01/01 00:00:01.000022000

      Expected:
      2018/01/01 00:00:01.220000000

      Notes:
      I tried with direct insert into CS and this works correctly.
      So issue lays somewhere in PDI adapter or api.

      PDI job script is attached.
      @Jens, could you please add it to automated tests?

      Attachments

        Issue Links

          Activity

            People

              elena.kotsinova Elena Kotsinova (Inactive)
              elena.kotsinova Elena Kotsinova (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.