summaryrefslogtreecommitdiff
path: root/sqlparse
diff options
context:
space:
mode:
authorAndi Albrecht <albrecht.andi@gmail.com>2017-05-25 08:52:13 +0200
committerAndi Albrecht <albrecht.andi@gmail.com>2017-05-25 08:52:13 +0200
commitdc788ab5b1af2e2a4a988b31a09d8d6656853f76 (patch)
treeca574d197ebe87165e5407c8090cfdd50d00b171 /sqlparse
parent0b467460762c51d5480271a7010c5936a116317b (diff)
downloadsqlparse-dc788ab5b1af2e2a4a988b31a09d8d6656853f76.tar.gz
Recognize MySQL table names starting with digits (fixes #337).
Diffstat (limited to 'sqlparse')
-rw-r--r--sqlparse/keywords.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/sqlparse/keywords.py b/sqlparse/keywords.py
index 6a214f1..92da63e 100644
--- a/sqlparse/keywords.py
+++ b/sqlparse/keywords.py
@@ -60,7 +60,7 @@ SQL_REGEX = {
(r'-?0x[\dA-F]+', tokens.Number.Hexadecimal),
(r'-?\d*(\.\d+)?E-?\d+', tokens.Number.Float),
(r'-?\d*\.\d+', tokens.Number.Float),
- (r'-?\d+', tokens.Number.Integer),
+ (r'-?\d+(?![_A-Z])', tokens.Number.Integer),
(r"'(''|\\\\|\\'|[^'])*'", tokens.String.Single),
# not a real string literal in ANSI SQL:
@@ -77,7 +77,7 @@ SQL_REGEX = {
(r'CREATE(\s+OR\s+REPLACE)?\b', tokens.Keyword.DDL),
(r'DOUBLE\s+PRECISION\b', tokens.Name.Builtin),
- (r'[_A-Z][_$#\w]*', is_keyword),
+ (r'[0-9_A-Z][_$#\w]*', is_keyword),
(r'[;:()\[\],\.]', tokens.Punctuation),
(r'[<>=~!]+', tokens.Operator.Comparison),