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

Nobody has claimed this yet.

Assessment

Difficulty
2/5
Estimated time
1-3 hours
Newbie friendliness
76/100
Issue type
Refactor
Clarity
Mostly clear
Activity status
Active
Tech stack
java, sql
Domain
backend, build-system, database

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.

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
Dominant language
Java
Stars
122
Forks
46
Avg merge
13h 8m
Merged PRs (30d)
8

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from apache/ozhera

All issues in apache/ozhera

Similar issues

More Java issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.