You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
'37KAP1_DL' deviceId,
1215373850266001408 companyId,
last(collect_date_time) endTime,
last(temp.collect_value) - first(temp.collect_value) usage from (
select
collect_date_time, collect_value
from aiot_dasmeasure.measure_data_t1743084587277402113
where project_id = 1192410229407772672
and device_id = '37KAP1_DL'
and collect_date_time >= 1741708800000
and collect_date_time <= 1745510400000
and is_delete is null
order by collect_date_time
) temp)
UNION ALL
(select 1741708800000 startTime,
'37KAP2_DL' deviceId,
1215373850266001408 companyId,
last(collect_date_time) endTime,
last(temp.collect_value) - first(temp.collect_value) usage from (
select
collect_date_time, collect_value
from aiot_dasmeasure.measure_data_t1743084587277402113
where project_id = 1192410229407772672
and device_id = '37KAP2_DL'
and collect_date_time >= 1741708800000
and collect_date_time <= 1745510400000
and is_delete is null
order by collect_date_time
) temp)
UNION ALL
(select 1741708800000 startTime,
'8FPDX_WYGL_3_DL' deviceId,
1215373861133443072 companyId,
last(collect_date_time) endTime,
last(temp.collect_value) - first(temp.collect_value) usage from (
select
collect_date_time, collect_value
from aiot_dasmeasure.measure_data_t1743084587277402113
where project_id = 1192410229407772672
and device_id = '8FPDX_WYGL_3_DL'
and collect_date_time >= 1741708800000
and collect_date_time <= 1745510400000
and is_delete is null
order by collect_date_time
) temp)
'37KAP1_DL' deviceId,
1215373850266001408 companyId,
last(collect_date_time) endTime,
last(temp.collect_value) - first(temp.collect_value) usage from (
select
collect_date_time, collect_value
from aiot_dasmeasure.measure_data_t1743084587277402113
where project_id = 1192410229407772672
and device_id = '37KAP1_DL'
and collect_date_time >= 1741708800000
and collect_date_time <= 1745510400000
and is_delete is null
order by collect_date_time
) temp)
UNION ALL
(select 1741708800000 startTime,
'37KAP2_DL' deviceId,
1215373850266001408 companyId,
last(collect_date_time) endTime,
last(temp.collect_value) - first(temp.collect_value) usage from (
select
collect_date_time, collect_value
from aiot_dasmeasure.measure_data_t1743084587277402113
where project_id = 1192410229407772672
and device_id = '37KAP2_DL'
and collect_date_time >= 1741708800000
and collect_date_time <= 1745510400000
and is_delete is null
order by collect_date_time
) temp)
UNION ALL
(select 1741708800000 startTime,
'WYGL_3_DL' deviceId,
1215373861133443072 companyId,
last(collect_date_time) endTime,
last(temp.collect_value) - first(temp.collect_value) usage from (
select
collect_date_time, collect_value
from aiot_dasmeasure.measure_data_t1743084587277402113
where project_id = 1192410229407772672
and device_id = '8FPDX_WYGL_3_DL'
and collect_date_time >= 1741708800000
and collect_date_time <= 1745510400000
and is_delete is null
order by collect_date_time
) temp)
Expected Behavior
在UNION ALL中长度不一样也能够正常执行
Environment (please complete the following information):
TDengine Version [3.3.5.0]
The text was updated successfully, but these errors were encountered:
Bug Description
3.3.5.0版本执行以下SQL语句异常:
(select 1741708800000 startTime,
当把第三段中的8FPDX_WYGL_3_DL长度减少到9位的时候正常,以下SQL能够正常执行:
(select 1741708800000 startTime,
Expected Behavior
在UNION ALL中长度不一样也能够正常执行
Environment (please complete the following information):
The text was updated successfully, but these errors were encountered: