【简述】
使用直连BE查询(查询QueryPlan后,使用open_scanner/get_next获取数据),出现column name为空的问题
【StarRocks版本】2.3.3
【详述】
表结构:
CREATE TABLE test.table1 (
id varchar(10) NOT NULL COMMENT “”,
price decimal64(17, 6) NULL COMMENT “”,
flag int(11) NULL COMMENT “”
) ENGINE=OLAP
PRIMARY KEY(id)
COMMENT “OLAP”
DISTRIBUTED BY HASH(id) BUCKETS 20
PROPERTIES (
“replication_num” = “1”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “false”
);
统计:
select * from test.table1 正确
select id,price from test.table1 正确
select * from test.table1 where flag=0 正确
select id,price,flag from test.table1 where flag=0 正确
select id,flag from test.table1 where flag=0 正确
select id,price from test.table1 where flag=0 错误
即:当筛选列(id,price)不包括过滤列(flag)时会有问题
正确截图:
select id,price,flag from test.table1 where flag=0
select id,price from test.table1
异常截图:
select id,price from test.table1 where flag=0

