phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas D'Silva (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-3996) DECIMAL TYPE DESC index compare wrong
Date Thu, 19 Oct 2017 17:18:00 GMT

     [ 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)

Mime
View raw message