[
https://issues.apache.org/jira/browse/PHOENIX-3197?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nick Dimiduk updated PHOENIX-3197:
----------------------------------
Attachment: test2.sql
test1.sql
Test files to run with psql.py
> DATE/TIMESTAMP comparison involving rowkey column broken
> --------------------------------------------------------
>
> Key: PHOENIX-3197
> URL: https://issues.apache.org/jira/browse/PHOENIX-3197
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.7.0, 4.8.0, 4.9.0
> Reporter: Nick Dimiduk
> Priority: Critical
> Attachments: test1.sql, test2.sql
>
>
> Similar to PHOENIX-2944, but involving rowkey columns. This uses a different
> compareTo method.
> The trivial test case passes:
> {noformat}
> drop table if exists test1;
> create table test1(c1 DATE NOT NULL, constraint pk primary key(c1));
> upsert into test1 values(DATE '2016-05-10 00:01:00');
> upsert into test1 values(DATE '2016-05-10 00:02:00');
> upsert into test1 values(DATE '2016-05-10 00:03:00');
> select case count(1) when 2 then 'PASS' else 'FAIL' end as test from test1
> where c1 >= DATE '2016-05-10T00:01:02.345Z';
> select case count(1) when 2 then 'PASS' else 'FAIL' end as test from test1
> where c1 >= TIMESTAMP '2016-05-10T00:01:02.345Z';
> select case count(1) when 2 then 'PASS' else 'FAIL' end as test from test1
> where DATE '2016-05-10T00:01:02.345Z' < c1;
> select case count(1) when 2 then 'PASS' else 'FAIL' end as test from test1
> where TIMESTAMP '2016-05-10T00:01:02.345Z' < c1;
> select case count(1) when 1 then 'PASS' else 'FAIL' end as test from test1
> where c1 < DATE '2016-05-10T00:01:02.345Z';
> select case count(1) when 1 then 'PASS' else 'FAIL' end as test from test1
> where c1 < TIMESTAMP '2016-05-10T00:01:02.345Z';
> select case count(1) when 1 then 'PASS' else 'FAIL' end as test from test1
> where DATE '2016-05-10T00:01:02.345Z' >= c1;
> select case count(1) when 1 then 'PASS' else 'FAIL' end as test from test1
> where TIMESTAMP '2016-05-10T00:01:02.345Z' >= c1;
> {noformat}
> But nest the date column in the rowkey and the DATE vs TIMESTAMP compares
> start failing:
> {noformat}
> drop table if exists test2;
> create table test2(c1 VARCHAR NOT NULL, c2 DATE NOT NULL, c3 VARCHAR NOT
> NULL, constraint pk primary key(c1,c2,c3));
> upsert into test2 values('a',DATE '2016-05-10 00:01:00','x');
> upsert into test2 values('a',DATE '2016-05-10 00:02:00','y');
> upsert into test2 values('a',DATE '2016-05-10 00:03:00','z');
> select case count(1) when 2 then 'PASS' else 'FAIL' end as test from test2
> where c2 >= DATE '2016-05-10T00:01:02.345Z';
> select case count(1) when 2 then 'PASS' else 'FAIL' end as test from test2
> where c2 >= TIMESTAMP '2016-05-10T00:01:02.345Z';
> select case count(1) when 2 then 'PASS' else 'FAIL' end as test from test2
> where DATE '2016-05-10T00:01:02.345Z' < c2;
> select case count(1) when 2 then 'PASS' else 'FAIL' end as test from test2
> where TIMESTAMP '2016-05-10T00:01:02.345Z' < c2;
> select case count(1) when 1 then 'PASS' else 'FAIL' end as test from test2
> where c2 < DATE '2016-05-10T00:01:02.345Z';
> select case count(1) when 1 then 'PASS' else 'FAIL' end as test from test2
> where c2 < TIMESTAMP '2016-05-10T00:01:02.345Z';
> select case count(1) when 1 then 'PASS' else 'FAIL' end as test from test2
> where DATE '2016-05-10T00:01:02.345Z' >= c2;
> select case count(1) when 1 then 'PASS' else 'FAIL' end as test from test2
> where TIMESTAMP '2016-05-10T00:01:02.345Z' >= c2;
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
