eggjs / eggjs/egg

egg-sequelize使用group by的时候查询报SequelizeDatabaseError,但拿SQL到数据库执行能正常返回值

Open
#3,766 2 comments 0 reactions 1 assignee Claimed by @dead-horse View on GitHub
Inactive plugin: egg-sequelize
Dominant language
TypeScript
Stars
19k
Forks
1.8k
PR merge metrics
No merged PRs in 30d

Description

## What happens?
A clear and concise description of what the bug is.
SQL如下,其中 team_id是主键,
SELECT `team_id`, `team_name`, `thumbnail`, `introduce`, COUNT(`team`.`father_id`) AS `count` FROM `team` AS `team` WHERE `team`.`father_id` = 0 GROUP BY `father_id` HAVING `father_id` = 0 LIMIT 0, 15;
## Mini Showcase Repository(REQUIRED)
> Provide a mini GitHub repository which can reproduce the issue.
> Use `npm init egg --type=simple bug` then upload to your GitHub

## How To Reproduce

**Steps to reproduce the behavior:**
1.
2.

**Expected behavior**
1.
2.

## Context
- **Node Version**:
- **Egg Version**:
- **Plugin Name**:
- **Plugin Version**:
- **Platform**:

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.