[
https://issues.apache.org/jira/browse/PHOENIX-3996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thomas D'Silva updated PHOENIX-3996:
------------------------------------
Labels: DESC (was: )
> 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
> Labels: DESC
>
> 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)
