yessql icon indicating copy to clipboard operation
yessql copied to clipboard

sqlbuilder generates multiple "limit" and "offset" clause when invoke ToSqlBuilder multiple times

Open HengzheLi opened this issue 3 years ago • 1 comments

I use postgres dialect sqlbuilder to generate customized sql. The .Skip() and .Take() is used in my sqlbuilder and found that a new "limit" and "offset" clause is generated as long as .ToSqlBuilder been invoked. If I invoke .ToSqlBuilder twice, there will be two paires of "limit" and "offset". If I invoke .ToSqlBuilder() three times. There will be three pares.

HengzheLi avatar Mar 21 '22 02:03 HengzheLi

Seems it's a bug, I may fix this if I have a time, it's long time from contributing in YesSQL ;)

hishamco avatar Mar 21 '22 18:03 hishamco