[OPENJPA-606] InformixDictionary default setting beaks many testcases

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.0.4, 1.2.0
• Component/s: sql
• Assignee: Unassigned
• Reporter: Catalina Wei
• Created: 21/May/08 01:33
• Updated: 09/Mar/10 18:32
• Resolved: 04/Jun/08 19:44

Description

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)

Issue Links

• is part of: OPENJPA-1243 migrate Informix functionality from 1.2 to 1.0.x