You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Vignesh Raghunathan (JIRA)" <ji...@apache.org> on 2016/08/21 06:53:20 UTC
[jira] [Created] (ASTERIXDB-1600) Support for date arthimetic
Vignesh Raghunathan created ASTERIXDB-1600:
----------------------------------------------
Summary: Support for date arthimetic
Key: ASTERIXDB-1600
URL: https://issues.apache.org/jira/browse/ASTERIXDB-1600
Project: Apache AsterixDB
Issue Type: Improvement
Reporter: Vignesh Raghunathan
{code}
drop dataverse sampdb if exists;
create dataverse sampdb;
use sampdb;
drop dataset samptable if exists;
drop type samptabletype if exists;
create type samptabletype as closed {
dt: date
};
create dataset samptable(samptabletype) primary key dt;
select *
from samptable s1, samptable s2
where s1.dt > s2.dt + 5;
{code}
The above query can't be expressed in sqlpp without support for date type arithmetic.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)