Optimize queryAppInfo SQL and upgrade ozhera-app to 2.2.7-incubating
- Dominant language
- Java
- Stars
- 122
- Forks
- 46
- Avg merge
- 11h 56m
- Merged PRs (30d)
- 9
Description
1. Remove unnecessary LEFT JOIN in queryAppInfo and queryLatestAppInfo
- The HeraAppBaseInfoMapper.xml queries used LEFT JOIN on hera_app_excess_info, but since the WHERE clause already filters on columns from that table, the LEFT JOIN
effectively behaves as an INNER JOIN. Removing it simplifies the query and improves performance.
2. Upgrade ozhera-app module version to 2.2.7-incubating
Contributor guide
Research direction
Locate HeraAppBaseInfoMapper.xml and inspect queryAppInfo and queryLatestAppInfo, then find the ozhera-app module version declaration. Check the existing module build and tests before making the query and version changes; done means the joins are simplified without changing results and the module reports version 2.2.7-incubating.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- backend, build-system, database
- Issue type
- Refactor
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 76/100