X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FParser%2FMySQL.pm;h=a3ba734c3e8e153a0ce84646b09ac638eb05496d;hb=565563b9799775b9992c3f7cb85753b1d2b31c39;hp=40ef243da3c3a4943c1a9c9452b567373ee8d235;hpb=e6c5fb6e892a94c4244dd8ee93848d6fb1b00308;p=dbsrgits%2FSQL-Translator.git

diff --git a/lib/SQL/Translator/Parser/MySQL.pm b/lib/SQL/Translator/Parser/MySQL.pm
index 40ef243..a3ba734 100644
--- a/lib/SQL/Translator/Parser/MySQL.pm
+++ b/lib/SQL/Translator/Parser/MySQL.pm
@@ -860,17 +860,21 @@ BACKTICK : '`'
 
 DOUBLE_QUOTE: '"'
 
+SINGLE_QUOTE: "'"
+
 QUOTED_NAME : BACKTICK /[^`]+/ BACKTICK
     { $item[2] }
     | DOUBLE_QUOTE /[^"]+/ DOUBLE_QUOTE
     { $item[2] }
+    | SINGLE_QUOTE /[^']+/ SINGLE_QUOTE
+    { $item[2] }
 
 NAME: QUOTED_NAME
     | /\w+/
 
 VALUE : /[-+]?\.?\d+(?:[eE]\d+)?/
     { $item[1] }
-    | /'.*?'/
+    | QUOTED_NAME
     {
         # remove leading/trailing quotes
         my $val = $item[1];