Steps to reproduce the behavior (Required)
- create table users (
user_id bigint NOT NULL,
name string NOT NULL,
email string NULL,
address string NULL,
age tinyint NULL,
sex tinyint NULL,
last_active datetime,
property0 tinyint NOT NULL,
property1 tinyint NOT NULL,
property2 tinyint NOT NULL,
property3 tinyint NOT NULL
) PRIMARY KEY (user_id)
DISTRIBUTED BY HASH(user_id)
ORDER BY(address,last_active)
PROPERTIES (
“replication_num” = “3”,
“enable_persistent_index” = “true”
);
2.SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ‘xxx’ AND TABLE_NAME =‘users’
Expected behavior (Required)
IS_NULLABLE 字段应该有YES和NO
Real behavior (Required)
StarRocks version (Required)
3.0.0 48f4d81
