【简述】
使用直连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