Add '<>' as not equal to in where clause

jsixface · jsixface · commit f0d7b3b5345e · 2017-10-31T21:09:52.000-04:00
diff --git a/lexical/lexical.go b/lexical/lexical.go
@@ -142,6 +142,9 @@ func Token() (uint8, *TokenError) {
 			if lexeme == "=" {
 				state = S_SMALLER_OR_EQUAL
 				break
+			} else if lexeme == ">" {
+				char = nextChar()
+				return T_NOT_EQUAL, nil
 			}
 			return T_SMALLER, nil
 		case S_SMALLER_OR_EQUAL:
diff --git a/runtime/commits_test.go b/runtime/commits_test.go
@@ -84,13 +84,23 @@ func TestSelectedFieldsCount(t *testing.T) {
 	}
 }
 
+func TestNotEqualsInWhereLTGT(t *testing.T) {
+	queryData := "select committer, hash from commits limit 1"
+	table := getTableForQuery(queryData, "../", t)
+	firstCommitter := table.rows[0]["committer"].(string)
+	query := fmt.Sprintf("select committer, hash from commits where committer <> '%s' limit 1", firstCommitter)
+	table = getTableForQuery(query, "../", t)
+	if firstCommitter == table.rows[0]["committer"].(string) {
+		t.Errorf("Still got the same committer as the first one. - %s", firstCommitter)
+	}
+}
 func TestNotEqualsInWhere(t *testing.T) {
 	queryData := "select committer, hash from commits limit 1"
 	table := getTableForQuery(queryData, "../", t)
 	firstCommitter := table.rows[0]["committer"].(string)
 	query := fmt.Sprintf("select committer, hash from commits where committer != '%s' limit 1", firstCommitter)
 	table = getTableForQuery(query, "../", t)
 	if firstCommitter == table.rows[0]["committer"].(string) {
-		t.Errorf("Strill got the same committer as the first one. - %s", firstCommitter)
+		t.Errorf("Still got the same committer as the first one. - %s", firstCommitter)
 	}
 }

Original file line number	Diff line number	Diff line change
`@@ -84,13 +84,23 @@ func TestSelectedFieldsCount(t *testing.T) {`
`84`	`84`	`}`
`85`	`85`	`}`
`86`	`86`
	`87`	`+func TestNotEqualsInWhereLTGT(t *testing.T) {`
	`88`	`+ queryData := "select committer, hash from commits limit 1"`
	`89`	`+ table := getTableForQuery(queryData, "../", t)`
	`90`	`+ firstCommitter := table.rows[0]["committer"].(string)`
	`91`	`+ query := fmt.Sprintf("select committer, hash from commits where committer <> '%s' limit 1", firstCommitter)`
	`92`	`+ table = getTableForQuery(query, "../", t)`
	`93`	`+ if firstCommitter == table.rows[0]["committer"].(string) {`
	`94`	`+ t.Errorf("Still got the same committer as the first one. - %s", firstCommitter)`
	`95`	`+ }`
	`96`	`+}`
`87`	`97`	`func TestNotEqualsInWhere(t *testing.T) {`
`88`	`98`	`queryData := "select committer, hash from commits limit 1"`
`89`	`99`	`table := getTableForQuery(queryData, "../", t)`
`90`	`100`	`firstCommitter := table.rows[0]["committer"].(string)`
`91`	`101`	`query := fmt.Sprintf("select committer, hash from commits where committer != '%s' limit 1", firstCommitter)`
`92`	`102`	`table = getTableForQuery(query, "../", t)`
`93`	`103`	`if firstCommitter == table.rows[0]["committer"].(string) {`
`94`		`- t.Errorf("Strill got the same committer as the first one. - %s", firstCommitter)`
	`104`	`+ t.Errorf("Still got the same committer as the first one. - %s", firstCommitter)`
`95`	`105`	`}`
`96`	`106`	`}`