phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "steve, Oh (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-3996) DECIMAL TYPE DESC index compare wrong
Date Thu, 06 Jul 2017 08:38:00 GMT

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

Mime
View raw message