Bug 1248527 - Reading tasks from DB on MySQL 5.5 returns tasks with createdOn field that contains midnight time
Summary: Reading tasks from DB on MySQL 5.5 returns tasks with createdOn field that co...
Keywords:
Status: CLOSED EOL
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: jBPM Core
Version: 6.1.0
Hardware: Unspecified
OS: Unspecified
high
unspecified
Target Milestone: ER5
: 6.2.0
Assignee: Alessandro Lazarotti
QA Contact: Tibor Zimanyi
URL:
Whiteboard:
Depends On:
Blocks: 1249260
TreeView+ depends on / blocked
 
Reported: 2015-07-30 13:00 UTC by Tibor Zimanyi
Modified: 2020-03-27 20:06 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
: 1249260 (view as bug list)
Environment:
Last Closed: 2020-03-27 20:06:02 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)

Description Tibor Zimanyi 2015-07-30 13:00:12 UTC 
Description of problem: 

When using MySQL 5.5 database system, reading tasks with method InternalTaskService.getActiveTasks() returns tasks that have narrowed creation time to midnight (e.g. 2015-07-23 00:00:00). Bug is probably somewhere where tasks are read from DB, because also method InternalTaskService.getActiveTasks(date) doesn't work.


Version-Release number of selected component (if applicable): 6.1.2.CR3


How reproducible: Run JUnit test LifeCycleLocalCommandBasedTest.testCompleteByActiveTasks from community repository jbpm using MySQL 5.5.

Actual results: Mentioned test fails. 

Expected results: Mentioned test passes. 

Additional info:
Comment 2 Maciej Swiderski 2015-10-16 14:32:38 UTC 
fixed test has been back ported to 6.3.x branch
https://github.com/droolsjbpm/jbpm/commit/385a002e5d32a16cff49e2af10bc461857d39b5b
Comment 3 Tibor Zimanyi 2015-11-10 13:53:08 UTC 
Verified in 6.2.0.ER5.
Note You need to log in before you can comment on or make changes to this bug.