apache / apache/shardingsphere
No result from sql: "select count(1) from t_order"
Open
db: SQLServer
feature: sharding
status: volunteer wanted
type: enhancement
- Dominant language
- Java
- Stars
- 20.8k
- Forks
- 6.9k
- Avg merge
- 11h 35m
- Merged PRs (30d)
- 326
Description
shardingsphere version: 5.1.2
database: sqlserver
error message: please add alias for aggregate selections.
I need add alias from sql : "select count(1) as c from t_order".
Contributor guide
Research direction
Start by reproducing the query against SQL Server with ShardingSphere 5.1.2, comparing `select count(1) from t_order` with the aliased form. Trace where the aggregate-selection alias requirement is reported, then add a regression test showing that the query without an alias succeeds.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100