influxdb: Selecting from sub query is returning unexpected data in specific cases
Bug report
System info: Influxdb 1.2, Max OS 10.12.2
Steps to reproduce:
- Seed influx with data
- Run
select * from workflows group by work_id order by time desc limit 1. This is the sub query, which returns the correct data I want to filter on. - Then run the full query
SELECT * FROM (select * from workflows group by work_id order by time desc limit 1 ) WHERE state = 'error'. This returns expected data. - Then run
SELECT * FROM (select * from workflows group by work_id order by time desc limit 1 ) WHERE state = 'render'. This returns expected data. - Then run
SELECT * FROM (select * from workflows group by work_id order by time desc limit 1 ) WHERE state = 'send'This returns unexpected data.
Expected behavior: I expect the sub query to only return the items that match the where clause, after the sub query sorts them and limits them to one.
Actual behavior: It returns data that should not be in the subquery.
Additional info: It seems like the sub query is not carrying over the correct data possibly.

About this issue
- Original URL
- State: closed
- Created 7 years ago
- Comments: 33 (13 by maintainers)
I think this is now fixed and will be merged back to master soon. I’m going to close this. There may be remaining issues with how conditions are evaluated so please comment if this is still not working.