[jira] Resolved: (OPENJPA-607) Extraneous "( )" on DISTINCT, ALL, ANY results in SQL syntax errors on some database systems

["Catalina Wei (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OPENJPA-607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Catalina Wei resolved OPENJPA-607.
----------------------------------

       Resolution: Fixed
    Fix Version/s: 1.2.0
         Assignee: Catalina Wei

This problem is fixed under r659027.

> Extraneous "( )" on DISTINCT, ALL, ANY results in  SQL syntax errors on some database systems
> ---------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-607
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-607
>             Project: OpenJPA
>          Issue Type: Bug
>            Reporter: Catalina Wei
>            Assignee: Catalina Wei
>             Fix For: 1.2.0
>
>
> In testing various back-end database systems such as Sybase, Informix. there are cases where the extra pair of () resulted in SQL Syntax error:
> For example,
> 1. in generating ALL, ANY subquery, there is extraneous pair of "(  )"  that are tolerated by most systems such as DB2, Oracle but not Sybase.
> WHERE (t0.DEPT_DEPTNO = ANY ((SELECT t1.deptno FROM DeptBean t1 WHERE (t1.deptno = ? )))
> 2.In the case of DISTINCT function, Informix reports syntax error when argument/s of the DISTINCT is/are parenthesized:
> SELECT COUNT(DISTINCT (t1.name)) FROM EmpBean t1

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.