SummaryHelper not setting replacements

Jay Bourland <[email protected]> Sun, 9 Jun 2013 09:03:15 -0600
Newsgroups gmane.comp.jakarta.turbine.torque.user
Message-ID <[email protected]>
I'm trying to convert an old Torque site to version 4. I'm running into =
a problem with using a count() function. The code looks like this:

      Criteria crit =3D getCriteriaDogsWithAllTitles( titles, year );

      SummaryHelper summary =3D new SummaryHelper();

      summary.addAggregate( "count", new Count( DogPeer.DOG_ID ) );
      List<ListOrderedMapCI> results =3D summary.summarize( crit );

When summarize() is executed, I get a "jdbc4.MySQLSyntaxErrorException: =
You have an error in your SQL syntax" exception. The Criteria is good =
and works fine with a doSelect(). It appears that the summarize converts =
the Criteria to a string without adding in the replacements for the =
parameters in the prepared statement. Also, if I take the string from =
the queryStatement and replace the '?' with values, the statement runs =
fine from an interactive MySQL session. When I compare the code in =
SummaryHelper.summarize() to BasePeerImpl.doSelect() the code to set the =
replacements is present in doSelect but not in summarize.

What's the best way to report this?

Thanks,
Jay Bourland=