[
https://issues.apache.org/jira/browse/ASTERIXDB-1600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vignesh Raghunathan updated ASTERIXDB-1600:
-------------------------------------------
Description:
{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 type samptabletype2 as closed {
id: int64,
firstname: string,
lastname: string
};
create dataset samptable(samptabletype) primary key dt;
create dataset samptable2(samptabletype2) primary key id;
select *
from samptable s1, samptable s2
where s1.dt > s2.dt + 5;
select firstname + " " + lastname as fullname
from samptable2
{code}
The above queries can't be expressed in sqlpp without support for date and
string type arithmetic.
was:
{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.
> 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 type samptabletype2 as closed {
> id: int64,
> firstname: string,
> lastname: string
> };
> create dataset samptable(samptabletype) primary key dt;
> create dataset samptable2(samptabletype2) primary key id;
> select *
> from samptable s1, samptable s2
> where s1.dt > s2.dt + 5;
> select firstname + " " + lastname as fullname
> from samptable2
> {code}
> The above queries can't be expressed in sqlpp without support for date and
> string type arithmetic.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
