Ordering an association property overrides the join type
Open
relates-to: gorm
- Dominant language
- Groovy
- Stars
- 2.9k
- Forks
- 975
- Avg merge
- 1d 22h
- Merged PRs (30d)
- 92
Description
```
new DetachedCriteria(Book).build {
author {
order("name")
}
join("author", JoinType.LEFT)
}
```
results in the author being joined with an inner join
Contributor guide
Research direction
Start with the DetachedCriteria example and trace how ordering the author association affects join construction. Reproduce the case, then verify that join("author", JoinType.LEFT) still produces a LEFT join when author ordering is present.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- groovy
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100