GridDB中含GroupByRange的嵌套SQL问题排查请求

在GridDB中使用嵌套SQL结合GROUP BY RANGE语法时出现异常，问题疑似与聚合列的位置计算逻辑相关。以下是可复现该问题的完整SQL代码：

CREATE TABLE trend_data2 (
    ts TIMESTAMP PRIMARY KEY,
    value INTEGER
);

INSERT INTO trend_data2 VALUES(TIMESTAMP('2023-01-01T00:00:00Z'), 5);
INSERT INTO trend_data2 VALUES(TIMESTAMP('2023-01-01T00:00:10Z'), 10);
INSERT INTO trend_data2 VALUES(TIMESTAMP('2023-01-01T00:00:20Z'), 15);
INSERT INTO trend_data2 VALUES(TIMESTAMP('2023-01-01T00:00:40Z'), 25);

SELECT COUNT(*)
FROM (
    SELECT *
    FROM trend_data2
    WHERE ts BETWEEN TIMESTAMP('2023-01-01T00:00:00Z') AND
TIMESTAMP('2023-01-01T00:00:40Z')
    GROUP BY RANGE (ts) EVERY (10,SECOND) FILL (LINEAR)
) dummy

内层SQL通过GROUP BY RANGE按10秒间隔分组并补全缺失数据，但将其作为子查询嵌套后，外层COUNT(*)的结果不符合预期，推测是GridDB对聚合列的位置计算存在错误。

内容的提问来源于stack exchange，提问作者Jessica Williams