added support for expressions with parentheses

virattara · virattara · commit 94df7c22e617 · 2018-10-07T14:23:05.000+05:30
diff --git a/src/sqlparser.rs b/src/sqlparser.rs
@@ -153,7 +153,14 @@ impl Parser {
                 Token::DoubleQuotedString(_) => {
                     self.prev_token();
                     self.parse_sql_value()
-                }
+                },
+                Token::LParen => {
+                    let expr = self.parse();
+                    if !self.consume_token(&Token::RParen)? {
+                        return parser_err!(format!("expected token RParen"));
+                    }
+                    expr
+                },
                 _ => parser_err!(format!(
                     "Prefix parser expected a keyword but found {:?}",
                     t
diff --git a/tests/sqlparser_generic.rs b/tests/sqlparser_generic.rs
@@ -334,6 +334,29 @@ fn parse_select_version() {
     }
 }
 
+#[test]
+fn parse_parens() {
+    use self::ASTNode::*;
+    use self::SQLOperator::*;
+    let sql = "(a + b) - (c + d)";
+    let ast = parse_sql(&sql);
+    assert_eq!(
+        SQLBinaryExpr { 
+            left: Box::new(SQLBinaryExpr {
+                left: Box::new(SQLIdentifier("a".to_string())), 
+                op: Plus, 
+                right: Box::new(SQLIdentifier("b".to_string())) 
+            }), 
+            op: Minus, 
+            right: Box::new(SQLBinaryExpr { 
+                left: Box::new(SQLIdentifier("c".to_string())),
+                op: Plus, 
+                right: Box::new(SQLIdentifier("d".to_string()))
+            })
+        }
+    , ast);
+}
+
 fn parse_sql(sql: &str) -> ASTNode {
     let dialect = GenericSqlDialect {};
     let mut tokenizer = Tokenizer::new(&dialect,&sql, );
