Hi, I have encountered a problem using OVER() in an Oracle database. I am adding two fields to a SelectQuery like this: Select.add(Factory.count().over(), Factory.rowNumber().over());
This translates to SELECT count(*) OVER (), FROM ..., which gives me an error about a missing ORDER BY in the OVER clause. In Postgres, this works without problems. IMHO, jOOQ should expand the OVER() for Oracle to OVER(ORDER BY 1). Is this possible? Cheers, Jörg -- 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.
