-
1. Re: pushing down multiple IN claus
rareddy Sep 1, 2014 4:56 PM (in response to mickalas)Teiid does not support multiple columns in IN clause
-
2. Re: pushing down multiple IN claus
shawkins Sep 1, 2014 6:14 PM (in response to rareddy)Do you array type support turned on the ExecutionFactory?
-
3. Re: pushing down multiple IN claus
mickalas Sep 2, 2014 4:31 AM (in response to rareddy)Re non-support in teiid.
I dont seem to get an error when I pass in SELECT a,b,c FROM tab WHERE (a,b) IN (('x','y'))
Rather the query that is passed down is transformed into SELECT a,b,c FROM tab
Thanks
Mick
-
4. Re: pushing down multiple IN claus
mickalas Sep 2, 2014 4:31 AM (in response to shawkins)No I dont have array type support turned on. Is that relevant here?
Thanks
Mick
-
5. Re: pushing down multiple IN claus
shawkins Sep 3, 2014 7:23 AM (in response to mickalas)> I dont seem to get an error when I pass in SELECT a,b,c FROM tab WHERE (a,b) IN (('x','y'))
Yes, this is supported in later versions of Teiid.
> Rather the query that is passed down is transformed into SELECT a,b,c FROM tab
Ideally we would have a compensation here when the translator does not advertise support for array types, but for now it's simply that the predicate is not pushed down.
> No I dont have array type support turned on. Is that relevant here?
Yes, you are performing an array comparison here. With array support turned on the predicate should be pushed down.