John Brooking wrote:
> Also one last question (AFAIK) about what is
> supported:
See the pod documentation in SQL::Parser for a description of what SQL
is supported in DBD::CSV.
> What about GROUP BY
No, not yet supported.
> and standard grouping
> functions such as SUM and COUNT?
Supported in the SELECT clause (e.g. SELECT COUNT(*) FROM ...) but not
supported yet in other clauses.
> my $parser = SQL::Parser->new('Ansi');
> $parser->feature( 'select', 'join', 1 );
No, forget that, DBD::CSV handles that for you. If you are using the
new SQL::Statemetn 1.x then joins are automatically enabled and you can
just pretend that SQL::* modules don't exist since DBD::CSV calls them
for you behind the scenes.
> C>perl runSQL.pl "SELECT S.Title, P.PerfDate FROM
> Shows S, ShowTimes P WHERE P.ShowID = S.ShowID"
There's currently a bug in dotted table names, try an explicit join with
a USING or ON clause. I hope to have the dotted table names thing fixed
in the next couple of weeks.
--
Jeff
