named query TasksAssignedAsPotentialOwner doesn't work with MySql db
---------------------------------------------------------------------
Key: JBRULES-3202
URL:
https://issues.jboss.org/browse/JBRULES-3202
Project: Drools
Issue Type: Bug
Security Level: Public (Everyone can see)
Environment: MYSQL database
Reporter: Frank23 Knoll23
Assignee: Mark Proctor
Hi,
When I add a task (having two potential owners) by calling the method addTask followed by
calling the method getTasksAssignedAsPotentialOwner of org.jbpm.task.service.TaskClient I
expect to receive a list of TaskSummaries containing at least the previously added task.
But I actually get an empty list!
Here is my setup and possible solution:
I am using the trunk version of ./jbpm-human-task/src/main/resources/META-INF/orm.xml and
a MYSQL database.
When calling addTask the Task table will be populated with a NULL actualOwner_id.
The named query TasksAssignedAsPotentialOwner
"select new org.jbpm.task.query.TaskSummary(...t.taskData.actualOwner...) from ...
left join t.taskData.actualOwner ..." of orm.xml generates SQL consisting of an inner
join "inner join OrganizationalEntity user7_ on task0_.actualOwner_id=user7_.id"
which doesn't take the NULL actualOwner_id correctly into account.
When I replace the named query TasksAssignedAsPotentialOwner with
"select new org.jbpm.task.query.TaskSummary(...actualOwner...) from ...left join
t.taskData.actualOwner as actualOwner ...", then the generated SQL consists of an
"left outer join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id"
which takes the NULL actualOwner_id correctly into account. So I get a List of
TaskSummaries containing the added task.
Is this a correct fix?
Cheers, Frank
--
This message is automatically generated by JIRA.
For more information on JIRA, see:
http://www.atlassian.com/software/jira