X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FParser%2FSQLite.pm;h=1aab7f0778bed736df72392cd41b41f3df999c4a;hb=2c4ace8a43bc2f9c387fc0d4d22699b8e1c1baca;hp=4787302678f656928b435f226c58ca838d6ea3a0;hpb=fd498bb0acde8fb312f841aaebc896ed19db59d1;p=dbsrgits%2FSQL-Translator.git diff --git a/lib/SQL/Translator/Parser/SQLite.pm b/lib/SQL/Translator/Parser/SQLite.pm index 4787302..1aab7f0 100644 --- a/lib/SQL/Translator/Parser/SQLite.pm +++ b/lib/SQL/Translator/Parser/SQLite.pm @@ -133,7 +133,7 @@ like-op::= use strict; use warnings; -our $VERSION = '1.59'; +our $VERSION = '1.62'; our $DEBUG; $DEBUG = 0 unless defined $DEBUG; @@ -477,7 +477,8 @@ column_list : field_name(s /,/) parens_value_list : '(' VALUE(s /,/) ')' { $item[2] } -expr : /[^)]+/ +expr : /[^)]* \( [^)]+ \) [^)]*/x # parens, balanced one deep + | /[^)]+/ sort_order : /(ASC|DESC)/i @@ -730,6 +731,7 @@ sub parse { database_events => $def->{'db_events'}, action => $def->{'action'}, on_table => $def->{'on_table'}, + scope => 'row', # SQLite only supports row triggers ); }