Re: Possible bug in SQL-Statement: reports Bad predicate: '^1^'

[Jeff Zucker]

Jon Warbrick wrote:
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)
Yes, the module has some problems with certain kinds of parenthetical 
statements, I'm working on it.  In particular, it doesn't like parens on 
the outside of statements (though they're certainly legal).

while the earlier version that I was using (0.1021) could.

The 0.x series of SQL::Statement currently handles parentheses better 
than the 1.x series.  OTOH, the 1.x series handles functions, joins, 
aliases, and many other features the 0.x series did not.  In the long 
run, I'll be converting the parsing to Parse::Yapp which will eliminate 
the parentheses problems.  In the shorter term, I'll try to patch some 
leaks and recommend that you simplify parentheses where possible.

Thanks for the report.
--
Jeff