apache / apache/ozhera

Optimize queryAppInfo SQL and upgrade ozhera-app to 2.2.7-incubating

Open Beginner friendly
#673 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.