You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Thomas D'Silva (JIRA)" <ji...@apache.org> on 2017/10/19 17:18:00 UTC
[jira] [Updated] (PHOENIX-3996) DECIMAL TYPE DESC index compare
wrong
[ 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)