Repository: phoenix Updated Branches: refs/heads/4.8-HBase-1.0 8e18c936a -> 9e8a7e2e0
PHOENIX-2793 Test case for date-time functions on null dates return no data (Kevin Liew) Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/9e8a7e2e Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/9e8a7e2e Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/9e8a7e2e Branch: refs/heads/4.8-HBase-1.0 Commit: 9e8a7e2e0439d5e08840801b2b5b78977f1cbcd1 Parents: 8e18c93 Author: Samarth <[email protected]> Authored: Thu Sep 1 10:37:26 2016 -0700 Committer: Samarth <[email protected]> Committed: Thu Sep 1 10:37:26 2016 -0700 ---------------------------------------------------------------------- .../it/java/org/apache/phoenix/end2end/DateTimeIT.java | 11 +++++++++++ 1 file changed, 11 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/phoenix/blob/9e8a7e2e/phoenix-core/src/it/java/org/apache/phoenix/end2end/DateTimeIT.java ---------------------------------------------------------------------- diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DateTimeIT.java b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DateTimeIT.java index 7ffc54f..7e01e54 100644 --- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DateTimeIT.java +++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DateTimeIT.java @@ -776,4 +776,15 @@ public class DateTimeIT extends BaseHBaseManagedTimeIT { assertEquals(false, rs.getBoolean(1)); assertFalse(rs.next()); } + + @Test + public void testFunctionOnNullDate() throws Exception { + ResultSet rs = conn.createStatement().executeQuery("SELECT YEAR(a_date), entity_id from " + ATABLE_NAME + " WHERE entity_id = '" + ROW10 + "'"); + assertNotNull(rs); + assertTrue(rs.next()); + assertEquals(ROW10, rs.getString(2)); + assertNull(rs.getDate(1)); + assertNull(rs.getDate(1, GregorianCalendar.getInstance())); + assertFalse(rs.next()); + } }
