This content has been marked as final.
Show 5 replies
-
1. Re: converting time values to time series.
shawkins Nov 6, 2014 8:20 AM (in response to gadeyne.bram)The current logic (8.4+) is checking if the predicate is compatible with the partition, but if there is an ordering on the window function then the predicate won't be pushed. This is too strict for the case that you have where the predicate is just over the partition - if it were against any other columns it could alter the aggregate values. Can you convert this to an issue?
-
2. Re: converting time values to time series.
gadeyne.bram Nov 6, 2014 9:16 AM (in response to shawkins)Thank you Steven,
I'll create an issue.
-
3. Re: converting time values to time series.
shawkins Nov 6, 2014 2:22 PM (in response to gadeyne.bram)[TEIID-3201] Pushing a predicate when it is used in an order by statement in a window function - JBoss Issue Tracker will be addressed for 8.9 Final
-
4. Re: converting time values to time series.
gadeyne.bram Dec 18, 2014 3:26 AM (in response to shawkins)I can confirm that this is resolved in 8.9
-
5. Re: converting time values to time series.
shawkins Dec 18, 2014 8:00 AM (in response to gadeyne.bram)Thanks Bram