This content has been marked as final.
Show 5 replies
-
1. Re: Columns of different type in UNION ALL. Query performance question.
shawkins Jun 17, 2014 8:28 AM (in response to rodion.myronov)1 of 1 people found this helpfulWe do detect this situation, but are not performing the necessary rewrite here due to a premature check on the predicate that makes us think it's in a final form. Can you log an issue?
-
2. Re: Columns of different type in UNION ALL. Query performance question.
rodion.myronov Jun 17, 2014 9:52 AM (in response to shawkins)Steven, thanks for your answer.
Case 01123522 has been created for this issue.
Meanwhile, are you aware of any workarounds (except function-based index creation)?
Thanks in advance,
Rodion Myronov
-
3. Re: Columns of different type in UNION ALL. Query performance question.
shawkins Jun 17, 2014 9:57 AM (in response to rodion.myronov)Unfortunately there is nothing that wouldn't involve coding that I can see.
-
4. Re: Columns of different type in UNION ALL. Query performance question.
shawkins Jun 17, 2014 10:52 AM (in response to shawkins)This will be addressed by https://issues.jboss.org/browse/TEIID-3011
-
5. Re: Columns of different type in UNION ALL. Query performance question.
rodion.myronov Jun 17, 2014 11:05 AM (in response to shawkins)Steven, many thank. Such a fast and constructive response is really fantastic.