fix XiaoMi#232 & XiaoMi#230

jerry-00 · Oct 17, 2019 · 5b03689 · 5b03689
1 parent c5170f0
commit 5b03689
Show file tree

Hide file tree

Showing 3 changed files with 10 additions and 4 deletions.
diff --git a/ast/meta.go b/ast/meta.go
@@ -297,8 +297,11 @@ func FindEQColsInWhere(node sqlparser.SQLNode) []*common.Column {
 				}
 
 			default:
-				if _, ok := eqOperators[node.Operator]; ok {
-					newCols = FindColumn(node)
+				switch node.Left.(type) {
+				case *sqlparser.ColName:
+					if _, ok := eqOperators[node.Operator]; ok {
+						newCols = FindColumn(node)
+					}
 				}
 			}
 

diff --git a/ast/meta_test.go b/ast/meta_test.go
@@ -85,7 +85,10 @@ func TestGetParseTableWithStmt(t *testing.T) {
 
 func TestFindCondition(t *testing.T) {
 	common.Log.Debug("Entering function: %s", common.GetFunctionName())
-	for _, sql := range common.TestSQLs {
+	sqls := []string{
+		`SELECT * FROM film WHERE length % 20 = 4;`,
+	}
+	for _, sql := range append(sqls, common.TestSQLs...) {
 		fmt.Println(sql)
 		stmt, err := sqlparser.Parse(sql)
 		// pretty.Println(stmt)

diff --git a/doc/install.md b/doc/install.md
@@ -14,7 +14,7 @@ chmod a+x soar
 
 一般依赖
 
-* Go 1.10+
+* Go 1.12+
 * git
 
 高级依赖（仅面向开发人员）