TDengine icon indicating copy to clipboard operation
TDengine copied to clipboard

最新3.3.2.0版本子查询窗口查询报错(3.x旧版本没报错)

Open peterchenhdu opened this issue 1 year ago • 1 comments

Bug Description 最新3.3.2.0版本子查询窗口查询报错(3.x旧版本没报错)

To Reproduce 执行以下语句报错:DB error: Window query not supported, since not valid primary timestamp column as input (0.000552s)

SELECT MIN( tag_value ) AS min_tag_value, tag_name FROM (SELECT _rowts, * FROM ptest4.ptbtest4 WHERE time > 1716520258085 AND time < 1717171199000 UNION ALL SELECT _rowts,* FROM ptest4_his.ptbtest4_his WHERE time > 1716048000000 AND time < 1716520258085 ) PARTITION BY tag_name INTERVAL ( 36000000a );

Expected Behavior 正确执行

Screenshots image

Environment (please complete the following information):

  • TDengine Version [3.3.2.0]

peterchenhdu avatar Aug 21 '24 05:08 peterchenhdu

请问旧版本指的是哪个版本?

yu285 avatar Aug 26 '24 07:08 yu285

更新到3.3.3.0版本,如果还有问题可以微信联系a15652223354

yu285 avatar Oct 14 '24 01:10 yu285