findAndCount无法使用count(distinct()) #2070

New Issue

yuerdongni · 2021-11-16T07:24:41Z

yuerdongni commented

2021-11-16 07:24:41 +00:00

		session_find.go
		Line 60 in aea91cc7de
	
					if len(session.statement.ColumnMap) > 0 {

https://gitea.com/xorm/xorm/src/branch/master/session_find.go

if len(session.statement.ColumnMap) > 0 {
	session.statement.ColumnMap = []string{}
}

这里的columnMap为什么要置空那我如何在findAndCount的字段里面传递count(distinct(cols))的cols?
columnMap置空导致sql变成了count(distinct )

https://gitea.com/xorm/xorm/src/commit/aea91cc7dede96f071514cea007bd792613ae748/session_find.go#L60 https://gitea.com/xorm/xorm/src/branch/master/session_find.go if len(session.statement.ColumnMap) > 0 { session.statement.ColumnMap = []string{} } 这里的columnMap为什么要置空那我如何在findAndCount的字段里面传递count(distinct(cols))的cols? columnMap置空导致sql变成了count(distinct )

yuerdongni changed title from ~~无法使用count(distinct())~~ to findAndCount无法使用count(distinct())

2021-11-16 08:29:05 +00:00

lunny commented

2021-11-17 06:28:35 +00:00

Could you paste your codes here?

👀 1

lunny added the

need

feedback

label 2021-11-17 06:29:13 +00:00

yuerdongni commented

2021-11-17 07:03:14 +00:00