【StarRocks版本】例如:3.0.3 单机
建表语句
create table if not exists test.`my_Money` (
`id` bigint(20) NOT NULL ,
`Name` varchar(150) NULL ,
`AGE` bigint(20) NULL ,
`my_money` decimal(19, 4) NULL ,
`s_money` decimal(10, 4) NULL ,
`my_b` boolean NULL ,
`my_image` string NULL
)ENGINE=OLAP
PRIMARY KEY(`id`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`id`)
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false",
"compression" = "LZ4"
);
select * FROM information_schema.columns WHERE TABLE_SCHEMA = ‘test’ AND UCASE(TABLE_NAME) = UCASE(‘my_Money’)
查出来IS_NULLABLE列全是NO
desc my_Money和SHOW FULL COLUMNS FROM my_Money 是正常的
|my_Money|test|id|1|||NO|bigint|
|my_Money|test|Name|2|||NO|varchar|
|my_Money|test|AGE|3|||NO|bigint|
|my_Money|test|my_money|4|||NO|decimal|
|my_Money|test|s_money|5|||NO|decimal|
|my_Money|test|my_b|6|||NO|tinyint|
|my_Money|test|my_image|7|||NO|varchar|