[jira] [Created] (TAJO-1788) form of INTERVAL literal need to be supported

["Dongkyu Hwangbo (JIRA)" <ji...@apache.org>]

Dongkyu Hwangbo created TAJO-1788:
-------------------------------------

             Summary: form of INTERVAL literal need to be supported
                 Key: TAJO-1788
                 URL: https://issues.apache.org/jira/browse/TAJO-1788
             Project: Tajo
          Issue Type: Wish
            Reporter: Dongkyu Hwangbo
            Priority: Minor


TPC-H Reference document introduce Q1 like below.

{code:SQL}
select
l_returnflag,
l_linestatus,
sum(l_quantity) as sum_qty,
sum(l_extendedprice) as sum_base_price,
sum(l_extendedprice*(1-l_discount)) as sum_disc_price,
sum(l_extendedprice*(1-l_discount)*(1+l_tax)) as sum_charge,
avg(l_quantity) as avg_qty,
avg(l_extendedprice) as avg_price,
avg(l_discount) as avg_disc,
count(*) as count_order
from
lineitem
where
l_shipdate <= date '1998-12-01' - interval '90' day (3)
group by
l_returnflag,
l_linestatus
order by
l_returnflag,
l_linestatus;
{code}
See this line.
{code:SQL}
l_shipdate <= date '1998-12-01' - interval '90' day (3)
{code}
TAJO cannot understand this line.

I find details of this literal.
http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm#i38598



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)