[#MCOL-4636] is null not working on varchar utf8mb4

[MCOL-4636] is null not working on varchar utf8mb4 Created: 2021-03-23 Updated: 2023-11-21 Resolved: 2023-10-27
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	ExeMgr, PrimProc
Affects Version/s:	5.5.2
Fix Version/s:	Icebox

Type:

Bug

Priority:

Major

Reporter:

David Hall (Inactive)

Assignee:

Leonid Fedorov

Resolution:

Fixed

Votes:

Labels:

regression

Environment:

Ubuntu 20.04

Description

create table t1(f1 varchar(5)) engine=columnstore default charset utf8mb4;
select max(f1) is null from t1;
Should return 1
But it returns 0

create table t1(f1 varchar(5)) engine=columnstore default charset utf8mb4;

select max(f1) is null from t1;

+-----------------+

| max(f1) is null |

+-----------------+

|               0 |

+-----------------+

If using utf8, it works

create table t2(f1 varchar(5)) engine=columnstore default charset utf8;

select max(f1) is null from t2;

+-----------------+

| max(f1) is null |

+-----------------+

|               1 |

+-----------------+

Generated at Thu Feb 08 02:51:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.