fix: mssql cursor pagination

[lstrihic]

#588

Here is the fix for MSSQL when offset is set to 0.

[vmihailenco]

Thanks 👍 Could you add a test to https://github.com/uptrace/bun/blob/master/internal/dbtest/query_test.go#L789-L800?

[vmihailenco]

The test failure looks real:

--- FAIL: TestORM (2.64s)
    --- FAIL: TestORM/mssql2019 (0.34s)
        --- FAIL: TestORM/mssql2019/testAuthorRelations (0.00s)
            orm_test.go:132: 
                	Error Trace:	orm_test.go:132
                	            				orm_test.go:43
                	Error:      	Received unexpected error:
                	            	mssql: Invalid usage of the option NEXT in the FETCH statement.
                	Test:       	TestORM/mssql[201](https://github.com/uptrace/bun/runs/6998766509?check_suite_focus=true#step:5:202)9/testAuthorRelations

Any ideas what is wrong?

[lstrihic]

The test failure looks real:

--- FAIL: TestORM (2.64s)
    --- FAIL: TestORM/mssql2019 (0.34s)
        --- FAIL: TestORM/mssql2019/testAuthorRelations (0.00s)
            orm_test.go:132: 
                	Error Trace:	orm_test.go:132
                	            				orm_test.go:43
                	Error:      	Received unexpected error:
                	            	mssql: Invalid usage of the option NEXT in the FETCH statement.
                	Test:       	TestORM/mssql[201](https://github.com/uptrace/bun/runs/6998766509?check_suite_focus=true#step:5:202)9/testAuthorRelations

Any ideas what is wrong?

I have to check.

[lstrihic]

The test failure looks real:

--- FAIL: TestORM (2.64s)
    --- FAIL: TestORM/mssql2019 (0.34s)
        --- FAIL: TestORM/mssql2019/testAuthorRelations (0.00s)
            orm_test.go:132: 
                	Error Trace:	orm_test.go:132
                	            				orm_test.go:43
                	Error:      	Received unexpected error:
                	            	mssql: Invalid usage of the option NEXT in the FETCH statement.
                	Test:       	TestORM/mssql[201](https://github.com/uptrace/bun/runs/6998766509?check_suite_focus=true#step:5:202)9/testAuthorRelations

Any ideas what is wrong?

I have to check.

In mssql to use limit we have to have defined order.

[vmihailenco]

Thanks 👍