[MCOL-1851] CASE statement cannot handle null values Created: 2018-11-02 Updated: 2021-01-15 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | None |
| Affects Version/s: | 1.1.5 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Critical |
| Reporter: | Frank Groot | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
CentOS 7 |
||
| Description |
|
CASE statement doesn't seem to handle null values correctly using columnstore tables. Example: create table if not exists mytable(mycode varchar(2), mydate date) engine=columnstore; insert into mytable select '01' as mycode, null as mydate; select outcome:
###################################### Can you confirm if this is indeed a columnstore bug? |
| Comments |
| Comment by Frank Groot [ 2018-11-16 ] |
|
Please have a look at this guys! |