summaryrefslogtreecommitdiff
path: root/sqlparse
diff options
context:
space:
mode:
authorVictor Uriarte <victor.m.uriarte@intel.com>2016-06-03 11:39:29 -0700
committerVictor Uriarte <victor.m.uriarte@intel.com>2016-06-04 11:54:26 -0700
commitece7c26727b28ea05feeeba3a9c2d1b4b7eb5c54 (patch)
treee4bba42af408aa4199883aba5715ca56b85a12db /sqlparse
parent689153a1fbe1bd8661c405e5305c4ac2414e55a8 (diff)
downloadsqlparse-ece7c26727b28ea05feeeba3a9c2d1b4b7eb5c54.tar.gz
Rewrite regex to allow spaces between `name` and `.`
Diffstat (limited to 'sqlparse')
-rw-r--r--sqlparse/keywords.py6
1 files changed, 5 insertions, 1 deletions
diff --git a/sqlparse/keywords.py b/sqlparse/keywords.py
index 34e4d80..38b7765 100644
--- a/sqlparse/keywords.py
+++ b/sqlparse/keywords.py
@@ -46,7 +46,11 @@ SQL_REGEX = {
(r'(CASE|IN|VALUES|USING)\b', tokens.Keyword),
(r'(@|##|#)[A-Z]\w+', tokens.Name),
- (r'[A-Z]\w*(?=\.)', tokens.Name), # see issue39
+
+ # see issue #39
+ # Spaces around period `schema . name` are valid identifier
+ # TODO: Spaces before period not implemented
+ (r'[A-Z]\w*(?=\s*\.)', tokens.Name), # 'Name' .
(r'(?<=\.)[A-Z]\w*', tokens.Name), # .'Name'
(r'[A-Z]\w*(?=\()', tokens.Name), # side effect: change kw to func