in reply to Static Data, SQL::Parser
It appears SQL::Statement has a bug, as
Perl Contrarian & SQL fanboy
does not produce the error. String literals also seem to be a problem.my $parser = SQL::Parser->new( 'ANSI', {RaiseError=>0,PrintError=>1} ) or die "No parser\n"; my $stmt = SQL::Statement->new( "SELECT 1 + 0 AS A FROM DUAL", $parser + ) or die "No statement";
There's an rt.cpan ticket thats kinda similar, but you might want to open a more specific one.
BTW: Keep in mind that 'ANSI' dialect ne 'Oracle' dialect; whatever storage engine you provide will have to supply its own interpretation of "DUAL".
Perl Contrarian & SQL fanboy
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Static Data, SQL::Parser
by CLovegren (Novice) on May 07, 2007 at 23:19 UTC | |
by renodino (Curate) on May 08, 2007 at 02:36 UTC | |
by CLovegren (Novice) on May 08, 2007 at 08:21 UTC |
In Section
Seekers of Perl Wisdom