Possible solution can be to drop the "sqlHandlerSupportsMaxNumber" condition and extend the while a little in all the readNodes methods:
Anothe rpossible soilution (maybe a betetr one) which I though uip was to make "sqlHandlerSupportsMaxNumber" dependent on the Query.
Rather than have the handler always return 'true' or 'false', it might return true depending on whether it could incorporate max/offset in a query.
I.e. in case of Informix, when UNION is used, the handler should return false, and true otherwise. So this migth be a property of Query rather than a property of the handler.
The point here is that while you can deal with 'max' not being supported in the way you propose, it is very hard to do the same for 'offset'.
-- Pierre van Rooden Mediapark, C 107 tel. +31 (0)35 6772815 "Never summon anything bigger than your head."
