Jon Warbrick wrote:
I've just spent a while sorting out a program which uses DBD-CSV and
which broke when moved to a new machine with updated versions of most
Perl modules, reporting
SQL ERROR: Bad predicate: '^1^'!
The problem appears to be that the current version of SQL-Statement
(1.09) can't parse
SELECT col FROM tbl WHERE ((c1 = 1 OR c1 = 2) AND c2 = 1)
while the earlier version that I was using (0.1021) could. Both are
happy with
SELECT col FROM tbl WHERE (c1 = 1 OR c1 = 2) AND c2 = 1
I've no idea if the former is actually legal and/or supposed to be
supported by SQL-Statement but I thought it worth mentioning. The
program below (mildly adapted from the POD example) demonstrates the
problem.
How timely...
Jeff Z. and I are working on a SQL-Statement update that should
fix your paren problems, plus provide a few more new features,
so stay tuned.
Regards,
Dean Arnold
Presicient Corp.
