summaryrefslogtreecommitdiff
path: root/sqlparse
diff options
context:
space:
mode:
authorAndi Albrecht <albrecht.andi@gmail.com>2019-05-01 11:55:31 +0200
committerAndi Albrecht <albrecht.andi@gmail.com>2019-05-01 11:55:31 +0200
commit93262c895b955ff50a1bc13536de3024d3eede50 (patch)
tree98a121b71942a0be9fd556f0d242018ae12d15f9 /sqlparse
parent913b56e34edc7e3025feea4744dbd762774805c3 (diff)
downloadsqlparse-93262c895b955ff50a1bc13536de3024d3eede50.tar.gz
Identitfy NULLS FIRST/LAST as keywords (fixes #487).
Diffstat (limited to 'sqlparse')
-rw-r--r--sqlparse/keywords.py1
1 files changed, 1 insertions, 0 deletions
diff --git a/sqlparse/keywords.py b/sqlparse/keywords.py
index 761d14e..d929cbf 100644
--- a/sqlparse/keywords.py
+++ b/sqlparse/keywords.py
@@ -78,6 +78,7 @@ SQL_REGEX = {
r'|(CROSS\s+|NATURAL\s+)?)?JOIN\b', tokens.Keyword),
(r'END(\s+IF|\s+LOOP|\s+WHILE)?\b', tokens.Keyword),
(r'NOT\s+NULL\b', tokens.Keyword),
+ (r'NULLS\s+(FIRST|LAST)\b', tokens.Keyword),
(r'UNION\s+ALL\b', tokens.Keyword),
(r'CREATE(\s+OR\s+REPLACE)?\b', tokens.Keyword.DDL),
(r'DOUBLE\s+PRECISION\b', tokens.Name.Builtin),