sqladvisor :Invalid parameter number 怎么会出现这个问题
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 25/100
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.
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
- Dominant language
- C
- Stars
- 5.6k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
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.
More from Meituan-Dianping/SQLAdvisor
-
修复了一些安装问题和代码bugOpen
Difficulty 5/5 Over a week Newbie friendliness 25/100
Meituan-Dianping/SQLAdvisor#100 ·
-
有纯洁的docker 镜像么？Open
Difficulty 4/5 3-5 days Newbie friendliness 20/100
-
连接访问不到Open
Difficulty 2/5 1-3 hours Newbie friendliness 25/100
-
Difficulty 5/5 Over a week Newbie friendliness 20/100
Meituan-Dianping/SQLAdvisor#97 · 1 reaction ·
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
All issues in Meituan-Dianping/SQLAdvisor
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
Maintainers usually reply within 1 day
-
severity: low
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
luainkernel/lunatik#1853 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 Half a day Newbie friendliness 70/100
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
resetes12/pokeemerald#204 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
Maintainers usually reply within 6 days