Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.2
-
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 | |
+-----------------+
|