[
https://issues.apache.org/jira/browse/OPENJPA-2692?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17350127#comment-17350127
]
Utkarsh Kumar Sharma commented on OPENJPA-2692:
-----------------------------------------------
Hi All, I want to work on this reported issue. I am confident that I can
resolve this. I just need a little help to set up the project and get started.
I am new to this open-source environment and don't know who to contact to get
this issue assigned to me.
> Generated query does not have enough parentheses
> ------------------------------------------------
>
> Key: OPENJPA-2692
> URL: https://issues.apache.org/jira/browse/OPENJPA-2692
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 2.4.0
> Reporter: Palani G
> Priority: Blocker
>
> Here is the JPQL
> SELECT process FROM com.aa.bb.Process process WHERE ((((process._server._id =
> :server_id and UPPER(process._processId) = :processId) and
> UPPER(process._processName) = :processName) and UPPER(process._origNode) =
> :origNode) or (((process._server._id = :server_id2 and
> UPPER(process._processId) = :processId2) and UPPER(process._processName) =
> :processName2) and UPPER(process._origNode) = :origNode2))]
> Incorrect query generated openJPA
> --> [SELECT t0.PROCESS_ID, t0.ORIG_NODE, t0.PROC_ID, t0.PROC_NAME, FROM
> PROCESS_TABLE t0 WHERE (t0.SERVER_ID = ? AND UPPER(t0.PROC_ID) = ? AND
> UPPER(t0.PROC_NAME) = ? AND UPPER(t0.ORIG_NODE) = ? OR t0.SERVER_ID = ? AND
> UPPER(t0.PROC_ID) = ? AND UPPER(t0.PROC_NAME) = ? AND UPPER(t0.ORIG_NODE) =
> ?)]
> This should be the correct query generated by openjpa
> SELECT t0.PROCESS_ID, t0.ORIG_NODE, t0.PROC_ID, t0.PROC_NAME, FROM
> PROCESS_TABLE t0 WHERE
> ( (t0.SERVER_ID = ? AND UPPER(t0.PROC_ID) = ? AND UPPER(t0.PROC_NAME) = ? AND
> UPPER(t0.ORIG_NODE) = ? ) OR (t0.SERVER_ID = ? AND UPPER(t0.PROC_ID) = ? AND
> UPPER(t0.PROC_NAME) = ? AND UPPER(t0.ORIG_NODE) = ?))
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
