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