Open eclbg opened 5 years ago
Similar experiences have been seen with the latest code.
select count(node) from calculated_kpis provides different results for each query even though the underlying data is not changed.
select count(*) from (select node from calculated_kpis) a provides the correct result
The following two queries yield different results while I understand they should be equivalent. The second one yields the correct result.
Their respective plans are: