Bug: Query folding not working with non-SQL datasource

Hi v-qiuyu-msft,

thank you very much for your quick answer.

1) correct

2) ZRIdFilter is the critical one (but the effect would be the same with Datumsfilter)

3) Yes, thats the profiler trace if query folding happens. But as soon as the number of items (ZRIds) is higher than 200, Profiler will not list these items individually any more, but load the whole table.

Ehren must have circled this back to the dev-team already where he got the confirmation and description of how the algorithm works and why it bugs here. So I would expect that this issue itself will be known or at least reproducable by the dev-team.

Thanks, Imke