[MCOL-1423] cpimport loads empty value ("") as NULL for all data types Created: 2018-05-16 Updated: 2021-04-19 Resolved: 2019-08-27 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | cpimport |
| Affects Version/s: | 1.1.4, 1.2.3 |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Minor |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| 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. |
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2019-08-01 ] |
|
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? |
| Comment by Nick (Inactive) [ 2019-08-27 ] |
|
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. |
| Comment by Andrew Hutchings (Inactive) [ 2019-08-27 ] |
|
This is a duplicate of |