Meituan-Dianping / Meituan-Dianping/SQLAdvisor

sqladvisor-web SQLAdvisor结束!错误日志:Invalid parameter number

Open
#42 5 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

2017-07-28 13:56:41 58531 [Note] 第1步: 对SQL解析优化之后得到的SQL:select * AS * from qk_auth.auth_function where (id = 100)

2017-07-28 13:56:41 58531 [Note] 第2步:开始解析where中的条件:(id = 100)

2017-07-28 13:56:41 58531 [Note] 第3步:SQLAdvisor结束!错误日志:Invalid parameter number

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

Reproduce the failure with the SQL shown in the issue and inspect the SQL parsing and parameter-handling path after the WHERE condition is processed. Done means the query completes without the “Invalid parameter number” error and still produces the expected optimization result.

Written by the indexing model from the issue text.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.