openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-606) InformixDictionary default setting beaks many testcases
Date Wed, 21 May 2008 09:43:55 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12598604#action_12598604
] 

Michael Dick commented on OPENJPA-606:
--------------------------------------

It seems that we can move some of the logic in Distinct.java into the DBDictionary. Or at
least add a flag in the DBDictionary that indicates whether ( ) are needed. Leaving :
if (sel.getConfiguration().getDBDictionaryInstance().platform.indexOf("Informix") > -1)
{

in the code is rather ugly.

> InformixDictionary default setting beaks many testcases
> -------------------------------------------------------
>
>                 Key: OPENJPA-606
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-606
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 1.2.0
>            Reporter: Catalina Wei
>
> In testing Informix backend store,  there are many query test string failed:
> 1. parameter of a boolean value does not work, should use 't for true, 'f' for false
>  WHERE (t1.isManager = ?) [params=(boolean) false]
>   
>    should generate  WHERE (t1.isManager = ?) [params=(String) f]
> 2. SELECT COUNT(DISTINCT(t1.name)) reported  syntax error  [code=-201, state=42000]
>     should generate COUNT(DISTINCT t1.name ) 
> 3. CROSS JOIN syntax error 
>  
>     should generate JOIN with ON 1 = 1
>    
> 4. There is no equivalent  function for LOCATE.  Informix users must create INSTR as
a user defined function.  
> 3. CONCAT function in '||' does not take parameter markers
>   WHERE ((?||t0.name) LIKE ? ESCAPE '\')
>   should generate  CONCAT(?, t0.name)

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


Mime
View raw message