hyoungjunkim created TAJO-120:
---------------------------------

             Summary: TestCase doesn't call ResultSet.close
                 Key: TAJO-120
                 URL: https://issues.apache.org/jira/browse/TAJO-120
             Project: Tajo
          Issue Type: Improvement
          Components: cli
    Affects Versions: 0.2-incubating
            Reporter: hyoungjunkim
            Priority: Trivial


Current implementation is
{code}
ResultSet res = tpch.execute("select 100 * sum(" +
        "case when p_type like 'PROMO%' then l_extendedprice else 0.0 end) / 
sum(l_extendedprice * (1 - l_discount)) "
        + "as promo_revenue from lineitem, part where l_partkey = p_partkey");

assertTrue(res.next());
assertEquals(33, res.getInt(1));
{code}

Changed implementation is
{code}
ResultSet res = tpch.execute("select 100 * sum(" +
        "case when p_type like 'PROMO%' then l_extendedprice else 0.0 end) / 
sum(l_extendedprice * (1 - l_discount)) "
        + "as promo_revenue from lineitem, part where l_partkey = p_partkey");

try {
  assertTrue(res.next());
  assertEquals(33, res.getInt(1));
} finally {
  res.close();
}
{code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to