This content has been marked as final.
Show 3 replies
-
1. Re: More DB2 mainframe weirdness - LIMIT within UNION
rareddy Jun 13, 2014 12:01 PM (in response to markaddleman)I believe this was one of the enhancements that was done in recent releases. Turning off limit completely removes the LIMIT functionality, but at same time I do not think there is fine grained option to turn off when being used with union push down, at least not yet.
-
2. Re: More DB2 mainframe weirdness - LIMIT within UNION
shawkins Jun 16, 2014 8:31 AM (in response to rareddy)> I believe this was one of the enhancements that was done in recent releases.
For simplistic union all scenarios we would have been pushing the limit for some time. However we should not push additional copies of the limit if it is making it to the source already.
-
3. Re: More DB2 mainframe weirdness - LIMIT within UNION
shawkins Jun 16, 2014 10:19 AM (in response to shawkins)Will address this with [TEIID-3008] limit being pushed even when already in the source query - JBoss Issue Tracker