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

cpimport loads empty value ("") as NULL for all data types

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 1.1.4, 1.2.3
    • Icebox
    • cpimport
    • None

    Description

      Both DML and LDI saturates values per the data type. For numeric data types, it should be saturated to 0. For date, datetime, and time, it should be saturated to all 0s. For strings, it should be loaded as empty string.

      Note: Empty values in string data types will returned as NULL when queried.

      Attachments

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. MCOL-271 Improved support for NULL for Varchar/char/text/datetime/timestamp + ?

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            LinuxJedi Andrew Hutchings (Inactive) added a comment -

            It is not clear what the complaint is here.

            Is it that on cpimport that empty turns into NULL? If so that is by design as there is no other way of entering NULL in the default mode. Or is LDI doing something weird?

            LinuxJedi Andrew Hutchings (Inactive) added a comment - It is not clear what the complaint is here. Is it that on cpimport that empty turns into NULL? If so that is by design as there is no other way of entering NULL in the default mode. Or is LDI doing something weird?
            nicklamb Nick (Inactive) added a comment -

            Yes, I believe the issue is empty '' string becoming NULL when data is loaded. Specific request from the customer:

            > I want the value of '' maintained on target table.

            nicklamb Nick (Inactive) added a comment - Yes, I believe the issue is empty '' string becoming NULL when data is loaded. Specific request from the customer: > I want the value of '' maintained on target table.
            LinuxJedi Andrew Hutchings (Inactive) added a comment -

            This is a duplicate of MCOL-271. The empty / NULL behaviour was originally by design in InfiniDB and therefore retained in ColumnStore. We will eventually change this behaviour but it requires a large data format change.

            LinuxJedi Andrew Hutchings (Inactive) added a comment - This is a duplicate of MCOL-271 . The empty / NULL behaviour was originally by design in InfiniDB and therefore retained in ColumnStore. We will eventually change this behaviour but it requires a large data format change.

            People

              Unassigned Unassigned
              dleeyh Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.