Issue with .LimitBy in ClickHouse using FreeSql

[gregor47]

Hello,

First of all, thank you for this amazing library – it’s truly incredible and very helpful in our projects.

I would like to report an issue related to the LimitBy feature when using ClickHouse.
Currently, the SQL being generated looks like this:

SELECT ifnull(a.`LeadState`, NULL) as1, count(1) as2 
FROM `LeadReport` a FINAL 
GROUP BY a.`LeadState` 
LIMIT 1 BY  
ORDER BY a.`LeadId`

As you can see:

The LIMIT 1 BY clause is not being rendered correctly (it is missing the column name).

An ORDER BY a.LeadId is being appended automatically, because I used .LimitBy(x => x.LeadId, 1).
However, in my case I actually need to order by another column, so that ORDER BY should not be forced in the generated SQL.

The expected SQL output should simply be:

... 
LIMIT 1 BY LeadId

If the expression could be generated exactly in this form, it would solve the issue.

Thanks a lot for your support and for considering this improvement.

Best regards,
Gregory Jimenez from Colombia

[2881099]

8951662#diff-689b6de89afb77817eed6149ab9f9b83eb8771caa4480216e830427299b6f7cd

This issue will be resolved in the next version.