DBMSSQL::applyLimit() and DISTINCT keyword

[jan.blaha]

DBMSSQL::applyLimit() method generates incorrect sql query in case of SELECT DISTINCT statement.

Instead of correct:

SELECT DISTINCT TOP n column FROM table

the method generates:

SELECT TOP n DISTINCT column FROM table

which results in an database error.

[KRavEN]

fix should be added to patch in #803

[francois]

(In [1556]) [1.5] Fixed LIMIT in MSSQL (closes #803, #825) (patch from KRavEN)

[KRavEN]

Distinct issue still not resolved. I will look into fixing it.

[francois]

any progress on this issue?

[francois]

bump

[francois]

bump again. No new on this one?

[KRavEN]

Sorry for the delay. The attached patch should resolve the issue. I need to write a test for this still.

[francois]

You should have write access by now, using the same password as your Trac account. Can you commit the patch and the test to check your credentials?

[KRavEN]

(In [1700]) Added check for distinct in the sql statement. Closes #825