TDengine
TDengine copied to clipboard
taosdata
3.3.5.0版本UNION ALL查询时字段长度不同执行SQL异常
Bug Description 3.3.5.0版本执行以下SQL语句异常： (select 1741708800000 startTime,
'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)
当把第三段中的8FPDX_WYGL_3_DL长度减少到9位的时候正常，以下SQL能够正常执行： (select 1741708800000 startTime,
'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]
