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)

Reply via email to