[MCOL-1783] cpimport is not handling BOOLEAN data type correctly Created: 2018-10-08 Updated: 2021-01-15 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | cpimport |
| Affects Version/s: | 1.2 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Build tested: 1.2 source 1. For a column is of BOOLEAN data type and the data value is the word true or false (not case sensitive) , value load 0. It should be 1 for true or 0 for false. It looks like it is doing a value saturation, string gets change to a 0. 2) When the data value is NULL, a) cpimport without -n or with "-n 0" switch Value of 0 is loaded. This is correct as NULL is treated as a value string, saturation should occurred. b) cpimort with "-n 1" |
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2018-10-10 ] |
|
Please provide your CSV file so we can reproduce 2 since there are several ways of representing NULL. |