| Key: |
OPENJPA-56
|
| Type: |
Bug
|
| Status: |
Closed
|
| Resolution: |
Fixed
|
| Priority: |
Major
|
| Assignee: |
Unassigned
|
| Reporter: |
George Hongell
|
| Votes: |
0
|
| Watchers: |
0
|
|
If you were logged in you would be able to see more operations.
|
|
|
|
File Attachments:
|
|
|
Environment:
|
Windows xp, derby, openjpa version 443432.
Windows xp, derby, openjpa version 443432.
|
|
| Resolution Date: |
01/Mar/07 02:20 AM
|
|
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}
|
|
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}
|
Show » |
|
in derby concat with input parameter needs a cast, otherwise becomes long varchar and some operations do not work
