|
|
|
A situation was discovered in which a query using a left outer join for which the "describeparam" call returned the wrong number of parameters and incorrect information about the parameters. This could occur in ODBC and potentially any other relational API. When a query with a left outer join returns only columns from the left table in the resultset, the outer join may be superfluous and can be eliminated from the query, in such a case the parameters affecting the right table were removed as well hence the problem.
The logic has been modified so that, when a left outer join that contains parameters is optimized away, the parameter information is not lost.
