Bug: Query folding not working with non-SQL datasource

Hi ImkeF,

Before I report this issue internally, I would like to confirm the reproduce steps from you:

Based on my understanding from your thread, the steps should be:

1. The table get data from the SQL database and inner join with other two tables: ZRIdFilter, Datumsfilter.

2. "So when I add additional lines to this filter-table, at a certain lenght the query will stop folding."?

Do you mean you add additional rows in ZRIdFilter or Datumsfilter table?

3. The profiler capture the T-sql like below:

select [$Ordered].[DBTabId],
    [$Ordered].[ZRId],
    [$Ordered].[Datum],
    [$Ordered].[Index],
    [$Ordered].[IsValid],
    [$Ordered].[Wert],
    [$Ordered].[Qualitaet],
    [$Ordered].[VWert]
from
(
    select [_].[DBTabId],
        [_].[ZRId],
        [_].[Datum],
        [_].[Index],
        [_].[IsValid],
        [_].[Wert],
        [_].[Qualitaet],
        [_].[VWert]
    from [dbo].[Daten] as [_]
    where ((((((((((((((((((((((([_].[ZRId] = 1069176 or [_].[ZRId] = 1069182) or [_].[ZRId] = 1069191) or [_].[ZRId] = 1069197) or [_].[ZRId] = 1069202) or [_].[ZRId] = 1075509) or [_].[ZRId] = 1075510) or [_].[ZRId] = 1075511) or [_].[ZRId] = 1075512) or [_].[ZRId] = 1075515) or [_].[ZRId] = 1075516) or [_].[ZRId] = 1075517) or [_].[ZRId] = 1075518) or [_].[ZRId] = 1243781) or [_].[ZRId] = 1243799) or [_].[ZRId] = 1243841) or [_].[ZRId] = 1649145) or [_].[ZRId] = 1649146) or [_].[ZRId] = 1649152) or [_].[ZRId] = 1652117) or [_].[ZRId] = 1652119) or [_].[ZRId] = 1652121) or [_].[ZRId] = 1652123) or [_].[ZRId] = 1652125) or [_].[ZRId] = 1652127
) as [$Ordered]
order by [$Ordered].[DBTabId],
        [$Ordered].[ZRId],
        [$Ordered].[Datum],
        [$Ordered].[Index]

If the steps above is not very clear and correct, would you please share detail steps?

Best Regards,
Qiuyun Yu