Balendra Singh created METAMODEL-60:
---------------------------------------
Summary: Error while using max rows with distinct for MSSQL in
Metamodel.
Key: METAMODEL-60
URL: https://issues.apache.org/jira/browse/METAMODEL-60
Project: Metamodel
Issue Type: Bug
Reporter: Balendra Singh
Priority: Critical
I am using MSSQL to fetch the records with max rows defined and distinct as
true also for the select clause as following -
Query q = new
Query().from(table).selectDistinct().select(column).setMaxRows(20);
So it is throwing Incorrect syntax near the keyword 'DISTINCT' error.
I debugged the code and found that in
SQLServerQueryRewriter.rewriteSelectClause(), we are appending TOP 20 after the
select keyword so with distinct it becomes select TOP 20 DISTINCT <rest query>
which is not correct.
It should be select DISTINCT TOP 20 <rest query>.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
