cubicweb #1154756 SQL Server support : do not use LIMIT and OFFSET keywords in generated SQL [resolved]

rql2sql should use an abstraction for LIMIT/OFFSET syntax (to be added in logilab.database).

ms sql supports "SELECT TOP(10) * FROM table" which is very similar to "SELECT * FROM table LIMIT 10"

OFFSET is not supported AFAIK, but see http://msdn.microsoft.com/en-us/library/ms979197

priorityimportant
typebug
done in3.11.2
load1.000
load left0.000
closed by#bcdf22734059 Abstract the support for ORDER BY and LIMIT/OFFSET SQL generation

Workflow history

from state (3)to statecommentdateUser
validation pendingresolved2011/05/27 14:37 UTCsthenault
donevalidation pending

version publiée

2011/03/28 17:25 UTCnchauvat
opendone2011/03/24 13:23 UTCadmin

Comments

add comment

Ticket #1154756 - latest update on 2011/05/27, created on 2010/07/07