Meituan-Dianping / Meituan-Dianping/SQLAdvisor
sqladvisor :Invalid parameter number 怎么会出现这个问题
Nobody has claimed this yet.
- Dominant language
- C
- Stars
- 5.6k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
2018-07-16 23:12:34 50130 [Note] 第1步: 对SQL解析优化之后得到的SQL:select * AS * from crmdb2.tbl_dept where ((1 = 1) and (id > 50) and (id < 100))
2018-07-16 23:12:34 50130 [Note] 第2步：开始解析where中的条件:(id > 50)
2018-07-16 23:12:34 50130 [Note] 第3步：SQLAdvisor结束！错误日志:Invalid parameter number
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the reported SQLAdvisor run with the exact SQL and log sequence in this issue, especially the WHERE condition id > 50. Trace the failure that produces “Invalid parameter number”; done means the query completes without that error and returns an index optimization recommendation. No source files or tests are identified in the report.
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