sqlkata / querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
https://sqlkata.com
MIT License
3.08k stars 498 forks source link

Fix duplicate column error #629

Closed mapogolions closed 1 year ago

mapogolions commented 1 year ago

The Paginate method calls the other two methods Count and Get. If the original query is complex and contains a join of two tables that have at least one column with the same name, a duplicate column error occurs during the count query. For more information, see added test case.