查询虚拟超表对应的字段结果与原始关联表的字段结果不一致

TDuser_vFLz_5686 · 2025 年11 月 5 日 03:12

【TDengine 使用环境】
生产环境

【TDengine 版本】

TSDB-OSS 3.3.7.0

【操作系统以及版本】

【部署方式】容器/非容器部署

【集群节点数】

【集群副本数】

【描述业务影响】

严重

【问题复现路径/shan】做过哪些操作出现的问题

【遇到的问题：问题现象及影响】

1、超表定义

CREATE STABLE iot_6a1c3a73740a000_v1.device_auto_usage_record ( ts TIMESTAMP ENCODE ‘delta-i’ COMPRESS ‘lz4’ LEVEL ‘medium’, total_in_use FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, auto_in_use FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’ ) TAGS (device_id VARCHAR(64), sub_device_id VARCHAR(64)) SMA(ts, total_in_use, auto_in_use) VIRTUAL 1

2、虚拟表定义

CREATE VTABLE iot_6a1c3a73740a000_v1.device_auto_usage_record_sf25 (total_in_use FROM iot_6a1c3a73740a000_v1.boiler_auto_standard_8f3aa032-1bea-442b-9d2b-a3f07a91be84.boilerEnable, auto_in_use FROM iot_6a1c3a73740a000_v1.boiler_auto_standard_8f3aa032-1bea-442b-9d2b-a3f07a91be84.coalFeederAutoStatus ) USING iot_6a1c3a73740a000_v1.device_auto_usage_record (device_id, sub_device_id) TAGS (“1#锅炉”, “总给煤机”)

查询虚拟超表对应的字段结果与原始关联表的字段结果不一致

【资源配置】

【报错完整截图】（不要大段的粘贴报错代码，论坛直接看报错代码不直观）

simondominic9997 · 2025 年11 月 5 日 03:21

已收到问题，我先看下

simondominic9997 · 2025 年11 月 5 日 06:45

可以尝试升级到最新版本，再看看该问题是否复现

TDuser_vFLz_5686 · 2025 年11 月 5 日 07:07

能大体说明一下问题原因吗，还有就是需要升级到那个版本？感谢！！

simondominic9997 · 2025 年11 月 5 日 07:15

我尝试本地复现，但是没复现出来，所以可能在 3.3.7-3.3.8中间的版本修复了，如果升级的话可以升级到3.3.8.4试试，
如果不想升级的话可以把原始表的结构也发一下，包括原始表的数据也发一下，我再尝试复现一下

TDuser_vFLz_5686 · 2025 年11 月 5 日 07:26

CREATE STABLE boiler_auto_standard (ts TIMESTAMP ENCODE ‘delta-i’ COMPRESS ‘lz4’ LEVEL ‘medium’, __placeholder__ TINYINT ENCODE ‘simple8b’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeedertotalAIField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, minBedTemperatureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater2AO FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, secondaryAirQualityFlowField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, boilerOnline FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, noxField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWaterEnable FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, primaryAirVolSmooth FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, primaryAirVol FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, bedPressureDiffField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, primaryAirFanAutoStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater2AutoStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, steamFlowSmooth FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAutoStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater1AdjustStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, secondaryAirVol FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater2AdjustStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, so2Field FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater2AI FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, boilerAutoStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, primaryAirqualityFlowField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, rightBedTemperatureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater2Enable FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWaterAutoStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, totalCoalField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, secondaryAirFanAutoStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerEnable FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, steamPressureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, boilerEnable FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalQualityField3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, secondaryAirOutPress FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalQualityField2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerEnable1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerEnable2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAOField1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerEnable3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAOField2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, steamTemperatureSmooth FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAOField3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, oxygenExhaustLeftSmooth FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, oxygenExhaust FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, oxygenExhaustLeft FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, funnelTemperatureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, secondaryAirCurrent FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, secondaryAirAI FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, draftFanAO FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerOutWater2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, airChamber_PresA FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerOutWater1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater1InTemp FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, airChamber_PresB FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, boilerAdjustStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, steamFlowField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, negPressureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAIField3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAIField2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAIField1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, test_flag FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAutoStatus2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAutoStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalPerAOField1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAutoStatus3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalPerAOField3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAI1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAutoStatus1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalPerAOField2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAI2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAdjustStatus3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAI3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederEnable3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederEnable FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederEnable2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, draftFanAI FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, boilerBlowing FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederEnable1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, oxygenExhaustRight FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater2InTemp FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, draftFanAdjustStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, draftFanEnable FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, secondaryAirAO FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, furnacePressureDiffField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, windChamberPressureSmooth FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, oxygenExhaustRightSmooth FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAdjustStatus2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater1Enable FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, primaryAirFanAdjustStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAdjustStatus1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, waterTemperatureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, negPressureSmooth FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeedertotalAOField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, draftAirInPress FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, furnacePressureDiffB FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederBlockStatus3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederBlockStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederBlockStatus1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederBlockStatus2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, secondaryAirFanAdjustStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, leftBedTemperatureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, primaryAirOutPress FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, primaryAirCurrent FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAO3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerOutWataer3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, windChamberPressureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, totalQualityFlowField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, waterPressureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, furnacePressureDiffA FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalQualityField1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, oxygenExhaustSmooth FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, avgBedTemperatureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAO1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAO2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater1AO FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater1OutTemp FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, primaryAirFanEnable FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, waterFlowField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater2OutTemp FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, topTemperatureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, draftFanCurrent FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater1AI FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater1AutoStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAdjustStatus1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, maxBedTemperatureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAdjustStatus3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, furnacePressureDiffSmooth FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, slagCoolerAdjustStatus2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, draftFanAutoStatus FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAutoStatus3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, attemperatorWater2OutTempSmooth FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, layerPressB FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, secondaryAirFanEnable FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, steamTemperatureField FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, layerPressA FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAutoStatus2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalFeederAutoStatus1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, primaryAirAI FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, primaryAirAO FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalQualityFieldCorr3 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalQualityFieldCorr2 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’, coalQualityFieldCorr1 FLOAT ENCODE ‘delta-d’ COMPRESS ‘lz4’ LEVEL ‘medium’) TAGS (corpId VARCHAR(32), uid VARCHAR(64)) SMA(ts,__placeholder__)

CREATE TABLE boiler_auto_standard_8f3aa032-1bea-442b-9d2b-a3f07a91be84 USING boiler_auto_standard (corpId, uid) TAGS (“6a1c3a73740a000”, “8f3aa032-1bea-442b-9d2b-a3f07a91be84”)

TDuser_vFLz_5686 · 2025 年11 月 5 日 07:42

ts	coalFeedertotalAIField	minBedTemperatureField	attemperatorWater2AO	secondaryAirQualityFlowField	boilerOnline	noxField	attemperatorWaterEnable	primaryAirVolSmooth	primaryAirVol	bedPressureDiffField	primaryAirFanAutoStatus	steamFlowSmooth	coalFeederAutoStatus	attemperatorWater1AdjustStatus	secondaryAirVol	attemperatorWater2AdjustStatus	so2Field	attemperatorWater2AI	boilerAutoStatus	primaryAirqualityFlowField	rightBedTemperatureField	attemperatorWater2Enable	totalCoalField	secondaryAirFanAutoStatus	slagCoolerEnable	steamPressureField	boilerEnable	coalQualityField3	secondaryAirOutPress	coalQualityField2	slagCoolerEnable2	coalFeederAOField1	slagCoolerEnable3	coalFeederAOField2	steamTemperatureSmooth	coalFeederAOField3	oxygenExhaustLeftSmooth	oxygenExhaust	oxygenExhaustLeft	funnelTemperatureField	secondaryAirCurrent	secondaryAirAI	draftFanAO	slagCoolerOutWater2	airChamber_PresA	slagCoolerOutWater1	attemperatorWater1InTemp	airChamber_PresB	boilerAdjustStatus	steamFlowField	negPressureField	coalFeederAIField3	coalFeederAIField2	coalFeederAIField1	slagCoolerAutoStatus2	slagCoolerAutoStatus	coalPerAOField1	slagCoolerAutoStatus3	coalPerAOField3	slagCoolerAI1	slagCoolerAutoStatus1	coalPerAOField2	slagCoolerAI2	coalFeederAdjustStatus3	slagCoolerAI3	coalFeederEnable3	coalFeederEnable	coalFeederEnable2	draftFanAI	coalFeederEnable1	oxygenExhaustRight	attemperatorWater2InTemp	draftFanAdjustStatus	draftFanEnable	secondaryAirAO	furnacePressureDiffField	windChamberPressureSmooth	oxygenExhaustRightSmooth	coalFeederAdjustStatus2	attemperatorWater1Enable	primaryAirFanAdjustStatus	coalFeederAdjustStatus1	secondaryAirFanAdjustStatus	slagCoolerAO2	attemperatorWater1AO	attemperatorWater1OutTemp	primaryAirFanEnable	waterFlowField	attemperatorWater2OutTemp	topTemperatureField	draftFanCurrent	attemperatorWater1AI	slagCoolerAdjustStatus1	maxBedTemperatureField	slagCoolerAdjustStatus3	furnacePressureDiffSmooth	slagCoolerAdjustStatus2	draftFanAutoStatus	coalFeederAutoStatus3	attemperatorWater2OutTempSmooth	layerPressB	secondaryAirFanEnable	steamTemperatureField	layerPressA	coalFeederAutoStatus2	coalFeederAutoStatus1	primaryAirAI	primaryAirAO
2025-06-27T21:00:01.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	21.57	1	4	62734	4	22.23	0.06	1	65.73251	901.64	1	18.4964	1	1	9.485451	1	6.9472	5.062	5.7998	1	34	1	31	529.5977	34	2.5757742	2.496	2.569	128.95	20.438	36.5225	41.89549	55.36	6.348	29.02	397.05002	6.336	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.935	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:03.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	21.21	1	4	62366.5	4	22.37	0.06	1	66.947464	901.505	1	18.5198	1	1	9.485451	1	6.9382	5.064	5.8117	1	34	1	31	529.6009	34	2.5753548	2.496	2.569	128.95	20.457998	36.521248	41.89549	55.36	6.35	29.039999	397.16998	6.336	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.9125	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:05.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	21.06	1	4	61712	4	22.52	0.06	1	66.6499	901.505	1	18.532	1	1	9.485451	1	6.9506	5.044	5.802	1	34	1	31	529.6073	34	2.574871	2.499	2.567	128.95	20.517	36.51875	41.89549	55.339996	6.346	29.02	397.11	6.329	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.920002	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:07.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	20.91	1	4	61309.5	4	22.52	0.06	1	64.12573	901.46	1	18.5385	1	1	9.485451	1	6.9657	5.09	5.7488	1	34	1	31	529.60406	34	2.5743225	2.498	2.565	129.01875	20.469002	36.52	41.89549	55.36	6.3739996	29.02	397.11	6.352	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.935	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:09.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	20.61	1	4	61479.25	4	22.52	0.06	1	62.81454	901.49	1	6.9657	1	1	9.485451	1	6.9687	5.064	5.7368	1	31	1	31	529.6168	34	2.5738387	2.498	2.565	129.03125	20.461	36.52125	41.89549	55.379997	6.359	29.02	396.84003	6.337	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.935	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:11.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	20.33	1	4	61892.25	4	22.52	0.06	1	63.386677	901.475	1	6.9687	1	1	9.485451	1	6.9596	5.1	5.74	1	31	1	31	529.6391	34	2.5733547	2.498	2.565	129.04375	20.477001	36.5225	41.89549	55.4	6.379	29.039999	396.93	6.3669996	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.935	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:13.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	20.02	1	4	62809.25	4	22.67	0.06	1	63.00484	901.565	1	6.9596	1	1	9.48675	1	6.963	5.097	5.736	1	31	1	31	529.6518	34	2.572871	2.497	2.565	128.95625	20.471	36.5225	41.89549	55.36	6.371	29.039999	397.13998	6.3630004	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.927498	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:15.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.88	1	4	64072.75	4	22.82	22.82	1	63.17318	901.565	1	6.963	1	1	9.48675	1	6.9781	5.043	5.7266	1	31	1	31	529.6868	34	2.5723548	2.502	2.564	128.93126	20.534	36.5225	41.89549	55.36	6.362	29.02	397.13998	6.351	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.935	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:17.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.88	1	4	65056.25	4	22.82	22.96	1	63.87901	901.655	1	6.9781	1	1	9.48675	1	6.9871	5.109	5.733	1	31	1	31	529.7186	34	2.5718386	2.501	2.564	129.0375	20.451	36.5225	41.89549	55.36	6.395	29.039999	397.11	6.383	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.927498	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:19.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.88	1	4	901.685	4	22.82	23.1	1	64.52349	901.57996	1	6.9871	1	1	9.48805	1	6.975	5.069	5.733	1	31	1	31	529.73456	34	1	1	1	1	1	1	1	1	1	1	1	6.361	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.927498	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:21.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.869999	1	4	901.925	4	22.96	23.1	1	63.842033	901.61	1	6.975	1	1	9.48805	1	6.963	5.086	5.733	1	31	1	31	529.7314	34	1	1	1	1	1	1	1	1	1	1	1	6.376	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.927498	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:23.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.869999	1	4	901.91003	4	23.1	23.1	1	64.12998	901.685	1	6.963	1	1	9.48805	1	6.969	5.068	5.7451	1	31	1	31	529.76	34	1	1	1	1	1	1	1	1	1	1	1	6.348	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.927498	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:25.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.88	1	4	901.745	4	23.1	23.26	1	64.71106	901.925	1	6.969	1	1	9.48675	1	6.969	5.065	5.7544	1	31	1	31	529.78546	34	1	1	1	1	1	1	1	1	1	1	1	6.377	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.935	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:27.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.73	1	4	901.94	4	23.1	23.26	1	65.09526	901.91003	1	6.969	1	1	9.48805	1	6.9541	5.067	5.7672	1	31	1	31	529.8141	34	1	1	1	1	1	1	1	1	1	1	1	6.335	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.9125	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:29.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.73	1	4	901.58	4	23.26	23.26	1	65.78558	901.745	1	6.9541	1	1	9.48805	1	6.9445	5.08	5.7697	1	31	1	31	529.8427	34	1	1	1	1	1	1	1	1	1	1	1	6.355	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.9125	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:31.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.71	1	4	901.73	4	23.26	23.26	1	66.88462	901.94	1	6.9445	1	1	9.48935	1	6.9535	5.11	5.7395	1	31	1	31	529.85864	34	1	1	1	1	1	1	1	1	1	1	1	6.335	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.935	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:33.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.67	1	4	901.64	4	23.26	23.26	1	68.19794	901.58	1	6.9535	1	1	9.49065	1	6.9682	5.08	5.7475	1	31	1	31	529.8618	34	1	1	1	1	1	1	1	1	1	1	1	6.357	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.927498	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:35.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.58	1	4	901.61	4	23.26	23.26	1	67.45056	901.73	1	6.9682	1	1	9.49065	1	6.9708	5.0700006	5.7542	1	31	1	31	529.87775	34	1	1	1	1	1	1	1	1	1	1	1	6.361	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.927498	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:37.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	19.58	1	4	901.625	4	23.26	23.26	1	65.21916	901.64	1	18.5017	1	1	9.49195	1	6.9561	5.062	5.751	1	31	1	31	529.8746	34	1	1	1	1	1	1	1	1	1	1	1	6.354	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.927498	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:39.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	140.34157	1	4	901.67	4	23.26	23.26	1	63.469837	901.61	1	18.461	1	1	9.49195	1	6.9411	5.08	5.7456	1	31	1	31	529.8746	34	1	1	1	1	1	1	1	1	1	1	1	6.378	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.927498	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:41.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	140.34782	1	4	901.61	4	23.26	23.41	1	65.171555	901.625	1	18.4986	1	1	9.49195	1	6.9471	5.056	5.755	1	31	1	31	529.8746	34	1	1	1	1	1	1	1	1	1	1	1	6.35	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.9125	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:43.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	140.36653	1	4	901.58	4	23.26	23.4	1	66.77406	901.67	1	18.4983	1	1	9.4939	1	6.9532	5.075	5.7518	1	34	1	31	529.87134	34	1	1	1	1	1	1	1	1	1	1	1	6.34	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.9125	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:45.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	140.38518	1	4	60315.5	4	23.41	23.41	1	66.61157	901.61	1	18.486	1	1	9.4952	1	6.9503	5.084	5.755	1	34	1	31	529.87134	34	1	1	1	1	1	1	1	1	1	1	1	6.342	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.91	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:47.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	140.40907	1	4	60733.75	4	23.4	23.41	1	64.76463	901.58	1	18.4794	1	1	9.4952	1	6.9533	5.086	5.755	1	34	1	31	529.8746	34	1	1	1	1	1	1	1	1	1	1	1	6.36	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.935	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:49.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	140.43022	1	4	61500.25	4	23.41	0.06	1	64.37683	901.58	1	18.4785	1	1	9.4952	1	6.9651	5.1130004	5.755	1	34	1	31	529.87134	34	1	1	1	1	1	1	1	1	1	1	1	6.394	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.935	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:51.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	901.685	1	4	62450.5	4	23.41	0.06	1	66.02098	901.655	1	18.4879	1	1	9.4952	1	5.7488	5.066	5.7424	1	31	1	31	529.8746	34	1	1	1	1	1	1	1	1	1	1	1	6.334	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.920002	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:53.000+08:00	11	11	1	11	1	11	1	20.33	20.33	20.33	1	901.925	1	4	63238	4	23.41	0.06	1	66.05336	901.58	1	18.5022	1	1	9.4965	1	5.7368	5.074	5.7424	1	31	1	31	529.8746	34	1	1	1	1	1	1	1	1	1	1	1	6.329	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.9125	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:55.000+08:00	11	11	0	11	1	11	1	20.33	20.33	20.33	1	901.91003	1	4	63715.75	4	23.4	0.06	1	66.724014	901.505	1	18.4999	1	1	9.4965	1	5.74	5.079	5.7488	1	31	1	31	529.8746	34	1	1	1	1	1	1	1	1	1	1	1	6.3489995	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.927498	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1
2025-06-27T21:00:57.000+08:00	11	11	0	11	1	11	1	20.33	20.33	20.33	1	901.745	1	4	63670.25	4	23.4	0	1	66.297806	901.61	1	18.5077	1	1	9.4965	1	5.736	5.103	5.7368	1	31	1	31	529.8746	34	1	1	1	1	1	1	1	1	1	1	1	6.37	1	1	1	1	1	1	1	1	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	2.429	1	1	1	41.935	1	99	99	1	1	199.16	199.16	199.16	199.16	1	1	1	1	1	7.5	4	4	1	4	4	4	4	4	4	1	1	1	1	1	1	38.11	38.11	38.11	38.11	38.11	1	1	1	1

TDuser_vFLz_5686 · 2025 年11 月 5 日 07:51

@simondominic9997 原始表结构和数据已提交，烦请检查一下原因

simondominic9997 · 2025 年11 月 5 日 07:52

好的，我看一下先

simondominic9997 · 2025 年11 月 5 日 08:19

你试一下不加 ts 条件的结果是否正确，
再试一下单独查虚拟子表的结果是否正确

TDuser_vFLz_5686 · 2025 年11 月 5 日 08:31

1、查询虚拟超表且不带 ts，结果错误

2、查询虚拟子表，结果返回正确

simondominic9997 · 2025 年11 月 5 日 08:36

这个环境可以远程上去看吗

TDuser_vFLz_5686 · 2025 年11 月 5 日 08:36

不行，客户的生成环境。提供的数据可以复现吗？

simondominic9997 · 2025 年11 月 5 日 08:41

这个虚拟超级表下是只有这一个虚拟子表吗

TDuser_vFLz_5686 · 2025 年11 月 5 日 08:45

正常情况下虚拟超级表会下存在多个子表，但目前为了检查方便只有一个子表

simondominic9997 · 2025 年11 月 5 日 08:58

你查一下
select * from information_schema.ins_virtual_child_columns where db_name = “iot_6a1c3a73740a000_v1” and stable_name = “device_auto_usage_record”;

TDuser_vFLz_5686 · 2025 年11 月 5 日 09:08

table_name	stable_name	db_name	col_name	uid	col_id	col_source	vgroup_id
device_auto_usage_record_sf25	device_auto_usage_record	iot_6a1c3a73740a000_v1	ts	7648560354169500549			338
device_auto_usage_record_sf25	device_auto_usage_record	iot_6a1c3a73740a000_v1	total_in_use	7648560354169500549	1869152258	iot_6a1c3a73740a000_v1.boiler_auto_standard_8f3aa032-1bea-442b-9d2b-a3f07a91be84.boilerEnable	338
device_auto_usage_record_sf25	device_auto_usage_record	iot_6a1c3a73740a000_v1	auto_in_use	7648560354169500549	1869152259	iot_6a1c3a73740a000_v1.boiler_auto_standard_8f3aa032-1bea-442b-9d2b-a3f07a91be84.coalFeederAutoStatus	338

simondominic9997 · 2025 年11 月 5 日 09:14

你直接 select * from device_auto_usage_record 看一下结果是啥

TDuser_vFLz_5686 · 2025 年11 月 5 日 09:51

直接查询结果还是错误

image2212×1188 338 KB

2、直接查询子表结果正确

simondominic9997 · 2025 年11 月 5 日 10:08

能拿到 taosd 的日志吗