openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Catalina Wei (JIRA)" <>
Subject [jira] Created: (OPENJPA-606) InformixDictionary default setting beaks many testcases
Date Wed, 21 May 2008 01:34:55 GMT
InformixDictionary default setting beaks many testcases

                 Key: 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( reported  syntax error  [code=-201, state=42000]

    should generate COUNT(DISTINCT ) 

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 ((?|| LIKE ? ESCAPE '\')

  should generate  CONCAT(?,

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

View raw message