I maybe missing something but would it not be possible to handle this by
turning the original SQL select into a sub select so
select * from table
ends up as
select count(*)
from ( select * from table )
This way all the edge cases caused by things like DISTINCT and UNION
operate correctly as long as the DB engine can handle them within a
sub-select. It also deals with the issue of DBs that do not have the window
functions.
I am saying this without any understanding of how you hold a query within
JOOQ so do not know if you can defind such a wrapping at will.
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
