[ https://issues.apache.org/jira/browse/ASTERIXDB-1600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yingyi Bu reassigned ASTERIXDB-1600: ------------------------------------ Assignee: Till (was: Yingyi Bu) > Support for date and string arthimetic > -------------------------------------- > > Key: ASTERIXDB-1600 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-1600 > Project: Apache AsterixDB > Issue Type: Improvement > Reporter: Vignesh Raghunathan > Assignee: Till > > {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.4.14#64029)