Meituan-Dianping / Meituan-Dianping/SQLAdvisor

索引优化出现错误sql,建议在对建议的sql做准确度校验。

Open
#61 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
C
Stars
5.6k
Forks
1.2k
PR merge metrics
No merged PRs in 30d

Description

出现两个字段同时出现在创建的索引中。

Contributor guide

No contributing guide indexed for this repository

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.

Research direction

Start by locating the index-optimization path that generates the recommended SQL and reproduce the reported case where two fields appear together in one created index. Trace how recommendations are validated, then add coverage for this case and confirm the generated SQL is accurate.

Written by the indexing model from the issue text.

Assessment

Tech stack
c
Domain
database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.