SQLAdvisor icon indicating copy to clipboard operation
SQLAdvisor copied to clipboard

bugfix:修复-q参数后面跟多个SQL无法正确解析的问题。(issue:#7)

Open dolphinsboy opened this issue 8 years ago • 0 comments

修复的版本验证:

2017-03-13 16:19:23 1180 [Note] Query 0 SELECT p.*,s.cn_name FROM cc_paysystem_withdrawal as p LEFT JOIN cc_shop as s ON p.type_id = s.id WHERE ( p.type = 'SHOP' ) ORDER BY p.id LIMIT 0,50

2017-03-13 16:19:23 1180 [Note] 第1步: 对SQL解析优化之后得到的SQL:select `p`.`*` AS `*`,`s`.`cn_name` AS `cn_name` from (`wk_shop`.`cc_paysystem_withdrawal` `p` left join `wk_shop`.`cc_shop` `s` on((`p`.`type_id` = `s`.`id`))) where (`p`.`type` = 'SHOP') order by `p`.`id` limit 0,50 

...
2017-03-13 16:19:23 1180 [Note] 第15步: SQLAdvisor结束! 

2017-03-13 16:19:23 1180 [Note] Query 1 select * from cc_paysystem_withdrawal where type='SHOP' order by id limit 0,50

2017-03-13 16:19:23 1180 [Note] 第1步: 对SQL解析优化之后得到的SQL:select `*` AS `*` from `wk_shop`.`cc_paysystem_withdrawal` where (`type` = 'SHOP') order by `id` limit 0,50 

.....
2017-03-13 16:19:23 1180 [Note] 第8步: SQLAdvisor结束! 

dolphinsboy avatar Mar 13 '17 08:03 dolphinsboy