summaryrefslogtreecommitdiff
path: root/pygments/lexers/sql.py
diff options
context:
space:
mode:
authorbgirarde <bgirarde@yelp.com>2014-08-21 16:49:40 -0700
committerbgirarde <bgirarde@yelp.com>2014-08-21 16:49:40 -0700
commit1987be8c8f814b4fb5ec3240e91a7ce2a399ed26 (patch)
treeb56501d58cb9c10ac6013dd7092d4b5e3cd33316 /pygments/lexers/sql.py
parent750ca02ad15f5c6a8090e090f08c659748cfc592 (diff)
downloadpygments-1987be8c8f814b4fb5ec3240e91a7ce2a399ed26.tar.gz
Fix parsing of escaped quotes in strings in MySqlLexer
Diffstat (limited to 'pygments/lexers/sql.py')
-rw-r--r--pygments/lexers/sql.py7
1 files changed, 3 insertions, 4 deletions
diff --git a/pygments/lexers/sql.py b/pygments/lexers/sql.py
index 7540f079..5070d487 100644
--- a/pygments/lexers/sql.py
+++ b/pygments/lexers/sql.py
@@ -464,10 +464,9 @@ class MySqlLexer(RegexLexer):
(r'/\*', Comment.Multiline, 'multiline-comments'),
(r'[0-9]+', Number.Integer),
(r'[0-9]*\.[0-9]+(e[+-][0-9]+)', Number.Float),
- # TODO: add backslash escapes
- (r"'(''|[^'])*'", String.Single),
- (r'"(""|[^"])*"', String.Double),
- (r"`(``|[^`])*`", String.Symbol),
+ (r"'(\\\\|\\'|''|[^'])*'", String.Single),
+ (r'"(\\\\|\\"|""|[^"])*"', String.Double),
+ (r"`(\\\\|\\`|``|[^`])*`", String.Symbol),
(r'[+*/<>=~!@#%^&|`?-]', Operator),
(r'\b(tinyint|smallint|mediumint|int|integer|bigint|date|'
r'datetime|time|bit|bool|tinytext|mediumtext|longtext|text|'