Bug #359

avatar

Offset-Emulation doesn't work with MSSQL

Added by Nils Wiegner 5412 days ago. Updated 5412 days ago.

Status:Closed Start:03/02/2010
Priority:Normal Due date:
Assigned to:avatarMirco Bauer % Done:

100%
Category:- Spent time: -
Target version:-
Votes: 0

Description

2010-03-02 16:53:59,962 [-1238369392] DEBUG Meebey.SmartDao.Query`1 - GetAll(): parsed SQL: SELECT TOP 20 "DebitCreditID", "BankleitzahlEmpfaenger", "KontonummerEmpfaenger", "BankleitzahlAuftraggeber", "KontonummerAuftraggeber" FROM "DebitCredit" 
2010-03-02 16:53:59,963 [-1238369392] DEBUG Meebey.SmartDao.Query`1 - GetAll(): query took: 1.525 ms
2010-03-02 16:53:59,963 [-1238369392] DEBUG Meebey.SmartDao.Query`1 - GetAll(): emulating offset of: 40

Associated revisions

Revision 51
Added by Mirco Bauer 5412 days ago

Fixed offset emulation when the RDBMS has limit but no offset support (e.g. MSSQL 2000). (closes: #359)

History

Updated by Mirco Bauer 5412 days ago

avatar
  • Status changed from New to Closed
  • % Done changed from 0 to 100

Applied in changeset r51.

Also available in: Atom PDF