XiaoMi / soar

SQL Optimizer And Rewriter
Apache License 2.0
8.67k stars 1.32k forks source link

CLA.001 suggest in JOIN condition #213

Closed martianzhang closed 5 years ago

martianzhang commented 5 years ago

Please answer these questions before submitting your issue. Thanks!

  1. What did you do? If possible, provide a recipe for reproducing the error.
select * from film join  film_actor ON film.film_id = film_actor.film_id AND film.length=120;
  1. What did you expect to see?

No suggest about CLA.001

  1. What did you see instead?
## 最外层 SELECT 未指定 WHERE 条件

* **Item:**  CLA.001

* **Severity:**  L4

* **Content:**  SELECT 语句没有 WHERE 子句,可能检查比预期更多的行(全表扫描)。对于 SELECT COUNT(\*) 类型的请求如果不要求精度,建议使用 SHOW TABLE STATUS 或 EXPLAIN 替代。
  1. What version of are you using (soar -version)?
Version: 2019-06-12 22:00:10 +0800 0.11.0-57-g342fd27
Branch: dev
Compile: 2019-07-03 14:54:50 +0800 by go version go1.11.4 linux/amd64
anythingwhat commented 5 years ago

请问这个问题解决了吗@ martianzhang