Fix coupling of some db tests with local timezone

18 files changed, 61 insertions, 166 deletions

diff --git a/sonar-core/src/test/java/org/sonar/core/issue/db/IssueChangeDaoTest.java b/sonar-core/src/test/java/org/sonar/core/issue/db/IssueChangeDaoTest.java
index b6c047e795d..c6d5d6219bf 100644
--- a/sonar-core/src/test/java/org/sonar/core/issue/db/IssueChangeDaoTest.java
+++ b/sonar-core/src/test/java/org/sonar/core/issue/db/IssueChangeDaoTest.java
@@ -191,9 +191,9 @@ public class IssueChangeDaoTest extends AbstractDaoTestCase {
       .setChangeData("Some text")
       .setChangeType("comment")
       .setIssueKey("ABCDE")
-      .setCreatedAt(DateUtils.parseDate("2014-09-09").getTime())
-      .setUpdatedAt(DateUtils.parseDate("2014-09-10").getTime())
-      .setIssueChangeCreationDate(DateUtils.parseDate("2014-09-11").getTime());
+      .setCreatedAt(1_500_000_000_000L)
+      .setUpdatedAt(1_501_000_000_000L)
+      .setIssueChangeCreationDate(1_502_000_000_000L);
 
     dao.insert(session, changeDto);
     session.commit();
@@ -210,7 +210,7 @@ public class IssueChangeDaoTest extends AbstractDaoTestCase {
 
     // Only the following fields can be updated:
     change.setChangeData("new comment");
-    change.setUpdatedAt(DateUtils.parseDate("2013-06-30").getTime());
+    change.setUpdatedAt(1_500_000_000_000L);
 
     assertThat(dao.update(change)).isTrue();
 
diff --git a/sonar-core/src/test/java/org/sonar/core/issue/db/IssueChangeMapperTest.java b/sonar-core/src/test/java/org/sonar/core/issue/db/IssueChangeMapperTest.java
index 6c428e4a901..070cd2641d8 100644
--- a/sonar-core/src/test/java/org/sonar/core/issue/db/IssueChangeMapperTest.java
+++ b/sonar-core/src/test/java/org/sonar/core/issue/db/IssueChangeMapperTest.java
@@ -23,7 +23,6 @@ import org.apache.ibatis.session.SqlSession;
 import org.junit.After;
 import org.junit.Before;
 import org.junit.Test;
-import org.sonar.api.utils.DateUtils;
 import org.sonar.core.persistence.AbstractDaoTestCase;
 import org.sonar.core.persistence.MyBatis;
 
@@ -50,10 +49,9 @@ public class IssueChangeMapperTest extends AbstractDaoTestCase {
     dto.setIssueKey("ABCDE");
     dto.setChangeType(IssueChangeDto.TYPE_FIELD_CHANGE);
     dto.setChangeData("severity=INFO|BLOCKER");
-    long d = DateUtils.parseDate("2013-05-18").getTime();
-    dto.setCreatedAt(d);
-    dto.setUpdatedAt(d);
-    dto.setIssueChangeCreationDate(d);
+    dto.setCreatedAt(1_500_000_000_000L);
+    dto.setUpdatedAt(1_500_000_000_000L);
+    dto.setIssueChangeCreationDate(1_500_000_000_000L);
     mapper.insert(dto);
     session.commit();
 
@@ -68,9 +66,8 @@ public class IssueChangeMapperTest extends AbstractDaoTestCase {
     dto.setIssueKey("ABCDE");
     dto.setChangeType(IssueChangeDto.TYPE_COMMENT);
     dto.setChangeData("the comment");
-    long d = DateUtils.parseDate("2013-05-18").getTime();
-    dto.setCreatedAt(d);
-    dto.setUpdatedAt(d);
+    dto.setCreatedAt(1_500_000_000_000L);
+    dto.setUpdatedAt(1_500_000_000_000L);
     mapper.insert(dto);
     session.commit();
 
diff --git a/sonar-core/src/test/java/org/sonar/core/issue/db/IssueDaoTest.java b/sonar-core/src/test/java/org/sonar/core/issue/db/IssueDaoTest.java
index 785b52b7e67..d8495ccb6d2 100644
--- a/sonar-core/src/test/java/org/sonar/core/issue/db/IssueDaoTest.java
+++ b/sonar-core/src/test/java/org/sonar/core/issue/db/IssueDaoTest.java
@@ -24,8 +24,6 @@ import org.apache.ibatis.executor.result.DefaultResultHandler;
 import org.junit.After;
 import org.junit.Before;
 import org.junit.Test;
-import org.sonar.api.rule.Severity;
-import org.sonar.api.utils.DateUtils;
 import org.sonar.core.persistence.AbstractDaoTestCase;
 import org.sonar.core.persistence.DbSession;
 
@@ -128,21 +126,4 @@ public class IssueDaoTest extends AbstractDaoTestCase {
     assertThat(issue.getComponentKey()).isNotNull();
     assertThat(issue.getProjectKey()).isNull();
   }
-
-  @Test
-  public void find_rules_by_component() {
-    setupData("shared", "find_rules_by_component");
-
-    assertThat(dao.findRulesByComponent("Action.java", null, session)).hasSize(3);
-    assertThat(dao.findRulesByComponent("Action.java", DateUtils.parseDate("2013-04-17"), session)).hasSize(2);
-  }
-
-  @Test
-  public void find_severities_by_component() {
-    setupData("shared", "find_severities_by_component");
-
-    assertThat(dao.findSeveritiesByComponent("Action.java", null, session)).containsExactly(Severity.BLOCKER, Severity.MAJOR, Severity.BLOCKER);
-    assertThat(dao.findSeveritiesByComponent("Action.java", DateUtils.parseDate("2013-04-17"), session)).containsExactly(Severity.MAJOR);
-  }
-
 }
diff --git a/sonar-core/src/test/java/org/sonar/core/issue/db/IssueMapperTest.java b/sonar-core/src/test/java/org/sonar/core/issue/db/IssueMapperTest.java
index b09958301cf..d9561829aa7 100644
--- a/sonar-core/src/test/java/org/sonar/core/issue/db/IssueMapperTest.java
+++ b/sonar-core/src/test/java/org/sonar/core/issue/db/IssueMapperTest.java
@@ -66,11 +66,11 @@ public class IssueMapperTest extends AbstractDaoTestCase {
     dto.setChecksum("123456789");
     dto.setMessage("the message");
 
-    dto.setIssueCreationDate(DateUtils.parseDate("2013-05-18"));
-    dto.setIssueUpdateDate(DateUtils.parseDate("2013-05-19"));
-    dto.setIssueCloseDate(DateUtils.parseDate("2013-05-20"));
-    dto.setCreatedAt(1400000000000L);
-    dto.setUpdatedAt(1500000000000L);
+    dto.setIssueCreationTime(1_401_000_000_000L);
+    dto.setIssueUpdateTime(1_402_000_000_000L);
+    dto.setIssueCloseTime(1_403_000_000_000L);
+    dto.setCreatedAt(1_400_000_000_000L);
+    dto.setUpdatedAt(1_500_000_000_000L);
 
     mapper.insert(dto);
     session.commit();
@@ -101,11 +101,11 @@ public class IssueMapperTest extends AbstractDaoTestCase {
     dto.setChecksum("123456789");
     dto.setMessage("the message");
 
-    dto.setIssueCreationDate(DateUtils.parseDate("2013-05-18"));
-    dto.setIssueUpdateDate(DateUtils.parseDate("2013-05-19"));
-    dto.setIssueCloseDate(DateUtils.parseDate("2013-05-20"));
-    dto.setCreatedAt(1400000000000L);
-    dto.setUpdatedAt(1500000000000L);
+    dto.setIssueCreationTime(1_401_000_000_000L);
+    dto.setIssueUpdateTime(1_402_000_000_000L);
+    dto.setIssueCloseTime(1_403_000_000_000L);
+    dto.setCreatedAt(1_400_000_000_000L);
+    dto.setUpdatedAt(1_500_000_000_000L);
 
     mapper.update(dto);
     session.commit();
@@ -135,11 +135,11 @@ public class IssueMapperTest extends AbstractDaoTestCase {
     dto.setIssueAttributes("JIRA=FOO-1234");
     dto.setChecksum("123456789");
     dto.setMessage("the message");
-    dto.setIssueCreationDate(DateUtils.parseDate("2013-05-18"));
-    dto.setIssueUpdateDate(DateUtils.parseDate("2013-05-19"));
-    dto.setIssueCloseDate(DateUtils.parseDate("2013-05-20"));
-    dto.setCreatedAt(1400000000000L);
-    dto.setUpdatedAt(1500000000000L);
+    dto.setIssueCreationTime(1_401_000_000_000L);
+    dto.setIssueUpdateTime(1_402_000_000_000L);
+    dto.setIssueCloseTime(1_403_000_000_000L);
+    dto.setCreatedAt(1_400_000_000_000L);
+    dto.setUpdatedAt(1_500_000_000_000L);
 
     // selected after last update -> ok
     dto.setSelectedAt(1500000000000L);
diff --git a/sonar-core/src/test/java/org/sonar/core/issue/db/IssueStorageTest.java b/sonar-core/src/test/java/org/sonar/core/issue/db/IssueStorageTest.java
index 8ec847c3c86..bdda38311e9 100644
--- a/sonar-core/src/test/java/org/sonar/core/issue/db/IssueStorageTest.java
+++ b/sonar-core/src/test/java/org/sonar/core/issue/db/IssueStorageTest.java
@@ -63,7 +63,7 @@ public class IssueStorageTest extends AbstractDaoTestCase {
     // override generated key
     comment.setKey("FGHIJ");
 
-    Date date = DateUtils.parseDate("2013-05-18");
+    Date date = DateUtils.parseDateTime("2013-05-18T12:00:00+0000");
     DefaultIssue issue = new DefaultIssue()
       .setKey("ABCDE")
       .setNew(true)
@@ -98,7 +98,7 @@ public class IssueStorageTest extends AbstractDaoTestCase {
     // override generated key
     comment.setKey("FGHIJ");
 
-    Date date = DateUtils.parseDate("2013-05-18");
+    Date date = DateUtils.parseDateTime("2013-05-18T12:00:00+0000");
     DefaultIssue issue = new DefaultIssue()
       .setKey("ABCDE")
       .setNew(true)
@@ -136,7 +136,7 @@ public class IssueStorageTest extends AbstractDaoTestCase {
     // override generated key
     comment.setKey("FGHIJ");
 
-    Date date = DateUtils.parseDate("2013-05-18");
+    Date date = DateUtils.parseDateTime("2013-05-18T12:00:00+0000");
     DefaultIssue issue = new DefaultIssue()
       .setKey("ABCDE")
       .setNew(true)
@@ -174,7 +174,7 @@ public class IssueStorageTest extends AbstractDaoTestCase {
     // override generated key
     comment.setKey("FGHIJ");
 
-    Date date = DateUtils.parseDate("2013-05-18");
+    Date date = DateUtils.parseDateTime("2013-05-18T12:00:00+0000");
     DefaultIssue issue = new DefaultIssue()
       .setKey("ABCDE")
       .setNew(false)
@@ -220,7 +220,7 @@ public class IssueStorageTest extends AbstractDaoTestCase {
     // override generated key
     comment.setKey("FGHIJ");
 
-    Date date = DateUtils.parseDate("2013-05-18");
+    Date date = DateUtils.parseDateTime("2013-05-18T12:00:00+0000");
     DefaultIssue issue = new DefaultIssue()
       .setKey("ABCDE")
       .setNew(false)
diff --git a/sonar-core/src/test/java/org/sonar/core/resource/ResourceDaoTest.java b/sonar-core/src/test/java/org/sonar/core/resource/ResourceDaoTest.java
index 56b56b5fe15..cb3f32dff32 100644
--- a/sonar-core/src/test/java/org/sonar/core/resource/ResourceDaoTest.java
+++ b/sonar-core/src/test/java/org/sonar/core/resource/ResourceDaoTest.java
@@ -28,7 +28,6 @@ import org.junit.Test;
 import org.sonar.api.component.Component;
 import org.sonar.api.resources.Qualifiers;
 import org.sonar.api.resources.Scopes;
-import org.sonar.api.utils.DateUtils;
 import org.sonar.api.utils.System2;
 import org.sonar.core.component.ComponentDto;
 import org.sonar.core.component.SnapshotDto;
@@ -36,7 +35,6 @@ import org.sonar.core.persistence.AbstractDaoTestCase;
 import org.sonar.core.persistence.DbSession;
 
 import javax.annotation.Nullable;
-
 import java.util.Collections;
 import java.util.List;
 
@@ -56,7 +54,7 @@ public class ResourceDaoTest extends AbstractDaoTestCase {
   public void createDao() {
     session = getMyBatis().openSession(false);
     system2 = mock(System2.class);
-    when(system2.now()).thenReturn(DateUtils.parseDate("2014-09-03").getTime());
+    when(system2.now()).thenReturn(1_500_000_000_000L);
     dao = new ResourceDao(getMyBatis(), system2);
   }
 
@@ -284,7 +282,7 @@ public class ResourceDaoTest extends AbstractDaoTestCase {
 
     assertThat(file1.getId()).isNotNull();
     assertThat(file2.getId()).isNotNull();
-    checkTables("insert", new String[] {"authorization_updated_at"}, "projects");
+    checkTables("insert", new String[] {"authorization_updated_at", "created_at"}, "projects");
 
     // SONAR-3636 : created_at must be fed when inserting a new entry in the 'projects' table
     ResourceDto fileLoadedFromDB = dao.getResource(file1.getId());
@@ -430,11 +428,11 @@ public class ResourceDaoTest extends AbstractDaoTestCase {
 
     assertThat(snapshotDto.getPeriodMode(2)).isEqualTo("days");
     assertThat(snapshotDto.getPeriodModeParameter(2)).isEqualTo("30");
-    assertThat(snapshotDto.getPeriodDate(2)).isEqualTo(DateUtils.parseDate("2011-09-24").getTime());
+    assertThat(snapshotDto.getPeriodDate(2)).isEqualTo(1_316_815_200_000L);
 
     assertThat(snapshotDto.getPeriodMode(3)).isEqualTo("days");
     assertThat(snapshotDto.getPeriodModeParameter(3)).isEqualTo("90");
-    assertThat(snapshotDto.getPeriodDate(3)).isEqualTo(DateUtils.parseDate("2011-07-26").getTime());
+    assertThat(snapshotDto.getPeriodDate(3)).isEqualTo(1_311_631_200_000L);
 
     assertThat(snapshotDto.getPeriodMode(4)).isEqualTo("previous_analysis");
     assertThat(snapshotDto.getPeriodModeParameter(4)).isNull();
diff --git a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeDaoTest/insert-result.xml b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeDaoTest/insert-result.xml
index 6e5a96df545..06468bff8a8 100644
--- a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeDaoTest/insert-result.xml
+++ b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeDaoTest/insert-result.xml
@@ -7,9 +7,9 @@
     user_login="emmerik"
     change_type="comment"
     change_data="Some text"
-    created_at="1410213600000"
-    updated_at="1410300000000"
-    issue_change_creation_date="1410386400000"
+    created_at="1500000000000"
+    updated_at="1501000000000"
+    issue_change_creation_date="1502000000000"
     />
 
 </dataset>
diff --git a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeDaoTest/update-result.xml b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeDaoTest/update-result.xml
index 754dfd948f2..16020534152 100644
--- a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeDaoTest/update-result.xml
+++ b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeDaoTest/update-result.xml
@@ -32,7 +32,7 @@
       change_type="comment"
       change_data="new comment"
       created_at="1367704800000"
-      updated_at="1372543200000"
+      updated_at="1500000000000"
       issue_change_creation_date="[null]"
       />
 </dataset>
diff --git a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeMapperTest/insert_comment-result.xml b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeMapperTest/insert_comment-result.xml
index ad0e38ea83d..0cafa3297f4 100644
--- a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeMapperTest/insert_comment-result.xml
+++ b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeMapperTest/insert_comment-result.xml
@@ -6,8 +6,8 @@
       user_login="emmerik"
       change_type="comment"
       change_data="the comment"
-      created_at="1368828000000"
-      updated_at="1368828000000"
+      created_at="1500000000000"
+      updated_at="1500000000000"
       issue_change_creation_date="[null]"
       />
 </dataset>
diff --git a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeMapperTest/insert_diff-result.xml b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeMapperTest/insert_diff-result.xml
index d4754f60a06..f84e3423e12 100644
--- a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeMapperTest/insert_diff-result.xml
+++ b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueChangeMapperTest/insert_diff-result.xml
@@ -6,8 +6,8 @@
       user_login="emmerik"
       change_type="diff"
       change_data="severity=INFO|BLOCKER"
-      created_at="1368828000000"
-      updated_at="1368828000000"
-      issue_change_creation_date="1368828000000"
+      created_at="1500000000000"
+      updated_at="1500000000000"
+      issue_change_creation_date="1500000000000"
       />
 </dataset>
diff --git a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueDaoTest/find_rules_by_component.xml b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueDaoTest/find_rules_by_component.xml
deleted file mode 100644
index 9d97be65b71..00000000000
--- a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueDaoTest/find_rules_by_component.xml
+++ /dev/null
@@ -1,80 +0,0 @@
-<dataset>
-
-  <!-- rule 500 -->
-  <issues
-      id="100"
-      kee="ABCDE-1"
-      component_uuid="CDEF"
-      project_uuid="ABCD"
-      rule_id="500"
-      severity="BLOCKER"
-      manual_severity="[false]"
-      message="[null]"
-      line="200"
-      effort_to_fix="4.2"
-      status="OPEN"
-      resolution="[null]"
-      checksum="XXX"
-      reporter="arthur"
-      assignee="perceval"
-      author_login="[null]"
-      issue_attributes="JIRA=FOO-1234"
-      issue_creation_date="1366063200000"
-      issue_update_date="1366063200000"
-      issue_close_date="1366063200000"
-      created_at="1400000000000"
-      updated_at="1400000000000"
-      />
-
-  <issues
-      id="101"
-      kee="ABCDE-2"
-      component_uuid="CDEF"
-      project_uuid="ABCD"
-      rule_id="500"
-      severity="BLOCKER"
-      manual_severity="[false]"
-      message="[null]"
-      line="200"
-      effort_to_fix="4.2"
-      status="OPEN"
-      resolution="[null]"
-      checksum="XXX"
-      reporter="arthur"
-      assignee="perceval"
-      author_login="[null]"
-      issue_attributes="JIRA=FOO-1234"
-      issue_creation_date="1366149600000"
-      issue_update_date="1366149600000"
-      issue_close_date="1366149600000"
-      created_at="1400000000000"
-      updated_at="1400000000000"
-      />
-
-
-  <!-- rule 501 -->
-  <issues
-      id="102"
-      kee="ABCDE-3"
-      component_uuid="CDEF"
-      project_uuid="ABCD"
-      rule_id="501"
-      severity="BLOCKER"
-      manual_severity="[false]"
-      message="[null]"
-      line="200"
-      effort_to_fix="4.2"
-      status="OPEN"
-      resolution="[null]"
-      checksum="XXX"
-      reporter="arthur"
-      assignee="perceval"
-      author_login="[null]"
-      issue_attributes="JIRA=FOO-1234"
-      issue_creation_date="1366236000000"
-      issue_update_date="1366236000000"
-      issue_close_date="1366236000000"
-      created_at="1400000000000"
-      updated_at="1400000000000"
-      />
-</dataset>
diff --git a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testInsert-result.xml b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testInsert-result.xml
index bbc47e84e7f..5083212cdc6 100644
--- a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testInsert-result.xml
+++ b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testInsert-result.xml
@@ -19,9 +19,9 @@
       assignee="karadoc"
       issue_attributes="JIRA=FOO-1234"
       tags="[null]"
-      issue_creation_date="1368828000000"
-      issue_update_date="1368914400000"
-      issue_close_date="1369000800000"
+      issue_creation_date="1401000000000"
+      issue_update_date="1402000000000"
+      issue_close_date="1403000000000"
       created_at="1400000000000"
       updated_at="1500000000000"
       action_plan_key="current_sprint"
diff --git a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testUpdate-result.xml b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testUpdate-result.xml
index 148d47a907b..bceb8d3e10b 100644
--- a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testUpdate-result.xml
+++ b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testUpdate-result.xml
@@ -19,9 +19,9 @@
       assignee="karadoc"
       issue_attributes="JIRA=FOO-1234"
       tags="[null]"
-      issue_creation_date="1368828000000"
-      issue_update_date="1368914400000"
-      issue_close_date="1369000800000"
+      issue_creation_date="1401000000000"
+      issue_update_date="1402000000000"
+      issue_close_date="1403000000000"
       created_at="1400000000000"
       updated_at="1500000000000"
       action_plan_key="current_sprint"
diff --git a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testUpdate.xml b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testUpdate.xml
index 941e2e0e698..65c1df5a462 100644
--- a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testUpdate.xml
+++ b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueMapperTest/testUpdate.xml
@@ -17,12 +17,11 @@
       reporter="[null]"
       author_login="[null]"
       assignee="[null]"
-      issue_attributes="[null]"
-      issue_creation_date="[null]"
-      issue_update_date="[null]"
-      issue_close_date="[null]"
+      issue_creation_date="1401000000000"
+      issue_update_date="1402000000000"
+      issue_close_date="1403000000000"
       created_at="1400000000000"
-      updated_at="1400000000000"
+      updated_at="1500000000000"
       action_plan_key="[null]"
       />
 </dataset>
diff --git a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_insert_new_issues-result.xml b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_insert_new_issues-result.xml
index a69e0a72135..bea6889ccad 100644
--- a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_insert_new_issues-result.xml
+++ b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_insert_new_issues-result.xml
@@ -16,9 +16,9 @@
           issue_attributes="foo=bar"
           tags="[null]"
           action_plan_key="[null]"
-          issue_creation_date="1368828000000"
-          issue_update_date="1368828000000"
-          issue_close_date="1368828000000"
+          issue_creation_date="1368878400000"
+          issue_update_date="1368878400000"
+          issue_close_date="1368878400000"
       />
 
   <issue_changes id="1" kee="FGHIJ" issue_key="ABCDE" change_type="comment" user_login="emmerik"
diff --git a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_resolve_conflicts_on_updates.xml b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_resolve_conflicts_on_updates.xml
index b026a0da238..ef25cfab275 100644
--- a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_resolve_conflicts_on_updates.xml
+++ b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_resolve_conflicts_on_updates.xml
@@ -29,7 +29,7 @@
           created_at="2005-05-12"
           updated_at="2013-05-18"
           issue_creation_date="1115848800000"
-          issue_update_date="1368828000000"
+          issue_update_date="1368878400000"
           issue_close_date="[null]"
       />
 </dataset>
diff --git a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_update_issues-result.xml b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_update_issues-result.xml
index ea291ef00bc..91524aa02bc 100644
--- a/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_update_issues-result.xml
+++ b/sonar-core/src/test/resources/org/sonar/core/issue/db/IssueStorageTest/should_update_issues-result.xml
@@ -21,9 +21,9 @@
           issue_attributes="foo=bar"
           tags="[null]"
           action_plan_key="[null]"
-          issue_creation_date="1368828000000"
-          issue_update_date="1368828000000"
-          issue_close_date="1368828000000"
+          issue_creation_date="1368878400000"
+          issue_update_date="1368878400000"
+          issue_close_date="1368878400000"
       />
 
   <issue_changes id="1" kee="FGHIJ" issue_key="ABCDE" change_type="comment" user_login="emmerik"
diff --git a/sonar-core/src/test/resources/org/sonar/core/resource/ResourceDaoTest/insert-result.xml b/sonar-core/src/test/resources/org/sonar/core/resource/ResourceDaoTest/insert-result.xml
index 940d4b28466..1758aac4fbb 100644
--- a/sonar-core/src/test/resources/org/sonar/core/resource/ResourceDaoTest/insert-result.xml
+++ b/sonar-core/src/test/resources/org/sonar/core/resource/ResourceDaoTest/insert-result.xml
@@ -3,13 +3,13 @@
   <projects id="1" root_id="[null]" uuid="ABCD" project_uuid="EFGH" module_uuid="EFGH" module_uuid_path=".EFGH."
             scope="FIL" qualifier="FIL" kee="org.struts:struts:/src/main/java/org/struts/Action.java" name="Action"
             description="[null]" long_name="org.struts.Action"
-            enabled="[true]" language="java" copy_resource_id="[null]" person_id="[null]" created_at="2014-09-03" path="/foo/bar" deprecated_kee="org.struts:struts:org.struts.Action"
+            enabled="[true]" language="java" copy_resource_id="[null]" person_id="[null]" created_at="[ignore]" path="/foo/bar" deprecated_kee="org.struts:struts:org.struts.Action"
             authorization_updated_at="123456789"/>
 
   <projects id="2" root_id="[null]" uuid="BCDE" project_uuid="FGHI" module_uuid="FGHI" module_uuid_path=".FGHI."
             scope="FIL" qualifier="FIL" kee="org.struts:struts:/src/main/java/org/struts/Filter.java" name="Filter"
             description="[null]" long_name="org.struts.Filter"
-            enabled="[true]" language="java" copy_resource_id="[null]" person_id="[null]" created_at="2014-09-03" path="[null]" deprecated_kee="org.struts:struts:org.struts.Filter"
+            enabled="[true]" language="java" copy_resource_id="[null]" person_id="[null]" created_at="[ignore]" path="[null]" deprecated_kee="org.struts:struts:org.struts.Filter"
             authorization_updated_at="123456789"/>
 
 </dataset>