database

database copied to clipboard

Firstly, I would like to send many, many thanks to Davit to implement support of MSSQL. I found one important bug.

$this->context->table(...)->limit(100,10) generate bad syntaxt.

SELECT * FROM [table] OFFSET 10 ROWS FETCH NEXT 100 ROWS ONLY

This syntax works only, if I use order clausule, for example: SELECT * FROM [table] ORDER BY [id] DESC OFFSET 10 ROWS FETCH NEXT 100 ROWS ONLY

Yes, it is known (and good) limitation.

Logic tells me, that you have truth. I was customized the driver in previous Nette version, and if ordering is not set in context, ordering is set automatically from identity column. Thank you for fast answer :-) Have a nice day.