IBO 4.2.Ib
If I use the search capabilities of IBO, with the proper setup,
correctly something like:
AND LAST_NAME STARTING 'DEVASINI'
is added to the WHERE clause of the SQL select.
But if there is a UNION in the SQL, the above addition is done only in
the first query, like:
Select age from customers
Where LAST_NAME STARTING 'DEVASINI'
Union
Select age from children
/* here is missing */
Is it a bug? Will it be fixed/added in a short time?
I ask this because with a selectable stored procedure it works, but
unfortunately SP creates the entire dataset what is then limited with
the WHERE, and it's very slow. If the problem will be fixed soon, I
can keep using the SP until then, otherwise I've to find another
solution :(
Thanks
Marco Menardi