我有一个应用程序正在运行测试-它们随着时间的推移而失败/通过,我想检查最新的状态,但我得到了奇怪的结果。
检查最新的一组测试返回正确的值,但如果我想按状态对该数字进行细分,则总和将大于原始值。
怎么可能在infloxdb?我只在查询时使用标记
> select count(*) from (SELECT last(*) FROM "mymeasurement" WHERE time>now()-7d GROUP BY "source_client", "product_group", "component","health_app_name")
name: mymeasurement
time count_last_detailed_status
---- --------------------------
0 48
> select count(*) from (SELECT last(*) FROM "mymeasurement" WHERE time>now()-7d GROUP BY "source_client", "product_group", "component","health_app_name") group by mymeasurement_status
name: mymeasurement
tags: mymeasurement_status=FAILING
time count_last_detailed_status
---- --------------------------
0 25
name: mymeasurement
tags: mymeasurement_status=PASSING
time count_last_detailed_status
---- --------------------------
0 41