You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2016/02/17 21:42:18 UTC
[jira] [Created] (DRILL-4399) query using OVERLAPS function
executes and returns 0 rows
N Campbell created DRILL-4399:
---------------------------------
Summary: query using OVERLAPS function executes and returns 0 rows
Key: DRILL-4399
URL: https://issues.apache.org/jira/browse/DRILL-4399
Project: Apache Drill
Issue Type: Wish
Components: Server
Affects Versions: 1.5.0
Reporter: N Campbell
Doc set makes not mention of this, but parses and executes
select 1 from postgres.public.tdt where (date '1999-12-01' , date '2001-12-31' ) overlaps ( date '2001-01-01' , tdt.cdt ) and rnum=0
This query executed by Postgres would return 1 row
create table TDT ( RNUM integer not null , CDT date ) ;
comment on table TDT is 'This describes table TDT.';
grant select on table TDT to public;
insert into TDT(RNUM, CDT) values ( 0, NULL);
insert into TDT(RNUM, CDT) values ( 1, DATE '1996-01-01');
insert into TDT(RNUM, CDT) values ( 2, DATE '2000-01-01');
insert into TDT(RNUM, CDT) values ( 3, DATE '2000-12-31');
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)