[
https://issues.apache.org/jira/browse/TAJO-417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi updated TAJO-417:
------------------------------
Attachment: TAJO-417.patch
> 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
>
> Attachments: TAJO-417.patch
>
>
> {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)
