Support for SET NULL, SET DEFAULT and NO ACTION in foreign key clauses for SQLite.

[dbsrgits/SQL-Translator.git] / lib / SQL / Translator / Parser / MySQL.pm

diff --git a/lib/SQL/Translator/Parser/MySQL.pm b/lib/SQL/Translator/Parser/MySQL.pm
index 40ef243..a3ba734 100644 (file)
--- 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];