Author: REHSACK
Date: Sun Oct 17 06:52:00 2010
New Revision: 14495
Modified:
dbi/branches/sqlengine/lib/DBI/SQL/Nano.pm
Log:
allow INSERT statement without "INTO" - SQL::Statement compat
Modified: dbi/branches/sqlengine/lib/DBI/SQL/Nano.pm
==============================================================================
--- dbi/branches/sqlengine/lib/DBI/SQL/Nano.pm (original)
+++ dbi/branches/sqlengine/lib/DBI/SQL/Nano.pm Sun Oct 17 06:52:00 2010
@@ -110,7 +110,7 @@
$self->{where_clause} = $self->parse_where_clause($clauses) if
($clauses);
}
};
- /^\s*INSERT\s+INTO\s+(\S+)\s*(\((.*?)\))?\s*VALUES\s*\((.+)\)/is
+ /^\s*INSERT\s+(?:INTO\s+)?(\S+)\s*(\((.*?)\))?\s*VALUES\s*\((.+)\)/is
&& do
{
$self->{command} = 'INSERT';