MSSQL+Oracle
Closed this issue · 1 comments
rixbeck commented
Hi guys,
first of all I really like the stuff. Brilliant. Unfortunately MSSQL and Oracle doesn't support LIMIT,OFFSET this way how it is implemented here. Need to extremely writing over original query and put some row numbering "emulation" around. Moreover it will complicates further joins and subqueries if any. There are several limit,offset hack but each has its own drawbacks.
I'll try to implement MSSQL solution. Is there any discussion platform where we can talk about just in case?
rixbeck commented
Oh, sorry I missed something and I see you were implemented that for OCI and DBLIB drivers. Only just for windows SQLSRV driver references are missing so it is easily correctable. Sorry again.