[
https://issues.apache.org/jira/browse/OFBIZ-1045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12527722
]
Cameron Smith commented on OFBIZ-1045:
--------------------------------------
I am afraid it didn't work for me.
a. The patch was not relative to ofbiz root dir, but I corrected that before
applying it, and then rebuilt ofbiz-entity.jar
b. Incorrect SQL was still being generated. When I debugged, the overridden
makeRHSWhereStringValue() declaration in the anonymous class, was not being
called. I can only imagine this is because you and I are working from
different trunks.
We use our own version of OFBiz, based on
http://svn.apache.org/repos/asf/ofbiz/branches/release4.0, which was last
merged with this branch at r545673. I have to say I don't recognize your
tags 4955 and 7941, they seem very old, what repository are you working with
Luke?
> EntityOperator does not correctly construct SQL for BETWEEN clause
> ------------------------------------------------------------------
>
> Key: OFBIZ-1045
> URL: https://issues.apache.org/jira/browse/OFBIZ-1045
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Environment: ubuntu 7.04, postgres 8.2, working with SVN release
> 4955, but EntityOperator.java has not changed since then.
> Reporter: Luke Prentice
> Attachments: all-app-framework-EntityOperator.java.diff,
> all-app-framework-EntityOperator.java.diff,
> all-app-framework-EntityOperator.java.diff
>
>
> when using the BETWEEN EntityOperator the SQL produced is incorrectly
> formatted:
> ... field1 BETWEEN (value1, value2)
> it should be
> ... field1 BETWEEN value1 AND value2
> this produces an SQL parse exception.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
