summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAlexander Beedie <ayembee@gmail.com>2013-09-02 16:04:30 +0900
committerAlexander Beedie <ayembee@gmail.com>2013-09-02 16:04:30 +0900
commit836de63befa939746605cb578dd0ffad8fd113ca (patch)
tree0600770ad2a14a9ce6b502eb32296837112b451d
parent3b41501e850f3de9c0ac3c480bf63e73aa20a45d (diff)
downloadsqlparse-836de63befa939746605cb578dd0ffad8fd113ca.tar.gz
add keyword recognition for "FULL OUTER JOIN" and "CROSS JOIN"
-rw-r--r--sqlparse/lexer.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/sqlparse/lexer.py b/sqlparse/lexer.py
index 45ba4cb..fa742a5 100644
--- a/sqlparse/lexer.py
+++ b/sqlparse/lexer.py
@@ -198,7 +198,7 @@ class Lexer(object):
# not a real string literal in ANSI SQL:
(r'(""|".*?[^\\]")', tokens.String.Symbol),
(r'(\[.*[^\]]\])', tokens.Name),
- (r'(LEFT\s+|RIGHT\s+)?(INNER\s+|OUTER\s+|STRAIGHT\s+)?JOIN\b', tokens.Keyword),
+ (r'(LEFT\s+|RIGHT\s+|FULL\s+)?(INNER\s+|OUTER\s+|STRAIGHT\s+|CROSS\s+)?JOIN\b', tokens.Keyword),
(r'END(\s+IF|\s+LOOP)?\b', tokens.Keyword),
(r'NOT NULL\b', tokens.Keyword),
(r'CREATE(\s+OR\s+REPLACE)?\b', tokens.Keyword.DDL),