You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2013/12/14 12:09:06 UTC
[jira] [Created] (TAJO-417) TestSQLExpression.testCastFromTable
causes unit test failure
Hyunsik Choi created TAJO-417:
---------------------------------
Summary: TestSQLExpression.testCastFromTable causes unit test failure
Key: TAJO-417
URL: https://issues.apache.org/jira/browse/TAJO-417
Project: Tajo
Issue Type: Bug
Components: operator/expression
Reporter: Hyunsik Choi
Assignee: Hyunsik Choi
Priority: Trivial
Fix For: 0.8-incubating
{code}
testSimpleEval("select '1980-04-01 01:50:01'::timestamp::bigint;", new String [] {"323369401000"});
testSimpleEval("select ('1980-04-01 01:50:01'::timestamp)::bigint;", new String [] {"323369401000"});
{code}
The above unit tests can cause failure due to the precision difference between bigint value and the value casted from timestamp string. This patch eliminates the difference by using only timestamp strings.
{code}
testSimpleEval("select '1980-04-01 01:50:01'::timestamp::bigint::timestamp", new String [] {"1980-04-01 01:50:01"});
testSimpleEval("select cast (('1980-04-01 01:50:01'::timestamp)::bigint as timestamp)",
new String [] {"1980-04-01 01:50:01"});
{code}
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)