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 | |
priority | important |
---|---|
type | bug |
done in | 3.11.2 |
load | 1.000 |
load left | 0.000 |
closed by | #bcdf22734059 Abstract the support for ORDER BY and LIMIT/OFFSET SQL generation |
similar entities
Comments
-
2010/07/07 10:41
add commentadded ticket on logilab-database (http://www.logilab.org/ticket/36717)