Add DISTINCTROW keyword (fixes #677).

2 files changed, 7 insertions, 0 deletions

diff --git a/CHANGELOG b/CHANGELOG
index 8ebb6e3..10185b2 100644
--- a/CHANGELOG
+++ b/CHANGELOG
@@ -7,6 +7,7 @@ Enhancements
 * Add support for additional SPARK keywords (pr643, by mrmasterplan).
 * Avoid tokens copy (pr622, by living180).
 * Add REGEXP as a comparision (pr647, by PeterSandwich).
+* Add DISTINCTROW keyword for MS Access (issue677).
 
 Bug Fixes
 
diff --git a/sqlparse/keywords.py b/sqlparse/keywords.py
index 29f27af..0f3a459 100644
--- a/sqlparse/keywords.py
+++ b/sqlparse/keywords.py
@@ -16,6 +16,7 @@ def is_keyword(value):
             or KEYWORDS_ORACLE.get(val)
             or KEYWORDS_PLPGSQL.get(val)
             or KEYWORDS_HQL.get(val)
+            or KEYWORDS_MSACCESS.get(val)
             or KEYWORDS.get(val, tokens.Name)), value
 
 
@@ -962,3 +963,8 @@ KEYWORDS_HQL = {
     'BREAK': tokens.Keyword,
     'LEAVE': tokens.Keyword,
 }
+
+
+KEYWORDS_MSACCESS = {
+    'DISTINCTROW': tokens.Keyword,
+}