[jboss-jira] [JBoss JIRA] Created: (JBAS-6745) org.jboss.test.cmp2.audit.test.AuditUnitTestCase failing with MySQL - miliseconds not supported

Tue Apr 7 09:58:24 EDT 2009

org.jboss.test.cmp2.audit.test.AuditUnitTestCase failing with MySQL - miliseconds not supported
-----------------------------------------------------------------------------------------------

                 Key: JBAS-6745
                 URL: https://jira.jboss.org/jira/browse/JBAS-6745
             Project: JBoss Application Server
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Test Suite
    Affects Versions: JBossAS-5.1.0.Beta1
         Environment: MySQL as DefaultDS
            Reporter: Martin Malina
            Assignee: Shelly McGowan

Tests in org.jboss.test.cmp2.audit.test.AuditUnitTestCase are failing because MySQL does not support storage of miliseconds when storing DATETIME (or any other).

(This is part of the effort of trying to run the jboss-all-config-tests target of the AS testsuite against different databases.)

testUpdateAudit	Failure	Expected created time to be set between 1238076991121-1238076991136 during the test but got 1238076991000
junit.framework.AssertionFailedError: Expected created time to be set between 1238076991121-1238076991136 during the test but got 1238076991000
	at org.jboss.test.cmp2.audit.test.AuditUnitTestCase.testUpdateAudit(AuditUnitTestCase.java:77)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
	at junit.extensions.TestSetup.run(TestSetup.java:25)

The problem is that the created time is saved in the DB, then retrieved and compared to the values taken before and after the audit was created.

This is similar to JBPAPP-1063 where Emmanuel noted: "Actually I would expect the test to fail. We ened to tell our customer that MySQL will not be able to support millisecond timestamp."

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira