[OPENJPA-1828] Query with expression IN (collection_valued_input_parameter) should report syntax error, correct usange is IN collection_valued_input_parameter

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.1.0
• Environment: openjpa-2.1.0-20101001.064809-70
• Assignee: Catalina Wei
• Reporter: Azuo Lee
• Created: 07/Oct/10 18:26
• Updated: 13/Jan/11 16:45
• Resolved: 20/Oct/10 05:11

Description

for (int i = 0; i < 2; i ++) {
List categories = new LinkedList();
categories.add("01");
categories.add("02");
categories.add("03");
Query q = entityManager.createQuery("select v.id from Category v where v.id in () order by v.id asc");
q.setParameter("p", categories);
List results = q.getResultList();
for (Iterator it = results.iterator(); it.hasNext(); )
System.out.print(it.next() + ", ");
System.out.println();
}

The above code will produce the following output:
01, 02, 03,
02, 03,

"01" is missing when the second time the same query is executed.