[OPENJPA-56] in derby concat with input parameter needs a cast, otherwise becomes long varchar and some operations do not work

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.7
• Component/s: query
• Environment: Windows xp, derby, openjpa version 443432.
• Assignee: Unassigned
• Reporter: George Hongell
• Created: 20/Sep/06 16:55
• Updated: 01/Mar/07 02:20
• Resolved: 01/Mar/07 02:20

Description

run on version 443432.
in derby concat with input parameter needs a cast, otherwise becomes long varchar and some operations do not work
(NOTE:already done if concat is inside substring eg. substring(concat(xxx,yyy),n,m)

EJBQL:
select d from EmpBean e left join e.dept d where concat(d.name, 'ahmad') = 'AhmadDept'

OPENJPA ERROR OR SQL PUSHDOWN:
Comparisons between 'LONG VARCHAR' and 'LONG VARCHAR' are not supported.

{SELECT t1.deptno, t1.budget, t1.mgr_empid, t1.name, t1.reportsTo_deptno FROM EmpBean t0 LEFT OUTER JOIN DeptBean t1 ON t0.dept_deptno = t1.deptno WHERE ((t1.name||?) = ?)}

[code=30000, state=42818]

SUGGESTED SQL PUSHDOWN:
select t1.deptno, t1.name FROM EmpBean t0 LEFT OUTER JOIN DeptBean t1 ON t0.dept_deptno = t1.deptno WHERE (cast((t1.name||?) as Varchar(1000))) = ?

{String ahmad, String AhmadDept}