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] [Created] (PHOENIX-3996) DECIMAL TYPE DESC index compare wrong
Date Thu, 06 Jul 2017 07:40:00 GMT
steve, Oh created PHOENIX-3996:
----------------------------------

             Summary: 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 
lot >= 1498755000000 and lot <= 1498755999000;

# explain result
DEGENERATE SCAN OVER TEST_TBL2



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message