On 6/1/2004, "Mark Huijser" <[EMAIL PROTECTED]> wrote:
>Ik think that's a solution for another problem ;-) , the
>sqlHandlerSupportsMaxNumber just don't belong there in that particlular
>condition.
I think you're missing the point, so I'll explain it here.
InformixSqlHanlder contains this code to test support for various
features:
public int getSupportLevel(int feature, SearchQuery query) throws
SearchQueryException {
int result;
switch (feature) {
case SearchQueryHandler.FEATURE_MAX_NUMBER:
result = SearchQueryHandler.SUPPORT_OPTIMAL;
break;
default:
result = super.getSupportLevel(feature, query);
}
return result;
}
Now your problem is that FEATURE_MAX_NUMBER is not supported when the
resulting query uses UNION. This is a bug, because this method has not
been updated when the UNION-code was introduced.
To resolve this issue, simply rewrite the code under case
SearchQueryHandler.FEATURE_MAX_NUMBER to encorporate a test for whether
the resulting query uses a UNION.
Rob van Maris
Technical Consultant
Quantiq
xmedia & communication solutions
Koninginneweg 11-13
1217 KP Hilversum
T +31 (0)356257211
M +31 (0)651444006
E [EMAIL PROTECTED]