Sybase support review
Lukas Eder
I have reviewed your checkin for Sybase, looks like we're on track for
the next release. I discovered some synergies between Sybase and SQL
Server (whose support I have finally implemented). We should review
the use of the "limit" clause in Sybase.
With my implementation of "limit clause simulation"
(https://sourceforge.net/apps/trac/jooq/ticket/21) for RDBMS such as
Oracle, SQL Server, DB2, I want to go in a direction where the jOOQ
API will be the same for all dialects. This means that Sybase should
fit in either
- by allowing only TOP statements (limiting number of rows, not
specifying offsets)
- by supporting 2-level subqueries actually filtering on a rownum
pseudo-column (like Oracle), or on the ROW_NUMBER() analytic function
(like DB2, SQL Server)
You'll find implementations in
AbstractResultProviderSelectQuery.toSQLReference(). Do you think this
can be done with Sybase?
Cheers
Lukas