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/11 10:17:07 UTC
[jira] [Updated] (TAJO-407) PostgreSQL-style cast should be higher
operator priority
[ https://issues.apache.org/jira/browse/TAJO-407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyunsik Choi updated TAJO-407:
------------------------------
Attachment: TAJO-407.patch
After this patch, the below expressions work well.
{code}
testSimpleEval("select '1980-04-01 01:50:01'::timestamp;", new String [] {"1980-04-01 01:50:01"});
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}
> PostgreSQL-style cast should be higher operator priority
> --------------------------------------------------------
>
> Key: TAJO-407
> URL: https://issues.apache.org/jira/browse/TAJO-407
> Project: Tajo
> Issue Type: Bug
> Components: operator/expression
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Fix For: 0.8-incubating
>
> Attachments: TAJO-407.patch
>
>
> See the title. Currently, postgresql-style cast has lower operator priority than some operators like equal(=). So, the following statement does not work properly.
> {noformat}
> tajo> select l_shipdate from lineitem where l_shipdate = '1996-03-13'::date limit 1;
> ERROR: No operator matches the given name and argument type(s): lineitem.l_shipdate (DATE(0)) = 1996-03-13
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)