[
https://issues.apache.org/jira/browse/PHOENIX-3996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
steve, Oh updated PHOENIX-3996:
-------------------------------
Description:
I created decimal type descending index column. Some case compare result is odd.
# table schema
CREATE TABLE IF NOT EXISTS test_tbl2 (
num DECIMAL NOT NULL
CONSTRAINT pk PRIMARY KEY (num DESC)
)
;
# explain query
explain
select * from test_tbl2
where
num >= 1498755000000 and num <= 1498755999000;
# explain result
DEGENERATE SCAN OVER TEST_TBL2
was:
I created decimal type descending index column. Some case compare result is odd.
# table schema
CREATE TABLE IF NOT EXISTS test_tbl2 (
num DECIMAL NOT NULL
CONSTRAINT pk PRIMARY KEY (num DESC)
)
;
# explain query
explain
select * from test_tbl2
where
lot >= 1498755000000 and lot <= 1498755999000;
# explain result
DEGENERATE SCAN OVER TEST_TBL2
> DECIMAL TYPE DESC index compare wrong
> -------------------------------------
>
> Key: PHOENIX-3996
> URL: https://issues.apache.org/jira/browse/PHOENIX-3996
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.8.1
> Reporter: steve, Oh
> Priority: Blocker
>
> I created decimal type descending index column. Some case compare result is
> odd.
> # table schema
> CREATE TABLE IF NOT EXISTS test_tbl2 (
> num DECIMAL NOT NULL
> CONSTRAINT pk PRIMARY KEY (num DESC)
> )
> ;
> # explain query
> explain
> select * from test_tbl2
> where
> num >= 1498755000000 and num <= 1498755999000;
> # explain result
> DEGENERATE SCAN OVER TEST_TBL2
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
