-
-
Notifications
You must be signed in to change notification settings - Fork 1.6k
Open
Description
Issue and How to Reproduce
let target = Tables.reportItemTable
.select(distinct: Columns.reportItemTableRowNumber)
.filter(Columns.reportItemParentReportItemInternalID == internalId)
.count
Results in:
SELECT count(*) FROM "tblReportItem" WHERE ("ParentReportItemInternalID" = 18)
Removing the count returns a SQL statement more similar to what you would expect:
let target = Tables.reportItemTable
.select(distinct: Columns.reportItemTableRowNumber)
.filter(Columns.reportItemParentReportItemInternalID == internalId)
Results in:
SELECT DISTINCT "TableRowNumber" FROM "tblReportItem" WHERE ("ParentReportItemInternalID" = 17)
Temporary Workaround
The SQL statement as it should be is:
SELECT COUNT(DISTINCT "column_name") FROM "table_name"