使用limit 和 FindAndCount的一个bug - sql server #1698

New Issue

344085057 · 2020-05-29T06:52:56Z

344085057 commented

2020-05-29 06:52:56 +00:00

code:

func GetBcdyByObj(
	t *Bcdy, //请求的条件
	dataOrder *DataOrder, //排序
	paging *Paging, //分页

) ([]*Bcdy, int64, error) {

	engine := utils.GetEngine()

	var roles []*Bcdy

	session := engine.Where("company_id = ?", t.CompanyId)

	if t.Id != 0 {
		session = session.And("id = ?", t.Id)
	}

	if t.Bcmc != "" {
		session = session.And("bcmc like CONCAT('%',?,'%')", t.Bcmc)
	}

	if dataOrder.SortField != "" && dataOrder.Order != "" {
		session = session.OrderBy(dataOrder.SortField + " " + dataOrder.Order)
	}

	count, err := session.Limit(paging.PageSize, (paging.Current-1)*paging.PageSize).FindAndCount(&roles)
	if err != nil {
		fmt.Println(err.Error(), "-----")
	}

	return roles, count, err
}

sql 日志：

[SQL] SELECT TOP 10 ... FROM [bcdy] WHERE (company_id = ?) AND (id NOT IN (SELECT TOP 1 id FROM [bcdy] WHERE (company_id = ?))) [33 33]

[SQL] SELECT TOP 10 count(*) FROM [bcdy] WHERE (company_id = ?) AND (id NOT IN (SELECT TOP 1 id FROM [bcdy] WHERE (company_id = ?))) [33]
这条count语句出现了2个占位符后面却只带了一个参数
sql: expected 2 arguments, got 1

code: ```golang func GetBcdyByObj( t *Bcdy, //请求的条件 dataOrder *DataOrder, //排序 paging *Paging, //分页 ) ([]*Bcdy, int64, error) { engine := utils.GetEngine() var roles []*Bcdy session := engine.Where("company_id = ?", t.CompanyId) if t.Id != 0 { session = session.And("id = ?", t.Id) } if t.Bcmc != "" { session = session.And("bcmc like CONCAT('%',?,'%')", t.Bcmc) } if dataOrder.SortField != "" && dataOrder.Order != "" { session = session.OrderBy(dataOrder.SortField + " " + dataOrder.Order) } count, err := session.Limit(paging.PageSize, (paging.Current-1)*paging.PageSize).FindAndCount(&roles) if err != nil { fmt.Println(err.Error(), "-----") } return roles, count, err } ``` ----- sql 日志： > [SQL] SELECT TOP 10 ... FROM [bcdy] WHERE (company_id = ?) AND (id NOT IN (SELECT TOP 1 id FROM [bcdy] WHERE (company_id = ?))) **[33 33]** > [SQL] SELECT TOP 10 count(*) FROM [bcdy] WHERE (company_id = ?) AND (id NOT IN (SELECT TOP 1 id FROM [bcdy] WHERE (company_id = ?))) **[33]** 这条count语句出现了2个占位符后面却只带了一个参数 sql: expected 2 arguments, got 1

344085057 closed this issue

2020-05-29 07:08:51 +00:00

344085057 reopened this issue

2020-05-29 08:53:56 +00:00

lunny commented

2020-05-29 13:56:37 +00:00

Which xorm version?

lunny added the

kind

bug

label 2020-05-29 13:56:43 +00:00

344085057 commented